Tabellenübersicht
| Speisekarte | |||
|---|---|---|---|
| Name | Typ | not null | |
| SK_ID | number (7) | x | PK |
| SK_Name | varchar2 (30) | ||
| SK_Beschreibung | varchar2 (200) | ||
| SK_Preis | number (4,2) | ||
| Pizzazutaten | |||
|---|---|---|---|
| Name | Typ | not null | |
| PZ_ID | number (7) | x | PK |
| PZ_SK_ID | number (7) | FK | |
| PZ_Name | varchar2 (30) | ||
| PZ_Preis | number (4,2) | ||
| Kunden | |||
|---|---|---|---|
| Name | Typ | not null | |
| K_ID | number (7) | x | PK |
| K_Name | varchar2 (30) | ||
| K_Passwort | varchar2 (30) | ||
| K_Adresse | varchar2 (30) | ||
| K_Telefon | varchar2 (30) | ||
| K_Mail | varchar2 (30) | ||
| K_Zahlung | varchar2 (50) | ||
| Bestellungen | |||
|---|---|---|---|
| Name | Typ | not null | |
| B_ID | number (7) | x | PK |
| B_BD_ID | number (7) | FK | |
| B_K_ID | number (7) | FK | |
| B_Summe | number (4,2) | ||
| B_Datum | date | ||
| B_Zustellung | number (7) | ||
| B_Kommentar | varchar2 (50) | ||
| Bestell-Details | |||
|---|---|---|---|
| Name | Typ | not null | |
| BD_ID | number (7) | x | PK |
| BD_SK_ID | number (7) | FK | |
| BD_B_ID | number (7) | FK | |
| BD_BZ_ID | number (7) | FK | |
PK = Primary Key
FK = Foreign Key