개인프로젝트

테이블 (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