Roomy

Tables (10)

bookmark

  • bookmark_id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • community_id — bigint — Foreign key → community.community_id — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL

comments

  • comment_id — bigint — Primary key — NOT NULL — 댓글 번호
  • content — text — NOT NULL — 댓글 내용
  • created_at — datetime(6) — 작성 시간
  • updated_at — datetime(6) — 수정 시간
  • user_id — bigint — Foreign key → user.id — NOT NULL — 작성자
  • community_id — bigint — Foreign key → community.community_id — NOT NULL — 커뮤니티 글 번호

community

  • community_id — bigint — Primary key — NOT NULL — 게시판 번호
  • content — text — NOT NULL — 내용
  • created_at — datetime(6) — 작성 시간
  • title — varchar(255) — NOT NULL — 제목
  • type — varchar(255) — NOT NULL — 커뮤니티 타입
  • updated_at — datetime(6) — 수정 시간
  • views — int — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL — 작성자
  • file_group_id — bigint — Foreign key → file_group.file_group_id

file_group

  • file_group_id — bigint — Primary key — NOT NULL

images

  • image_id — bigint — Primary key — NOT NULL
  • image_url — varchar(255) — NOT NULL
  • file_group_id — bigint — Foreign key → file_group.file_group_id — NOT NULL

likes

  • id — bigint — Primary key — NOT NULL
  • is_liked — int — NOT NULL
  • community_id — bigint — Foreign key → community.community_id — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL

notification_entity

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • message — varchar(255)
  • sender_id — bigint — Foreign key → user.id — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL

replies

  • reply_id — bigint — Primary key — NOT NULL — 대댓글 번호
  • content — text — NOT NULL — 대댓글 내용
  • created_at — datetime(6) — 작성 시간
  • updated_at — datetime(6) — 수정 시간
  • user_id — bigint — Foreign key → user.id — NOT NULL — 작성자
  • comment_id — bigint — Foreign key → comments.comment_id — NOT NULL — 부모 댓글 번호

report

  • id — bigint — Primary key — NOT NULL
  • local_date_time — datetime(6)
  • report_reason — varchar(255)
  • type — varchar(255)
  • comment_id — bigint — Foreign key → comments.comment_id
  • community_id — bigint — Foreign key → community.community_id
  • reported_id — bigint — Foreign key → user.id
  • reporter_id — bigint — Foreign key → user.id

user

  • id — bigint — Primary key — NOT NULL
  • report_count — int — NOT NULL
  • area — varchar(255)
  • email — varchar(255)
  • fcm_token — varchar(2048)
  • gender — varchar(255)
  • password — varchar(255)
  • profile — varchar(255)
  • provider — varchar(255)
  • refresh_token — varchar(255)
  • role — enum('ADMIN','MEMBER')
  • socail_id — varchar(255)
  • status — enum('ACTIVITY','BAN')
  • username — varchar(255)