Ocean

Tables (20)

appointment_participants

  • appointment_id — VARCHAR(100)
  • user_code — VARCHAR(100)
  • participation_status — ENUM('INVITED', 'ACCEPTED', 'DECLINED', 'MAYBE')
  • current_latitude — DOUBLE
  • current_longitude — DOUBLE
  • location_updated_at — TIMESTAMP
  • estimated_arrival_time — DATETIME
  • transportation_mode — VARCHAR(50)
  • is_arrived — BOOLEAN
  • arrived_at — TIMESTAMP
  • INDEX — idx_status

appointments

  • appointment_id — VARCHAR(100)
  • appointment_name — VARCHAR(200) — NOT NULL
  • place_code — VARCHAR(100)
  • workspace_code — VARCHAR(100)
  • event_id — VARCHAR(100)
  • appointment_time — DATETIME — NOT NULL
  • description — TEXT
  • status — ENUM('SCHEDULED', 'IN_PROGRESS', 'COMPLETED', 'CANCELLED')
  • reminder_minutes — INT
  • created_by — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_appointment_time
  • INDEX — idx_status
  • INDEX — idx_workspace

calendar_events

  • event_id — VARCHAR(100)
  • user_code — VARCHAR(100) — NOT NULL
  • workspace_code — VARCHAR(100)
  • title — VARCHAR(300) — NOT NULL
  • description — TEXT
  • start_datetime — DATETIME — NOT NULL
  • end_datetime — DATETIME — NOT NULL
  • location — VARCHAR(500)
  • color — VARCHAR(20)
  • is_all_day — BOOLEAN
  • is_shared — BOOLEAN
  • shared_workspace_code — VARCHAR(100)
  • google_event_id — VARCHAR(255)
  • original_event_id — VARCHAR(100)
  • event_type — ENUM('PERSONAL', 'WORKSPACE', 'SHARED') — NOT NULL
  • status — ENUM('CONFIRMED', 'TENTATIVE', 'CANCELLED')
  • recurrence_rule — JSON
  • reminder_minutes — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_user_date
  • INDEX — idx_workspace_date
  • INDEX — idx_google_event
  • INDEX — idx_type_status

document_pages

  • page_id — VARCHAR(100)
  • document_id — VARCHAR(100) — NOT NULL
  • page_number — INT — NOT NULL
  • image_path — VARCHAR(1000) — NOT NULL
  • thumbnail_path — VARCHAR(1000)
  • width — INT
  • height — INT
  • INDEX — idx_document

event_attendees

  • event_id — VARCHAR(100)
  • user_code — VARCHAR(100)
  • response_status — ENUM('ACCEPTED', 'DECLINED', 'TENTATIVE', 'NEEDS_ACTION')
  • is_organizer — BOOLEAN
  • is_optional — BOOLEAN
  • responded_at — TIMESTAMP
  • INDEX — idx_user_response

file_info

  • file_code — VARCHAR(100)
  • file_name — VARCHAR(300) — NOT NULL
  • original_file_name — VARCHAR(300) — NOT NULL
  • file_path — VARCHAR(1000) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • file_type — VARCHAR(100)
  • file_extension — VARCHAR(20)
  • event_id — VARCHAR(100)
  • upload_type — ENUM('CALENDAR_PERSONAL', 'CALENDAR_WORKSPACE', 'BOARD', 'TASK', 'MEETING') — NOT NULL
  • uploader_code — VARCHAR(100) — NOT NULL
  • download_count — INT
  • is_deleted — BOOLEAN
  • deleted_at — TIMESTAMP
  • uploaded_at — TIMESTAMP
  • last_accessed_at — TIMESTAMP
  • INDEX — idx_event
  • INDEX — idx_upload_type
  • INDEX — idx_uploader
  • INDEX — idx_uploaded

file_previews

  • file_code — VARCHAR(100)
  • thumbnail_path — VARCHAR(1000)
  • preview_path — VARCHAR(1000)
  • width — INT
  • height — INT
  • page_count — INT
  • generated_at — TIMESTAMP

meeting_documents

  • document_id — VARCHAR(100)
  • room_code — VARCHAR(100) — NOT NULL
  • file_name — VARCHAR(300) — NOT NULL
  • file_type — ENUM('PDF', 'PPT', 'PPTX') — NOT NULL
  • file_path — VARCHAR(1000) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • total_pages — INT
  • conversion_status — ENUM('PENDING', 'PROCESSING', 'COMPLETED', 'FAILED')
  • uploaded_by — VARCHAR(100) — NOT NULL
  • uploaded_at — TIMESTAMP
  • converted_at — TIMESTAMP
  • is_active — BOOLEAN
  • INDEX — idx_room_active
  • INDEX — idx_conversion

meeting_participants

  • room_code — VARCHAR(100)
  • user_code — VARCHAR(100)
  • joined_at — TIMESTAMP
  • left_at — TIMESTAMP
  • is_active — BOOLEAN
  • role — ENUM('HOST', 'PRESENTER', 'PARTICIPANT')
  • INDEX — idx_active

meeting_rooms

  • room_code — VARCHAR(100)
  • room_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • workspace_code — VARCHAR(100) — NOT NULL
  • host_user_code — VARCHAR(100) — NOT NULL
  • status — ENUM('WAITING', 'IN_PROGRESS', 'ENDED')
  • max_participants — INT
  • is_recording_enabled — BOOLEAN
  • scheduled_start_time — TIMESTAMP
  • scheduled_end_time — TIMESTAMP
  • actual_start_time — TIMESTAMP
  • actual_end_time — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_workspace_status
  • INDEX — idx_scheduled

meeting_sketches

  • sketch_id — VARCHAR(100)
  • room_code — VARCHAR(100) — NOT NULL
  • save_name — VARCHAR(200)
  • description — TEXT
  • sketch_data — JSON
  • thumbnail_path — VARCHAR(1000)
  • created_by — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_room
  • INDEX — idx_created

places

  • place_code — VARCHAR(100)
  • place_name — VARCHAR(200) — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • address — VARCHAR(500)
  • road_address — VARCHAR(500)
  • kakao_place_id — VARCHAR(50)
  • category — VARCHAR(100)
  • phone — VARCHAR(20)
  • place_url — VARCHAR(500)
  • place_type — ENUM('CUSTOM', 'KAKAO')
  • workspace_code — VARCHAR(100)
  • is_public — BOOLEAN
  • tags — JSON
  • created_by — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_kakao_place
  • INDEX — idx_workspace
  • INDEX — idx_coordinates

refresh_tokens

  • token_id — VARCHAR(100)
  • user_code — VARCHAR(100) — NOT NULL
  • refresh_token — VARCHAR(500) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP
  • INDEX — idx_token
  • INDEX — idx_expires

user_calendar_sync

  • user_code — VARCHAR(100)
  • google_calendar_id — VARCHAR(255)
  • google_refresh_token — VARCHAR(500)
  • sync_enabled — BOOLEAN
  • last_sync_at — TIMESTAMP
  • sync_error_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_locations

  • location_id — BIGINT
  • user_code — VARCHAR(100) — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • accuracy — DOUBLE
  • address — VARCHAR(500)
  • location_type — ENUM('CURRENT', 'HOME', 'WORK', 'FAVORITE')
  • location_name — VARCHAR(100)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • INDEX — idx_user_type
  • INDEX — idx_created

user_tokens

  • user_code — VARCHAR(100)
  • access_token — VARCHAR(500)
  • refresh_token — VARCHAR(500)
  • token_expires_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • user_code — VARCHAR(100)
  • user_id — VARCHAR(100) — NOT NULL — 소셜 로그인 ID
  • user_name — VARCHAR(100) — NOT NULL — 실명
  • nickname — VARCHAR(50) — 서비스 내 닉네임
  • email — VARCHAR(255)
  • user_profile_img — VARCHAR(500)
  • provider — VARCHAR(20) — NOT NULL — google, kakao
  • phone_number — VARCHAR(20)
  • department — VARCHAR(100)
  • position — VARCHAR(100)
  • is_profile_complete — BOOLEAN
  • is_active — BOOLEAN
  • last_login_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_provider_user
  • INDEX — idx_nickname
  • INDEX — idx_created

workspace_invitations

  • invite_id — VARCHAR(100)
  • workspace_code — VARCHAR(100) — NOT NULL
  • invite_code — VARCHAR(50) — NOT NULL
  • invited_by — VARCHAR(100) — NOT NULL
  • invited_email — VARCHAR(255)
  • status — ENUM('PENDING', 'ACCEPTED', 'REJECTED', 'EXPIRED')
  • expired_at — TIMESTAMP
  • created_at — TIMESTAMP
  • used_at — TIMESTAMP
  • INDEX — idx_invite_code
  • INDEX — idx_status
  • INDEX — idx_expired

workspace_members

  • workspace_code — VARCHAR(100)
  • user_code — VARCHAR(100)
  • user_nickname — VARCHAR(50) — 워크스페이스별 닉네임
  • user_role — ENUM('OWNER', 'ADMIN', 'MEMBER')
  • status_message — VARCHAR(200)
  • is_active — BOOLEAN
  • joined_at — TIMESTAMP
  • last_activity_at — TIMESTAMP
  • INDEX — idx_user
  • INDEX — idx_role
  • INDEX — idx_joined

workspaces

  • workspace_code — VARCHAR(100)
  • workspace_name — VARCHAR(200) — NOT NULL
  • workspace_description — TEXT
  • workspace_img — VARCHAR(500)
  • workspace_color — VARCHAR(20)
  • invite_code — VARCHAR(50)
  • max_members — INT
  • is_active — BOOLEAN
  • created_by — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_invite_code
  • INDEX — idx_created