BAKERY

Tables (3)

BOOK

  • BOOK_ID — NUMBER(10) — Primary key — NOT NULL
  • BOOKDATE — VARCHAR2(20)
  • CUST_ID — NUMBER(10) — Foreign key → CUSTOMER.CUST_ID — NOT NULL
  • FOOD_ID — NUMBER(10) — Foreign key → MENU.FOOD_ID — NOT NULL

CUSTOMER (CUSTOMER)

  • CUST_ID — NUMBER(10) — Primary key — NOT NULL
  • ID — VARCHAR2(50)
  • PASSWORD — VARCHAR2(50)
  • NAME — VACHAR2(50)
  • PHONE — VARCHAR2(50)

MENU

  • FOOD_ID — NUMBER(10) — Primary key — NOT NULL
  • FOOD_NAME — VACHAR2(50)
  • PRICE — NUMBER(10)