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