rfid

테이블 (6)

Monthly

  • Key (Id) — 기본 키 — NOT NULL
  • Field (General)
  • Field (Isolation)
  • Field2 (Tissue)
  • Field3 (Damaged)
  • Field4 (Biochemistry)
  • Field (Blood)
  • Field2 (Pathological)
  • Field3 (TotalAmount)
  • Field (TotalWeight)
  • Field (GeneralW)
  • Field2 (IsolationW)
  • Field3 (TissueW)
  • Field4 (DamagedW)
  • Field5 (BiochemistryW)
  • Field6 (BloodW)
  • Field7 (PathologicalW)
  • Key (DeptId) — 외래 키 → 부서.Key — NOT NULL

RFID

  • Key (ID) — 기본 키 — NOT NULL
  • Field (KKRCODE)
  • Field2 (Type)
  • Field3 (Status)
  • Field4 (DispatchedAt)
  • Field5 (AttatchedAt)
  • Field6 (PickupAt)
  • Field7 (Weight)
  • Field8 (StorageTime)
  • Key (DeptId) — 외래 키 → 부서.Key — NOT NULL

Weekly

  • Key (Id) — 기본 키 — NOT NULL
  • Field (General)
  • Field (Isolation)
  • Field2 (Tissue)
  • Field3 (Damaged)
  • Field4 (Biochemistry)
  • Field (Blood)
  • Field2 (Pathological)
  • Field3 (TotalAmount)
  • Field (TotalWeight)
  • Field (GeneralW)
  • Field2 (IsolationW)
  • Field3 (TissueW)
  • Field4 (DamagedW)
  • Field5 (BiochemistryW)
  • Field6 (BloodW)
  • Field7 (PathologicalW)
  • Key (DeptId) — 외래 키 → 부서.Key — NOT NULL

부서 (Department)

  • Key (DeptId) — 기본 키 — NOT NULL
  • Field (DeptName)
  • Field2 (DeptCode)

사용자 (Users)

  • Key (UserID) — VARCHAR(20) — 기본 키 — NOT NULL
  • Field2 (UserPw) — VARCHAR(50)
  • Field (UserRole) — VARCHAR(50)
  • Field (UserName) — VARCHAR(10)
  • Field2 (UserCode)
  • Field3 (CreatedAt)
  • Key (DeptId) — 외래 키 → 부서.Key — NOT NULL

청구 내역 (claim)

  • Key (Id) — 기본 키 — NOT NULL
  • Field (General)
  • Field (Isolation)
  • Field2 (Tissue)
  • Field3 (Damaged)
  • Field4 (Biochemistry)
  • Field (Blood)
  • Field2 (Pathological)
  • Field3 (Status)
  • Field (DispatchedAt)
  • Key (UserID) — VARCHAR(20) — 외래 키 → 사용자.Key — NOT NULL