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)