siteinfo_update/doc/部署文档/建表语句/cfm.cfg_0_4g_siteinfo.sql

-- cfm.cfg_0_4g_siteinfo definition

-- Drop table

-- DROP TABLE cfm.cfg_0_4g_siteinfo;

CREATE TABLE cfm.cfg_0_4g_siteinfo (
	sdate date NULL,
	city_code numeric NULL,
	city_name varchar(200) NULL,
	district_code numeric NULL,
	district_name varchar(200) NULL,
	network_name varchar(200) NULL,
	phystation_address varchar(200) NULL,
	bbu_name varchar(200) NULL,
	enbid numeric NULL,
	cell_name varchar(200) NULL,
	cell_id numeric NULL,
	cgi varchar(200) NULL,
	lon numeric NULL,
	lat numeric NULL,
	direction numeric NULL,
	height numeric NULL,
	m_downtilt numeric NULL,
	e_downtilt numeric NULL,
	station_type varchar(200) NULL,
	isdigitalindoor varchar(200) NULL,
	down_freq numeric NULL,
	vender varchar(200) NULL,
	own_schoolyard varchar(200) NULL,
	toweraddress_code varchar(200) NULL,
	property varchar(200) NULL,
	scene varchar(200) NULL,
	is_scenesite varchar(200) NULL,
	marketing_network varchar(200) NULL,
	terminalamount_5g varchar(200) NULL,
	sector_incoming varchar(200) NULL,
	is_busy varchar(200) NULL,
	is_alive numeric NULL,
	is_alive_update_time date NULL,
	construction varchar(200) NULL,
	is_same_address varchar(200) NULL,
	same_address_sites numeric NULL,
	is_same_address_ct varchar(200) NULL
)
DISTRIBUTED BY (sdate);