IMS_LAB

Tables (4)

labAccount

  • accountId — bigint(20) — Primary key — NOT NULL
  • mappingId — bigint(20) — Foreign key → labMapping.mappingId — NOT NULL
  • labId — bigint(20) — Foreign key → labMapping.labId — NOT NULL — PK
  • syncType — enum('DB','API')
  • user — varchar(50)
  • password — varchar(50)
  • regCode — varchar(50)
  • customerCode — varchar(50)
  • createDateTime — datetime
  • modifyDateTime — datetime

labMapping

  • mappingId — bigint(20) — Primary key — NOT NULL
  • labId — bigint(20) — Foreign key → labMaster.labId — NOT NULL — PK
  • agency — varchar(50) — TNH or DBNAME
  • createDateTime — datetime
  • modifyDateTime — datetime

labMaster

  • labId — bigint(20) — Primary key — NOT NULL — PK
  • isManaged — tinyint
  • managedName
  • companyCode — varchar(50) — 검체업체코드
  • companyName — varchar(50) — 검체업체명
  • createDateTime — datetime
  • modifyDateTime

labMasterLevel

  • levelId — bigint(20) — Primary key — NOT NULL
  • labId (labId2) — bigint(20) — Foreign key → labMaster.labId — NOT NULL — PK
  • diagnosisLevel — tinyint(4) — NOT NULL — 진단등급
  • pathologyLevel — tinyint(4) — NOT NULL — 병리등급
  • nuclearLevel — tinyint(4) — NOT NULL — 핵의학등급
  • applyDate — varchar(50) — 적용일자
  • createDateTime — datetime — NOT NULL — 생성일자
  • modifyDateTime — datetime — NOT NULL — 수정일자