sns

Tables (5)

BOARD (CopyOfUntitled)

  • content_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key3) — INT — Foreign key → MEMBER.id — NOT NULL
  • content (Field)
  • created_at (Field5)
  • modified_at (Field6)

COMMENT (CopyOfCopyOfUntitled)

  • comment_id (Key) — INT — Primary key — NOT NULL
  • content_id (Key2) — INT — Foreign key → BOARD.content_id — NOT NULL
  • user_id (Key3) — INT — Foreign key → MEMBER.id — NOT NULL
  • comment (Field)
  • createdAt (Field5)
  • modified_at (Field6)

FOLLOW (Untitled2)

  • follow_id (Key) — Primary key — NOT NULL
  • following_id (Key2) — INT — Foreign key → MEMBER.id — NOT NULL
  • follower_id (Key3) — INT — Foreign key → MEMBER.id — NOT NULL
  • created_at (Field)
  • modified_at (Field2)

LIKES (Untitled3)

  • like_id (Key4) — INT — Primary key — NOT NULL
  • board_id (Key2) — INT — Foreign key → BOARD.content_id — NOT NULL
  • comment_id (Key3) — INT — Foreign key → COMMENT.comment_id — NOT NULL
  • id (Key) — INT — Foreign key → MEMBER.id — NOT NULL

MEMBER (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • user_name (Field3)
  • password (Field2)
  • profileImageUrl (Field4)
  • created_at (Field5)
  • modified_at (Field6)