gotox

Tables (14)

ai_inference_logs

  • model — VARCHAR(100)
  • token_usage — INT
  • latency_ms — INT
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

ai_insights

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — ENUM( 'RECOMMENDATION', 'WARNING', 'DUPLICATE', 'FREE_TRIAL', 'SAVING' ) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • saving_amount — DECIMAL(10,2)
  • related_service — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

embedding_documents

  • id — BIGINT — Primary key — NOT NULL
  • document_type — ENUM( 'SERVICE', 'PLAN', 'FAQ', 'EVENT', 'COMMUNITY' ) — NOT NULL
  • reference_id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT — NOT NULL
  • vector_id — VARCHAR(255)
  • status — ENUM( 'PENDING', 'COMPLETED', 'FAILED' )
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

group_subscription_members

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • group_subscription_id — BIGINT — Foreign key → group_subscriptions.id — NOT NULL
  • role — ENUM( 'HOST', 'MEMBER' )
  • joined_at — DATETIME — NOT NULL
  • status — ENUM( 'PENDING', 'APPROVED', 'LEFT' )
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

group_subscriptions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • host_name — VARCHAR(100)
  • service_name — VARCHAR(100) — NOT NULL
  • plan_name — VARCHAR(100)
  • total_slots — INT — NOT NULL
  • current_members — INT
  • monthly_share — DECIMAL(10,2)
  • status — ENUM( 'RECRUITING', 'FULL', 'CLOSED' )
  • category — VARCHAR(50)
  • description — TEXT
  • popularity — INT
  • review_count — INT
  • color — VARCHAR(7)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

notifications

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — ENUM( 'PAYMENT', 'PRICE_UP', 'TRIAL_END', 'GROUP_FULL', 'AI_INSIGHT' )
  • title — VARCHAR(255) — NOT NULL
  • message — TEXT
  • is_read — BOOLEAN
  • link_path — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

payments

  • id — BIGINT — Primary key — NOT NULL
  • user_subscription_id — BIGINT — Foreign key → user_subscriptions.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • payment_date — DATETIME
  • status — ENUM( 'SUCCESS', 'FAILED', 'REFUNDED', 'PENDING' )
  • merchant_name — VARCHAR(150)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

recommendations

  • id — BIGINT — Primary key — NOT NULL
  • service_catalog_id — BIGINT — Foreign key → service_catalogs.id
  • service_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50)
  • price — DECIMAL(10,2)
  • has_free_trial — BOOLEAN
  • reason — TEXT
  • match_score — INT
  • is_new — BOOLEAN
  • color — VARCHAR(7)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

search_histories

  • user_id — BIGINT — NOT NULL
  • keyword — VARCHAR(255) — NOT NULL
  • searched_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

service_catalogs

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • slug — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • description — TEXT
  • base_price — DECIMAL(10,2)
  • billing_cycle — ENUM('MONTHLY','YEARLY')
  • has_free_trial — BOOLEAN
  • free_trial_days — INT
  • is_new — BOOLEAN
  • website — VARCHAR(500)
  • color — VARCHAR(7)
  • logo_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

user_profile_embeddings

  • id — BIGINT — Primary key — NOT NULL
  • user_profile_id — BIGINT — Foreign key → user_profiles.id — NOT NULL
  • embedding_provider — VARCHAR(50) — NOT NULL
  • vector_id — VARCHAR(255) — NOT NULL
  • embedding_model — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

user_profiles

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • profile_text — TEXT — NOT NULL
  • version — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

user_subscriptions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • service_catalog_id — BIGINT — Foreign key → service_catalogs.id
  • service_name — VARCHAR(100) — NOT NULL
  • plan_name — VARCHAR(100)
  • price — DECIMAL(10,2) — NOT NULL
  • billing_cycle — ENUM('MONTHLY','YEARLY')
  • next_payment_date — DATETIME
  • auto_renew — BOOLEAN
  • category — VARCHAR(50)
  • status — ENUM( 'ACTIVE', 'PAUSED', 'EXPIRED', 'CANCELED' )
  • color — VARCHAR(7)
  • usage_level — ENUM( 'HIGH', 'MEDIUM', 'LOW' )
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • avatar — VARCHAR(500)
  • role — VARCHAR(30) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • metadata — JSON
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL
  • updated_by — BIGINT
  • deleted_at — DATETIME
  • deleted_by — BIGINT