개인프로젝트
테이블 (3)
laboratorymanagement_environmentincubationobject
- Id — varchar(100) — 기본 키 — NOT NULL
- HospitalId — varchar(100) — 기본 키 — NOT NULL
- TenantId — varchar(100) — 기본 키 — NOT NULL
- PatientId — varchar(100) — NOT NULL
- PatientDisplayCode — varchar(150) — NOT NULL
- BuildingId — varchar(100)
- RoomId — varchar(100)
- Code — varchar(150) — NOT NULL
- Name — varchar(500) — NOT NULL
- ObjectTypeCode — varchar(150) — NOT NULL
- CategoryType — varchar(150)
- InspectionPeriodCode — varchar(150)
- ObjectDescription — longtext
- DataFirstRegisteredDateTimeUtc — datetime — NOT NULL
- DataLastModifiedDateTimeUtc — datetime — NOT NULL
- IsValidDataRow — bit(1) — NOT NULL
- RowVersion — datetime(6)
- SystemLogs — longtext
laboratorymanagement_environmentincubationorder
- Id — varchar(100) — 기본 키 — NOT NULL
- HospitalId — varchar(100) — 기본 키 — NOT NULL
- TenantId — varchar(100) — 기본 키 — NOT NULL
- EncounterId — varchar(100) — NOT NULL
- PatientId — varchar(100) — NOT NULL
- ExaminationGroupCode — varchar(150)
- ExaminationId — varchar(100) — NOT NULL
- OrderComment — longtext
- SpecimenTypeId — varchar(100)
- IssuedStaffId — varchar(100)
- IssuedDate — datetime — NOT NULL
- DataFirstRegisteredDateTimeUtc — datetime — NOT NULL
- DataLastModifiedDateTimeUtc — datetime — NOT NULL
- IsValidDataRow — bit(1) — NOT NULL
- RowVersion — datetime(6)
- SystemLogs — longtext
laboratorymanagement_environmentincubationorderset
- Id — varchar(100) — 기본 키 — NOT NULL
- HospitalId — varchar(100) — 기본 키 — NOT NULL
- TenantId — varchar(100) — 기본 키 — NOT NULL
- Name — varchar(150)
- Examination — longtext
- OrderSetDescription — longtext
- DataFirstRegisteredDateTimeUtc — datetime — NOT NULL
- DataLastModifiedDateTimeUtc — datetime — NOT NULL
- IsValidDataRow — bit(1) — NOT NULL
- RowVersion — datetime(6)
- SystemLogs — longtext