Sprint Mart

테이블 (6)

결제 카드Cards) (Untitled2)

  • card_ID (PK) — INT — 기본 키 — NOT NULL
  • order_ID (FK) — INT
  • name (Field3) — VARCHAR(10)
  • installment (Field4) — FLOAT

고객(Customers) (Untitled5)

  • customer_ID (PK) — INT — 기본 키 — NOT NULL
  • name (Field2) — VARCHAR(20)

구매 상품(Order_Products) (Untitled4)

  • order_ID (Key) — INT — 기본 키 — NOT NULL
  • product_ID (Key2) — INT — 기본 키 — NOT NULL
  • price (Field3) — FLOAT
  • quantity (Field4) — FLOAT

마켓(Markets) (Untitled3)

  • market_ID (Key) — INT — 기본 키 — NOT NULL
  • name (Field2) — VARCHAR(10)
  • address (Field3) — VARCHAR

상품(Products) (Untitled6)

  • product_ID (Key) — INT — 기본 키 — NOT NULL
  • product_name (Field) — VARCHAR
  • price (Field2) — FLOAT

주문(Orders) (Untitled)

  • order_ID (PK) — INT — 기본 키 — NOT NULL
  • customer_ID (Field2) — INT
  • market_ID (Field3) — INT
  • order_date (Field4) — TIMESTAMP
  • amount (Field5) — FLOAT
  • payment (Field6) — VARCHAR(10)