북레이 상품 기타등등 ERD
테이블 (10)
Untitled (product_ask)
- Key (product_ask_post_id) — int — 기본 키 — NOT NULL
- Key (ISBN) — varchar(30) — 외래 키 → 상품 ( Product.Key — NOT NULL
- Field (product_ask_post_created_at) — date
- Field (product_ask_user_id)
- Field (product_ask_title) — varchar(500)
- Field (product_ask_content) — varchar(10000)
- Field (answer_checker) — boolean
Untitled (subscribe)
- Key (ISBN) — varchar(30) — 외래 키 → 상품 ( Product.Key — NOT NULL
- Field (term) — int
Untitled (Author)
- Key (author_id) — 기본 키 — NOT NULL
- Field (auther_name) — varchar(800)
Untitled (faq)
- Key (faq_id) — int — 기본 키 — NOT NULL
- Field (faq_question) — varchar(500)
- Field (faq_answer) — varchar(10000)
Untitled (notice)
- Key (notice_id) — int — 기본 키 — NOT NULL
- Field (notice_author)
- Field (notice_title) — varchar(500)
- Field (notice_content) — varchar(10000)
- Field (notice_created_ad) — date
Untitled (product_ask_comment)
- Key (comment_id) — int — 기본 키 — NOT NULL
- Key (product_ask_post_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (comment_user_id)
- Field (comment_content) — varchar(2000)
- Field (comment_created_at) — date
Untitled (one_to_one_ask)
- Key (oto_post_id) — int — 기본 키 — NOT NULL
- Field (oto_title) — varchar(500)
- Field (oto_content) — varchar(10000)
- Field (oto_created_at) — date
- Field (oto_answer) — varchar(10000)
- Field2 (oto_answer_user_id)
- Field3 (oto_answer_created_at) — date
Untitled (product_ask_reply)
- Key (reply_id) — int — 기본 키 — NOT NULL
- Key (product_ask_post_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (reply_title) — varchar(500)
- Field (reply_content) — varchar(10000)
- Field (reply_user_id)
- Field (reply_created_at) — date
Untitled (author_product)
- Key (ISBN) — varchar(30) — 외래 키 → 상품 ( Product.Key — NOT NULL
- Key (author_id) — 외래 키 → Untitled.Key — NOT NULL
상품 ( Product (Product)
- Key (ISBN) — varchar(30) — 기본 키 — NOT NULL
- Field2 (category)
- Field (title) — varchar(600)
- Field (chapter) — varchar(10000)
- Field (descript) — varchar(10000)
- Field (publisher) — varchar
- Field (publish_date) — Date
- Field (price) — int
- Field (subscribe) — boolean