테스트

테이블 (25)

banned_team_member

  • ban_id — BIGINT — 기본 키 — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • banned_at — DATETIME

invite

  • invite_id — BIGINT — 기본 키 — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • code — VARCHAR(10) — UNIQUE
  • status — VARCHAR(10) — EXPIRED : 만료 VALID : 유효
  • created_at — DATETIME
  • expired_at — DATETIME — 생성일자 + 24h

meeting

  • meeting_id — BIGINT — 기본 키 — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • series_id — BIGINT — 외래 키 → meeting_series.series_id — 일회성 회의는 NULL
  • meeting_type — VARCHAR(30) — NOT NULL — INITIAL_REGULAR / ADDITIONAL_ONE_TIME / ADDITIONAL_RECURRING
  • title — VARCHAR(255) — NOT NULL
  • location — VARCHAR(255) — 선택 정보
  • start_time — DATETIME — NOT NULL — UTC 저장
  • end_time — DATETIME — NOT NULL — UTC 저장
  • duration_minutes — INT — NOT NULL
  • meeting_date — DATE — NOT NULL
  • is_individually_modified — TINYINT(1) — NOT NULL
  • creator_name — VARCHAR(50) — NOT NULL — 스냅샷
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

meeting_participant

  • participant_id — BIGINT — 기본 키 — NOT NULL
  • meeting_id — BIGINT — 외래 키 → meeting.meeting_id — NOT NULL — ON DELETE CASCADE
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL — ON DELETE CASCADE
  • created_at — DATETIME — NOT NULL

meeting_series

  • series_id — BIGINT — 기본 키 — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • meeting_type — VARCHAR(30) — NOT NULL — INITIAL_REGULAR / ADDITIONAL_RECURRING
  • day_of_week — VARCHAR(3) — NOT NULL — MON/TUE/WED/THU/FRI/SAT/SUN
  • default_start_time — TIME — NOT NULL
  • default_duration_minutes — INT — NOT NULL
  • creator_name — VARCHAR(50) — NOT NULL — 스냅샷
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

member_rule_vote

  • rule_vote_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → team_member.member_id — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • rule_template_id — BIGINT — 외래 키 → rule_template.rule_template_id — NOT NULL
  • is_agree — TINYINT(1)

member_tool_vote

  • tool_vote_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → team_member.member_id — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • tool_template_id — BIGINT — 외래 키 → tool_template.tool_template_id — NOT NULL
  • category_id — BIGINT — 외래 키 → tool_category.category_id — NOT NULL

notification

  • notification_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • target_id — BIGINT
  • type — VARCHAR(30)
  • title — VARCHAR(100)
  • message — VARCHAR(255)
  • is_read — TINYINT(1)
  • created_at — DATETIME

rule_template

  • rule_template_id — BIGINT — 기본 키 — NOT NULL
  • rule_content — VARCHAR(255)

social_account

  • social_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • provider — VARCHAR(10)
  • provider_id — VARCHAR(255)
  • email — VARCHAR(255)

team_member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • role — VARCHAR(10) — LEADER : 팀장 HOST : 방장 MEMBER : 팀원
  • created_at — DATETIME
  • updated_at — DATETIME

team_room

  • team_room_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255)
  • description — VARCHAR(255)
  • deadline — DATETIME — NOT NULL
  • lifecycle — VARCHAR(20) — lifecycle 추적 ACTIVE : 운영중 DELETE : 방 삭제 ARCHIVE : 프로젝트 종료
  • phase(이름 — 변경)` — 설정 중 / 완료 뱃지 표기는 백엔드 애플리케이션에서 처리 (COMPLETE가 아니면 false) <단계별 표시> PENDING : 대기 중 LEADER_SELECTION : 팀
  • banner_image_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

team_room_setup

  • setup_id — BIGINT — 기본 키 — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • tool_completed — TINYINT(1)
  • rule_completed — TINYINT(1)
  • meeting_completed — TINYINT(1) — false
  • created_at — DATETIME — 회의 정하기 완료 시 생성
  • deadline — DATETIME — 생성 시각 + 6시간

team_rule

  • rule_id — BIGINT — 기본 키 — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • content — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

team_tool

  • tool_id — BIGINT — 기본 키 — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • tool_name — VARCHAR(255)
  • created_at — DATETIME

team_tool_proposal

  • proposal_id — BIGINT — 기본 키 — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL
  • requested_by — BIGINT — 외래 키 → team_member.member_id — NOT NULL
  • tool_name — VARCHAR(255)
  • is_approval — TINYINT(1)
  • created_at — DATETIME
  • decided_at — DATETIME

term

  • terms_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(100)
  • content — TEXT
  • version — VARCHAR(50)
  • is_mandatory — TINYINT(1)
  • created_at — DATETIME

time_pick

  • time_pick_id — BIGINT — 기본 키 — NOT NULL
  • team_room_id — BIGINT — 외래 키 → team_room.team_room_id — NOT NULL — UNIQUE
  • status — VARCHAR(20) — NOT NULL — OPEN / FINALIZED
  • deadline — DATETIME — NOT NULL — 팀장 확정 + 3시간
  • created_at — DATETIME — NOT NULL
  • finalized_at — DATETIME

time_pick_participant

  • time_pick_participant_id — BIGINT — 기본 키 — NOT NULL
  • time_pick_id — BIGINT — 외래 키 → time_pick.time_pick_id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL — ON DELETE CASCADE
  • status — VARCHAR(20) — NOT NULL — PENDING / SUBMITTED / EXPIRED
  • preferred_block — VARCHAR(20) — BLOCK_08_12 / BLOCK_12_16 / BLOCK_16_20 / BLOCK_20_24
  • availability_mon — INT — 비트맵
  • availability_tue — INT — 비트맵
  • availability_wed — INT — 비트맵
  • availability_thu — INT — 비트맵
  • availability_fri — INT — 비트맵
  • availability_sat — INT — 비트맵
  • availability_sun — INT — 비트맵
  • submitted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

tool_category

  • category_id — BIGINT — 기본 키 — NOT NULL
  • category_name — VARCHAR(20)

tool_template

  • tool_template_id — BIGINT — 기본 키 — NOT NULL
  • category_id — BIGINT — 외래 키 → tool_category.category_id — NOT NULL
  • tool_name — VARCHAR(255)

user

  • user_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL — not null
  • email — VARCHAR(50) — NOT NULL — not null
  • profile_image_url — VARCHAR(255)
  • major — VARCHAR(50)
  • mbti — CHAR(4)
  • is_alarm_on — TINYINT(1)
  • created_at — DATETIME
  • updated_at — DATETIME

userDevice

  • fcm_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • fcm_token — VARCHAR(512)
  • device_type — VARCHAR(20)
  • last_active_at — DATETIME — 활동이 없는 기기에 알림을 보내지 않기 위해 필요. 일정 기간 이후 삭제하기 위함.

user_agreement

  • agreement_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
  • terms_id — BIGINT — 외래 키 → term.terms_id — NOT NULL
  • is_agreed — TINYINT(1)
  • agreed_at — DATETIME

user_time_pick_default

  • default_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.user_id — NOT NULL — UNIQUE, ON DELETE CASCADE
  • preferred_block — VARCHAR(20) — BLOCK_08_12 / BLOCK_12_16 / BLOCK_16_20 / BLOCK_20_24
  • availability_mon — INT — 비트맵
  • availability_tue — INT — 비트맵
  • availability_wed — INT — 비트맵
  • availability_thu — INT — 비트맵
  • availability_fri — INT — 비트맵
  • availability_sat — INT — 비트맵
  • availability_sun — INT — 비트맵
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME