상품 ERD
테이블 (11)
image
- id — INT — 기본 키 — NOT NULL
- product_id — INT — NOT NULL
- image_url — VARCHAR
- is_thumbnail — TINYINT
- sequence_number — SHORT
- create_date — DATETIME
- update_date — DATETIME
product
- id — INT — 기본 키 — NOT NULL
- category — VARCHAR
- price — INT
- stock — INT
- favorite_count — INT
- seller_id — INT — NOT NULL
- is_decaf — TINYINT
- name — VARCHAR(255)
- bean_type — VARCHAR
- Field — VARCHAR
- infomation — LONGTEXT
- status — VARCHAR
- create_date — DATETIME
- update_date — DATETIME
qna
- qna_id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- qna_title — VARCHAR
- qna_content — LONGTEXT
- user_id — BIGINT
- user_name — VARCHAR
- is_answer — TINYINT
- answer_content — VARCHAR
- is_delete — TINYINT
- create_date — DATETIME
- update_date — DATEITIME
qna_category
- qna_category_id — BIGINT — 기본 키 — NOT NULL
- qna_category_name — VARCHAR
review
- id — INT — 기본 키 — NOT NULL
- product_id — INT — NOT NULL
- user_id — INT — NOT NULL
- review_content — LONGTEXT
- grade — DECIMAL(2,1)
- is_deleted — TINYINT
- create_date — DATETIME
- update_date — DATETIME
seller_rep
- id — INT — 기본 키 — NOT NULL
- biz_name — VARCHAR(255)
user_rep
- id — INT — 기본 키 — NOT NULL
- name — VARCHAR
카테고리 (Untitled)
- id — 기본 키 — NOT NULL
- weight — Integer
- id (id3) — INT — 외래 키 → product.id — NOT NULL