news-pid
Tables (9)
Comments (댓글)
- id (Key) — BIGINT — Primary key — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → Posts.id — NOT NULL
- parent_comment_id (Key4) — BIGINT — Foreign key → Comments.id — NOT NULL
- content (Field) — VARCHAR
- created_at (Field2) — TIMESTAMP
Follows (팔로우 관계)
- follower_id (Key) — BIGINT — Foreign key → Users.id — NOT NULL
- followee_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
- created_at (Field) — TIMESTAMP
FriendGroups (친구 그룹)
- id (Key) — BIGINT — Primary key — NOT NULL
- owner_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
- name (Field) — VARCHAR
GroupMembers (그룹 멤버)
- group_id (Key) — BIGINT — Foreign key → FriendGroups.id — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
- Field
Notifications (알림 히스토리)
- id (Key) — BIGINT — Primary key — NOT NULL
- recipient_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
- sender_id (Key3) — BIGINT — Foreign key → Users.id — NOT NULL
- noti_type (Field) — VARCHAR
- target_id (Field2) — BIGINT
- is_read (Field3) — BOOLEAN
- created_at (Field4) — TIMESTAMP
PostImages (게시글별 이미지)
- id (Key) — BIGINT — Primary key — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → Posts.id — NOT NULL
- url (Field) — VARCHAR
- order_index (Field2) — INT
PostLikes (게시글 좋아요)
- id (Key) — BIGINT — Primary key — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → Posts.id — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → Users.id — NOT NULL
- created_at (Field) — TIMESTAMP
Posts (게시물)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
- content (Field) — TEXT
- like_count (Field2) — BIGINT
- comment_count (Field3) — BIGINT
- created_at (Field4) — TIMESTAMP
Users (사용자)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR
- password (Field2) — VARCHAR
- username (Field3) — VARCHAR
- profile_image_url (Field4) — VARCHAR
- created_at (Field5) — TIMESTAMP