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