w6-newsfeed
Tables (6)
Untitled (accounts)
- Key (id) — bigint — Primary key — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (password) — varchar(80) — NOT NULL
- Field (name) — varchar(20) — NOT NULL — 한글 기준 최대 6자
- Field (birthdate) — date
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
Untitled (friends)
- Key (id) — bigint — Primary key — NOT NULL
- Key (from_profile_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (to_profile_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (status) — varchar(20) — NOT NULL — default 'PENDING'
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
Untitled (post_likes)
- Key (id) — bigint — Primary key — NOT NULL
- Key (post_id) — bigint — Foreign key → Untitled2.Key — NOT NULL
- Key (profile_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (profiles)
- Key (id) — bigint — Primary key — NOT NULL
- Key (account_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (nickname) — varchar(25) — NOT NULL — 한글 기준 최대 8자
- Field (profile_img_url) — text
- Field (bio) — varchar(160) — 한글 기준 최대 50자
- Field (friends_count) — int — NOT NULL — default 0
- Field (post_count) — int — NOT NULL — default 0
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
Untitled2 (posts)
- Key (id) — bigint — Primary key — NOT NULL
- Key (profile_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (content) — varchar(4500) — NOT NULL — 한글 기준 최대 1500자
- Field (view_count) — int — NOT NULL — default 0
- Field (comment_count) — int — NOT NULL — default 0
- Field (like_count) — int — NOT NULL — default 0
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
Untitled3 (comments)
- Key (id) — bigint — Primary key — NOT NULL
- Key (profile_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — bigint — Foreign key → Untitled2.Key — NOT NULL
- Field (content) — varchar(600) — NOT NULL — 한글 기준 최대 200자
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL