SEM
테이블 (21)
Area 위치 정보 (ht_geofence_area_points)
- area_id — integer — 외래 키 → Geofence 에 할당된 Area.area_id — NOT NULL
- geofence_id — integer — 외래 키 → Geofence 에 할당된 Area.geofence_id — NOT NULL
- latitude — double — NOT NULL
- longitude — double — NOT NULL
- sequence — integer — NOT NULL
- creation_user — character
- creation_date — timestamp
- modification_user — character
- modification_date — timestamp
- tag_point — boolean
Geofence 에 할당된 Area (ht_geofence_area)
- area_id — integer — 기본 키 — NOT NULL
- geofence_id — integer — 외래 키 → Geofence 정보.geofence_id — NOT NULL
- area_name — character — NOT NULL
Geofence 위치 정보 (ht_geofence_points)
- geofence_id — integer — 외래 키 → Geofence 정보.geofence_id — NOT NULL
- latitude — double — NOT NULL
- longitude — double — NOT NULL
- sequence — integer — NOT NULL
- creation_user — character
- creation_date — timestamp
- modification_user — character
- modification_date — timestamp
Geofence 정보 (ht_geofence)
- geofence_id — integer — 기본 키 — NOT NULL
- geofence_name — character — NOT NULL
- geofence_color — character — NOT NULL
- group_name — character — NOT NULL
- active — boolean
- creation_user — character
- creation_date — timestamp
- modification_user — character
- modification_date — timestamp
ht_task_type
- type — character — 기본 키 — NOT NULL
마스터 테이블 데이터 (ht_bems)
- equipment_number — text
- equipment_status — text
- equipment_company — text
- equipment_vin — text
- material_group — text
- material_no — text
- material_description — text
- plant — text
- storage_location — text
- storage_type — text
- storage_type_name — text
- document_number — text
- base_unit — text
- total_stock — integer
- first_gr_date — text
- date_last_move — text
- loaded_ts — bigint
- creation_user — character
- creation_date — timestamp
- modification_user — character
- modification_date — timestamp
- equipment_type — text
- usage_type — text
- plate_number — text
- storage_bin — text
- bin_position — text
- warehouse_number — text
- total_distance — double
메일 인증 (ht_auth_mail)
- id — character — 기본 키 — NOT NULL
- type — character — 기본 키 — NOT NULL
- generate_key — character
- authenticated — boolean
- creation_user — character
- creation_date — timestamp
- modification_user — character
- modification_date — timestamp
- retry_count — integer
사용자 (ht_user)
- id — character — 기본 키 — NOT NULL
- geofence_id (geofence_id2) — integer — 외래 키 → Geofence 정보.geofence_id — NOT NULL
- first_name — character
- last_name — character
- password — character
- company_id — character
- department — character
- position — character
- locale — character
- time_zone — character
- country_code — character
- phone_no — character
- user_level — character
- join_date — timestamp
- inviter — character
- deactivated — boolean
- geofence_id — integer — NOT NULL
사용자 권한 (ht_authority)
- username — character — 기본 키 — NOT NULL
- authority_name — character — NOT NULL
사용자 로그인 내역 (ht_login_history)
- id — character — 기본 키 — NOT NULL
- user_id — character
- type — character
- ip_address — character
- mac_address — character
- history_date — timestamp
습도 내역 (ht_moisture_history)
- moisture_id — integer — 기본 키 — NOT NULL
- material_no — character — NOT NULL
- left_front — integer
- left_back — integer
- back — integer
- right_front — integer
- right_back — integer
- avg — integer
- max — integer
- worker_id — character — NOT NULL
- ts — integer
업무 (ht_task)
- task_id — character — 기본 키 — NOT NULL
- type — character — 외래 키 → ht_task_type.type — NOT NULL
- worker_id — text
- manager_id — character
- equipment — character
- tracker — character
- comment — text — ext COLLATE pg_catalog."default
- worker_comment — text — ext COLLATE pg_catalog."default
- due_date — timestamp
- completed_date — timestamp
- order_date — timestamp
- deleted — boolean — NOT NULL
- order_type — character
인증된 사용자 (ht_auth_user)
- username — character — 기본 키 — NOT NULL
- password — character — NOT NULL
- name — character
- is_account_non_expired — boolean
- is_account_non_locked — boolean
- is_credentials_non_expired — boolean
- is_enabled — boolean
초대 유저 (ht_invite_user)
- id — character — 기본 키 — NOT NULL
- user_level — character
- first_name — character
- last_name — character
카트 목록 (ht_cart)
- id — character — 기본 키 — NOT NULL
- cart_equipments — text
- cart_trackers — text
- order_equipments — text
- order_trackers — text
- creation_user — character
- creation_date — timestamp
- modification_user — character
- modification_date — timestamp
태그 (ht_tag)
- tag_id — integer — 기본 키 — NOT NULL
- tag_eui — character — NOT NULL
태그 Attaching 내역 (ht_tag_attaching)
- attaching_id — integer — 기본 키 — NOT NULL
- tag_id — integer — 외래 키 → 태그.tag_id — NOT NULL
- equip_id — character — NOT NULL
- ts — bigint — NOT NULL
- status — integer
태그 상태 내역 (ht_tag_status_history)
- tag_id — integer — 외래 키 → 태그.tag_id — NOT NULL
- status — boolean — NOT NULL
- ts — bigint — NOT NULL
태그 위치 (ht_tag_location)
- location_id — bigint — 기본 키 — NOT NULL
- tag_id — integer — 외래 키 → 태그.tag_id — NOT NULL
- area_id — integer — 외래 키 → Geofence 에 할당된 Area.area_id — NOT NULL
- geofence_id — integer — 외래 키 → Geofence 에 할당된 Area.geofence_id — NOT NULL
- latitude — double — NOT NULL
- longitude — double — NOT NULL
- ts — bigint — NOT NULL
- battery — double
- last_seen — integer — NOT NULL
- trip_count — bigint
- battery_mv — double
- ts_date — character
- last_seen_date — character
- gateway — character
태그 정보 (ht_tag_info)
- tag_id — integer — 외래 키 → 태그.tag_id — NOT NULL
- gps_interval — integer
- retry — integer
- q_size — integer
- f_version — character
- report_interval_moving — integer
- report_interval_standing — integer
- submitted_ts — bigint
- query_ts — bigint
- battery — integer
- imu_threshold — integer
- imu_mode — integer
- imu_duration — integer
회사 (ht_company)
- id — character — 기본 키 — NOT NULL
- name — character
- location — text
- creation_user — character
- creation_date — timestamp
- modification_user — character
- modification_date — timestamp