ㄴㄴ
Tables (9)
app_user
- user_id — INTEGER
- username — VARCHAR(20) — NOT NULL
- password — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP
comment
- comment_id — int
- content — text — NOT NULL
- user_id — INT — NOT NULL
- post_id — INT — NOT NULL
comment_likes
- like_id — INT
- user_id — INT — NOT NULL
- comment_id — INT — NOT NULL
comments
- comment_id — INTEGER
- likes — INT — NOT NULL
- dislikes — INT — NOT NULL
- user_id — INT — Foreign key → app_user.user_id — NOT NULL
- post_id — INT — Foreign key → post.post_id — NOT NULL
- created_at — TIMESTAMP
follow
- follow_id — INT — NOT NULL
- following_id — INT — NOT NULL
image
- img_id — INT
- img_name — VARCHAR(30)
- post_id — INT — NOT NULL
post
- post_id — INTEGER
- author — INT — Foreign key → app_user.user_id — NOT NULL
- likes — INT — NOT NULL
- views — INT — NOT NULL
- title — VARCHAR(30) — NOT NULL
- content — VARCHAR(2000) — NOT NULL
- created_at — TIMESTAMP
post_likes
- like_id — INT
- user_id — INT — NOT NULL
- post_id — INT — NOT NULL
user
- user_id — INT
- name — VARCHAR(10) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(13) — NOT NULL
- gender — VARCHAR(10)
- birthday — VARCHAR(20)
- user_img — VARCHAR(30)