practice
Tables (5)
comment (댓글)
- comment_ID (key) — bigint — Primary key — NOT NULL
- POST_ID (Key) — bigint — Foreign key → post_table.POST_ID — NOT NULL
- writer (user_id) — bigint
- content — CHAR
- comment_good_count (.) — bigint
log in (private)
- ID (Key) — bigint — Primary key — NOT NULL
- user_id — NOT NULL
- password — NOT NULL
post_table (게시물)
- POST_ID (Key) — bigint — Primary key — NOT NULL
- poster (user_id) — bigint
- content — NOT NULL
- attached file — ? — NOT NULL
- good_count — bigint
- written_time (when) — bigint
- view_count — bigint
re-comment (대댓글)
- comment_ID (key) — bigint — Primary key — NOT NULL
- comment_ID (key2) — bigint — Foreign key → comment.comment_ID — NOT NULL
- POST_ID (Key) — bigint — Foreign key → comment.POST_ID — NOT NULL
- writer (user_id) — bigint
- content — CHAR
user
- ID (Key) — bigint — Primary key — NOT NULL
- user_id — NOT NULL
- password — NOT NULL
- user_role — CHAR — NOT NULL
- activity — CHAR
- user_title — CHAR
- background (picture) — PNG
- weed — NOT NULL
- Hashtag (hashtag) — CHAR
- user_post — bigint
- user_comment (comment) — bignit
- user_profile (user_picture) — PNG
- user_email (email) — NOT NULL
- enabled — bit