palnslot
Tables (28)
AdminReport
- report_id — BIGINT — Primary key — NOT NULL
- reporter_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- group_target_id — BIGINT — Foreign key → GroupReport.report_id
- board_target_id — BIGINT — Foreign key → BoardReport.report_id
- source_type — VARCHAR(20) — NOT NULL
- reason_category — VARCHAR(50) — NOT NULL
- reason_detail — TEXT
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
AdminSanction
- sanction_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- accumulated_count — INT — NOT NULL
- source_type — VARCHAR(20) — NOT NULL
- source_report_id — BIGINT — NOT NULL
- reason — VARCHAR(255) — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
AiImageSchedule
- ai_image_schedule_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- prompt_type — VARCHAR(10) — NOT NULL
- prompt_text — VARCHAR(500) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- extracted_title — VARCHAR(50)
- extracted_start_date — DATETIME
- extracted_end_date — DATETIME
- extracted_location — VARCHAR(200)
- confidence_score — DECIMAL(5,2)
- fail_reason — VARCHAR(200)
- schedule_id — BIGINT — Foreign key → Schedule.schedule_id
- created_at — DATETIME — NOT NULL
- analyzed_at — DATETIME
- confirmed_at — DATETIME
AuthEmail
- auth_email_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- auth_code — VARCHAR(10) — NOT NULL
- is_verified — CHAR(1) — NOT NULL
- expired_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
AuthToken
- token_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- refresh_token — VARCHAR(255) — NOT NULL
- expired_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
Board
- board_id — BIGINT — Primary key — NOT NULL
- writer_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT — NOT NULL
- board_type — VARCHAR(30) — NOT NULL
- board_status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
BoardApplication
- application_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → Board.board_id — NOT NULL
- applicant_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- application_status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- responded_at — DATETIME
BoardComment
- comment_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → Board.board_id — NOT NULL
- writer_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- content — TEXT — NOT NULL
- comment_status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
BoardFile
- file_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → Board.board_id — NOT NULL
- file_url — VARCHAR(200) — NOT NULL
- created_at — DATETIME — NOT NULL
BoardInvitation
- invitation_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → Board.board_id — NOT NULL
- inviter_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- invitee_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- invitation_status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- responded_at — DATETIME
BoardReport
- report_id — BIGINT — Primary key — NOT NULL
- reporter_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- reported_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- target_id — BIGINT — NOT NULL
- reason — VARCHAR(30) — NOT NULL
- reason_detail — TEXT
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- processed_at — DATETIME
ChatMessage
- chat_message_id — BIGINT — Primary key — NOT NULL
- group_chat_room_id — BIGINT — Foreign key → GroupChatRoom.group_chat_room_id — NOT NULL
- sender_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- created_at — DATETIME — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
GoogleCalendar
- google_calendar_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- google_email — VARCHAR(100) — NOT NULL
- access_token — VARCHAR(255) — NOT NULL
- refresh_token — VARCHAR(255) — NOT NULL
- sync_token — VARCHAR(255)
- auto_sync_yn — CHAR(1) — NOT NULL
- last_sync_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Group
- group_id — BIGINT — Primary key — NOT NULL
- group_name — VARCHAR(30) — NOT NULL
- owner_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- person_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
GroupChatRoom
- group_chat_room_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → Group.group_id — NOT NULL
- created_at — DATETIME — NOT NULL
GroupMember
- group_member_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → Group.group_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- inviter_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- member_status — VARCHAR(20) — NOT NULL
- joined_at — DATETIME — NOT NULL
GroupNotificationSetting
- group_setting_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → Group.group_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- is_enabled — BOOLEAN — NOT NULL
- updated_at — DATETIME — NOT NULL
GroupRecommendation
- recommendation_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → Group.group_id — NOT NULL
- requested_by — BIGINT — Foreign key → Member.member_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- requested_at — DATETIME — NOT NULL
- completed_at — DATETIME
- confirmed_at — DATETIME
GroupRecommendationSlot
- recommendation_slot_id — BIGINT — Primary key — NOT NULL
- recommendation_id — BIGINT — Foreign key → GroupRecommendation.recommendation_id — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- available_count — INT — NOT NULL
- is_all_available — TINYINT(1) — NOT NULL
- is_selected — TINYINT(1) — NOT NULL
GroupReport
- report_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → Group.group_id — NOT NULL
- chat_message_id — BIGINT — Foreign key → ChatMessage.chat_message_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- reported_member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- reason — VARCHAR(30) — NOT NULL
- reason_detail — TEXT
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- processed_at — DATETIME
GroupSchedule
- group_schedule_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → Group.group_id — NOT NULL
- sharer_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- schedule_id — BIGINT — Foreign key → Schedule.schedule_id — NOT NULL
- is_visible — BOOLEAN — NOT NULL
- shared_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
GroupScheduleShareCard
- share_card_id — BIGINT — Primary key — NOT NULL
- group_id — BIGINT — Foreign key → Group.group_id — NOT NULL
- schedule_id — BIGINT — Foreign key → Schedule.schedule_id — NOT NULL
- sharer_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- shared_title — VARCHAR(100)
- shared_memo — VARCHAR(500)
- updated_at — DATETIME — NOT NULL
Member
- member_id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50)
- password — VARCHAR(255)
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- address — VARCHAR(255)
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Notification
- notification_id — BIGINT — Primary key — NOT NULL
- receiver_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- notification_type — VARCHAR(30) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(200) — NOT NULL
- target_type — VARCHAR(30)
- target_id — BIGINT
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- read_at — DATETIME
NotificationSetting
- notification_setting_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- all_enabled — BOOLEAN — NOT NULL
- group_enabled — BOOLEAN — NOT NULL
- schedule_enabled — BOOLEAN — NOT NULL
- board_enabled — BOOLEAN — NOT NULL
- application_enabled — BOOLEAN — NOT NULL
- reminder_enabled — BOOLEAN — NOT NULL
- updated_at — DATETIME — NOT NULL
Schedule
- schedule_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- title — VARCHAR(50) — NOT NULL
- description — VARCHAR(400)
- schedule_type — VARCHAR(10) — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME
- is_public — CHAR(1) — NOT NULL
- google_sync_yn — CHAR(1) — NOT NULL
- google_event_id — VARCHAR(200)
- shared_group_id — BIGINT — Foreign key → Group.group_id
- source_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- location — VARCHAR(200)
ScheduleDeadline
- schedule_deadline_id — BIGINT — Primary key — NOT NULL
- schedule_id — BIGINT — Foreign key → Schedule.schedule_id — NOT NULL
- deadline_date — DATE — NOT NULL
- notify_days_before — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
SocialAccount
- social_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- provider — VARCHAR(255) — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL