레스토랑 DB
테이블 (5)
address
- zip_code — VARCHAR2(5) — 기본 키 — NOT NULL — PK
- address_detail — VARCHAR2(20)
customer
- customer_id — VARCHAR2(10) — 기본 키 — NOT NULL — PK
- customer_name — VARCHAR2(20)
- phone_number — VARCHAR2(15)
- email — VARCHAR2(20)
- first_reg_date — DATE
- gender_code — VARCHAR2(2)
- birth — VARCHAR2(8)
- job — VARCHAR2(20)
- zip_code — VARCHAR2(5) — 외래 키 → address.zip_code — NOT NULL — FK
item
- item_id — VARCHAR2(10) — 기본 키 — NOT NULL — PK
- product_name — VARCHAR2(30)
- product_desc — VARCHAR2(50)
- category_id — VARCHAR2(10)
- price — NUMBER
order_info
- order_no — VARCHAR2(30) — 기본 키 — NOT NULL — PK
- item_id — VARCHAR2(10) — 외래 키 → item.item_id — NOT NULL — PK, FK
- reserv_no — VARCHAR2(30) — 외래 키 → reservation.reserv_no — NOT NULL — FK
- quantity — NUMBER
- sales — NUMBER
reservation
- reserv_no — VARCHAR2(30) — 기본 키 — NOT NULL — PK
- reserv_date — VARCHAR2(8)
- reserv_time — VARCHAR2(4)
- customer_id — VARCHAR2(10) — 외래 키 → customer.customer_id — NOT NULL — FK
- branch — VARCHAR2(20)
- visitor_cnt — NUMBER
- cancel — VARCHAR2(1)