terminal_info/doc/部署文档/10.170.42.93_部署/sql脚本/volte.sql

-- 建表语句
create table terminal_info.o_info_list_volte_terminal
(
    msisdn         varchar not null
        constraint o_info_list_volte_terminal_pk
        primary key,
    imsi           varchar,
    imei           varchar,
    tac            varchar,
    fact_name      varchar,
    terminal_name  varchar,
    hprovince      varchar,
    hprovince_name varchar,
    hcity          varchar,
    hcity_name     varchar,
    vprovince      varchar,
    vprovince_name varchar,
    vcity          varchar,
    vcity_name     varchar,
    is_volte       varchar,
    day_date       varchar
)
    distributed by (msisdn);

alter table terminal_info.o_info_list_volte_terminal
    owner to lifuq;