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)