a

Tables (16)

comment

  • id — bigint — Primary key — NOT NULL
  • content — varchar(100) — NOT NULL — 댓글 내용
  • user_id — bigint — Foreign key → user.id
  • post_id — bigint — Foreign key → post.id
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

dm

  • id — bigint — Primary key — NOT NULL
  • message — varchar(255) — NOT NULL
  • sender_id — bigint — Foreign key → user.id
  • receiver_id — bigint — Foreign key → user.id
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

friend

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id
  • friend_id — bigint — Foreign key → user.id
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

game

  • id — bigint — Primary key — NOT NULL
  • mode — tinyint — NOT NULL
  • name — varchar(100) — NOT NULL
  • password — varchar(20)
  • limit — tinyint — NOT NULL
  • owner_id — bigint — Foreign key → user.id
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

game_member

  • id — bigint — Primary key — NOT NULL
  • game_id — bigint — Foreign key → game.id
  • user_id — bigint — Foreign key → user.id
  • game_role_id — tinyint — Foreign key → game_role.id
  • score — tinyint — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

game_role

  • id — tinyint — Primary key — NOT NULL
  • role — enum('CITIZEN','MAFIA','DOCTOR','POLICE') — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

image

  • id — varchar(36) — Primary key — NOT NULL
  • originalName — varchar(255) — NOT NULL
  • encoding — varchar(255) — NOT NULL
  • mimeType — varchar(255) — NOT NULL
  • size — decimal(10,2) — NOT NULL
  • url — varchar(255) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

notification

  • uuid — varchar(36) — Primary key — NOT NULL
  • type — enum('COMMENT','COMMENT_COMMENT','COMMENT_COMMENT_MENTION','DM','REQUESTED_FRIEND','RECEIVED_FRIEND','INVITED_GAME','SYSTEM') — NOT NULL
  • data — varchar(255) — NOT NULL
  • user_id — bigint — Foreign key → user.id
  • target_id — bigint — Foreign key → user.id
  • read — tinyint — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

post

  • id — bigint — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • post_category_id — tinyint — Foreign key → post_category.id
  • user_id — bigint — Foreign key → user.id
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

post_category

  • id — tinyint — Primary key — NOT NULL
  • name — varchar(10) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

profile

  • id — bigint — Primary key — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • image — varchar(255)
  • self_introduction — varchar(255)
  • manner — int — NOT NULL
  • level — int — NOT NULL
  • exp — int — NOT NULL
  • user_id — bigint — Foreign key → user.id
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

recommendation

  • id — bigint — Primary key — NOT NULL
  • post_id — bigint — Foreign key → post.id
  • user_id — bigint — Foreign key → user.id
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

report

  • id — bigint — Primary key — NOT NULL
  • report_category_id — tinyint — Foreign key → report_category.id
  • content — text — NOT NULL
  • user_id — bigint — Foreign key → user.id
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

report_category

  • id — tinyint — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

user

  • id — bigint — Primary key — NOT NULL
  • social_id — varchar(255) — NOT NULL
  • provider — enum('KAKAO','NAVER','GOOGLE') — NOT NULL
  • role — tinyint — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)

view

  • id — bigint — Primary key — NOT NULL
  • hit — int — NOT NULL
  • post_id — bigint — Foreign key → post.id
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • deletedAt — datetime(6)