EzenBuks
Tables (5)
CF_ (COFFEE)
- CF_ID — NOT NULL — Primary key — NOT NULL
- OP_ID — NOT NULL — Primary key — NOT NULL
- PD_ID (Key5) — NOT NULL — Foreign key → PD_.PD_ID — NOT NULL
- CF_ID (Key23) — NULL=TRUE — Foreign key → PD_.CF_ID — NOT NULL
- FD_ID (Key33) — NULL=TRUE — Foreign key → PD_.FD_ID — NOT NULL
- OD_ID (Key42) — NOT NULL — Foreign key → PD_.OD_ID — NOT NULL
- PD_ID (Key223) — NOT NULL — Foreign key → PD_.PD_ID — NOT NULL
- CF_TITLE — varchar
- CF_PRICE — int
FD_ (FOOD)
- FD_ID — NOT NULL — Primary key — NOT NULL
- PD_ID (Key2) — NOT NULL — Foreign key → PD_.PD_ID — NOT NULL
- CF_ID (Key22) — NULL=TRUE — Foreign key → PD_.CF_ID — NOT NULL
- FD_ID (Key3) — NULL=TRUE — Foreign key → PD_.FD_ID — NOT NULL
- OD_ID (Key4) — NOT NULL — Foreign key → PD_.OD_ID — NOT NULL
- PD_ID (Key222) — NOT NULL — Foreign key → PD_.PD_ID — NOT NULL
- FD_TITLE — varchar
- FD_PRICE — int
OD_ (ORDER)
- OD_ID — NOT NULL — Primary key — NOT NULL
- PD_ID — NOT NULL — Primary key — NOT NULL
- OD_DATE — DATETIME
- OD_TOTAL — int
OP_ (OPTION)
- OP_ID — NOT NULL — Primary key — NOT NULL
- CF_ID (Key2) — NOT NULL — Foreign key → CF_.CF_ID — NOT NULL
- OP_ID (Key22) — NOT NULL — Foreign key → CF_.OP_ID — NOT NULL
- PD_ID (Key5) — NOT NULL — Foreign key → CF_.PD_ID — NOT NULL
- CF_ID (Key23) — NULL=TRUE — Foreign key → CF_.CF_ID — NOT NULL
- FD_ID (Key33) — NULL=TRUE — Foreign key → CF_.FD_ID — NOT NULL
- OD_ID (Key42) — NOT NULL — Foreign key → CF_.OD_ID — NOT NULL
- PD_ID (Key223) — NOT NULL — Foreign key → CF_.PD_ID — NOT NULL
- OP_TYPE
- OP_SIZE
PD_ (PRODUCT)
- PD_ID — NOT NULL — Primary key — NOT NULL
- CF_ID — NULL=TRUE — Primary key — NOT NULL
- FD_ID — NULL=TRUE — Primary key — NOT NULL
- OD_ID (Key4) — NOT NULL — Foreign key → OD_.OD_ID — NOT NULL
- PD_ID (Key22) — NOT NULL — Foreign key → OD_.PD_ID — NOT NULL