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