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

create table terminal_info.o_info_list_5g_terminal
(
    msisdn            varchar not null
        constraint o_info_list_5g_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_name        varchar,
    roaming_city_name varchar,
    cell_most         varchar,
    used_5g           varchar,
    status_5g         varchar,
    day               varchar
)
    distributed by (msisdn);

alter table terminal_info.o_info_list_5g_terminal
    owner to lifuq;