设置了主键,你看下表结构:
CREATE TABLE GponPmOnuLocalInfos
(
node_id_str
varchar(100) NOT NULL COMMENT ‘设备的hostname,为设备在网络中的唯一标识’,
subscription_id_str
varchar(100) NOT NULL COMMENT ‘订阅名称’,
collection_id
bigint(20) unsigned NOT NULL COMMENT ‘标识采样轮次’,
collection_start_time
datetime DEFAULT NULL COMMENT ‘标识采样轮次开始时间’,
name
varchar(100) DEFAULT NULL COMMENT ‘//ONU名称,格式:v_ani.f.s.p.onuid’,
channel
varchar(100) DEFAULT NULL,
index
int(10) unsigned DEFAULT NULL,
olt_rx_power
int(10) DEFAULT NULL COMMENT ‘//OLT光模块接收到ONU的光功率,单位:0.01dBm’,
online_duration
int(10) unsigned DEFAULT NULL COMMENT ‘//在线时长,单位:秒’,
last_down_time
int(10) unsigned DEFAULT NULL COMMENT ‘//最后一次下线时间’,
last_down_cause
int(10) unsigned DEFAULT NULL COMMENT ‘//最后一次下线原因’,
onu_status
int(10) unsigned DEFAULT NULL COMMENT ‘//ONU状态,1-online,2-offline,255-invalid’,
PRIMARY KEY (node_id_str
,subscription_id_str
,collection_id
)
) SHARD_ROW_ID_BITS = 4 PRE_SPLIT_REGIONS=3;