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