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