ISCS#FEP

15号线需要创建轮巡表(TB5017_CCTVTOUR,TB5018_TOURCAMERA)保存轮巡信息
create table TB5017_CCTVTOUR
F5017_TOURINDEX NUMBER NOT NULL,
F5017_TOURDESC CHAR NOT NULL,
F5017_SCREENINDEX NUMBER NOT NULL,
F5017_SCREENNUM NUMBER NOT NULL,
F5017_TIMESPACE NUMBER NOT NULL,
F0101_PTZPLEVEL NUMBER NOT NULL

create table TB5018_TOURCAMERA
F5017_TOURINDEX NUMBER NOT NULL,
F5018_GROUPNO NUMBER NOT NULL,
F5018_GROUPDESC CHAR NOT NULL,
F5018_CAMERACODE CHAR NOT NULL,
F5018_CAMERADESC CHAR NOT NULL,
F5018_CAMERANO CHAR NOT NULL,
F5018_CAMERAINDEX NUMBER NOT NULL