orbit
Tables (18)
attachments
- attachment_id — varchar(36)
- message_id — varchar(36) — Foreign key → chat_messages.message_id — NOT NULL
- file_name — varchar(255) — NOT NULL
- file_path — varchar(512) — NOT NULL
- file_type — varchar(100)
- file_size — number
- uploaded_at — timestamp
bug_reports
- report_id — varchar(36)
- user_id — varchar(36) — Foreign key → users.user_id — NOT NULL
- title — varchar(200) — NOT NULL
- description — clob — NOT NULL
- severity — varchar(20) — low, medium, high, critical
- category — varchar(50)
- browser_info — clob
- steps_to_reproduce — clob
- expected_behavior — clob
- actual_behavior — clob
- status — varchar(20) — open, in_progress, resolved, closed, duplicate
- priority — varchar(20) — low, normal, high, urgent
- assigned_to — varchar(36)
- resolution_notes — clob
- attachment_urls — clob
- created_at — date
- updated_at — date
- resolved_at — date
chat_messages
- message_id — varchar(36)
- session_id — varchar(36) — Foreign key → chat_sessions.session_id — NOT NULL
- user_id — varchar(36) — Foreign key → users.user_id
- message_type — varchar(10) — NOT NULL — user, ai, system, file
- message_content — clob — NOT NULL
- created_at — timestamp
- reaction — varchar(50)
- is_edited — number(1)
- edited_at — timestamp
- parent_message_id — varchar(36) — Foreign key → chat_messages.message_id
- user_message_token_count — number
- ai_message_token_count — number
chat_sessions
- session_id — varchar(36) — Foreign key → chat_sessions.is_archived
- user_id — varchar(36) — Foreign key → users.user_id — NOT NULL
- title — varchar(255) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- is_archived — number(1)
- category — varchar(100)
feedback_reports
- feedback_id — varchar(36)
- user_id — varchar(36) — Foreign key → users.user_id — NOT NULL
- title — varchar(200) — NOT NULL
- content — clob — NOT NULL
- feedback_type — varchar(30) — feature_request, improvement, general, ui_ux, performance, content
- category — varchar(50)
- upvotes — number
- downvotes — number
- status — varchar(20) — submitted, under_review, planned, in_development, completed, rejected
- priority — varchar(20) — low, normal, high, urgent
- admin_response — clob
- implementation_notes — clob
- attachment_urls — clob
- created_at — date
- updated_at — date
- reviewed_at — date
level_requirements
- level_num — number
- required_exp — number — NOT NULL
- level_name — varchar(50)
- level_description — varchar(200)
- unlock_features — clob
- level_badge — varchar(100)
- created_at — timestamp
message_edit_history
- edit_id — varchar(36)
- message_id — varchar(36) — Foreign key → chat_messages.message_id — NOT NULL
- old_content — clob
- new_content — clob
- edit_reason — varchar(200)
- edited_by — varchar(36) — Foreign key → users.user_id
- edited_at — timestamp
post_translations
- post_id — number — Foreign key → posts.idx
- language_code — varchar(10)
- subject — clob — Foreign key → translation_resources.translation_id
- content — clob
- is_original — number(1)
- translation_method — varchar(20)
- created_date — date
posts
- idx — number
- user_id (user_name) — varchar(100)
- user_ip — varchar(45)
- pwd — varchar(255)
- origin_language — varchar(10)
- is_notice — number(1)
- created_date — date
- updated_date — date
subscription_tiers
- tier_id — varchar(36)
- tier_name — varchar(50) — NOT NULL
- tier_display_name — varchar(100) — NOT NULL
- tier_emoji — varchar(10)
- tier_description — clob
- monthly_price — number(10,2)
- yearly_price — number(10,2)
- tier_level — number — NOT NULL
- max_ai_requests_per_day — number
- max_file_upload_size — number
- features_included — clob
- is_enterprise — number(1)
- is_active — number(1)
- created_at — timestamp
- updated_at — timestamp
translation_resources
- translation_id — varchar(36)
- lang_code — varchar(10) — NOT NULL
- resource_key — varchar(200) — NOT NULL
- resource_value — clob — NOT NULL
- category — varchar(50)
- updated_at — timestamp
user_badges
- badge_id — varchar(36)
- user_id — varchar(36) — Foreign key → users.user_id — NOT NULL
- badge_type — varchar(50) — NOT NULL
- badge_name — varchar(100) — NOT NULL
- badge_description — varchar(500)
- badge_icon — varchar(200)
- badge_color — varchar(7)
- badge_level — number
- is_equipped — number(1)
- earned_at — timestamp
- updated_at — timestamp
user_experience_log
- log_id — varchar(36)
- user_id — varchar(36) — Foreign key → users.user_id — NOT NULL
- exp_type — varchar(50) — NOT NULL
- exp_amount — number — NOT NULL
- exp_reason — varchar(200)
- old_total_exp — number
- new_total_exp — number
- old_level — number
- new_level — number
- multiplier_applied — number(3,2)
- earned_at — timestamp
user_items
- item_id — varchar(36)
- user_id — varchar(36) — Foreign key → users.user_id — NOT NULL
- item_type — varchar(50) — NOT NULL
- item_name — varchar(100) — NOT NULL
- item_description — varchar(500)
- item_effect — clob
- quantity — number
- is_active — number(1)
- obtained_at — timestamp
- expires_at — timestamp
user_profiles
- user_id — varchar(36) — Foreign key → users.user_id
- theme_preference — varchar(50)
- bio — clob
- badge — varchar(100)
- experience — number
- level — number
- updated_at — timestamp
- nickname — varchar(100)
- birth_date — date
- gender — varchar(10)
- introduction — clob
- profile_theme — varchar(50)
- profile_border — varchar(50)
- profile_background — varchar(100)
- status_message — varchar(200)
- experience_multiplier — number(3,2)
- premium_until — timestamp
- is_premium — number(1)
user_settings
- user_id — varchar(36) — Foreign key → users.user_id
- theme — varchar(50)
- language — varchar(10)
- font_size — number(2)
- notifications_enabled — number(1)
- ai_model_preference — varchar(100)
- updated_at — timestamp
user_subscriptions
- subscription_id — varchar(36)
- user_id — varchar(36) — Foreign key → users.user_id — NOT NULL
- tier_id — varchar(36) — Foreign key → subscription_tiers.tier_id — NOT NULL
- subscription_start — timestamp
- subscription_end — timestamp
- is_active — number(1)
- payment_method — varchar(50)
- auto_renewal — number(1)
- created_at — timestamp
- updated_at — timestamp
users
- user_id — varchar(36)
- username — varchar(100) — NOT NULL
- email — varchar(255) — NOT NULL
- password_hash — varchar(255) — NOT NULL
- profile_image_path — varchar(512)
- created_at — timestamp
- last_login — timestamp
- is_active — number(1)
- is_admin — number(1)