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