Motif
Tables (10)
ChatRooms
- chatroom_id — bigint
- chatroom_limit — int — NOT NULL
- chatroom_name — varchar(20) — NOT NULL
- is_deleted — boolean — NOT NULL
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
Chats
- chat_id — bigint
- chatroom_id — bigint — Foreign key → ChatRooms.chatroom_id — NOT NULL
- member_id — bigint — Foreign key → Members.member_id — NOT NULL
- message — text — NOT NULL
- is_deleted — boolean — NOT NULL
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
Comments
- comment_id — bigint
- post_id — bigint — Foreign key → Posts.post_id — NOT NULL
- member_id — bigint — Foreign key → Members.member_id — NOT NULL
- parents_id — bigint — Foreign key → Comments.comment_id
- contents — text — NOT NULL
- is_deleted — boolean — NOT NULL
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
Images
- image_id — bigint
- post_id — bigint — Foreign key → Posts.post_id — NOT NULL
- original_name — varchar(255) — NOT NULL
- stored_name — varchar(255) — NOT NULL
- image_url — varchar(255) — NOT NULL
- is_deleted — boolean — NOT NULL
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
Likes
- like_id — bigint
- post_id — bigint — Foreign key → Posts.post_id — NOT NULL
- member_id — bigint — Foreign key → Members.member_id — NOT NULL
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
Members
- member_id — BIGINT
- username — VARCHAR(30) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile_img — VARCHAR(255)
- is_deleted — boolean — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
- modifiedAt — TIMESTAMP — NOT NULL
- INDEX — (email)
Posts
- post_id — bigint
- member_id — bigint — Foreign key → Members.member_id — NOT NULL
- contents — text — NOT NULL
- is_deleted — boolean — NOT NULL
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
RefreshTokens
- token_id — BIGINT
- token_value — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — Foreign key → Members.email — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
- modifiedAt — TIMESTAMP — NOT NULL
Schedules
- schedule_id — bigint
- timetable_id — bigint — Foreign key → TimeTables.timetable_id — NOT NULL
- name — varchar(20) — NOT NULL
- category — varchar(10) — NOT NULL
- latitude — double — NOT NULL
- longitude — double — NOT NULL
- start_time — timestamp — NOT NULL
- end_time — timestamp — NOT NULL
- color_code — char(7) — NOT NULL
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL
TimeTables
- timetable_id — bigint
- member_id — bigint — Foreign key → Members.member_id — NOT NULL
- timetable_name — varchar(30) — NOT NULL
- date — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
- createdAt — timestamp — NOT NULL
- modifiedAt — timestamp — NOT NULL