Table of contents
Page number: 2 1 Account
Page number: 3 2 Bilder
Page number: 4 3 Buchung
Page number: 5 4 DText
Page number: 6 5 EText
Page number: 7 6 FInfo
Page number: 8 7 Firmen
Page number: 9 8 Forum
Page number: 10 9 Kunden
Page number: 11 10 Links
Page number: 12 11 MInfo
Page number: 13 12 MPreise
Page number: 14 13 Preise
Page number: 15 14 Saison
Page number: 16 15 Texte
Page number: 17 16 TText
Page number: 18 17 Zimmer
Page number: 19 18 Relational schema
Page number: 1/19 Jun 06, 2004 at 07:50 PM
1 Account
Table comments : InnoDB free: 3072 kB; (MID) REFER hotel/Kunden(MID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
MID int(10) No 0 Kunden -> MID
Login varchar(10) No
Pwd varchar(20) No
Seit date No 0000-00-00
Page number: 2/19 Jun 06, 2004 at 07:50 PM
2 Bilder
Table comments : InnoDB free: 3072 kB; (LID) REFER hotel/Links(LID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
BID int(10) No auto_increment
Datei mediumblob No image/jpeg
Type enum('image/j
peg', 'image/gif', 'video/mpeg')
No image/jpeg
Beschreibung varchar(50) No
LID int(10) Yes NULL Links -> LID
Page number: 3/19 Jun 06, 2004 at 07:50 PM
3 Buchung
Table comments : InnoDB free: 3072 kB; (MID) REFER hotel/Kunden(MID) ON UPDATE CASCADE; (Znr) REFER hotel/Zimmer(Znr) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
BuchID int(10) No auto_increment
Znr int(10) No 0 Zimmer -> Znr
DatGeb date No 0000-00-00
DatGez date No 0000-00-00
DatVon date No 0000-00-00
DatBis date No 0000-00-00
MID int(10) No 0 Kunden -> MID
Page number: 4/19 Jun 06, 2004 at 07:50 PM
4 DText
Table comments : InnoDB free: 3072 kB; (TID) REFER hotel/Texte(TID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
TID int(10) No 0 Texte -> TID
Text text No
Page number: 5/19 Jun 06, 2004 at 07:50 PM
5 EText
Table comments : InnoDB free: 3072 kB; (TID) REFER hotel/Texte(TID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
TID int(10) No 0 Texte -> TID
Text text No
Page number: 6/19 Jun 06, 2004 at 07:50 PM
6 FInfo
Table comments : InnoDB free: 3072 kB; (FID) REFER hotel/Firmen(FID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
FID int(10) No 0 Firmen -> FID
Buchungen int(10) No 0
FNachl float No 0
Page number: 7/19 Jun 06, 2004 at 07:50 PM
7 Firmen
Table comments : InnoDB free: 3072 kB
Field Type Attributes Null Default Extra Links to Comments MIME
FID int(10) No auto_increment
Firma varchar(100) No
Page number: 8/19 Jun 06, 2004 at 07:50 PM
8 Forum
Table comments : InnoDB free: 3072 kB; (MID) REFER hotel/Kunden(MID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
MsgID int(10) No auto_increment
ThreadID int(10) No 0
Subject varchar(255) No
Text text No
Date date No 0000-00-00
MID int(10) Yes NULL Kunden -> MID
ReplyID int(10) No 0 Forum -> MsgID
Sprache enum('D', 'E', 'T')
No D
Page number: 9/19 Jun 06, 2004 at 07:50 PM
9 Kunden
Table comments : InnoDB free: 3072 kB; (FID) REFER hotel/Firmen(FID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
MID int(10) No auto_increment
FID int(10) No 0 Firmen -> FID
Name varchar(100) No
Vorname varchar(100) No
Strasse varchar(100) No
Hnr varchar(10) No
Plz varchar(10) No
Ort varchar(100) No
Land varchar(100) No
EMail varchar(100) No
Tel varchar(100) No
Fax varchar(100) No
Page number: 10/19 Jun 06, 2004 at 07:50 PM
10 Links
Table comments : InnoDB free: 3072 kB
Field Type Attributes Null Default Extra Links to Comments MIME
LID int(10) No auto_increment
Url varchar(255) No
Page number: 11/19 Jun 06, 2004 at 07:50 PM
11 MInfo
Table comments : InnoDB free: 3072 kB; (MID) REFER hotel/Kunden(MID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
MID int(10) No 0 Kunden -> MID
Buchungen int(10) No 0
MNachl float No 0
Page number: 12/19 Jun 06, 2004 at 07:50 PM
12 MPreise
Table comments : InnoDB free: 3072 kB; (MID) REFER hotel/Kunden(MID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
MID int(10) No 0 Kunden -> MID
Pez float No 0
Pdz float No 0
Pap6 float No 0
Pap8 float No 0
Page number: 13/19 Jun 06, 2004 at 07:50 PM
13 Preise
Table comments : InnoDB free: 3072 kB
Field Type Attributes Null Default Extra Links to Comments MIME
Zart enum('EZ',
'DZ', '3Bett', '2-4App', '4-6App')
No EZ
Hp float Yes NULL
Uf float Yes NULL
U float Yes NULL
Page number: 14/19 Jun 06, 2004 at 07:50 PM
14 Saison
Table comments : InnoDB free: 3072 kB
Field Type Attributes Null Default Extra Links to Comments MIME
SID int(10) No auto_increment
DatVon text No
DatBis text No
Nachlass float No 0
Page number: 15/19 Jun 06, 2004 at 07:50 PM
15 Texte
Table comments : InnoDB free: 3072 kB; (LID) REFER hotel/Links(LID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
TID int(10) No auto_increment
LID int(10) Yes NULL Links -> LID
Page number: 16/19 Jun 06, 2004 at 07:50 PM
16 TText
Table comments : InnoDB free: 3072 kB; (TID) REFER hotel/Texte(TID) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
TID int(10) No 0 Texte -> TID
Text text No
Page number: 17/19 Jun 06, 2004 at 07:50 PM
17 Zimmer
Table comments : InnoDB free: 3072 kB; (Zart) REFER hotel/Preise(Zart) ON UPDATE CASCADE
Field Type Attributes Null Default Extra Links to Comments MIME
Znr int(10) No 0
Zart enum('EZ',
'DZ', '3Bett', '2-4App', '4-6App')
No EZ Preise -> Zart
Du enum('Y', 'N') No Y
Wc enum('Y', 'N') No Y
Bad enum('Y', 'N') No Y
Telefon enum('Y', 'N') No Y
Tv enum('Y', 'N') No Y
Klima enum('Y', 'N') No Y
Balkon enum('Y', 'N') No Y
Safe enum('Y', 'N') No Y
Zustellbett enum('Y', 'N') No N
Küche enum('Y', 'N') No N
Wohnzimmer enum('Y', 'N') No N
Maisonette enum('Y', 'N') No N
Sonstiges text No
Page number: 18/19 Jun 06, 2004 at 07:50 PM
Pwd Seit
Bilder BID Datei Type Beschreibung LID
Buchung BuchID Znr DatGeb DatGez DatVon DatBis MID TID
Text
EText TID Text
FInfo FID Buchungen FNachl Firmen
FID Firma
Forum MsgID ThreadID Subject Text Date MID ReplyID Sprache
Kunden MID FID Name Vorname Strasse Hnr Plz Ort Land EMail Tel Fax
Links LID Url
MInfo MID Buchungen MNachl
Pdz Pap6 Pap8
Preise Zart Hp Uf U Saison
SID DatVon DatBis Nachlass Texte
TID LID
TText TID Text
Zimmer Znr Zart Du Wc Bad Telefon Tv Klima Balkon Safe Zustellbett Küche Wohnzimmer Maisonette Sonstiges