commer-backend

Tables (8)

CATEGORY

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

COUPON

  • id — BIGINT
  • product_id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • discount_rate — DECIMAL(19, 2) — NOT NULL
  • discount_type — VARCHAR(20) — NOT NULL
  • expired_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

LIKE

  • id — BIGINT
  • product_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • count — INT
  • created_at — TIMESTAMP

PRODUCT

  • id — BIGINT
  • image — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • price — DECIMAL(19, 2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

PRODUCT_CATEGORY

  • id — BIGINT
  • product_id — BIGINT — NOT NULL
  • category_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

PRODUCT_DETAIL

  • id — BIGINT
  • product_id — BIGINT — NOT NULL
  • html_content — LONGTEXT — NOT NULL
  • template_type — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

QNA

  • id — BIGINT
  • product_id — BIGINT — NOT NULL
  • asker_id — BIGINT — NOT NULL
  • answerer_id — BIGINT
  • question — TEXT — NOT NULL
  • answer — TEXT
  • is_answered — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

REVIEW

  • id — BIGINT
  • product_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • rating — INT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP