3군 2미 프로젝트

테이블 (3)

Contents

  • Goods_Name (goods_name) — VARCHAR(50)
  • Goods_Price (goods_price) — INTEGER

Customer_Bill

  • Order_ID (order_id) — INTEGER — 기본 키 — NOT NULL
  • Order_Time (order_time) — DATETIME
  • Goods_Price (goods_price) — INTEGER
  • Goods_Name (goods_name) — VARCHAR(50)
  • Goods_Count (goods_count) — INTEGER
  • Payment (payment) — VARCHAR(50)
  • Payment_Method (payment_method) — BOOLEAN

Order_Bill

  • Goods_Name (goods_name) — VARCHAR(50) — 기본 키 — NOT NULL
  • Order_ID (order_id) — INTEGER — 외래 키 → Customer_Bill.Order_ID — NOT NULL
  • Goods_Count (goods_count) — INTEGER
  • Order_Time (order_time) — DATETIME