siteinfo_update/doc/部署文档/建表语句/customer_service.cfg_p_netconf_std.sql

-- customer_service.cfg_p_netconf_std definition

-- Drop table

-- DROP TABLE customer_service.cfg_p_netconf_std;

CREATE TABLE customer_service.cfg_p_netconf_std (
	id varchar(400) NULL,
	city_id varchar(400) NULL,
	city_name varchar(400) NULL,
	area_id varchar(400) NULL,
	core_ne_name varchar(400) NULL,
	radio_ne_name varchar(400) NULL,
	site_name varchar(400) NULL,
	site_id varchar(400) NULL,
	cell_no varchar(400) NULL,
	cell_name varchar(400) NULL,
	cell_id varchar(400) NULL,
	ecgi int8 NULL,
	gnb_cu_id varchar(400) NULL,
	gnb_du_id varchar(400) NULL,
	gsm_cell_id varchar(400) NULL,
	network_type varchar(400) NULL,
	type_5g varchar(400) NULL,
	tac varchar(400) NULL,
	cover_type varchar(400) NULL,
	nodeb_type varchar(400) NULL,
	rac varchar(400) NULL,
	lac varchar(400) NULL,
	grid varchar(400) NULL,
	areatype varchar(400) NULL,
	sub_areatype varchar(400) NULL,
	area3 varchar(400) NULL,
	longitude varchar(400) NULL,
	latitude varchar(400) NULL,
	vendor varchar(400) NULL,
	height varchar(400) NULL,
	downtilt varchar(400) NULL,
	azimuth varchar(400) NULL,
	fr varchar(400) NULL,
	scramber varchar(400) NULL,
	province_id varchar(400) NULL,
	bsbusip varchar(400) NULL,
	bsbusip_1 varchar(400) NULL,
	isanchor varchar(400) NULL,
	"operator" varchar(400) NULL,
	isshare varchar(400) NULL,
	slice_type varchar(400) NULL
)
DISTRIBUTED RANDOMLY;