게시물 회원가입
테이블 (4)
comment
- comment_id — int — NOT NULL
- comment_content — varchar(255) — NOT NULL
- comment_date — DATETIME — NOT NULL
- user_id — varchar(255) — 외래 키 → user.user_id — NOT NULL
- post_id — integer — 외래 키 → post.post_id — NOT NULL
like_list
- like_id — integer — NOT NULL
- like_count — integer — NOT NULL
- user_id — varchar(255) — 외래 키 → user.user_id — NOT NULL
- post_id — integer — 외래 키 → post.post_id — NOT NULL
post
- post_id — integer — NOT NULL
- post_title — varchar(255) — NOT NULL
- post_content — longtext — NOT NULL
- post_date — DATETIME — NOT NULL
- count — integer — NOT NULL
- user_id — varchar(255) — 외래 키 → user.user_id — NOT NULL
user
- user_id — varchar(255) — NOT NULL
- user_passwd — varchar(255) — NOT NULL
- user_nickname — varchar(255) — NOT NULL
- user_profile — blob — NOT NULL
- user_hellomsg — varchar(255)