요기오디오
테이블 (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