app服务开发组-数据库表设计

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网元 idprimary key, uniquebts_name网元名称varchar(45)not nullcity城市varchar(45)not nulldevice_type设备类型varchar(20)warning_device_type告警对象设备类型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告警发生时间datetimeprimary keywarning_clear_time告警清除时间datetimewarning_factory_id厂家告警 idnot nullwarning_netadmin_id告警 idnot null字段名描述类型备注bts_id网元 idvarchar(20)primary key, uniquebts_name网元名称varchar(45)not nulllongitude经度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