board
Tables (6)
Admin (Untitled)
- id — int — Primary key — NOT NULL
- afreecatv_id — varchar(50) — NOT NULL
- enroll_id — varchar(50)
- enroll_date — datetime — NOT NULL
Image (Untitled2)
- id — int — Primary key — NOT NULL
- post_id — int — Foreign key → Post.id — NOT NULL
- image_name — varchar(256) — NOT NULL
Post (Untitled3)
- id — int — Primary key — NOT NULL
- is_notice — tinyint — NOT NULL — 공지글 1 일반글 0
- user_name — varchar(50) — NOT NULL — 아프리카tv 유저 ID
- user_id — int — NOT NULL
- title — varchar(50) — NOT NULL
- content — text
- date — datetime — NOT NULL
- up — int — NOT NULL
- visit — int — NOT NULL
- reply_count — int
Post_up (Untitled5)
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- post_id — int — NOT NULL
Reply (CopyOfUntitled3)
- id — int — Primary key — NOT NULL
- post_id — int — Foreign key → Post.id — NOT NULL
- parent_id — int — NOT NULL — 부모의 인덱스
- type — varchar(10) — NOT NULL — 게시글인지, 댓글인지, 답글인지 판단
- content — text — NOT NULL
- image_name — varchar(256)
- user_id — int — NOT NULL
- user_name — varchar(50) — NOT NULL — 사용자 닉네임
- is_admin — tinyint — NOT NULL
- date — datetime — NOT NULL
- up — int — NOT NULL
- rereply_count — int
Reply_up (CopyOfUntitled5)
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- reply_id — int — NOT NULL
- type — varchar(10)