NewsFeed
Tables (5)
Posts (게시글)
- id (게시글키) — bigint — Primary key — NOT NULL
- profile_id (프로필키) — bigint — Foreign key → profiles.id — NOT NULL
- id (계정키) — bigint — Foreign key → profiles.account_id — NOT NULL
- content (글내용) — varchar(1500)
- view_count (기본 0) — int
- comment_count (0) — int
- like_count (좋아요수(기본 0)) — int
- created_at (생성일자) — datetime
- updated_at (수정일자) — datetime
accounts (Untitled3)
- id (계정키) — bigint — Primary key — NOT NULL
- email (이메일) — varchar(255)
- password (비밀번호) — varchar(80)
- name (이름) — varchar(80)
- birthdate (생년월일) — date
- created_at (생성일자) — datetime
- updated_at (수정일자) — datetime
comments (Untitled4)
- id (댓글키) — bigint — Primary key — NOT NULL
- post_id (게시글키) — bigint — Foreign key → Posts.id — NOT NULL
- profile_id (프로필키) — bigint — Foreign key → Posts.profile_id — NOT NULL
- account_id (계정키2) — bigint — Foreign key → profiles.account_id — NOT NULL
- content (댓글내용) — varchar(600)
- created_at (생성일자) — datetime
- updated_at (수정일자) — datetime
post likes (Untitled)
- Key (좋아요키) — bigint — Primary key — NOT NULL
- post_id (게시글키) — bigint — Foreign key → Posts.id — NOT NULL
- id (프로필키) — bigint — Foreign key → profiles.id — NOT NULL
- id (프로필키2) — bigint — Foreign key → Posts.profile_id — NOT NULL
- id (계정키) — bigint — Foreign key → profiles.account_id — NOT NULL
profiles (Untitled2)
- id (프로필키) — bigint — Primary key — NOT NULL
- account_id (계정키) — bigint — Foreign key → accounts.id — NOT NULL
- nickname (닉네임) — varchar(25)
- profileImg (프로필 이미지)
- bio (자기소개) — varchar(160)
- friends_count (친구수) — int
- post_count (게시글 수) — int
- created_at (생성일자) — datetime
- updated_at (수정일자) — datetime