ITS_OP/SRC - 스마트교차로 테이블 연계 이전 소스/SQL/avi_table.sql

--------------------------------------------------
-- Export file for user GJUTIS                  --
-- Created by OpenValue on 2014-07-16, 11:02:29 --
--------------------------------------------------

spool avi.log

prompt
prompt Creating table TB_AVI_SECT_MSTR
prompt ===============================
prompt
create table GJUTIS.TB_AVI_SECT_MSTR
(
  avi_sect_nmbr  VARCHAR2(10) not null,
  strt_spot_nm   VARCHAR2(60),
  end_spot_nm    VARCHAR2(60),
  avi_sect_nm    VARCHAR2(60),
  avi_sect_dstc  NUMBER(6) default 0,
  shrt_pass_hh   NUMBER(6) default 0,
  lnst_pass_hh   NUMBER(6) default 0,
  spot_num       NUMBER(3) default 0,
  stnd_drft_val  NUMBER(9),
  min_sped       NUMBER(3) default 0,
  max_sped       NUMBER(3) default 0,
  smth_fctr      NUMBER(5,2) default 0,
  del_yn         CHAR(1) default 'N',
  frst_regr_nmbr VARCHAR2(20),
  frst_rgst_dt   VARCHAR2(14),
  last_crpr_nmbr VARCHAR2(20),
  last_crct_dt   VARCHAR2(14)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_SECT_MSTR
  is 'AVI 구간 마스터';
comment on column GJUTIS.TB_AVI_SECT_MSTR.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_SECT_MSTR.strt_spot_nm
  is '시작 지점 명';
comment on column GJUTIS.TB_AVI_SECT_MSTR.end_spot_nm
  is '종료 지점 명';
comment on column GJUTIS.TB_AVI_SECT_MSTR.avi_sect_nm
  is 'AVI 구간 명';
comment on column GJUTIS.TB_AVI_SECT_MSTR.avi_sect_dstc
  is 'AVI 구간 거리';
comment on column GJUTIS.TB_AVI_SECT_MSTR.shrt_pass_hh
  is '최단 통과 시간';
comment on column GJUTIS.TB_AVI_SECT_MSTR.lnst_pass_hh
  is '최장 통과 시간';
comment on column GJUTIS.TB_AVI_SECT_MSTR.spot_num
  is '지점 개수';
comment on column GJUTIS.TB_AVI_SECT_MSTR.stnd_drft_val
  is '표준 편차 값';
comment on column GJUTIS.TB_AVI_SECT_MSTR.min_sped
  is '최소 속도';
comment on column GJUTIS.TB_AVI_SECT_MSTR.max_sped
  is '최대 속도';
comment on column GJUTIS.TB_AVI_SECT_MSTR.smth_fctr
  is '평활화 계수';
comment on column GJUTIS.TB_AVI_SECT_MSTR.del_yn
  is '삭제 여부';
comment on column GJUTIS.TB_AVI_SECT_MSTR.frst_regr_nmbr
  is '최초 등록자 번호';
comment on column GJUTIS.TB_AVI_SECT_MSTR.frst_rgst_dt
  is '최초 등록 일시';
comment on column GJUTIS.TB_AVI_SECT_MSTR.last_crpr_nmbr
  is '최종 수정자 번호';
comment on column GJUTIS.TB_AVI_SECT_MSTR.last_crct_dt
  is '최종 수정 일시';
alter table GJUTIS.TB_AVI_SECT_MSTR
  add constraint IX_AVI_SECT_MSTR_PK primary key (AVI_SECT_NMBR)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;

prompt
prompt Creating table TB_AVI_15M_STAT
prompt ==============================
prompt
create table GJUTIS.TB_AVI_15M_STAT
(
  avi_sect_nmbr VARCHAR2(10) not null,
  stat_dt       VARCHAR2(14) not null,
  stat_yy       VARCHAR2(4) not null,
  stat_mn       VARCHAR2(2) not null,
  stat_dd       VARCHAR2(2) not null,
  stat_hm       VARCHAR2(4) not null,
  day_type_cd   VARCHAR2(7),
  tfvl          NUMBER(6) default 0,
  trvl_sped     NUMBER(3) default 0,
  data_num      NUMBER(3) default 0,
  mtch_rate     NUMBER(3)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_15M_STAT
  is 'AVI 15분 통계';
comment on column GJUTIS.TB_AVI_15M_STAT.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_15M_STAT.stat_dt
  is '통계 일시';
comment on column GJUTIS.TB_AVI_15M_STAT.stat_yy
  is '통계 년';
comment on column GJUTIS.TB_AVI_15M_STAT.stat_mn
  is '통계 월';
comment on column GJUTIS.TB_AVI_15M_STAT.stat_dd
  is '통계 일';
comment on column GJUTIS.TB_AVI_15M_STAT.stat_hm
  is '통계 시분';
comment on column GJUTIS.TB_AVI_15M_STAT.day_type_cd
  is '요일 유형 코드';
comment on column GJUTIS.TB_AVI_15M_STAT.tfvl
  is '교통량';
comment on column GJUTIS.TB_AVI_15M_STAT.trvl_sped
  is '통행 속도';
comment on column GJUTIS.TB_AVI_15M_STAT.data_num
  is '데이터 개수';
comment on column GJUTIS.TB_AVI_15M_STAT.mtch_rate
  is '매칭 율';
alter table GJUTIS.TB_AVI_15M_STAT
  add constraint IX_AVI_15M_STAT_PK primary key (AVI_SECT_NMBR, STAT_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_15M_STAT
  add constraint FK_AVI_15M_STAT__AVI_SECT_NMBR foreign key (AVI_SECT_NMBR)
  references GJUTIS.TB_AVI_SECT_MSTR (AVI_SECT_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_5M_STAT
prompt =============================
prompt
create table GJUTIS.TB_AVI_5M_STAT
(
  avi_sect_nmbr VARCHAR2(10) not null,
  stat_dt       VARCHAR2(14) not null,
  stat_ymd      VARCHAR2(8) not null,
  stat_hm       VARCHAR2(4) not null,
  day_type_cd   VARCHAR2(7),
  tfvl          NUMBER(6) default 0,
  trvl_sped     NUMBER(3) default 0,
  data_num      NUMBER(3) default 0,
  mtch_rate     NUMBER(3)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_5M_STAT
  is 'AVI 5분 통계';
comment on column GJUTIS.TB_AVI_5M_STAT.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_5M_STAT.stat_dt
  is '통계 일시';
comment on column GJUTIS.TB_AVI_5M_STAT.stat_ymd
  is '통계 일자';
comment on column GJUTIS.TB_AVI_5M_STAT.stat_hm
  is '통계 시분';
comment on column GJUTIS.TB_AVI_5M_STAT.day_type_cd
  is '요일 유형 코드';
comment on column GJUTIS.TB_AVI_5M_STAT.tfvl
  is '교통량';
comment on column GJUTIS.TB_AVI_5M_STAT.trvl_sped
  is '통행 속도';
comment on column GJUTIS.TB_AVI_5M_STAT.data_num
  is '데이터 개수';
comment on column GJUTIS.TB_AVI_5M_STAT.mtch_rate
  is '매칭 율';
alter table GJUTIS.TB_AVI_5M_STAT
  add constraint IX_AVI_5M_STAT_PK primary key (AVI_SECT_NMBR, STAT_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_5M_STAT
  add constraint FK_TB_AVI_5M_STAT_01 foreign key (AVI_SECT_NMBR)
  references GJUTIS.TB_AVI_SECT_MSTR (AVI_SECT_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_CTLR
prompt ==========================
prompt
create table GJUTIS.TB_AVI_CTLR
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  avi_id             VARCHAR2(10),
  link_id            NUMBER(10),
  avi_lctn_nm        VARCHAR2(60),
  avi_vald_yn        CHAR(1) default 'N',
  avi_ctlr_ip        VARCHAR2(20),
  avi_ctlr_cmnc_port VARCHAR2(5),
  avi_main_ctlr_yn   CHAR(1) default 'N',
  avi_mngm_lane_num  NUMBER(2),
  avi_cmra_num       NUMBER(2),
  avi_dtct_num       NUMBER(2),
  avi_dtct_nm        VARCHAR2(60),
  avi_clct_cycl      NUMBER(3),
  avi_lamp_auto_yn   CHAR(1) default 'N',
  avi_lamp_on_hms    VARCHAR2(6),
  avi_lamp_off_hms   VARCHAR2(6),
  avi_lamp_on_yn     CHAR(1) default 'N',
  x_crdn             NUMBER(11,8),
  y_crdn             NUMBER(10,8),
  rmrk               VARCHAR2(600),
  del_yn             CHAR(1) default 'N',
  frst_regr_nmbr     VARCHAR2(20),
  frst_rgst_dt       VARCHAR2(14),
  last_crpr_nmbr     VARCHAR2(20),
  last_crct_dt       VARCHAR2(14)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_CTLR
  is 'AVI 제어기';
comment on column GJUTIS.TB_AVI_CTLR.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_CTLR.avi_id
  is 'AVI ID';
comment on column GJUTIS.TB_AVI_CTLR.link_id
  is '링크 ID';
comment on column GJUTIS.TB_AVI_CTLR.avi_lctn_nm
  is 'AVI 위치 명';
comment on column GJUTIS.TB_AVI_CTLR.avi_vald_yn
  is 'AVI 유효 여부';
comment on column GJUTIS.TB_AVI_CTLR.avi_ctlr_ip
  is 'AVI 제어기 아이피';
comment on column GJUTIS.TB_AVI_CTLR.avi_ctlr_cmnc_port
  is 'AVI 제어기 통신 포트';
comment on column GJUTIS.TB_AVI_CTLR.avi_main_ctlr_yn
  is 'AVI 주 제어기 여부';
comment on column GJUTIS.TB_AVI_CTLR.avi_mngm_lane_num
  is 'AVI 관리 차로 개수';
comment on column GJUTIS.TB_AVI_CTLR.avi_cmra_num
  is 'AVI 카메라 개수';
comment on column GJUTIS.TB_AVI_CTLR.avi_dtct_num
  is 'AVI 검지기 개수';
comment on column GJUTIS.TB_AVI_CTLR.avi_dtct_nm
  is 'AVI 검지기 명';
comment on column GJUTIS.TB_AVI_CTLR.avi_clct_cycl
  is 'AVI 수집 주기';
comment on column GJUTIS.TB_AVI_CTLR.avi_lamp_auto_yn
  is 'AVI 조명장치 자동 여부';
comment on column GJUTIS.TB_AVI_CTLR.avi_lamp_on_hms
  is 'AVI 조명장치 ON 시각';
comment on column GJUTIS.TB_AVI_CTLR.avi_lamp_off_hms
  is 'AVI 조명장치 OFF 시각';
comment on column GJUTIS.TB_AVI_CTLR.avi_lamp_on_yn
  is 'AVI 조명장치 ON 여부';
comment on column GJUTIS.TB_AVI_CTLR.x_crdn
  is 'X 좌표';
comment on column GJUTIS.TB_AVI_CTLR.y_crdn
  is 'Y 좌표';
comment on column GJUTIS.TB_AVI_CTLR.rmrk
  is '비고';
comment on column GJUTIS.TB_AVI_CTLR.del_yn
  is '삭제 여부';
comment on column GJUTIS.TB_AVI_CTLR.frst_regr_nmbr
  is '최초 등록자 번호';
comment on column GJUTIS.TB_AVI_CTLR.frst_rgst_dt
  is '최초 등록 일시';
comment on column GJUTIS.TB_AVI_CTLR.last_crpr_nmbr
  is '최종 수정자 번호';
comment on column GJUTIS.TB_AVI_CTLR.last_crct_dt
  is '최종 수정 일시';
alter table GJUTIS.TB_AVI_CTLR
  add constraint IX_AVI_CTLR_PK primary key (AVI_CTLR_MNGM_NMBR)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;

prompt
prompt Creating table TB_AVI_CMRA
prompt ==========================
prompt
create table GJUTIS.TB_AVI_CMRA
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  avi_cmra_id        VARCHAR2(20) not null,
  pcpn_lane          NUMBER(2),
  avi_cmra_drct_cd   VARCHAR2(7),
  updt_dt            VARCHAR2(14),
  del_yn             CHAR(1) default 'N',
  fan_val            NUMBER(4),
  tilt_val           NUMBER(4),
  zoom_val           NUMBER(4),
  focs_val           NUMBER(4),
  frst_regr_nmbr     VARCHAR2(20),
  frst_rgst_dt       VARCHAR2(14),
  last_crpr_nmbr     VARCHAR2(20),
  last_crct_dt       VARCHAR2(14)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_CMRA
  is 'AVI 카메라';
comment on column GJUTIS.TB_AVI_CMRA.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_CMRA.avi_cmra_id
  is 'AVI 카메라 아이디';
comment on column GJUTIS.TB_AVI_CMRA.pcpn_lane
  is '감지 차로';
comment on column GJUTIS.TB_AVI_CMRA.avi_cmra_drct_cd
  is 'AVI 카메라 방향 코드';
comment on column GJUTIS.TB_AVI_CMRA.updt_dt
  is '갱신 일시';
comment on column GJUTIS.TB_AVI_CMRA.del_yn
  is '삭제 여부';
comment on column GJUTIS.TB_AVI_CMRA.fan_val
  is '팬 값';
comment on column GJUTIS.TB_AVI_CMRA.tilt_val
  is '틸트 값';
comment on column GJUTIS.TB_AVI_CMRA.zoom_val
  is '줌 값';
comment on column GJUTIS.TB_AVI_CMRA.focs_val
  is '초점 값';
comment on column GJUTIS.TB_AVI_CMRA.frst_regr_nmbr
  is '최초 등록자 번호';
comment on column GJUTIS.TB_AVI_CMRA.frst_rgst_dt
  is '최초 등록 일시';
comment on column GJUTIS.TB_AVI_CMRA.last_crpr_nmbr
  is '최종 수정자 번호';
comment on column GJUTIS.TB_AVI_CMRA.last_crct_dt
  is '최종 수정 일시';
alter table GJUTIS.TB_AVI_CMRA
  add constraint IX_AVI_CMRA_PK primary key (AVI_CTLR_MNGM_NMBR, AVI_CMRA_ID)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_CMRA
  add constraint FK_AVI_CMRA__AVI_CTLR_MNGM_NMB foreign key (AVI_CTLR_MNGM_NMBR)
  references GJUTIS.TB_AVI_CTLR (AVI_CTLR_MNGM_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_CMRA_LANE
prompt ===============================
prompt
create table GJUTIS.TB_AVI_CMRA_LANE
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  avi_cmra_id        VARCHAR2(20) not null,
  lane_nmbr          NUMBER(2) not null,
  fan_val            NUMBER(4),
  tilt_val           NUMBER(4),
  zoom_val           NUMBER(4),
  focs_val           NUMBER(4),
  pcpn_lane_yn       CHAR(1) default 'N',
  frst_regr_nmbr     VARCHAR2(20),
  frst_rgst_dt       VARCHAR2(14),
  last_crpr_nmbr     VARCHAR2(20),
  last_crct_dt       VARCHAR2(14)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_CMRA_LANE
  is 'AVI 카메라 차로';
comment on column GJUTIS.TB_AVI_CMRA_LANE.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_CMRA_LANE.avi_cmra_id
  is 'AVI 카메라 아이디';
comment on column GJUTIS.TB_AVI_CMRA_LANE.lane_nmbr
  is '차로 번호';
comment on column GJUTIS.TB_AVI_CMRA_LANE.fan_val
  is '팬 값';
comment on column GJUTIS.TB_AVI_CMRA_LANE.tilt_val
  is '틸트 값';
comment on column GJUTIS.TB_AVI_CMRA_LANE.zoom_val
  is '줌 값';
comment on column GJUTIS.TB_AVI_CMRA_LANE.focs_val
  is '초점 값';
comment on column GJUTIS.TB_AVI_CMRA_LANE.pcpn_lane_yn
  is '감지 차로 여부';
comment on column GJUTIS.TB_AVI_CMRA_LANE.frst_regr_nmbr
  is '최초 등록자 번호';
comment on column GJUTIS.TB_AVI_CMRA_LANE.frst_rgst_dt
  is '최초 등록 일시';
comment on column GJUTIS.TB_AVI_CMRA_LANE.last_crpr_nmbr
  is '최종 수정자 번호';
comment on column GJUTIS.TB_AVI_CMRA_LANE.last_crct_dt
  is '최종 수정 일시';
alter table GJUTIS.TB_AVI_CMRA_LANE
  add constraint IX_AVI_CMRA_LANE_PK primary key (AVI_CTLR_MNGM_NMBR, AVI_CMRA_ID, LANE_NMBR)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_CMRA_LANE
  add constraint FK_AVI_CMRA_LANE__AVI_CTLR_MNG foreign key (AVI_CTLR_MNGM_NMBR, AVI_CMRA_ID)
  references GJUTIS.TB_AVI_CMRA (AVI_CTLR_MNGM_NMBR, AVI_CMRA_ID)
  disable;

prompt
prompt Creating table TB_AVI_CTLR_IDNT
prompt ===============================
prompt
create table GJUTIS.TB_AVI_CTLR_IDNT
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  avi_dtct_nmbr      VARCHAR2(2) not null,
  crtn_dt            VARCHAR2(14) not null,
  crtn_ymd           VARCHAR2(8) not null,
  crtn_hms           VARCHAR2(6) not null,
  tot_data_num       NUMBER(6) default 0,
  idnt_data_num      NUMBER(6) default 0,
  nidn_data_num      NUMBER(6) default 0,
  idnt_rate          NUMBER(3)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_CTLR_IDNT
  is 'AVI 제어기 인식';
comment on column GJUTIS.TB_AVI_CTLR_IDNT.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_CTLR_IDNT.avi_dtct_nmbr
  is 'AVI 검지기 번호';
comment on column GJUTIS.TB_AVI_CTLR_IDNT.crtn_dt
  is '생성 일시';
comment on column GJUTIS.TB_AVI_CTLR_IDNT.crtn_ymd
  is '생성 일자';
comment on column GJUTIS.TB_AVI_CTLR_IDNT.crtn_hms
  is '생성 시각';
comment on column GJUTIS.TB_AVI_CTLR_IDNT.tot_data_num
  is '총 데이터 개수';
comment on column GJUTIS.TB_AVI_CTLR_IDNT.idnt_data_num
  is '인식 데이터 개수';
comment on column GJUTIS.TB_AVI_CTLR_IDNT.nidn_data_num
  is '미인식 데이터 개수';
comment on column GJUTIS.TB_AVI_CTLR_IDNT.idnt_rate
  is '인식 율';
alter table GJUTIS.TB_AVI_CTLR_IDNT
  add constraint IX_AVI_CTLR_IDNT_PK primary key (AVI_CTLR_MNGM_NMBR, AVI_DTCT_NMBR, CRTN_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_CTLR_IDNT
  add constraint FK_AVI_CTLR_IDNT__AVI_CTLR_MNG foreign key (AVI_CTLR_MNGM_NMBR)
  references GJUTIS.TB_AVI_CTLR (AVI_CTLR_MNGM_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_CTLR_STTS
prompt ===============================
prompt
create table GJUTIS.TB_AVI_CTLR_STTS
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  cmnc_stts_cd       VARCHAR2(7),
  cbox_door_stts_cd  VARCHAR2(7),
  fan_stts_cd        VARCHAR2(7),
  hetr_stts_cd       VARCHAR2(7),
  tmpr               NUMBER(6,3),
  cmra_mtns_stts_cd  VARCHAR2(7),
  volt_stts_cd       VARCHAR2(7),
  lamp_stts_cd       VARCHAR2(7),
  updt_dt            VARCHAR2(14)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_CTLR_STTS
  is 'AVI 제어기 상태';
comment on column GJUTIS.TB_AVI_CTLR_STTS.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_CTLR_STTS.cmnc_stts_cd
  is '통신 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS.cbox_door_stts_cd
  is '함체 문 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS.fan_stts_cd
  is '팬 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS.hetr_stts_cd
  is '히터 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS.tmpr
  is '온도';
comment on column GJUTIS.TB_AVI_CTLR_STTS.cmra_mtns_stts_cd
  is '카메라 동작 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS.volt_stts_cd
  is '전압 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS.lamp_stts_cd
  is '조명장치 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS.updt_dt
  is '갱신 일시';
alter table GJUTIS.TB_AVI_CTLR_STTS
  add constraint IX_AVI_CTLR_STTS_PK primary key (AVI_CTLR_MNGM_NMBR)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_CTLR_STTS
  add constraint FK_AVI_CTLR_STTS__AVI_CTLR_MNG foreign key (AVI_CTLR_MNGM_NMBR)
  references GJUTIS.TB_AVI_CTLR (AVI_CTLR_MNGM_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_CTLR_STTS_HS
prompt ==================================
prompt
create table GJUTIS.TB_AVI_CTLR_STTS_HS
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  crtn_dt            VARCHAR2(14) not null,
  cmnc_stts_cd       VARCHAR2(7),
  cbox_door_stts_cd  VARCHAR2(7),
  fan_stts_cd        VARCHAR2(7),
  hetr_stts_cd       VARCHAR2(7),
  tmpr               NUMBER(6,3),
  cmra_mtns_stts_cd  VARCHAR2(7),
  volt_stts_cd       VARCHAR2(7),
  lamp_stts_cd       VARCHAR2(7)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_CTLR_STTS_HS
  is 'AVI 제어기 상태 이력';
comment on column GJUTIS.TB_AVI_CTLR_STTS_HS.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_CTLR_STTS_HS.crtn_dt
  is '생성 일시';
comment on column GJUTIS.TB_AVI_CTLR_STTS_HS.cmnc_stts_cd
  is '통신 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS_HS.cbox_door_stts_cd
  is '함체 문 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS_HS.fan_stts_cd
  is '팬 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS_HS.hetr_stts_cd
  is '히터 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS_HS.tmpr
  is '온도';
comment on column GJUTIS.TB_AVI_CTLR_STTS_HS.cmra_mtns_stts_cd
  is '카메라 동작 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS_HS.volt_stts_cd
  is '전압 상태 코드';
comment on column GJUTIS.TB_AVI_CTLR_STTS_HS.lamp_stts_cd
  is '조명장치 상태 코드';
alter table GJUTIS.TB_AVI_CTLR_STTS_HS
  add constraint IX_AVI_CTLR_STTS_HS_PK primary key (AVI_CTLR_MNGM_NMBR, CRTN_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_CTLR_STTS_HS
  add constraint FK_AVI_CTLR_STTS_HS__AVI_CTLR_ foreign key (AVI_CTLR_MNGM_NMBR)
  references GJUTIS.TB_AVI_CTLR (AVI_CTLR_MNGM_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_CTLR_TRFC
prompt ===============================
prompt
create table GJUTIS.TB_AVI_CTLR_TRFC
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  avi_dtct_chnl_nmbr VARCHAR2(2) not null,
  crtn_dt            VARCHAR2(14) not null,
  crtn_ymd           VARCHAR2(8) not null,
  crtn_hms           VARCHAR2(6) not null,
  tfvl               NUMBER(6) default 0,
  ocpy_rate          NUMBER(5,2) default 0,
  spot_sped          NUMBER(3) default 0
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_CTLR_TRFC
  is 'AVI 제어기 교통';
comment on column GJUTIS.TB_AVI_CTLR_TRFC.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_CTLR_TRFC.avi_dtct_chnl_nmbr
  is 'AVI 검지기 채널 번호';
comment on column GJUTIS.TB_AVI_CTLR_TRFC.crtn_dt
  is '생성 일시';
comment on column GJUTIS.TB_AVI_CTLR_TRFC.crtn_ymd
  is '생성 일자';
comment on column GJUTIS.TB_AVI_CTLR_TRFC.crtn_hms
  is '생성 시각';
comment on column GJUTIS.TB_AVI_CTLR_TRFC.tfvl
  is '교통량';
comment on column GJUTIS.TB_AVI_CTLR_TRFC.ocpy_rate
  is '점유 율';
comment on column GJUTIS.TB_AVI_CTLR_TRFC.spot_sped
  is '지점 속도';
alter table GJUTIS.TB_AVI_CTLR_TRFC
  add constraint IX_AVI_CTLR_TRFC_PK primary key (AVI_CTLR_MNGM_NMBR, AVI_DTCT_CHNL_NMBR, CRTN_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_CTLR_TRFC
  add constraint FK_AVI_CTLR_TRFC__AVI_CTLR_MNG foreign key (AVI_CTLR_MNGM_NMBR)
  references GJUTIS.TB_AVI_CTLR (AVI_CTLR_MNGM_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_DD_STAT
prompt =============================
prompt
create table GJUTIS.TB_AVI_DD_STAT
(
  avi_sect_nmbr VARCHAR2(10) not null,
  stat_dt       VARCHAR2(14) not null,
  stat_yy       VARCHAR2(4) not null,
  stat_mn       VARCHAR2(2) not null,
  stat_dd       VARCHAR2(2) not null,
  day_type_cd   VARCHAR2(7),
  tfvl          NUMBER(6) default 0,
  trvl_sped     NUMBER(3) default 0,
  data_num      NUMBER(3) default 0,
  mtch_rate     NUMBER(3)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_DD_STAT
  is 'AVI 일 통계';
comment on column GJUTIS.TB_AVI_DD_STAT.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_DD_STAT.stat_dt
  is '통계 일시';
comment on column GJUTIS.TB_AVI_DD_STAT.stat_yy
  is '통계 년';
comment on column GJUTIS.TB_AVI_DD_STAT.stat_mn
  is '통계 월';
comment on column GJUTIS.TB_AVI_DD_STAT.stat_dd
  is '통계 일';
comment on column GJUTIS.TB_AVI_DD_STAT.day_type_cd
  is '요일 유형 코드';
comment on column GJUTIS.TB_AVI_DD_STAT.tfvl
  is '교통량';
comment on column GJUTIS.TB_AVI_DD_STAT.trvl_sped
  is '통행 속도';
comment on column GJUTIS.TB_AVI_DD_STAT.data_num
  is '데이터 개수';
comment on column GJUTIS.TB_AVI_DD_STAT.mtch_rate
  is '매칭 율';
alter table GJUTIS.TB_AVI_DD_STAT
  add constraint IX_AVI_DD_STAT_PK primary key (AVI_SECT_NMBR, STAT_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_DD_STAT
  add constraint FK_AVI_DD_STAT__AVI_SECT_NMBR foreign key (AVI_SECT_NMBR)
  references GJUTIS.TB_AVI_SECT_MSTR (AVI_SECT_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_HH_STAT
prompt =============================
prompt
create table GJUTIS.TB_AVI_HH_STAT
(
  avi_sect_nmbr VARCHAR2(10) not null,
  stat_dt       VARCHAR2(14) not null,
  stat_yy       VARCHAR2(4) not null,
  stat_mn       VARCHAR2(2) not null,
  stat_dd       VARCHAR2(2) not null,
  stat_hm       VARCHAR2(4) not null,
  day_type_cd   VARCHAR2(7),
  tfvl          NUMBER(6) default 0,
  trvl_sped     NUMBER(3) default 0,
  data_num      NUMBER(3) default 0,
  mtch_rate     NUMBER(3)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_HH_STAT
  is 'AVI 시간 통계';
comment on column GJUTIS.TB_AVI_HH_STAT.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_HH_STAT.stat_dt
  is '통계 일시';
comment on column GJUTIS.TB_AVI_HH_STAT.stat_yy
  is '통계 년';
comment on column GJUTIS.TB_AVI_HH_STAT.stat_mn
  is '통계 월';
comment on column GJUTIS.TB_AVI_HH_STAT.stat_dd
  is '통계 일';
comment on column GJUTIS.TB_AVI_HH_STAT.stat_hm
  is '통계 시분';
comment on column GJUTIS.TB_AVI_HH_STAT.day_type_cd
  is '요일 유형 코드';
comment on column GJUTIS.TB_AVI_HH_STAT.tfvl
  is '교통량';
comment on column GJUTIS.TB_AVI_HH_STAT.trvl_sped
  is '통행 속도';
comment on column GJUTIS.TB_AVI_HH_STAT.data_num
  is '데이터 개수';
comment on column GJUTIS.TB_AVI_HH_STAT.mtch_rate
  is '매칭 율';
alter table GJUTIS.TB_AVI_HH_STAT
  add constraint IX_AVI_HH_STAT_PK primary key (AVI_SECT_NMBR, STAT_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_HH_STAT
  add constraint FK_AVI_HH_STAT__AVI_SECT_NMBR foreign key (AVI_SECT_NMBR)
  references GJUTIS.TB_AVI_SECT_MSTR (AVI_SECT_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_PASS_VHCL
prompt ===============================
prompt
create table GJUTIS.TB_AVI_PASS_VHCL
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  whol_vhcl_nmbr     VARCHAR2(15) not null,
  crtn_dt            VARCHAR2(14) not null,
  vhcl_nmbr          VARCHAR2(15),
  lane_nmbr          NUMBER(2),
  lane_drct          VARCHAR2(7),
  vhcl_kind_cd       VARCHAR2(7)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_PASS_VHCL
  is 'AVI 통과 차량';
comment on column GJUTIS.TB_AVI_PASS_VHCL.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_PASS_VHCL.whol_vhcl_nmbr
  is '전체 차량 번호';
comment on column GJUTIS.TB_AVI_PASS_VHCL.crtn_dt
  is '생성 일시';
comment on column GJUTIS.TB_AVI_PASS_VHCL.vhcl_nmbr
  is '차량 번호';
comment on column GJUTIS.TB_AVI_PASS_VHCL.lane_nmbr
  is '차로 번호';
comment on column GJUTIS.TB_AVI_PASS_VHCL.lane_drct
  is '차로 방향';
comment on column GJUTIS.TB_AVI_PASS_VHCL.vhcl_kind_cd
  is '차량 종류 코드';
alter table GJUTIS.TB_AVI_PASS_VHCL
  add constraint IX_AVI_PASS_VHCL_PK primary key (AVI_CTLR_MNGM_NMBR, WHOL_VHCL_NMBR, CRTN_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_PASS_VHCL
  add constraint FK_AVI_PASS_VHCL__AVI_CTLR_MNG foreign key (AVI_CTLR_MNGM_NMBR)
  references GJUTIS.TB_AVI_CTLR (AVI_CTLR_MNGM_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_IMGN_DATA
prompt ===============================
prompt
create table GJUTIS.TB_AVI_IMGN_DATA
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  whol_vhcl_nmbr     VARCHAR2(15) not null,
  crtn_dt            VARCHAR2(14) not null,
  idnt_rslt_yn       CHAR(1) default 'N',
  data_size          NUMBER(14),
  stor_path          VARCHAR2(200),
  file_nm            VARCHAR2(100)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_IMGN_DATA
  is 'AVI 영상 데이터';
comment on column GJUTIS.TB_AVI_IMGN_DATA.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_IMGN_DATA.whol_vhcl_nmbr
  is '전체 차량 번호';
comment on column GJUTIS.TB_AVI_IMGN_DATA.crtn_dt
  is '생성 일시';
comment on column GJUTIS.TB_AVI_IMGN_DATA.idnt_rslt_yn
  is '인식 결과 여부';
comment on column GJUTIS.TB_AVI_IMGN_DATA.data_size
  is '데이터 크기';
comment on column GJUTIS.TB_AVI_IMGN_DATA.stor_path
  is '저장 경로';
comment on column GJUTIS.TB_AVI_IMGN_DATA.file_nm
  is '파일 명';
alter table GJUTIS.TB_AVI_IMGN_DATA
  add constraint IX_AVI_IMGN_DATA_PK primary key (AVI_CTLR_MNGM_NMBR, WHOL_VHCL_NMBR, CRTN_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_IMGN_DATA
  add constraint FK_AVI_IMGN_DATA__AVI_CTLR_MNG foreign key (AVI_CTLR_MNGM_NMBR, WHOL_VHCL_NMBR, CRTN_DT)
  references GJUTIS.TB_AVI_PASS_VHCL (AVI_CTLR_MNGM_NMBR, WHOL_VHCL_NMBR, CRTN_DT)
  disable;

prompt
prompt Creating table TB_AVI_LMP_MTNS_RECL
prompt ===================================
prompt
create table GJUTIS.TB_AVI_LMP_MTNS_RECL
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  avi_cmra_id        VARCHAR2(20) not null,
  lmp_nmbr           NUMBER(2),
  mtns_recl          NUMBER(9),
  rgst_dt            VARCHAR2(14)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_LMP_MTNS_RECL
  is 'AVI 램프 동작 회수';
comment on column GJUTIS.TB_AVI_LMP_MTNS_RECL.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_LMP_MTNS_RECL.avi_cmra_id
  is 'AVI 카메라 아이디';
comment on column GJUTIS.TB_AVI_LMP_MTNS_RECL.lmp_nmbr
  is '램프 번호';
comment on column GJUTIS.TB_AVI_LMP_MTNS_RECL.mtns_recl
  is '동작 회수';
comment on column GJUTIS.TB_AVI_LMP_MTNS_RECL.rgst_dt
  is '등록 일시';
alter table GJUTIS.TB_AVI_LMP_MTNS_RECL
  add constraint IX_AVI_LMP_MTNS_RECL_PK primary key (AVI_CTLR_MNGM_NMBR, AVI_CMRA_ID)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_LMP_MTNS_RECL
  add constraint FK_AVI_LMP_MTNS_RECL__AVI_CTLR foreign key (AVI_CTLR_MNGM_NMBR, AVI_CMRA_ID)
  references GJUTIS.TB_AVI_CMRA (AVI_CTLR_MNGM_NMBR, AVI_CMRA_ID)
  disable;

prompt
prompt Creating table TB_AVI_MN_STAT
prompt =============================
prompt
create table GJUTIS.TB_AVI_MN_STAT
(
  avi_sect_nmbr VARCHAR2(10) not null,
  stat_dt       VARCHAR2(14) not null,
  stat_yy       VARCHAR2(4) not null,
  stat_mn       VARCHAR2(2) not null,
  tfvl          NUMBER(6) default 0,
  trvl_sped     NUMBER(3) default 0,
  data_num      NUMBER(3) default 0,
  mtch_rate     NUMBER(3)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_MN_STAT
  is 'AVI 월 통계';
comment on column GJUTIS.TB_AVI_MN_STAT.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_MN_STAT.stat_dt
  is '통계 일시';
comment on column GJUTIS.TB_AVI_MN_STAT.stat_yy
  is '통계 년';
comment on column GJUTIS.TB_AVI_MN_STAT.stat_mn
  is '통계 월';
comment on column GJUTIS.TB_AVI_MN_STAT.tfvl
  is '교통량';
comment on column GJUTIS.TB_AVI_MN_STAT.trvl_sped
  is '통행 속도';
comment on column GJUTIS.TB_AVI_MN_STAT.data_num
  is '데이터 개수';
comment on column GJUTIS.TB_AVI_MN_STAT.mtch_rate
  is '매칭 율';
alter table GJUTIS.TB_AVI_MN_STAT
  add constraint IX_AVI_MN_STAT_PK primary key (AVI_SECT_NMBR, STAT_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_MN_STAT
  add constraint FK_AVI_MN_STAT__AVI_SECT_NMBR foreign key (AVI_SECT_NMBR)
  references GJUTIS.TB_AVI_SECT_MSTR (AVI_SECT_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_SECT_CNFG
prompt ===============================
prompt
create table GJUTIS.TB_AVI_SECT_CNFG
(
  avi_ctlr_mngm_nmbr VARCHAR2(20) not null,
  avi_sect_nmbr      VARCHAR2(10) not null,
  ord                NUMBER(3) default 0,
  frst_regr_nmbr     VARCHAR2(20),
  frst_rgst_dt       VARCHAR2(14),
  last_crpr_nmbr     VARCHAR2(20),
  last_crct_dt       VARCHAR2(14)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_SECT_CNFG
  is 'AVI 구간 구성';
comment on column GJUTIS.TB_AVI_SECT_CNFG.avi_ctlr_mngm_nmbr
  is 'AVI 제어기 관리 번호';
comment on column GJUTIS.TB_AVI_SECT_CNFG.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_SECT_CNFG.ord
  is '순서';
comment on column GJUTIS.TB_AVI_SECT_CNFG.frst_regr_nmbr
  is '최초 등록자 번호';
comment on column GJUTIS.TB_AVI_SECT_CNFG.frst_rgst_dt
  is '최초 등록 일시';
comment on column GJUTIS.TB_AVI_SECT_CNFG.last_crpr_nmbr
  is '최종 수정자 번호';
comment on column GJUTIS.TB_AVI_SECT_CNFG.last_crct_dt
  is '최종 수정 일시';
alter table GJUTIS.TB_AVI_SECT_CNFG
  add constraint IX_AVI_SECT_CNFG_PK primary key (AVI_CTLR_MNGM_NMBR, AVI_SECT_NMBR)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_SECT_CNFG
  add constraint FK_AVI_SECT_CNFG_02 foreign key (AVI_SECT_NMBR)
  references GJUTIS.TB_AVI_SECT_MSTR (AVI_SECT_NMBR)
  disable;
alter table GJUTIS.TB_AVI_SECT_CNFG
  add constraint FK_AVI_SECT_CNFG__AVI_CTLR_MNG foreign key (AVI_CTLR_MNGM_NMBR)
  references GJUTIS.TB_AVI_CTLR (AVI_CTLR_MNGM_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_SECT_LINK
prompt ===============================
prompt
create table GJUTIS.TB_AVI_SECT_LINK
(
  avi_sect_nmbr VARCHAR2(10) not null,
  link_id       NUMBER(10) not null,
  ord           NUMBER(3) default 0
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_SECT_LINK
  is 'AVI 구간_링크';
comment on column GJUTIS.TB_AVI_SECT_LINK.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_SECT_LINK.link_id
  is '링크 ID';
comment on column GJUTIS.TB_AVI_SECT_LINK.ord
  is '순서';
alter table GJUTIS.TB_AVI_SECT_LINK
  add constraint IX_AVI_SECT_LINK_PK primary key (AVI_SECT_NMBR, LINK_ID)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_SECT_LINK
  add constraint FK_AVI_SECT_LINK__AVI_SECT_NMB foreign key (AVI_SECT_NMBR)
  references GJUTIS.TB_AVI_SECT_MSTR (AVI_SECT_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_SECT_MTCH
prompt ===============================
prompt
create table GJUTIS.TB_AVI_SECT_MTCH
(
  avi_sect_nmbr VARCHAR2(10) not null,
  crtn_dt       VARCHAR2(14) not null,
  strt_spot_cnt NUMBER(6) default 0,
  end_spot_cnt  NUMBER(6) default 0,
  tot_mtch_cnt  NUMBER(6) default 0,
  mtch_rate     NUMBER(3)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_SECT_MTCH
  is 'AVI 구간 매칭';
comment on column GJUTIS.TB_AVI_SECT_MTCH.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_SECT_MTCH.crtn_dt
  is '생성 일시';
comment on column GJUTIS.TB_AVI_SECT_MTCH.strt_spot_cnt
  is '시작 지점 건수';
comment on column GJUTIS.TB_AVI_SECT_MTCH.end_spot_cnt
  is '종료 지점 건수';
comment on column GJUTIS.TB_AVI_SECT_MTCH.tot_mtch_cnt
  is '총 매칭 건수';
comment on column GJUTIS.TB_AVI_SECT_MTCH.mtch_rate
  is '매칭 율';
alter table GJUTIS.TB_AVI_SECT_MTCH
  add constraint IX_AVI_SECT_MTCH_PK primary key (AVI_SECT_NMBR, CRTN_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_SECT_MTCH
  add constraint FK_AVI_SECT_MTCH__AVI_SECT_NMB foreign key (AVI_SECT_NMBR)
  references GJUTIS.TB_AVI_SECT_MSTR (AVI_SECT_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_SECT_RAW
prompt ==============================
prompt
create table GJUTIS.TB_AVI_SECT_RAW
(
  avi_sect_nmbr    VARCHAR2(10) not null,
  crtn_dt          VARCHAR2(14) not null,
  crtn_ord         NUMBER(6) default 0 not null,
  vhcl_nmbr        VARCHAR2(15),
  trvl_hh          NUMBER(6) default 0,
  strt_avi_pass_dt VARCHAR2(14),
  end_avi_pass_dt  VARCHAR2(14),
  trvl_sped        NUMBER(3) default 0,
  vhcl_kind_cd     VARCHAR2(7)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_SECT_RAW
  is 'AVI 구간 원시';
comment on column GJUTIS.TB_AVI_SECT_RAW.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_SECT_RAW.crtn_dt
  is '생성 일시';
comment on column GJUTIS.TB_AVI_SECT_RAW.crtn_ord
  is '생성 순서';
comment on column GJUTIS.TB_AVI_SECT_RAW.vhcl_nmbr
  is '차량 번호';
comment on column GJUTIS.TB_AVI_SECT_RAW.trvl_hh
  is '통행 시간';
comment on column GJUTIS.TB_AVI_SECT_RAW.strt_avi_pass_dt
  is '시작 AVI 통과 일시';
comment on column GJUTIS.TB_AVI_SECT_RAW.end_avi_pass_dt
  is '종료 AVI 통과 일시';
comment on column GJUTIS.TB_AVI_SECT_RAW.trvl_sped
  is '통행 속도';
comment on column GJUTIS.TB_AVI_SECT_RAW.vhcl_kind_cd
  is '차량 종류 코드';
alter table GJUTIS.TB_AVI_SECT_RAW
  add constraint IX_AVI_SECT_RAW_PK primary key (AVI_SECT_NMBR, CRTN_DT, CRTN_ORD)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_SECT_RAW
  add constraint FK_AVI_SECT_RAW__AVI_SECT_NMBR foreign key (AVI_SECT_NMBR)
  references GJUTIS.TB_AVI_SECT_MSTR (AVI_SECT_NMBR)
  disable;

prompt
prompt Creating table TB_AVI_SECT_TRAF
prompt ===============================
prompt
create table GJUTIS.TB_AVI_SECT_TRAF
(
  avi_sect_nmbr VARCHAR2(10) not null,
  crtn_dt       VARCHAR2(14) not null,
  tfvl          NUMBER(6) default 0,
  trvl_sped     NUMBER(3) default 0,
  data_num      NUMBER(3) default 0,
  mtch_rate     NUMBER(3)
)
tablespace ITS_HIST_DATA
  pctfree 10
  initrans 1
  maxtrans 255
nologging;
comment on table GJUTIS.TB_AVI_SECT_TRAF
  is 'AVI 구간 소통상황';
comment on column GJUTIS.TB_AVI_SECT_TRAF.avi_sect_nmbr
  is 'AVI 구간 번호';
comment on column GJUTIS.TB_AVI_SECT_TRAF.crtn_dt
  is '생성 일시';
comment on column GJUTIS.TB_AVI_SECT_TRAF.tfvl
  is '교통량';
comment on column GJUTIS.TB_AVI_SECT_TRAF.trvl_sped
  is '통행 속도';
comment on column GJUTIS.TB_AVI_SECT_TRAF.data_num
  is '데이터 개수';
comment on column GJUTIS.TB_AVI_SECT_TRAF.mtch_rate
  is '매칭 율';
alter table GJUTIS.TB_AVI_SECT_TRAF
  add constraint IX_AVI_SECT_TRAF_PK primary key (AVI_SECT_NMBR, CRTN_DT)
  using index 
  tablespace ITS_HIST_DATA
  pctfree 10
  initrans 2
  maxtrans 255;
alter table GJUTIS.TB_AVI_SECT_TRAF
  add constraint FK_AVI_SECT_TRAF__AVI_SECT_NMB foreign key (AVI_SECT_NMBR)
  references GJUTIS.TB_AVI_SECT_MSTR (AVI_SECT_NMBR)
  disable;


spool off