its_gangneung

Tables (5)

3D_INTERFACE_OPTION (3D맵_인터페이스_옵션)

  • id (계정 ID) — varchar — Foreign key → USER.opr_id — NOT NULL
  • top_menu_bar (상단메뉴바) — varchar
  • mini_map (미니맵) — varchar
  • icon (아이콘) — varchar
  • traffic_line (통행량선) — varchar
  • information_window (정보창) — varchar
  • mode (모드) — varchar
  • create_date (생성일자) — varchar
  • update_date (수정일자) — varchar

3D_SCREEN_OPTION (3D맵_화면설정)

  • id (계정 ID) — varchar — Foreign key → USER.opr_id — NOT NULL
  • window_mode (창모드) — varchar
  • resolution (해상도) — varchar
  • facility_quality (시설물 품질) — varchar
  • vehicle_quality (차량 품질) — varchar
  • create_date (생성일자) — varchar
  • update_date (수정일자) — varchar

FACILITY_OPTION (시설물 옵션)

  • facility_option_id (id (pk)) — number — Primary key
  • id (계정 ID) — varchar — Foreign key → USER.opr_id — NOT NULL
  • category (its/일반) — varchar
  • type (시설물 종류) — varchar
  • order (순서) — varchar
  • designation (명칭) — varchar
  • use_or_not (사용유무) — varchar
  • color (색) — varchar
  • Field (on/off) — varchar
  • create_date (생성일자) — varchar
  • update_date (수정일자) — varchar

ROLE (권한)

  • role_id (id (pk)) — number — Primary key — NOT NULL
  • role_name (권한명) — varchar

USER (사용자)

  • opr_id (계정 ID) — varchar — Primary key — NOT NULL
  • opr_name (이름) — varchar
  • opr_sex (성별) — varchar
  • opr_mtel (휴대폰번호) — varchar — NOT NULL
  • opr_dept (운영부서) — varchar — NOT NULL
  • role (권한) — varchar — Foreign key → ROLE.role_id — NOT NULL