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