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