blog

Tables (3)

Member (Untitled)

  • member_id (Key) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR
  • email (이메일) — VARCHAR
  • phone (전화번호) — VARCHAR

Order (Untitled3)

  • order_id (주문 고유 ID) — BIGINT — Primary key — NOT NULL
  • member_id (Key) — BIGINT — Foreign key → Member.member_id — NOT NULL
  • product_id (Key2) — BIGINT — Foreign key → Product.product_id — NOT NULL
  • order_date (주문 날짜) — DATETIME

Product (Untitled2)

  • product_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • price (Field2) — INT
  • stock (Field3) — INT