25_03_27_OrderERD

Tables (4)

items (Untitled2)

  • id (Key) — BIGINT(10) — Primary key — NOT NULL
  • name (Field) — VARCHAR(100) — NOT NULL
  • category (Field2) — VARCHAR(50)
  • price (Field4) — FLOAT — NOT NULL
  • create_date (Field3) — DATETIME

member

  • id (Key) — BIGINT(10) — Primary key — NOT NULL
  • name (Field) — VARCHAR(20) — NOT NULL
  • password (Field2) — VARCHAR(20) — NOT NULL
  • nickname (Field3) — VARCHAR(30)
  • address (Field4) — VARCHAR(300)
  • join_date (Field5) — DATETIME — NOT NULL

order_item (Untitled3)

  • id (Key3) — BIGINT(10) — Primary key — NOT NULL
  • order_id (Key) — BIGINT(10) — Foreign key → orders.id — NOT NULL
  • item_id (Key2) — BIGINT(10) — Foreign key → items.id — NOT NULL

orders (Untitled)

  • id (Key) — BIGINT(10) — Primary key — NOT NULL
  • member_id (Key2) — BIGINT(10) — Foreign key → member.id — NOT NULL
  • title (Field) — VARCHAR(200) — NOT NULL
  • price (Field2) — FLOAT — NOT NULL
  • create_date (Field3) — DATETIME — NOT NULL