Players

The central user table storing all player account information, personal details, verification statuses, and preferences.

Relationships

• Belongs to brands via brand_id
• Belongs to companies via company_id
• Has one user_vip_status via player_id
• Has many transactions via player_id
• Has many player_balances via player_id
• Has many coin_package_purchases via player_id
• Has many coin_package_player_assignments via player_id
• Has many player_sweepstakes_rewards via player_id
• Has many daily_reward_logs via player_id
• Has one player_affiliates via player_id
• Has many user_vip_status_log via player_id
• Has many vip_daily_cashback_log via player_id
• References transactions via first_purchase_transaction_id

Columns

Column	Type	Nullable	Default	Description
id	uuid	NO	gen_random_uuid()	Primary key
email	varchar(255)	NO		Player's email address. Unique per brand (email + brand_id composite unique).
password	varchar(255)	YES		Hashed password. NULL for social login accounts.
first_name	varchar(255)	YES		Player's first name
last_name	varchar(255)	YES		Player's last name
title	varchar(10)	YES		Honorific title (Mr, Mrs, etc.)
gender	varchar(10)	NO	'UNKNOWN'	Player gender. Values: MALE, FEMALE, UNKNOWN
birthdate	date	YES		Date of birth (used for age verification and VIP birthday gifts)
phone	varchar(20)	YES		Phone number
country	varchar(3)	YES		ISO 3166-1 alpha-2/3 country code
state	varchar(3)	YES		US state code (relevant for sweepstakes geo-restrictions)
address	varchar(255)	YES		Street address
city	varchar(100)	YES		City
zip_code	varchar(20)	YES		Postal/ZIP code
brand_id	uuid	NO		FK to brands. Which brand the player registered under.
company_id	uuid	NO		FK to companies. Parent company of the brand.
account_status	varchar(50)	YES	'PENDING'	Account lifecycle status. Values: PENDING, ACTIVE, SUSPENDED, CLOSED
is_verified	boolean	YES	false	Overall verification flag
is_kyc_verified	boolean	YES	false	KYC (Know Your Customer) verification complete
kyc_status	varchar(50)	YES	'not_started'	KYC verification workflow status. Values: not_started, pending, approved, rejected
kyc_applicant_id	varchar(255)	YES		External KYC provider applicant identifier
kyc_triggered_at	timestamptz	YES		When KYC verification was initiated
kyc_completed_at	timestamptz	YES		When KYC verification was completed
address_verified	boolean	YES	false	Address verification status
address_confirmed_at	timestamptz	YES		When address was confirmed
personal_details_confirmed_at	timestamptz	YES		When personal details were confirmed
terms_accepted	boolean	NO	false	Whether the player accepted terms and conditions
email_verified	boolean	NO	false	Whether the player's email has been verified
phone_verified	boolean	YES	false	Whether the player's phone has been verified
can_withdraw	boolean	YES	false	Whether the player is allowed to withdraw funds. Managed by the sync_can_withdraw trigger.
can_purchase	boolean	YES	false	Whether the player is allowed to make purchases
first_purchase_date	timestamp	YES		Timestamp of the player's first purchase
first_purchase_transaction_id	uuid	YES		FK to transactions. Links to the first deposit/purchase transaction.
social_provider	varchar(50)	YES		OAuth provider name (e.g., google, facebook)
social_provider_id	varchar(255)	YES		External ID from the social provider
wallet_currency	varchar(3)	YES	'EUR'	Player's wallet display currency
preferred_currency_type	varchar(20)	YES	'real_money'	User currency preference: real_money (regular casinos), sweepstakes (legacy), gc (Gold Coins), or sc (Sweepstakes Coins)
user_language	char(2)	YES	'EN'	Player's preferred language (ISO 639-1)
consecutive_login_days	integer	YES	0	Tracks how many consecutive days the player has logged in. Used by the daily login rewards system.
last_login_date	timestamp	YES		Timestamp of the player's most recent login
ip	inet	YES		Last known IP address
browser	varchar(100)	YES		Last known browser user-agent
os	varchar(100)	YES		Last known operating system
is_test_account	boolean	NO	false	Indicates whether this is a test/QA account (excluded from reporting)
affiliate_id	numeric	YES		Legacy numeric affiliate identifier
affiliate_str	varchar(255)	YES		Legacy affiliate string identifier
email_disabled_by_platform	boolean	YES	false	Whether marketing emails were disabled by the platform
sms_disabled_by_platform	boolean	YES	false	Whether marketing SMS was disabled by the platform
redeemable_sc	numeric(18)	NO	0	Amount of SC (Sweepstakes Coins) eligible for redemption. Only SC that has been wagered (bet or won from betting) qualifies. Maintained automatically by triggers. Always <= current SC withdrawable balance.
metadata	jsonb	YES		Flexible JSON metadata for additional player data
created_at	timestamp	YES	CURRENT_TIMESTAMP	Account creation timestamp
updated_at	timestamp	YES		Last update timestamp (managed by update_updated_at trigger)

Triggers

Trigger	Function	Description
trigger_update_updated_at	update_updated_at	Automatically sets updated_at on row update
trigger_sync_can_withdraw	sync_can_withdraw	Synchronizes the can_withdraw flag based on verification status
trigger_log_user_status_changes	log_user_status_changes	Logs changes to account_status for audit
trigger_log_first_time_actions	log_first_time_actions	Logs first-time events (first login, first purchase, etc.)

Key Indexes

Index	Columns	Notes
players_pkey	id	Primary key
players_email_brand_id_key	email, brand_id	Unique - one email per brand
idx_players_brand_id	brand_id	Brand lookup
idx_players_auth_fast	id, account_status	Partial: WHERE account_status = 'ACTIVE'
idx_players_kyc_status	kyc_status	KYC filtering
idx_players_redeemable_sc	redeemable_sc	Partial: WHERE redeemable_sc > 0
idx_players_is_test_account	is_test_account	Filter test accounts

Business Rules

• A player's email is unique within a brand but can exist across multiple brands
• The redeemable_sc field is automatically maintained by database triggers on the transactions and player_balances tables
• The can_withdraw flag is synced via triggers based on KYC and verification status
• consecutive_login_days resets to 0 if the player misses a day, driving the daily login rewards system