newsfeed

Tables (6)

Bookmark (북마크)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • id (PK2) — BIGINT — Foreign key → Post.id — NOT NULL

Comment (댓글)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • id (PK3) — BIGINT — Foreign key → Post.id — NOT NULL
  • id (PK2) — BIGINT — Foreign key → User.id — NOT NULL
  • content (내용) — LONGTEXT
  • createdAt (생성일시) — DATETIME
  • updatedAt (수정일시) — DATETIME

Follow (친구)

  • Key — BIGINT — Primary key — NOT NULL
  • my_id (PK) — BIGINT — Foreign key → User.id — NOT NULL

Like (좋아요)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • user_id (사용자) — BIGINT — Foreign key → User.id — NOT NULL
  • post_id (포스트) — BIGINT — Foreign key → Post.id — NOT NULL
  • comment_id (댓글) — BIGINT — Foreign key → Comment.id — NOT NULL

Post (게시글)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • id (PK2) — BIGINT — Foreign key → User.id — NOT NULL
  • title (제목) — VARCHAR(45)
  • content (내용) — LONGTEXT
  • createdAt (생성일시) — DATETIME
  • updatedAt (수정일시) — DATETIME
  • Field

User (사용자)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(45)
  • name (이름) — VARCHAR(45)
  • password (비밀번호) — VARCHAR(45)
  • interest (tag) — VACHAR(255)
  • delete_flag (삭제여부) — BOOLEAN
  • role (역할) — ENUM
  • createdAt (생성일시) — DATETIME
  • updatedAt (수정일시) — DATETIME