| |
|
|
| |
Neue Datenstruktur für Tourenbuch
Version 5 |
|
da inzwischen eine ganze Reihe von Leuten das Programm zu
nutzen scheinen und immer wieder mal gute Ideen bei mir ankommen bin ich es
leid, mir den Kopf allein zu zerbrechen ;-) |
|
| Entwurf Stand
24.12.2002 |
|
|
Haupttabellen |
|
|
|
Regionen |
|
|
REG_R |
A2 |
| |
| Region |
A50 |
| |
| O |
B |
|
Original |
|
Notiz |
M |
| |
| |
|
| |
|
|
Gebiete |
|
Region |
|
|
|
| |
|
|
REG_R |
A2 |
|
REG_R |
|
|
|
|
|
>>Region |
|
|
REG_RG |
A4 |
| |
| Gebiet |
A100 |
| |
|
Skalen |
| SkalaNr |
N |
|
SkalaNr |
N |
|
>>Skalen |
|
Skala |
A |
| |
|
|
O |
N |
|
|
|
|
|
|
|
Original |
|
|
|
|
|
|
|
Notiz |
M |
|
|
|
|
|
|
| |
|
|
|
| |
|
|
Gipfel |
|
|
|
|
|
| REG_RG |
A4 |
|
Gebiet |
|
>>Gebiet |
REG_RG |
|
REG_RGGNr |
A7 |
|
|
|
| |
| Gipfel |
A100 |
Q |
| |
Q |
A3 |
| QG |
N |
|
QNr |
N |
|
lohnend |
|
|
| KindF |
N |
|
KindF |
|
Kinderfreundlich |
KindFNr |
N |
| O |
B |
|
KindF |
A3 |
| |
|
|
Original |
|
|
|
|
|
|
| |
|
|
Typ |
A1 |
|
|
|
|
|
|
| |
|
|
Status |
A1 |
|
Sperrungen |
|
| |
|
|
Notiz |
M |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
Wege |
|
|
|
|
|
| REG_RGGNr |
A7 |
|
Gipfel |
| |
REG_RGGNr |
A |
|
REG |
A10 |
|
|
|
|
>>Gipfel |
|
Weg |
A100 |
|
|
|
Wegname |
Grade |
|
GRD |
N |
|
GRDX |
N |
|
Grad (af) |
GRDRömisch |
A |
| GRDoU |
N |
|
|
|
|
Grad (o.U.) |
|
|
| GRDRP |
N |
|
|
|
|
Grad RP |
| GRDSprung |
N |
|
|
Sprungbewertung |
| GRDO |
A25 |
|
|
|
Originalbewertung |
Q |
| QW |
N |
|
QNr |
N |
|
|
|
lohnend |
Q |
A3 |
Si |
| SI |
N |
|
|
|
|
SiNr |
N |
|
Sicherung |
|
|
|
|
Si |
A3 |
| C1 |
N |
|
C |
|
|
|
|
Charakter 1 |
C |
N |
| C2 |
N |
|
Charakter |
A |
|
|
|
|
Charakter 2 |
SymbolC |
BLOB |
| N1 |
N |
|
|
|
|
N |
|
Neigung 1 |
|
|
|
|
N |
N |
| N2 |
N |
|
|
|
|
Neigung |
A |
|
Neigung 2 |
|
A |
|
SymbolN |
BLOB |
| A1 |
N |
|
A |
N |
|
|
|
|
Anforderung 1 |
|
Anforderung |
A |
|
|
|
| A2 |
N |
|
SymbolA |
BLOB |
|
|
|
|
Anforderung 2 |
|
|
|
|
S |
| S1 |
N |
|
|
|
|
S |
N |
|
Sicherung 1 |
|
|
|
|
Sicherung |
A |
| S2 |
N |
|
|
|
|
SymbolS |
BLOB |
|
Sicherung 2 |
|
|
|
|
|
|
|
Mark |
B |
|
|
|
|
|
|
|
Markierung |
|
|
|
|
|
|
|
|
Indiv1 |
B |
|
|
|
|
|
|
|
individuell |
|
|
|
|
|
|
|
|
Indiv2 |
B |
|
|
|
|
|
|
|
individuell |
|
|
|
|
|
|
|
|
Crux |
M |
|
|
|
|
|
|
|
Schlüsselstelle |
|
|
|
|
|
|
|
|
Tipp |
M |
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
EignungA |
B |
|
|
|
|
|
|
|
für Anfänger |
|
|
|
|
|
|
|
|
EignungV |
B |
|
|
|
|
|
|
|
für Vorstiege |
|
|
|
|
|
|
|
|
EignungK |
B |
|
|
|
|
|
|
|
für Kinder |
|
|
|
|
|
|
|
|
Sonne |
B |
|
|
|
|
|
|
|
sonnig |
|
|
|
|
|
|
|
|
Schatten |
B |
|
|
|
|
|
|
|
schattig |
|
|
|
|
|
|
|
| TS |
B |
|
|
|
|
|
|
|
schnell trocken |
|
|
|
|
|
|
|
| TL |
B |
|
|
|
|
|
|
|
lange feucht |
|
|
|
|
|
|
|
|
EBDatum |
D |
|
|
|
|
|
|
|
Erstbeg. Datum |
|
|
EB |
|
|
|
|
EBNameNr |
N |
|
EBNr |
AI |
|
|
|
|
>>EB |
|
|
|
|
|
|
|
|
Status |
A1 |
|
Name |
A |
|
|
|
|
Sperrungen |
|
|
|
|
|
|
|
| Nr |
AI |
|
Vorname |
A |
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Begehungen |
|
|
|
|
|
|
|
Nr |
AI |
|
|
|
|
|
|
| |
|
|
Weg |
|
|
|
| REG |
A10 |
|
REG |
|
|
|
|
|
>>Weg |
|
|
|
|
|
|
|
| Datum |
Date |
|
|
|
|
|
|
| |
|
|
Art |
|
|
|
| ArtN |
N |
|
ArtN |
AI |
|
|
|
|
>>Art |
|
|
|
|
|
Stil |
| StilN |
N |
|
Art |
A |
|
StilN |
AI |
|
>>Stil |
|
|
|
|
|
|
| ID |
N |
|
V |
B |
|
Stil |
A |
|
>>Nutzer |
|
|
Vorstiegskennung |
|
|
|
| Notiz |
M |
|
|
|
|
Bewertung |
N |
| |
|
|
|
|
|
|
|
| BegNrTag |
N |
|
Nutzer |
|
O |
B |
|
Sortierung unab- |
|
|
ID |
|
|
Original |
|
|
hängig von der |
|
|
|
|
|
|
|
|
Eingabereihenfolge |
|
Name |
A25 |
|
|
|
| GrdBeg |
N |
|
|
|
|
|
|
|
Bewertung dieser Begehung |
|
|
Vorname |
A25 |
|
|
|
| |
|
|
|
|
| |
|
|
|
|
|
Spitzname |
A25 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Symbol |
N |
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
Vorsteiger |
|
Nachsteiger |
|
Namen |
| BegNr |
N |
|
BegNr |
N |
|
NameNr |
AI |
|
>>Begehungen |
|
|
>>Begehungen |
|
|
|
|
| NameNr |
N |
|
NameNr |
N |
|
Name |
A25 |
| |
|
|
>>Namen |
|
|
>>Namen |
|
|
|
|
| |
|
|
Position |
N |
|
Position |
N |
|
Vorname |
A25 |
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
CurrentUser |
|
|
|
|
|
|
ID |
N |
|
|
|
|
|
|
Angemeldeter |
|
|
|
|
| |
|
|
Nutzer |
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
A |
Alphanumerisch (mit
Längenangabe) |
|
AI |
Autoincrement, Zähler |
|
N |
Numerisch (Integer) |
|
Date |
Datum |
|
M |
Memo |
|
B |
Bool, Logisch Ja/Nein |
|
|
|
|
|
|
|
|
| |
|
© by Iven Eissner
letzte Bearbeitung:
24.12.02
|
|
