Feature #950
Updated by pengfei xu over 3 years ago
15号线需要创建轮巡表(TB5017_CCTVTOUR,TB5018_TOURCAMERA)保存轮巡信息
create table TB5017_CCTVTOUR
F5017_TOURINDEX NUMBER(6) NOT NULL,
F5017_TOURDESC CHAR(128) NOT NULL,
F5017_SCREENINDEX NUMBER(2) NOT NULL,
F5017_SCREENNUM NUMBER(2) NOT NULL,
F5017_TIMESPACE NUMBER(3) NOT NULL,
F0101_PTZPLEVEL NUMBER(3) NOT NULL
create table TB5018_TOURCAMERA
F5017_TOURINDEX NUMBER(6) NOT NULL,
F5018_GROUPNO NUMBER(6) NOT NULL,
F5018_GROUPDESC CHAR(40) NOT NULL,
F5018_CAMERACODE CHAR(24) NOT NULL,
F5018_CAMERADESC CHAR(128) NOT NULL,
F5018_CAMERANO CHAR(40) NOT NULL,
F5018_CAMERAINDEX NUMBER(6) NOT NULL
15号线需要创建轮巡表(TB5017_CCTVTOUR)保存轮巡信息
create table TB5017_CCTVTOUR
F5017_TOURINDEX NUMBER(6) NOT NULL,
F5017_TOURDESC CHAR(128) NOT NULL,
F5017_SCREENINDEX NUMBER(2) NOT NULL,
F5017_SCREENNUM NUMBER(2) NOT NULL,
F5017_TIMESPACE NUMBER(3) NOT NULL,
F0101_PTZPLEVEL NUMBER(3) NOT NULL
create table TB5018_TOURCAMERA
F5017_TOURINDEX NUMBER(6) NOT NULL,
F5018_GROUPNO NUMBER(6) NOT NULL,
F5018_GROUPDESC CHAR(40) NOT NULL,
F5018_CAMERACODE CHAR(24) NOT NULL,
F5018_CAMERADESC CHAR(128) NOT NULL,
F5018_CAMERANO CHAR(40) NOT NULL,
F5018_CAMERAINDEX NUMBER(6) NOT NULL
15号线需要创建轮巡表(TB5017_CCTVTOUR)保存轮巡信息