ㅁㄴㅇ
Tables (12)
bookmarks
- id — SERIAL
- user_id — INTEGER — NOT NULL
- post_id — INTEGER — NOT NULL
- created_at — TIMESTAMP
categories
- id — SERIAL
- name — VARCHAR(25) — NOT NULL
- slug — VARCHAR(200) — NOT NULL
- is_public — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
comment_likes
- comment_id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Primary key — NOT NULL
comments
- id — SERIAL
- post_id — INTEGER — NOT NULL
- author_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- parent_comment_id — INTEGER
notifications
- id — SERIAL
- user_id — INTEGER — NOT NULL
- content — VARCHAR(255) — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMP
post_likes
- post_id — INTEGER — Primary key — NOT NULL
- user_id — INTEGER — Primary key — NOT NULL
post_tags
- post_id — INTEGER — Primary key — NOT NULL
- tag_id — INTEGER — Primary key — NOT NULL
posts
- id — SERIAL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- head_image — VARCHAR(255)
- file_upload — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- author_id — INTEGER — NOT NULL
- category_id — INTEGER
- view_count — INTEGER
- birthday — DATE
- location — VARCHAR(100)
profile_followers
- profile_id — INTEGER — Primary key — NOT NULL
- follower_id — INTEGER — Primary key — NOT NULL
profiles
- id — SERIAL
- user_id — INTEGER — NOT NULL
- bio — TEXT
- location — VARCHAR(30)
- birth_date — DATE
- profile_picture — VARCHAR(255)
tags
- id — SERIAL
- name — VARCHAR(50) — NOT NULL
- slug — VARCHAR(100) — NOT NULL
users
- id — SERIAL
- username — VARCHAR(150) — NOT NULL
- email — VARCHAR(254)
- password — VARCHAR(128) — NOT NULL