familyrest
Tables (5)
address
- zip_code — VARCHAR2(6)
- address_detail — VARCHAR2(20)
customer
- customer_id — VARCHAR2(10)
- customer_name — VARCHAR2(20)
- phone_number — VARCHAR2(15)
- email — VARCHAR2(20)
- first_reg_date — DATE
- sex_code — VARCHAR2(2)
- birth — VARCHAR2(8)
- job — VARCHAR2(20)
- zip_code — VARCHAR2(6) — Foreign key → address.zip_code
item
- item_id — VARCHAR2(10)
- product_name — VARCHAR2(30)
- product_desc — VARCHAR2(50)
- category_id — VARCHAR2(10)
- price — NUMBER(10,0)
order_info
- order_no — VARCHAR2(30)
- item_id — VARCHAR2(10) — Foreign key → item.item_id
- reserv_no — VARCHAR2(30) — Foreign key → reservation.reserv_no
- quantity — NUMBER(3,0)
- sales — NUMBER(10,0)
reservation
- reserv_no — VARCHAR2(30)
- reserv_date — VARCHAR2(8)
- reserv_time — VARCHAR2(4)
- customer_id — VARCHAR2(10) — Foreign key → customer.customer_id — NOT NULL
- branch — VARCHAR2(20)
- visitor_cnt — NUMBER(3,0)
- cancel — VARCHAR2(1)