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