1p1p
Tables (5)
CUSTOMER
- CUS_ID — varchar(50) — Primary key — NOT NULL
- CUS_PW — varchar(10) — NOT NULL
- CUS_NAME — varchar(50) — NOT NULL
- BIRTH — date
CUS_CLASS
- CUS_ID — varchar(50) — Foreign key → CUSTOMER.CUS_ID — NOT NULL
- CLASS_NAME — varchar(255) — NOT NULL
- QUALIFICATION — varchar(255) — NOT NULL
- CLASS — int — NOT NULL
MENU
- MENU_NAME — varchar(255) — Primary key — NOT NULL
- CALORIE — int
- EXPIRY_DAY — date — NOT NULL
- MENU_NUM — int
MENU_PRICE
- MENU_NAME — varchar(255) — Foreign key → MENU.MENU_NAME — NOT NULL
- PRICE — int — NOT NULL
- CUS_ID — varchar(50) — Foreign key → CUS_CLASS.CUS_ID — NOT NULL
RESERVATION
- CUS_ID — varchar(50) — Foreign key → CUSTOMER.CUS_ID — NOT NULL
- RES_CNT — int — NOT NULL
- MENU_NAME — varchar(255) — Foreign key → MENU.MENU_NAME — NOT NULL