hds3

Tables (13)

CCTV (Untitled)

  • cctv_cd (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → USER.user_id — NOT NULL

CMM_CODE (Untitled7)

    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)