
create or replace view centile_terminals.v_centile_user_account as select * from user_account_centile.user_account;

create or replace view centile_terminals.v_user_account_alive as select * from centile_auth_user.v_out_user_account_alive;

create or replace view centile_terminals.v_user_terminal_choose as select * from centile_terminals.terminals ct_t WHERE ct_t.choosed = 'Y';


create or replace view centile_terminals.v_in_centile_user_account as SELECT *    FROM
                                                                          `user_account_centile`.`user_account`;


create or replace view centile_terminals.v_in_user_account_alive as SELECT
                                                                        `centile_auth_user`.`v_out_user_account_alive`.`id` AS `id`,
                                                                        `centile_auth_user`.`v_out_user_account_alive`.`query_id` AS `query_id`,
                                                                        `centile_auth_user`.`v_out_user_account_alive`.`cookie` AS `cookie`,
                                                                        `centile_auth_user`.`v_out_user_account_alive`.`x_application` AS `x_application`,
                                                                        `centile_auth_user`.`v_out_user_account_alive`.`centile_user_account_id` AS `centile_user_account_id`,
                                                                        `centile_auth_user`.`v_out_user_account_alive`.`expired_at` AS `expired_at`
                                                                    FROM
                                                                        `centile_auth_user`.`v_out_user_account_alive`;