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)