logi-d
Tables (7)
inventory (Untitled3)
- id (Key) — Primary key — NOT NULL
- quantity (Field) — bigint
- product_id (Key2) — bigInt — Foreign key → product.id — NOT NULL
- id (Key3) — bigint — Foreign key → warehouse.id — NOT NULL
order (Untitled4)
- id (Key) — Primary key — NOT NULL
- status (Field)
- created_at (Field2)
- updated_at (Field3)
orderItem (Untitled5)
- id (Key) — Primary key — NOT NULL
- quantity (Field)
- id (Key2) — Foreign key → order.id — NOT NULL
- id (Key3) — bigInt — Foreign key → product.id — NOT NULL
product (Untitled)
- id (Key) — bigInt — Primary key — NOT NULL
- name (Field) — varchar
- status (Field2)
- sku (Field3) — varchar
- status (Field4)
- create_at (Field5)
- update_at (Field6)
shipment (Untitled7)
- id (Key) — Primary key — NOT NULL
- status (Field)
- shipped_at (Field2)
- delevered_at (Field3)
- id (Key2) — Foreign key → order.id — NOT NULL
user (Untitled6)
- id (Key) — Primary key — NOT NULL
- name (Field)
- email (Field2)
- pw (Field3)
- status (Field4)
- created_at (Field5)
- updated_at (Field6)
warehouse (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field)
- location (Field2)
- status (Field3)
- created_at (Field4)
- updated_at (Field5)