BizMakes

Tables (10)

Product (PRODUCT)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (CATEGORY_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (NAME) — VARCHAR(100) — NOT NULL
  • Field (DESCRIPTION) — VARCHAR(1000)

ProductOption (PRODUCT_OPTION_KEY)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(100)

Untitled (PRODUCT_OPTION_VALUE)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (OPTION_ITEM_ID) — BIGINT — Foreign key → ProductOption.Key — NOT NULL
  • Field (NAME) — VARCHAR(100)

Untitled (PRODUCT_OPTION)

  • Key (PRODUCT_ID) — BIGINT — Foreign key → Product.Key — NOT NULL
  • Key (OPTION_VALUE_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (OPTION_COMBINATION)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (PRODUCT_ID) — BIGINT — Foreign key → Product.Key — NOT NULL
  • Field (PRICE) — BIGINT — NOT NULL
  • Field (ACTIVE) — CHAR(1) — NOT NULL

Untitled (PRODUCT_CATEGORY)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(50) — NOT NULL

Untitled (CART_ITEM)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (USER_ID) — BIGINT — Foreign key → User.Key — NOT NULL
  • Key (PRODUCT_ID) — BIGINT — Foreign key → Product.Key — NOT NULL
  • Key (ORDER_ID) — BIGINT — Foreign key → Untitled.Key
  • Key (OPTION_COMBINATION_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (QUANTITY) — INT — NOT NULL
  • Field (STATUS) — INT — NOT NULL
  • Field (CREATED_AT) — TIMESTAMP — NOT NULL
  • Field (UPDATED_AT) — TIMESTAMP — NOT NULL
  • Field (DELETED_AT) — TIMESTAMP

Untitled (ORDERS)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (USER_ID) — BIGINT — Foreign key → User.Key — NOT NULL
  • Field (STATUS) — INT — NOT NULL
  • Field (CREATED_AT) — TIMESTAMP — NOT NULL
  • Field2 (UPDATED_AT) — TIMESTAMP — NOT NULL

Untitled (OPTION_COMBINATION_ITEM)

  • Key (OPTION_VALUE_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (OPTION_COMBINATION_ID) — BIGINT — Foreign key → Untitled.Key — NOT NULL

User (USER)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Key (EMAIL) — VARCHAR(320) — NOT NULL
  • Key (PROVIDER) — VARCHAR(50) — NOT NULL
  • Field (NAME) — VARCHAR(30) — NOT NULL
  • Field (ENCODED_PASSWORD) — VARCHAR(200) — NOT NULL
  • Field (PHONE_NUMBER) — VARCHAR(20)
  • Field (ADDRESS) — VARCHAR(100)
  • Field (CREATED_AT) — TIMESTAMP — NOT NULL
  • Field2 (UPDATED_AT) — TIMESTAMP — NOT NULL
  • Field (DELETED_AT) — TIMESTAMP