HTportal
Tables (25)
activity_log
- id — bigint — Primary key — NOT NULL
- log_name — varchar(255)
- description — text — NOT NULL
- subject_type — varchar(255)
- event — varchar(255)
- subject_id — bigint
- causer_type — varchar(255)
- causer_id — bigint
- properties — json
- batch_uuid — char(36)
- created_at — timestamp
- updated_at — timestamp
auto_message_conditions
- id — bigint — Primary key — NOT NULL
- text — longtext
- category_id — int — NOT NULL
- active — int — NOT NULL
- position — int — NOT NULL
- brand — enum('btime','momobet','tenxten','alphabet','ezbet','admin') — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
auto_message_exclusive_conditions
- id — bigint — Primary key — NOT NULL
- text — longtext
- category_id — int — NOT NULL
- active — int — NOT NULL
- position — int — NOT NULL
- brand — enum('btime','momobet','tenxten','alphabet','ezbet','yp','admin') — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
auto_message_logs
- id — bigint — Primary key — NOT NULL
- text — longtext
- deposit_request_id — int — NOT NULL
- category_id — int — NOT NULL
- brand — enum('btime','momobet','tenxten','alphabet','ezbet','admin') — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
banks
- id — bigint — Primary key — NOT NULL
- aliases — longtext — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
bonus_players
- id — bigint — Primary key — NOT NULL
- user_id — varchar(255)
- name — varchar(255)
- amount — varchar(255)
- date — datetime
- notes — varchar(255)
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- balance — int
- category_id — int
cache
- key — varchar(255) — Primary key — NOT NULL
- value — mediumtext — NOT NULL
- expiration — int — NOT NULL
cache_locks
- key — varchar(255) — Primary key — NOT NULL
- owner — varchar(255) — NOT NULL
- expiration — int — NOT NULL
categories
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- value — varchar(255) — NOT NULL
- color — varchar(255) — NOT NULL
- brand — varchar(255) — NOT NULL
- line_id — int
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
configurations
- id — bigint — Primary key — NOT NULL
- label — varchar(255) — NOT NULL
- value — longtext
- brand — varchar(255) — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
deposit_receipts
- id — bigint — Primary key — NOT NULL
- sender_number — varchar(255)
- deposit_datetime — datetime — NOT NULL
- user_name — varchar(255) — NOT NULL
- bank_account_no — varchar(255) — NOT NULL
- deposit_request_id — int
- deposit_guid — varchar(255) — NOT NULL
- brand — enum('btime','momobet','tenxten','alphabet','ezbet','admin') — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- deposit_amount — int — NOT NULL
deposit_requests
- id — bigint — Primary key — NOT NULL
- deposit_request_id — varchar(255) — NOT NULL
- deposit_receipt_id — int
- amount — int — NOT NULL
- notes — longtext
- name — varchar(255) — NOT NULL
- bank_name — varchar(255) — NOT NULL
- bank_account_number — varchar(255) — NOT NULL
- iban — varchar(255)
- state — int — NOT NULL
- deposit_request_datetime — datetime — NOT NULL
- brand — enum('btime','momobet','tenxten','alphabet','ezbet','admin') — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
- category — varchar(255)
deposit_sms_conditions
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- brand — enum('btime','momobet','tenxten','alphabet','ezbet','admin') — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
deposit_sms_exclusions
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- brand — enum('btime','momobet','tenxten','alphabet','ezbet','admin') — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
failed_jobs
- id — bigint — Primary key — NOT NULL
- uuid — varchar(255) — NOT NULL
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
job_batches
- id — varchar(255) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- total_jobs — int — NOT NULL
- pending_jobs — int — NOT NULL
- failed_jobs — int — NOT NULL
- failed_job_ids — longtext — NOT NULL
- options — mediumtext
- cancelled_at — int
- created_at — int — NOT NULL
- finished_at — int
jobs
- id — bigint — Primary key — NOT NULL
- queue — varchar(255) — NOT NULL
- payload — longtext — NOT NULL
- attempts — tinyint — NOT NULL
- reserved_at — int
- available_at — int — NOT NULL
- created_at — int — NOT NULL
lines
- id — bigint — Primary key — NOT NULL
- label — varchar(255) — NOT NULL
- value — int — NOT NULL
- brand — varchar(255) — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
migrations
- id — int — Primary key — NOT NULL
- migration — varchar(255) — NOT NULL
- batch — int — NOT NULL
password_reset_tokens
- email — varchar(255) — Primary key — NOT NULL
- token — varchar(255) — NOT NULL
- created_at — timestamp
personal_access_tokens
- id — bigint — Primary key — NOT NULL
- tokenable_type — varchar(255) — NOT NULL
- tokenable_id — bigint — NOT NULL
- name — varchar(255) — NOT NULL
- token — varchar(64) — NOT NULL
- abilities — text
- last_used_at — timestamp
- expires_at — timestamp
- created_at — timestamp
- updated_at — timestamp
sessions
- id — varchar(255) — Primary key — NOT NULL
- user_id — bigint
- ip_address — varchar(45)
- user_agent — text
- payload — longtext — NOT NULL
- last_activity — int — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- email_verified_at — timestamp
- password — varchar(255) — NOT NULL
- remember_token — varchar(100)
- created_at — timestamp
- updated_at — timestamp
- brand — varchar(255) — NOT NULL
withdrawal_receipts
- id — bigint — Primary key — NOT NULL
- sender_number — varchar(255)
- withdraw_datetime — datetime — NOT NULL
- user_name — varchar(255) — NOT NULL
- bank_name — varchar(255) — NOT NULL
- bank_account_no — varchar(255) — NOT NULL
- withdrawal_request_id — int
- withdrawal_guid — varchar(255) — NOT NULL
- withdrawal_amount — int — NOT NULL
- brand — enum('btime','momobet','tenxten','alphabet','ezbet','yp','admin') — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp
withdrawal_sms_exclusions
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- deleted_at — timestamp
- created_at — timestamp
- updated_at — timestamp