logi

Tables (19)

tb_alrt (공통 알림)

  • Key — Primary key — NOT NULL
  • Field

tb_alrt_risk_dtls (위험상황 상세)

  • Key — Primary key — NOT NULL
  • Field
  • Key (Key2) — Foreign key → tb_alrt.Key — NOT NULL

tb_alrt_skltn_dtls (근골격계 상세)

  • Key — Primary key — NOT NULL
  • Field
  • Key (Key2) — Foreign key → tb_alrt.Key — NOT NULL

tb_alrt_wrkld_dtls (과부하 상세)

  • Key — Primary key — NOT NULL
  • Field
  • Key (Key2) — Foreign key → tb_alrt.Key — NOT NULL

tb_bimtc_raw (생체 원본 데이터)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → tb_usr.Key — NOT NULL
  • Field

tb_cam (카메라)

  • Key — Primary key — NOT NULL
  • Field

tb_dngr_zone (위험지역)

  • Key — Primary key — NOT NULL
  • Field

tb_ftbt_conn (fitbit 연결)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → tb_usr.Key — NOT NULL
  • Field

tb_img (이미지)

  • Key — Primary key — NOT NULL
  • Field

tb_kypnt (키포인트)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → tb_skltn_anls_rslt.Key — NOT NULL
  • Key (Key22) — Foreign key → tb_skltn_anls_rslt.Key — NOT NULL
  • Field

tb_lr_model (로지스틱 회귀 모델)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → tb_usr.Key — NOT NULL
  • Field

tb_ntic (공지사항)

  • Key — Primary key — NOT NULL
  • Field

tb_ovld_anls_rslt (과부하 분석 결과)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → tb_usr.Key — NOT NULL
  • Field

tb_risk_anls_rslt (위험상황 분석 결과)

  • Key — Primary key — NOT NULL
  • Field

tb_role (역할)

  • Key — Primary key — NOT NULL
  • Field

tb_skltn_anls_rslt (근골격계 분석결과)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → tb_img.Key — NOT NULL
  • Field

tb_usr (사용자)

  • Key — Primary key — NOT NULL
  • Field

tb_usr_role (사용자-역할)

  • Key (Key2) — Foreign key → tb_usr.Key — NOT NULL
  • Key (Key3) — Foreign key → tb_role.Key — NOT NULL
  • Field

tb_wrkr (작업자)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → tb_usr.Key — NOT NULL
  • Field