{"ok":true,"database":"ccrewmain_cardgame","tables":{"bgio_games":[{"COLUMN_NAME":"game_id","COLUMN_TYPE":"varchar(64)","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"state_json","COLUMN_TYPE":"longtext","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"metadata_json","COLUMN_TYPE":"longtext","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"log_json","COLUMN_TYPE":"longtext","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"updated_at","COLUMN_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","EXTRA":"on update current_timestamp()"}],"cards":[{"COLUMN_NAME":"id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":"auto_increment"},{"COLUMN_NAME":"card_id","COLUMN_TYPE":"int(11)","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"disabled","COLUMN_TYPE":"tinyint(1)","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","EXTRA":""},{"COLUMN_NAME":"type","COLUMN_TYPE":"enum('story','consequence','mission')","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"title","COLUMN_TYPE":"varchar(255)","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"situation","COLUMN_TYPE":"text","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"choice1","COLUMN_TYPE":"text","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"choice2","COLUMN_TYPE":"text","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"outcome1","COLUMN_TYPE":"text","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"outcome2","COLUMN_TYPE":"text","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""}],"card_effects":[{"COLUMN_NAME":"id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":"auto_increment"},{"COLUMN_NAME":"card_id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"outcome","COLUMN_TYPE":"tinyint(3) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"seq","COLUMN_TYPE":"tinyint(3) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"code","COLUMN_TYPE":"varchar(64)","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"value","COLUMN_TYPE":"varchar(64)","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"target","COLUMN_TYPE":"varchar(32)","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"created_at","COLUMN_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","EXTRA":""}],"decks":[{"COLUMN_NAME":"game_id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"type","COLUMN_TYPE":"enum('story','consequence','mission')","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"pile_json","COLUMN_TYPE":"longtext","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"discard_json","COLUMN_TYPE":"longtext","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""}],"games":[{"COLUMN_NAME":"id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":"auto_increment"},{"COLUMN_NAME":"room_code","COLUMN_TYPE":"varchar(16)","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"status","COLUMN_TYPE":"enum('lobby','active','ended')","IS_NULLABLE":"NO","COLUMN_DEFAULT":"'lobby'","EXTRA":""},{"COLUMN_NAME":"world_balance","COLUMN_TYPE":"int(11)","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","EXTRA":""},{"COLUMN_NAME":"players_max","COLUMN_TYPE":"tinyint(3) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":"4","EXTRA":""},{"COLUMN_NAME":"ended_reason","COLUMN_TYPE":"varchar(32)","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"created_at","COLUMN_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","EXTRA":""}],"game_events":[{"COLUMN_NAME":"id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":"auto_increment"},{"COLUMN_NAME":"game_id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"created_at","COLUMN_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","EXTRA":""},{"COLUMN_NAME":"actor_player_id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"kind","COLUMN_TYPE":"varchar(48)","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"payload_json","COLUMN_TYPE":"longtext","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""}],"game_state_cache":[{"COLUMN_NAME":"game_id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"active_seat","COLUMN_TYPE":"tinyint(3) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","EXTRA":""},{"COLUMN_NAME":"turn_number","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","EXTRA":""},{"COLUMN_NAME":"phase","COLUMN_TYPE":"varchar(32)","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"current_card_id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"effect_queue_json","COLUMN_TYPE":"longtext","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"prompt_json","COLUMN_TYPE":"longtext","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""}],"hands":[{"COLUMN_NAME":"player_id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"mission_json","COLUMN_TYPE":"longtext","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""}],"mission_conditions":[{"COLUMN_NAME":"card_id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"cond1_code","COLUMN_TYPE":"varchar(64)","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"cond1_value","COLUMN_TYPE":"varchar(64)","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"cond2_code","COLUMN_TYPE":"varchar(64)","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"cond2_value","COLUMN_TYPE":"varchar(64)","IS_NULLABLE":"YES","COLUMN_DEFAULT":"NULL","EXTRA":""},{"COLUMN_NAME":"created_at","COLUMN_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","EXTRA":""}],"players":[{"COLUMN_NAME":"id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":"auto_increment"},{"COLUMN_NAME":"game_id","COLUMN_TYPE":"int(10) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"seat_index","COLUMN_TYPE":"tinyint(3) unsigned","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"is_bot","COLUMN_TYPE":"tinyint(1)","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","EXTRA":""},{"COLUMN_NAME":"display_name","COLUMN_TYPE":"varchar(64)","IS_NULLABLE":"NO","COLUMN_DEFAULT":null,"EXTRA":""},{"COLUMN_NAME":"tokens","COLUMN_TYPE":"smallint(6)","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","EXTRA":""},{"COLUMN_NAME":"skip_next_turn","COLUMN_TYPE":"tinyint(1)","IS_NULLABLE":"NO","COLUMN_DEFAULT":"0","EXTRA":""},{"COLUMN_NAME":"is_active","COLUMN_TYPE":"tinyint(1)","IS_NULLABLE":"NO","COLUMN_DEFAULT":"1","EXTRA":""},{"COLUMN_NAME":"joined_at","COLUMN_TYPE":"timestamp","IS_NULLABLE":"NO","COLUMN_DEFAULT":"current_timestamp()","EXTRA":""}]}}