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