app服務(wù)開發(fā)組-數(shù)據(jù)庫表設(shè)計

1、一資源信息表（tb_bsinfo）：建表 sql 語句：CREATE TABLE db_bsmonitor.tb_bsinfo (bts_idNOT NULL,bts_name VARCHAR(45) NOT NULL,latitude DOUBLE NOT NULL,longitude DOUBLE NOT NULL, PRIMARY KEY (bts_id),UNIQUE INDEX bts_id_UNIQUE (bts_id ASC);二告警信息表（tb_bswarning）:建表 sql 語句：CREATE TABLE db_bsmonitor.tb_bswarning (bts_id

2、NOT NULL,字段名描述類型備注bts_id網(wǎng)元 idprimary key, uniquebts_name網(wǎng)元名稱varchar(45)not nullcity城市varchar(45)not nulldevice_type設(shè)備類型varchar(20)warning_device_type告警對象設(shè)備類型varchar(20)warning_factory_level廠家告警級別varchar(10)factory_id廠家原始 idfactory_name廠家名稱varchar(20)warning_title告警標題varchar(100)not nullwarning_netad

3、min_level告警級別varchar(2)not nullwarning_happen_time告警發(fā)生時間datetimeprimary keywarning_clear_time告警清除時間datetimewarning_factory_id廠家告警 idnot nullwarning_netadmin_id告警 idnot null字段名描述類型備注bts_id網(wǎng)元 idvarchar(20)primary key, uniquebts_name網(wǎng)元名稱varchar(45)not nulllongitude經(jīng)度doublenot nulllatitude緯度doublenot nu

4、llbts_name VARCHAR(45) NOT NULL,city VARCHAR(45) NOT NULL,device_type VARCHAR(20) NULL,warning_device_type VARCHAR(20) NULL,warning_factory_level VARCHAR(10) NULL,factory_idNULL,factory_name VARCHAR(20) NULL,warning_title VARCHAR(100) NOT NULL,warning_netadmin_level VARCHAR(2) NOT NULL,warning_happe

5、n_time DATETIME NOT NULL,warning_clear_time DATETILL,warning_factory_idwarning_netadmin_idNOT NULL,NOT NULL,PRIMARY KEY (bts_id, warning_happen_time),UNIQUE INDEX bts_id_UNIQUE (bts_id ASC);三用戶信息表（tb_user）建表 sql 語句：CREATE TABLE db_bsmonitor.tb_user (id(11) NOT NULL,username VARCHAR(20) NOT NULL,password VARCHAR(45) NOT NULL, PRIMARY KEY (id),字段名描述類型備注id用戶 idprimary key, uniqueuserna