hanghaePost
Tables (4)
COMMENT (comment)
- COMMENT_ID (comment_id) — BIGINT — Primary key — NOT NULL
- CONTENT (content) — VARCHAR
- USER_ID (user_id) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
- POST_ID (post_id) — BIGINT — Foreign key → POST.POST_ID — NOT NULL
LIKE (like)
- LIKE_ID (like_id) — BIGINT — Primary key — NOT NULL
- POST_ID (post_id) — BIGINT — Foreign key → POST.POST_ID — NOT NULL
- USER_ID (user_id) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
POST (post)
- POST_ID (post_id) — BIGINT — Primary key — NOT NULL
- TITLE (title) — VARCHAR
- CONTENT (content) — VARCHAR
- IMAGE (image) — FILE
- USER_ID (user_id) — BIGINT — Foreign key → USERS.USER_ID — NOT NULL
USERS (users)
- USER_ID (user_id) — BIGINT — Primary key — NOT NULL
- USERNAME (username) — VARCHAR
- PASSWORD (password) — VARCHAR