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 — 수정일자