bbs

Tables (3)

qna (1:1 문의)

  • qna_id (Key) — BIGINT — Primary key — NOT NULL
  • bbs_id (Key2) — BIGINT — Foreign key → qna_bbs.bbs_qna_id — NOT NULL
  • answer_yn (Field5) — CHAR
  • title (Field2) — VARCHAR
  • content (Field3) — VARCHAR
  • create_datetime (Field4) — DATETIME

qna_answer (1:1 문의 답변)

  • qna_answer_id (Key) — BIGNIT — Primary key — NOT NULL
  • qna_id (Key2) — BIGINT — Foreign key → qna.qna_id — NOT NULL
  • bbs_id (Key22) — BIGINT — Foreign key → qna.bbs_id — NOT NULL
  • content (Field2) — VARCHAR
  • create_datetime (Field3) — DATETIME

qna_bbs (1:1 문의 분류)

  • bbs_qna_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • use_yn (Field2) — CHAR
  • create_datetime (Field3) — DATETIME
  • update_datetime (Field4) — DATETIME