테스트
테이블 (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