페밀리레스토랑

테이블 (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) — 외래 키 → 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) — 외래 키 → item.item_id
  • reserv_no — VARCHAR2(30) — 외래 키 → 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) — 외래 키 → customer.customer_id — NOT NULL
  • branch — VARCHAR2(20)
  • visitor_cnt — NUMBER(3,0)
  • cancel — VARCHAR2(1)