wanted-market

Tables (3)

Member (Untitled)

  • id (Key) — integer — Primary key — NOT NULL
  • email (Field) — varchar(50)
  • password (Field2) — varchar(100)
  • name (Field3) — varchar(50)
  • nickname (Field4) — varchar(50)
  • create_at (Field5) — timestamp
  • update_at (Field6) — timestamp
  • deleted_at (Field7) — timestamp

Order (Untitled3)

  • id (Key3) — integer — Primary key — NOT NULL
  • buyer_id (Key) — integer — Foreign key → Member.id — NOT NULL
  • post_id (Key2) — integer — Foreign key → Post.id — NOT NULL
  • price (Field) — integer
  • order_state (Field2) — varchar(1)
  • create_at (Field3) — timestamp

Post (Untitled2)

  • id (Key) — integer — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • price (Field3) — integer
  • quantity (Field4) — integer
  • product_state (Field5) — varchar(1)
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp
  • deleted_at (Field8) — timestamp
  • seller_seq (Key2) — integer — Foreign key → Member.id — NOT NULL