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