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