Musinsa

Tables (4)

inbound

  • Key — Primary key — NOT NULL
  • product (ForeignKey) — char
  • quantity (Field3)
  • date (Field4)
  • price (Field5)

inventory

  • Key — Foreign key → product.Key — NOT NULL
  • Key (Key2) — Foreign key → product.Key — NOT NULL
  • Key (Key3) — Foreign key → product.Key — NOT NULL
  • product (ForeignKey) — char
  • quantity (Field3) — int

outbound

  • Key — Primary key — NOT NULL
  • product (ForeignKey)
  • quantity (Field3) — int
  • date (Field)
  • price (Field4)

product

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → inbound.Key — NOT NULL
  • Key (Key3) — Foreign key → outbound.Key — NOT NULL
  • name (Field)
  • code (Field2)
  • description (Field3)
  • price (Field4) — int
  • size (Field5) — char