newsFeed-project

Tables (4)

board

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • contents — VARCHAR(500) — NOT NULL
  • image — LONGBLOB
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

comment

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • board_id — BIGINT — Foreign key → board.id — NOT NULL
  • contents — VARCHAR(200) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)

friend

  • id — BIGINT — Primary key — NOT NULL
  • follower_id — BIGINT — Foreign key → user.id — NOT NULL
  • following_id — BIGINT — Foreign key → user.id — NOT NULL
  • approval — TINYINT — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

user

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • birth — DATETIME(6) — NOT NULL
  • image — LONGBLOB
  • mbti — VARCHAR(4)
  • password — VARCHAR(60) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • deleted_at — DATETIME(6)