커피 키오스크 제어 Sys

테이블 (6)

Order_Item

  • order_item_id — INT — 기본 키 — NOT NULL
  • order_id — INT — 외래 키 → order.order_id — NOT NULL
  • Product_id — INT — 외래 키 → Product.Product_id — NOT NULL
  • quantity — INT — NOT NULL

Product

  • Product_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • info — VARCHAR(45)
  • price — INT — NOT NULL
  • category_seq — INT — 외래 키 → category.category_seq — NOT NULL
  • INDEX — `fk_item_category1_idx`

category

  • category_seq — INT — 기본 키 — NOT NULL
  • name — VARCHAR(45) — NOT NULL

order

  • order_id — INT — 기본 키 — NOT NULL
  • user_seq — INT — 외래 키 → user.user_seq — NOT NULL
  • order_date — DATE
  • total_price — INT
  • status — INT
  • order_method_id — INT — 외래 키 → order_method.order_method_id — NOT NULL

order_method

  • order_method_id — INT — 기본 키 — NOT NULL
  • point_rate — INT — NOT NULL

user

  • user_seq — INT — 기본 키 — NOT NULL
  • user_id — VARCHAR(45) — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • pw — VARCHAR(45) — NOT NULL
  • membership_level — INT — NOT NULL
  • point — INT — NOT NULL