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