쇼핑몰 설계

테이블 (6)

customers (Untitled)

  • customer_id — INT — 기본 키 — NOT NULL
  • name — varchar(10)
  • email — varchar(30)
  • phone — varchar(20)
  • address — varchar(40)
  • gender — varchar(1)

inquiries (Untitled6)

  • inquiry_id — INT(PK) — 기본 키 — NOT NULL
  • customer_id (customer_id2) — INT(FK) — 외래 키 → customers.customer_id — NOT NULL
  • product_id — INT(FK) — 외래 키 → products.product_id — NOT NULL
  • title — varchar(100)
  • content — TEXT
  • created_at — DATETIME
  • answer_at — DATETIME

orders (Untitled3)

  • order_id — INT(PK) — 기본 키 — NOT NULL
  • customer_id — INT(FK) — 외래 키 → customers.customer_id — NOT NULL
  • payment_id (payment_id2) — INT(FK) — 외래 키 → payments.payment_id — NOT NULL
  • order_date — datetime
  • total_price — INT
  • memo — TEXT

payments (Untitled4)

  • payment_id — INT(PK) — 기본 키 — NOT NULL
  • amount — INT
  • patment_date (payment_date) — DATETIME

products (Untitled2)

  • product_id — INT — 기본 키 — NOT NULL
  • name — varchar(100)
  • price — INT
  • stock — INT

shipments (Untitled5)

  • shipment_id — INT(PK) — 기본 키 — NOT NULL
  • order_id — INT(FK) — 외래 키 → orders.order_id — NOT NULL
  • address — varchar(50)
  • recipient_name — varchar(10)
  • recipient_phone — varchar(20)
  • shipped_date — DATETIME