ㅁㄴㅇㄹ
Tables (12)
Bookmark
- id — SERIAL
- user_id — INTEGER
- post_id — INTEGER
- created_at — TIMESTAMP
Category
- id — SERIAL
- name — VARCHAR(25) — NOT NULL
- slug — VARCHAR(200) — NOT NULL
- is_public — BOOLEAN
- created_at — TIMESTAMP
- updated_at — DATE
Comment
- id — SERIAL
- post_id — INTEGER
- author_id — INTEGER
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- parent_comment_id — INTEGER
Comment_Likes
- id — SERIAL
- comment_id — INTEGER
- user_id — INTEGER
Notification
- id — SERIAL
- user_id — INTEGER
- content — VARCHAR(255) — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMP
Post
- id — SERIAL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- head_image — VARCHAR(100)
- file_upload — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- author_id — INTEGER
- category_id — INTEGER
- view_count — INTEGER
- birthday — DATE
- location — VARCHAR(100)
Post_Likes
- id — SERIAL
- post_id — INTEGER
- user_id — INTEGER
Post_Tags
- id — SERIAL
- post_id — INTEGER
- tag_id — INTEGER
Profile
- id — SERIAL
- user_id — INTEGER
- bio — TEXT
- location — VARCHAR(30)
- birth_date — DATE
- profile_picture — VARCHAR(100)
- followers — INTEGER
Profile_Followers
- id — SERIAL
- profile_id — INTEGER
- follower_id — INTEGER
Tag
- id — SERIAL
- name — VARCHAR(50) — NOT NULL
- slug — VARCHAR(100) — NOT NULL
User
- id — SERIAL
- username — VARCHAR(150) — NOT NULL
- email — VARCHAR(254)
- password — VARCHAR(128) — NOT NULL