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)