erd

Tables (4)

item (Untitled2)

  • item_number (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • price (Field2) — integer
  • type (Field3) — varchar
  • start_at (Field4) — timestamp
  • create_at (Field5) — timestamp
  • update_at (Field6) — timestamp

item_info (Untitled3)

  • item_info_number (Key) — bigint — Primary key — NOT NULL
  • item_number (Key2) — bigint — Foreign key → item.item_number — NOT NULL
  • content (Field) — TEXT

order (Untitled)

  • order_id (pk) — varchar — Primary key — NOT NULL
  • item_number (not null) — bigint
  • count (Field2) — int
  • status (Field3) — varchar
  • unit_price (Field4) — int
  • user_number (Field5) — long
  • create_at (Field6) — timestamp
  • update_at (Field7) — timestamp

stock (Untitled4)

  • stock_number (Key) — bigint — Primary key — NOT NULL
  • item_number (Field) — bigint
  • total (Field2) — int