스터디 모임 플랫폼

테이블 (17)

boards

  • borad_id (id) — BIGINT — 기본 키
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

category

  • category_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100)
  • created_at — DATETIME
  • updated_at — DATETIME
  • study_groups_id (id2) — BIGINT — 외래 키 → study_groups.study_groups_id
  • post_id (id3) — BIGINT — 외래 키 → posts.post_id
  • question_id (id4) — BIGINT — 외래 키 → qna_questions.question_id

chat_messages

  • chat_message_id (id) — BIGINT — 기본 키
  • message — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id (id2) — BIGINT — 외래 키 → users.user_id
  • chat_room_id (id3) — BIGINT — 외래 키 → chat_rooms.chat_room_id

chat_rooms

  • chat_room_id (id) — BIGINT — 기본 키
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

comments

  • comment_id (id) — BIGINT — 기본 키
  • content — TEXT — NOT NULL
  • parent_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME
  • post_id (id2) — BIGINT — 외래 키 → posts.post_id
  • user_id (id3) — BIGINT — 외래 키 → users.user_id

elastic_fail_log

  • id — BIGINT — 기본 키 — NOT NULL
  • postId — INT
  • operation_type — ENUM
  • errorMessage — VARCHAR
  • retryCount — INT
  • createdAt — DATETIME
  • lastRetryAt — DATETIME

post_bookmarks

  • post_id (id2) — BIGINT — 기본 키
  • user_id (id) — BIGINT — 기본 키
  • created_at — DATETIME

post_likes

  • user_id (Key) — 기본 키 — NOT NULL
  • post_id (Key2) — 기본 키 — NOT NULL
  • created_at — DATETIME

posts

  • post_id (id) — BIGINT — 기본 키
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • view_count — INT
  • like_count — INT
  • post_type — TEXT
  • comment_count — INT
  • isPinned — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • borad_id (id2) — BIGINT — 외래 키 → boards.borad_id
  • user_id (id3) — BIGINT — 외래 키 → users.user_id
  • study_groups_id (id4) — BIGINT — 외래 키 → study_groups.study_groups_id

qna_answers

  • answer_id (id) — BIGINT — 기본 키
  • content — TEXT — NOT NULL
  • is_accepted — TINYINT(1)
  • like_count — INT
  • author_type — ENUM("AI","USER")
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id (id2) — BIGINT — 외래 키 → users.user_id
  • question_id (id3) — BIGINT — 외래 키 → qna_questions.question_id

qna_questions

  • question_id (id) — BIGINT — 기본 키
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — BIGINT
  • answer_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id (id2) — BIGINT — 외래 키 → users.user_id
  • study_groups_id (id3) — BIGINT — 외래 키 → study_groups.study_groups_id

study_groups

  • study_groups_id (id) — BIGINT — 기본 키
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • current_members — INT
  • max_members — INT
  • type — ENUM(카테고리)
  • status — ENUM
  • created_at — DATETIME
  • updated_at — DATETIME

study_members

  • id — BIGINT — 기본 키
  • role — ENUM('LEADER', 'MEMBER')
  • join_date — DATETIME
  • last_modified_date — DATETIME
  • status — ENUM('ACTIVE',' INACTIVE')
  • user_id (id2) — BIGINT — 외래 키 → users.user_id
  • study_groups_id (id3) — BIGINT — 외래 키 → study_groups.study_groups_id

todo_user

  • todo_user_id — BIGINT — 기본 키 — NOT NULL
  • todo_id (id) — BIGINT — 외래 키 → todos.todo_id
  • user_id (id2) — BIGINT — 외래 키 → users.user_id

todos

  • todo_id (id) — BIGINT — 기본 키
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • due_date — DATETIME
  • todo_status — ENUM
  • is_all_members — TINYINT(1)
  • created_at — DATETIME
  • updated_at — DATETIME
  • study_groups_id (id3) — BIGINT — 외래 키 → study_groups.study_groups_id

user_chat_room

  • user_chat_room_id (id) — 기본 키 — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id (id2) — BIGINT — 외래 키 → users.user_id
  • chat_room_id (id3) — BIGINT — 외래 키 → chat_rooms.chat_room_id

users

  • user_id (id) — BIGINT — 기본 키
  • username — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image_url — VARCHAR(255)
  • user_status — VARCHAR(100)
  • role — VARCHAR(100)
  • created_at — DATETIME
  • updated_at — DATETIME