SOONEBO

Tables (4)

option

  • id — INT — Primary key — NOT NULL
  • value — VARCHAR(100)
  • price — INT
  • isDelete — BOOLEAN

optionList

  • id — INT — Primary key — NOT NULL
  • ProductId — INT — Foreign key → product.id — NOT NULL
  • OptionId — INT — Foreign key → option.id — NOT NULL

product (Product)

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(300)
  • thumbnail — VARCHAR(600)
  • price — INT
  • description — VARCHAR(2000)
  • deliveryPrice — INT
  • descImage — VARCHAR
  • isDelete — BOOLEAN
  • ProductTypeId — INT — Foreign key → productType.id — NOT NULL

productType

  • id — INT — Primary key — NOT NULL
  • value — VARCHAR(100)
  • isDelete — BOOLEAN