Mart

Tables (5)

Card (카드 정보)

  • Key (purchase ID) — INT — Foreign key → Purchase.Key — NOT NULL
  • Field (card ID) — INT

Customer (고객)

  • Key (customer ID) — INT — Foreign key → Purchase.Key — NOT NULL
  • Field (customer_name) — VARCHAR

Mart (마트)

  • Key2 (mart ID) — INT — Foreign key → Purchase.Key — NOT NULL
  • Field2 (mart_name) — VARCHAR
  • Field3 (adress) — VARCHAR

Purchase (구매)

  • Key (mart ID) — INT — Primary key — NOT NULL
  • Key (purchase ID) — INT — Primary key — NOT NULL
  • Key (customer ID) — INT — Primary key — NOT NULL
  • Field (order_time) — DATETIME
  • Field2 (amount) — INT
  • Field3 (payment) — FLOAT
  • Field (method) — VARCHAR

Purchase_Product (구매 제품)

  • Key (purchase ID) — INT — Foreign key → Purchase.Key — NOT NULL
  • Field (product_name) — VARCHAR
  • Field2 (price) — FLOAT
  • Field (quantity) — INT