요기오디오

테이블 (7)

board_blame

  • id — int — 기본 키 — NOT NULL
  • target_type — int — NOT NULL
  • target_id — int — NOT NULL
  • target_user_id — int — NOT NULL
  • user_id — int — NOT NULL
  • blame_count — int
  • blame_reason — varchar(255)
  • status — int
  • created_at — timestamp

board_free

  • id — int — 기본 키 — NOT NULL
  • writer_id — int — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — longtext — NOT NULL
  • hit — int
  • file_path — varchar(255)
  • created_at — timestamp
  • id (id2) — int — 외래 키 → board_blame.id — NOT NULL
  • id (id3) — int — 외래 키 → board_free_comment.id — NOT NULL

board_free_comment

  • id — int — 기본 키 — NOT NULL
  • writer_id — int — NOT NULL
  • board_free_id — int — NOT NULL
  • content — longtext — NOT NULL
  • created_at — timestamp

board_notice

  • id — int — 기본 키 — NOT NULL
  • writer_id — varchar(50) — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — longtext — NOT NULL
  • file_path — varchar(255)
  • created_at — timestamp

board_qna

  • id — int — 기본 키 — NOT NULL
  • writer_id — int — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — longtext — NOT NULL
  • answer_yn — varchar(45)
  • file_path — varchar(255)
  • created_at — timestamp

board_qna_reply

  • id — int — 기본 키 — NOT NULL
  • writer_id — int — NOT NULL
  • board_qna_id — int — NOT NULL
  • content — longtext — NOT NULL
  • created_at — timestamp

cancel

  • cno — int — 기본 키 — NOT NULL
  • id — varchar(45) — NOT NULL
  • pno — varchar(45)
  • amount — varchar(45)
  • date — datetime