kurs:tab
Differences
This shows you the differences between two versions of the page.
|
kurs:tab [2014/09/10 21:22] |
kurs:tab [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | {{ 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 | ||
kurs/tab.txt · Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
