{{ kurs:cyberpizza.gif}}
====== 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