북레이 상품 기타등등 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