Livoa LogoLivoa
public.refresh_tokens


id uuid

user_id uuid

token_hash character varying(255)

expires_at timestamp with time zone

revoked_at timestamp with time zone

user_agent character varying(500)

ip_address character varying(100)

created_at timestamp with time zone

updated_at timestamp with time zone

public.transactions


id uuid

user_id uuid

transaction_type character varying(20)

amount bigint

balance_before bigint

balance_after bigint

reference_id uuid

status character varying(20)

metadata jsonb

created_at timestamp with time zone

updated_at timestamp with time zone

deleted_at timestamp with time zone

public.users


id uuid

username character varying(255)

email character varying(255)

password character varying(255)

name character varying(255)

phone_number character varying(50)

is_active boolean

created_at timestamp with time zone

updated_at timestamp with time zone

token_version integer

public.user_rooms


id uuid

room_id uuid

user_id uuid

seal_index integer

is_owner boolean

is_connected boolean

status character varying(20)

rank integer

joined_at timestamp with time zone

left_at timestamp with time zone

created_at timestamp with time zone

updated_at timestamp with time zone

public.rooms


id uuid

owner_id uuid

max_players integer

current_players integer

is_public boolean

password character varying(255)

bet_value bigint

minimum_amount bigint

is_active boolean

created_at timestamp with time zone

updated_at timestamp with time zone

public.matches


id uuid

room_id uuid

status character varying(20)

max_players integer

current_players integer

total_bet_amount bigint

current_turn integer

current_player_seat_index integer

started_at timestamp with time zone

finished_at timestamp with time zone

winner_id uuid

created_at timestamp with time zone

updated_at timestamp with time zone

public.match_players


id uuid

match_id uuid

user_id uuid

status character varying(20)

created_at timestamp with time zone

updated_at timestamp with time zone

public.dice_histories


id uuid

match_id uuid

player_id uuid

turn_number integer

dice_value integer

is_extra_turn boolean

is_used boolean

rolled_at timestamp with time zone

created_at timestamp with time zone

updated_at timestamp with time zone

public.match_transactions


id uuid

match_id uuid

user_id uuid

type character varying(30)

amount bigint

metadata jsonb

reference_id uuid

round_number integer

note text

created_at timestamp with time zone

updated_at timestamp with time zone

public.piece_kick_histories


id uuid

piece_id uuid

kicked_by uuid

kick_value integer

turn integer

created_at timestamp with time zone

updated_at timestamp with time zone

public.piece_states


id uuid

match_id uuid

user_id uuid

status character varying(50)

color character varying(20)

position integer

home_index integer

finish_index integer

created_at timestamp with time zone

updated_at timestamp with time zone

public.piece_race_histories


id uuid

piece_id uuid

from_index integer

to_index integer

turn integer

created_at timestamp with time zone

updated_at timestamp with time zone

public.user_balances


id uuid

user_id uuid

balance bigint

currency character varying(10)

is_locked boolean

is_deleted boolean

created_at timestamp with time zone

updated_at timestamp with time zone

public.schema_migrations


module character varying(255)

version bigint

dirty boolean

public.system_configs


id uuid

key character varying(255)

value text

created_at timestamp without time zone

updated_at timestamp without time zone

ABC

by TuongPhat

0
0 uses