hds3
Tables (13)
CCTV (Untitled)
- cctv_cd (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
CMM_CODE_GRP (Untitled8)
- grp_cd (Key) — Primary key — NOT NULL
- grp_nm (Field)
DANGER_DETECT_HIS (Untitled6)
- seq (Key2) — Primary key — NOT NULL
- cctv_cd (Key) — Foreign key → CCTV.cctv_cd — NOT NULL
DETECT_SETTING (감지옵션 영역별 설정)
- decect_code (Key) — Foreign key → DETECT_TYPE.decect_code — NOT NULL
- code (Key2) — Foreign key → DIV_MIX.code — NOT NULL
- name (명칭)
- use_yn (Field)
DETECT_TYPE (Untitled4)
- decect_code (Key) — Primary key — NOT NULL
- weight (Field)
- color (Field2)
- all_check (전체감지여부) — boolean
DIV (Untitled10)
- seq (Key2) — Primary key — NOT NULL
- grp_cd (Key) — Foreign key → DIV_GRP.grp_cd — NOT NULL
- type_nm (Field)
DIV_GRP (Untitled9)
- grp_cd (Key) — Primary key — NOT NULL
- grp_nm (Field)
- grp_column (Field2)
DIV_MIX (Untitled11)
- code (Key) — Primary key — NOT NULL
- detect_zone_div (Field)
- yard_div (Field2)
- bg_img_path (Field4)
- use_yn (Field3) — boolean
DIV_MIX(2) (CopyOfUntitled11)
- code (Key) — Primary key — NOT NULL
- name (Field)
- bg_img_path (Field4)
- use_yn (Field3) — boolean
DZ_BOX (Untitled3)
- dz_box_seq (Key2) — Primary key — NOT NULL
- cctv_cd (Key) — Foreign key → CCTV.cctv_cd — NOT NULL
- decect_code (Key3) — Foreign key → DETECT_TYPE.decect_code — NOT NULL
DZ_BOX_COOR (Untitled5)
- coor_no (Key) — Primary key — NOT NULL
- dz_box_seq (Key2) — Foreign key → DZ_BOX.dz_box_seq — NOT NULL
- coor_x (Field)
- coor_y (Field2)
USER (Untitled2)
- user_id (Key) — Primary key — NOT NULL
- password (Field)
- user_nm (Field2)
- tel (Field3)
- use_yn (Field4)
- auth_cd (Field5)
- dept_cd (Field6)
- reg_id (Field7)
- reg_dt (Field8)
- upd_id (Field9)
- upd_dt (Field10)