newsfeed

테이블 (5)

comment (댓글)

  • comment_id (PK) — BIGINT — 기본 키 — NOT NULL
  • post_id (FK1) — BIGINT — 외래 키 → post.id — NOT NULL
  • user_id (FK2) — BIGINT — 외래 키 → 사용자.id — NOT NULL
  • content (Field) — VARCHAR
  • created_at (Field2) — DATETIME
  • modified_at (Field3) — DATETIME

friendship (친구)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • user_id (FK) — BIGINT — 외래 키 → 사용자.id — NOT NULL
  • deleted (Field) — bit(1)
  • created_at (Field2) — DATETIME
  • modified_at (Field3) — DATETIME
  • deleted_at (Field4) — DATETIME

frined_request (친구요청)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • user_id (FK) — BIGINT — 외래 키 → 사용자.id — NOT NULL
  • deleted (Field) — bit(1)
  • created_at (Field2) — DATETIME
  • modified_at (Field3) — DATETIME
  • deleted_at (Field4) — DATETIME

post (게시글)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • user_id (FK) — BIGINT — 외래 키 → 사용자.id — NOT NULL
  • image_url (Field) — VARCHAR
  • contents (Field2) — VARCHAR
  • created_at (Field3) — DATETIME
  • modified_at (Field4) — DATETIME
  • deleted_at (Field5) — DATETIME
  • num_of_comments (Field6) — BIGINT

사용자 (users)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • 아이디 (email) — VARCHAR
  • profile_image_url (Field4) — VARCHAR
  • email (Field2) — VARCHAR
  • password (Field3) — VARCHAR
  • status_message (Field5) — VARCHAR
  • created_at (Field6) — DATETIME
  • modified_at (Filed7) — DATETIME
  • deleted_at (Filed8) — DATETIME