user
Tables (5)
board
- index — int — Primary key — NOT NULL
- 작성자 (username) — varchar(255) — Foreign key → users.id — NOT NULL
- 제목 (title) — varchar(255)
- 내용 (content) — varchar(255)
- 파일 이름 (file_name) — varchar(255)
- 날짜 (date) — datetime
- 비밀글 (secret) — bool — 0 : 공개글 1 : 비밀글
- 조회수 (view) — int
- 좋아요 (good) — int
- 싫어요 (bad) — int
- 신고 (report) — bool
- 수정 (modify) — bool — NOT NULL
comment
- com_index — int — Primary key — NOT NULL
- board_index — int — NOT NULL
- parent_index — int
- depth — int — NOT NULL
- username — varchar(255) — NOT NULL
- content — varchar(255) — NOT NULL
- date — datetime — NOT NULL
- secret — bool — NOT NULL
- edit — bool — NOT NULL
good_bad
- board_index — int
- username — varchar(255)
- good — int
- bad — int
manage_view
- board_index — int
- username — varchar(255)
users
- id — varchar(255) — Primary key — NOT NULL
- pw — varchar(255) — NOT NULL
- username — varchar(255)
- email — varchar(255) — NOT NULL — 비밀번호 검증용
- role — int