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