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)