레스토랑 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)