HealthMIS
Tables (50)
DureCode
- DurgKey — uniqueidentifier — Primary key — NOT NULL
- Kind — varchar(50)
- DurgSeqNo — varchar(50)
- DurgCode — varchar(50)
- DurgName — varchar(500)
- DurgKName — varchar(500)
- in_item — varchar(50)
- ReportKind2 — varchar(50)
- ReportKind3 — varchar(50)
- ReportKind4 — varchar(50)
- ReportKind5 — varchar(50)
- ReportKind6 — varchar(50)
- ReportKind7 — varchar(50)
- DurgCommant — varchar(2500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
DurgReport
- ReportKey — uniqueidentifier — Primary key — NOT NULL
- ReportIDNO — varchar(50) — NOT NULL
- ReportKind — varchar(50) — NOT NULL
- REQUEST_DATE — varchar(50)
- EXAM_NO — varchar(50)
- PRDUCT_CD — varchar(500)
- PRDUCT_NM — varchar(5000)
- PRDUCT_ID — varchar(500)
- BARCODE — varchar(500)
- DurgName — varchar(200)
- DurgKName — varchar(500)
- Value — varchar(2048)
- Status — varchar(50)
- RegDate — varchar(500)
- RegName — varchar(500)
- TEST — varchar(50)
- DurgTotCount — int
- EndCheck — varchar(50)
- TempValue — varchar(2048)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisAccountCode
- AccountKey — uniqueidentifier — Primary key — NOT NULL
- AccountCode — varchar(50) — NOT NULL
- AccountKind — int — NOT NULL
- AccountName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisBusData
- RegistKey — uniqueidentifier — Primary key — NOT NULL
- SearchGubun — varchar(50) — Primary key — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisBusMemo
- BusMemoKey — uniqueidentifier — Primary key — NOT NULL
- CheckupDate — date
- CheckupMemo — varchar(5000)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisBusPerson
- RegistKey — uniqueidentifier — Primary key — NOT NULL
- BusKey — uniqueidentifier — NOT NULL
- BusDate — date
- UserName — varchar(50)
- BusName — varchar(50)
- RegistDate — datetime
- RegistByName — varchar(50)
- ModifiedDate — datetime
- ModifiedByName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisBusinessItem
- BusinessItemKey — uniqueidentifier — Primary key — NOT NULL
- BusinessItemCode — varchar(50) — NOT NULL
- BusinessItemName — varchar(500) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCheckupCode
- CheckupKey — uniqueidentifier — Primary key — NOT NULL
- CheckupCode — varchar(50) — NOT NULL
- CheckupUsed — bit — NOT NULL
- CheckupKindCode — varchar(50) — NOT NULL
- CheckupRegistYear — varchar(50)
- CheckupSeqNo — int — NOT NULL
- CheckupName — varchar(50)
- CheckupShortName — varchar(50)
- CheckupStartDate — date — NOT NULL
- CheckupEndDate — date
- CheckupDescription — varchar(max)
- StartCheckupNo — int
- EndCheckupNo — int
- RegistedByName — varchar(50) — NOT NULL
- RegistedDate — datetime2(7) — NOT NULL
- ModifiedByName — varchar(50) — NOT NULL
- ModifiedDate — datetime2(7) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCheckupData
- CheckupDataKey — uniqueidentifier — Primary key — NOT NULL
- CheckupCode — varchar(50) — NOT NULL
- CheckupYear — varchar(50)
- CheckupNationalType — int — NOT NULL
- CheckupDataPosition — int — NOT NULL
- CheckupDataLength — int — NOT NULL
- CheckupDataGroup — varchar(50)
- CheckupDataName — varchar(500)
- CheckupDataType — int — NOT NULL
- CheckupDataItems — varchar(max)
- CheckupDataMin — decimal(9, 3) — NOT NULL
- CheckupDataMax — decimal(9, 3) — NOT NULL
- CheckupDataCode — varchar(50)
- CheckupDataDefault — varchar(50)
- CheckupDataTable — varchar(50)
- CheckupDataField — varchar(50)
- CheckupDataDescription — varchar(max)
- RegistedByName — varchar(50) — NOT NULL
- RegistedDate — datetime2(7) — NOT NULL
- ModifiedByName — varchar(50) — NOT NULL
- ModifiedDate — datetime2(7) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCheckupDataCode
- CheckupDataKey — uniqueidentifier — Primary key — NOT NULL
- DataYear — varchar(50)
- DataCode — varchar(50)
- Sex — varchar(50)
- GroupName — varchar(50)
- GroupName1 — varchar(50)
- DisPlayNo — int
- AMin — varchar(50)
- AMax — varchar(50)
- ACode — varchar(50)
- BMin — varchar(50)
- BMax — varchar(50)
- BCode — varchar(50)
- R1Min — varchar(300)
- R1Max — varchar(50)
- R1Code — varchar(50)
- R2Min — varchar(50)
- R2Max — varchar(50)
- R2Code — varchar(50)
- DMin — varchar(50)
- DMax — varchar(50)
- DCode — varchar(50)
- EtcMin — varchar(50)
- EtcMax — varchar(50)
- EtcCode — varchar(50)
- DiMin — varchar(50)
- DiMax — varchar(50)
- DiCode — varchar(50)
- DoMin — varchar(50)
- DoMax — varchar(50)
- DoCode — varchar(50)
- AgeOption1 — varchar(50) — 이상지질
- AgeOption2 — varchar(50) — 골밀도
- AgeOption6 — varchar(50) — 노인기능
- NationalCheckup1 — varchar(50) — B형간염
- NationalCheckupC — varchar(50) — C형간염
- ResultGubun — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCheckupDataCodeSub
- CheckupDataSubKey — uniqueidentifier — Primary key — NOT NULL
- DataCode — varchar(50)
- Min — varchar(50)
- Max — varchar(50)
- ViewMemo — varchar(500)
- FirstPan — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCheckupKind
- CheckupKindKey — uniqueidentifier — Primary key — NOT NULL
- CheckupKindCode — varchar(50) — NOT NULL
- CheckupKindSeqNo — int — NOT NULL
- CheckupKindGroup — varchar(50)
- CheckupKindName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCheckupLocationCode
- CheckupLocationKey — uniqueidentifier — Primary key — NOT NULL
- CheckupLocationCode — varchar(50) — NOT NULL
- CheckupLocationSeqNo — int — NOT NULL
- CheckupLocationType — int — NOT NULL
- CheckupLocationName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCheckupNational
- CheckupNationalKey — uniqueidentifier — Primary key — NOT NULL
- CheckupCode — varchar(50) — NOT NULL
- CheckupYear — varchar(50) — NOT NULL
- CheckupNationalType — int — NOT NULL
- CheckupNationalName — varchar(50)
- CheckupStartDate — date — NOT NULL
- CheckupEndDate — date
- RegistedByName — varchar(50) — NOT NULL
- RegistedDate — datetime2(7) — NOT NULL
- ModifiedByName — varchar(50) — NOT NULL
- ModifiedDate — datetime2(7) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCheckupReportingCode
- CheckupReportingKey — uniqueidentifier — Primary key — NOT NULL
- CheckupReportingCode — varchar(50) — NOT NULL
- CheckupReportingSeqNo — int — NOT NULL
- CheckupReportingType — int — NOT NULL
- CheckupReportingName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisContractMemo
- MemoKey — uniqueidentifier — Primary key — NOT NULL
- ContractKey — uniqueidentifier
- ProfileKey — uniqueidentifier
- RichMemo — varchar(max)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisContractProgress
- ProgressKey — uniqueidentifier — Primary key — NOT NULL
- ContractKey — uniqueidentifier — NOT NULL
- ContractState — varchar(50)
- ContractName — varchar(50)
- ContractDate — datetime
- RegistedByName — varchar(50)
- RegistedDate — date
- ModifiedByName — varchar(50)
- ModifiedDate — date
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisContractRefrence
- RefrenceKey — uniqueidentifier — Primary key — NOT NULL
- DataCode — varchar(50)
- RefernceShotKey — varchar(50)
- RefrenceName — varchar(50)
- ReferenceColor — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisContractReport
- ContractKey — uniqueidentifier — Primary key — NOT NULL
- CustomerCode — varchar(50)
- CustomerDepartMent — varchar(100)
- CustomerPostion — varchar(100)
- CustomerManagerName — varchar(100)
- CustomerManagerPhoneNo — varchar(50)
- CustomerManagerFaxNo — varchar(50)
- CustomerManagerEmail — varchar(50)
- CustomerStartDate — date
- CustomerEndDate — date
- CustomerPersonPrice — money
- CustomerEmployee — varchar(50)
- CustomerTotalPrice — money
- CustomerNewYN — varchar(50)
- CustomerAddReport — varchar(50)
- CustomerMemo — varchar(max)
- RegistedByName — varchar(50)
- RegistedDate — date
- ModifiedByName — varchar(50)
- ModifiedDate — date
- ClaimDate — varchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisContractSub
- SubKey — uniqueidentifier — Primary key — NOT NULL
- ContractKey — uniqueidentifier
- ProfileKey — uniqueidentifier
- DataCode — varchar(50)
- DataValue — varchar(50)
- DataMemo — varchar(500)
- DataTextValue — varchar(500)
- DataColor — varchar(50)
- ManagerYN — varchar(50)
- RegistedBYName — varchar(50)
- RegistedDate — date
- ModifiedByName — varchar(50)
- ModifiedDate — date
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCounselKind
- CounselKindKey — uniqueidentifier — Primary key — NOT NULL
- CounselKindCode — varchar(50) — NOT NULL
- CounselKindSeqNo — int — NOT NULL
- CounselKindName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCounselSatisfy
- CounselSatisfyKey — uniqueidentifier — Primary key — NOT NULL
- CounselSatisfyCode — varchar(50) — NOT NULL
- CounselSatisfySeqNo — int — NOT NULL
- CounselSatisfyName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCountryCode
- CountryKey — uniqueidentifier — Primary key — NOT NULL
- CountryCode — varchar(50) — NOT NULL
- CountrySeqNo — int — NOT NULL
- CountryName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCustomerClass
- CustomerClassKey — uniqueidentifier — Primary key — NOT NULL
- CustomerClassCode — varchar(50) — NOT NULL
- CustomerClassSeqNo — int — NOT NULL
- CustomerClassName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCustomerCode
- CustomerKey — uniqueidentifier — Primary key — NOT NULL
- CustomerCode — varchar(50) — NOT NULL
- CustomerUsed — bit — NOT NULL
- CustomerKindCode — varchar(50)
- CustomerClassCode — varchar(50)
- CustomerName — varchar(100)
- CustomerNewGubun — varchar(50)
- CustomerPhoneNo — varchar(50)
- CustomerFaxNo — varchar(50)
- CustomerEmail — varchar(100)
- CustomerHomepage — varchar(50)
- CustomerZipCode — varchar(50)
- CustomerAddress01 — varchar(500)
- CustomerAddress02 — varchar(500)
- CustomerMemo — varchar(max)
- BusinessNo — varchar(50)
- BusinessName — varchar(50)
- BusinessUpjong — varchar(50)
- BusinessUptea — varchar(50)
- BusinessPresident — varchar(50)
- BusinessStartDate — date — NOT NULL
- BusinessEndDate — date — NOT NULL
- BusinessLogo — varbinary(max)
- OfficeYn — varchar(50)
- DisplayColor — varchar(50)
- ManagerByName — varchar(50)
- RegistedByName — varchar(50) — NOT NULL
- RegistedDate — datetime2(7) — NOT NULL
- ModifiedByName — varchar(50) — NOT NULL
- ModifiedDate — datetime2(7) — NOT NULL
- ColorMemo — varchar(500)
- CheckupStartDate — varchar(50)
- CheckupEndDate — varchar(50)
- GroupName — varchar(500)
- ManagerName — varchar(50)
- ManagerPhone — varchar(50)
- ManagerDepart — varchar(100)
- MnagerRemark — varchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCustomerConnect
- CustomerConnectKey — uniqueidentifier — Primary key — NOT NULL
- CustomerCode — varchar(50)
- ProfileCode — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCustomerEmployee
- CustomerEmployeeKey — uniqueidentifier — Primary key — NOT NULL
- CustomerCode — varchar(50) — NOT NULL
- NationalYear — int — NOT NULL
- TotalEmployeeMan — int — NOT NULL
- TotalEmployeeFeman — int — NOT NULL
- WhiteCollarEmployeeMan — int — NOT NULL
- WhiteCollarEmployeeFeman — int — NOT NULL
- BlueCollarEmployeeMan — int — NOT NULL
- BlueCollarEmployeeFeman — int — NOT NULL
- RegistedByName — varchar(50) — NOT NULL
- RegistedDate — datetime2(7) — NOT NULL
- ModifiedByName — varchar(50) — NOT NULL
- ModifiedDate — datetime2(7) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCustomerKind
- CustomerKindKey — uniqueidentifier — Primary key — NOT NULL
- CustomerKindCode — varchar(50) — NOT NULL
- CustomerKindSeqNo — int — NOT NULL
- CustomerKindName — varchar(50) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisCustomerOffice
- CustomerOfficeKey — uniqueidentifier — Primary key — NOT NULL
- CustomerCode — varchar(50) — NOT NULL
- OfficeUsed — bit — NOT NULL
- OfficeSeqNo — int — NOT NULL
- OfficeName — varchar(100)
- OfficePhoneNo — varchar(50)
- OfficeFaxNo — varchar(50)
- OfficeEmail — varchar(100)
- OfficeHomepage — varchar(50)
- OfficeZipCode — varchar(50)
- OfficeAddress01 — varchar(500)
- OfficeAddress02 — varchar(500)
- OfficeMemo — varchar(max)
- RegistedByName — varchar(50) — NOT NULL
- RegistedDate — datetime2(7) — NOT NULL
- ModifiedByName — varchar(50) — NOT NULL
- ModifiedDate — datetime2(7) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataCalc
- DataCalcKey — uniqueidentifier — Primary key — NOT NULL
- DataCode — varchar(50) — NOT NULL
- DataCalcSeqNo — int — NOT NULL
- DataCalcResultCode — varchar(50)
- DataCalcResultFormula — varchar(max)
- RegistedByName — varchar(50) — NOT NULL
- RegistedDate — datetime2(7) — NOT NULL
- ModifiedByName — varchar(50) — NOT NULL
- ModifiedDate — datetime2(7) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataCode
- DataKey — uniqueidentifier — Primary key — NOT NULL
- DataCode — varchar(50) — NOT NULL
- DataUsed — bit — NOT NULL
- DataSeqNo — int — NOT NULL
- DataKindCode — varchar(50) — NOT NULL
- DataPartCode — varchar(50)
- DataEditType — int — NOT NULL
- DataEditGroup — varchar(50)
- DataDisplayName — varchar(500)
- DataPrintName — varchar(500)
- DataShortName — varchar(500)
- DataStartDate — date — NOT NULL
- DataEndDate — date
- DataDescription — varchar(max)
- StandardCode — varchar(50)
- SampleCode — varchar(50)
- RelatedDiseases — varchar(50)
- CollectVolume — varchar(50)
- CollectUnit — varchar(50)
- CollectNotice — varchar(max)
- InsuranceCode — varchar(50)
- InsuranceCategory — varchar(50)
- InsurancePoint — decimal(9, 2) — NOT NULL
- PacsModality — varchar(50)
- PacsOption1 — varchar(50)
- PacsOption2 — varchar(50)
- PacsOption3 — varchar(50)
- PacsOption4 — varchar(50)
- PacsOption5 — varchar(50)
- PacsOption6 — varchar(50)
- DefaultValue — varchar(50)
- CheckColor — varchar(50)
- PacsAtRegist — varchar(50)
- UserSex — varchar(50)
- ViewChar — varchar(50)
- RegistedByName — varchar(50) — NOT NULL
- RegistedDate — datetime2(7) — NOT NULL
- ModifiedByName — varchar(50) — NOT NULL
- ModifiedDate — datetime2(7) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataCodeNational
- DataCodeKey — uniqueidentifier
- DataCode — varchar(50)
- DataDisplayName — varchar(500)
HmisDataCodeNationalAll
- DataCodeKey — uniqueidentifier — Primary key — NOT NULL
- DataYear — varchar(50)
- DataGroup — varchar(50)
- DataCode — varchar(50)
- DataDisplayName — varchar(500)
- DataQACode — varchar(500)
- DataShortName — varchar(500)
- DataControlKind — varchar(50)
- DisplayNo — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataCodeNationalAll01
- DataCodeKey — uniqueidentifier — NOT NULL
- DataYear — varchar(50)
- DataGroup — varchar(50)
- DataSubGroup — varchar(500)
- DataCode — varchar(50)
- DataDisplayName — varchar(500)
- DataWebDisplayName — varchar(500)
- DataQACode — varchar(500)
- DataQAViewYN — varchar(50)
- DataShortName — varchar(500)
- DisplayYN — varchar(50)
- RelationCode — varchar(50)
- DisplayValue — varchar(50)
- DataControlKind — varchar(50)
- RefValue — varchar(500)
- ValueLength — varchar(50)
- DisplayNo — int
- DataUnit — varchar(50)
- DefaultValue — varchar(50)
- ReceiptDefaultValue — varchar(50)
- PointSumItem — varchar(50)
- PointRang — varchar(50)
- MaxChoice — int
- UseSex — varchar(50)
- ExampleView — varchar(50)
- DetailKind — varchar(50)
- StartPostion — int
- StartYearPostion — int
- EndPostion — int
- DataFormat — varchar(50)
- NoEmpty — varchar(50)
- ResultChange — varchar(50)
- ReceiptCode — varchar(100)
- NextEnterCode — varchar(50)
- PanJongCode — varchar(50)
- NationalRang — varchar(50)
- ReceiptMinValue — varchar(50)
- ReceiptMaxValue — varchar(50)
- WebDisplayPage — int
- WebUnit — varchar(50)
- FullChar — varchar(50)
- SaveNoEmpty — varchar(50)
- PacsViewMember — varchar(50)
- WebNoEmpty — varchar(50)
- WebKeyBordKind — varchar(50)
- LRGubun — varchar(50)
- CheckupNationalType — int
HmisDataCodeNationalAll02
- DataCodeKey — uniqueidentifier — NOT NULL
- DataYear — varchar(50)
- DataGroup — varchar(50)
- DataSubGroup — varchar(500)
- DataCode — varchar(50)
- DataDisplayName — varchar(500)
- DataWebDisplayName — varchar(500)
- DataQACode — varchar(500)
- DataQAViewYN — varchar(50)
- DataShortName — varchar(500)
- DisplayYN — varchar(50)
- RelationCode — varchar(50)
- DisplayValue — varchar(50)
- DataControlKind — varchar(50)
- RefValue — varchar(500)
- ValueLength — varchar(50)
- DisplayNo — int
- DataUnit — varchar(50)
- DefaultValue — varchar(50)
- ReceiptDefaultValue — varchar(50)
- PointSumItem — varchar(50)
- PointRang — varchar(50)
- MaxChoice — int
- UseSex — varchar(50)
- ExampleView — varchar(50)
- DetailKind — varchar(50)
- StartPostion — int
- StartYearPostion — int
- EndPostion — int
- DataFormat — varchar(50)
- NoEmpty — varchar(50)
- ResultChange — varchar(50)
- ReceiptCode — varchar(100)
- NextEnterCode — varchar(50)
- PanJongCode — varchar(50)
- NationalRang — varchar(50)
- ReceiptMinValue — varchar(50)
- ReceiptMaxValue — varchar(50)
- WebDisplayPage — int
- WebUnit — varchar(50)
- FullChar — varchar(50)
- SaveNoEmpty — varchar(50)
- PacsViewMember — varchar(50)
- WebNoEmpty — varchar(50)
- WebKeyBordKind — varchar(50)
HmisDataCodeNationalLinkCode
- LinkKey — uniqueidentifier — NOT NULL
- DataCode — varchar(50)
- LinkDataCode — varchar(50)
- LinkOption — varchar(50)
- LinkResult — varchar(50)
HmisDataCodeNationalQA
- DataQAKey — uniqueidentifier — Primary key — NOT NULL
- DataQACode — varchar(50)
- DataQAName — varchar(500)
- DisplayNo — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataCodeNationalSub
- DataCodeSubKey — uniqueidentifier — Primary key — NOT NULL
- DataCode — varchar(50)
- DataDisplayName — varchar(500)
- DisplayNo — int
- ItemPoint — int
- RelationCode — varchar(50)
- Temp01 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataCodeNationalSub01
- DataCodeSubKey — uniqueidentifier — NOT NULL
- DataCode — varchar(50)
- DataDisplayName — varchar(500)
- DisplayNo — int
- RelationCode — varchar(50)
- ItemPoint — int
HmisDataCode_공단코드
- DataKey — uniqueidentifier — NOT NULL
- DataCode — varchar(50) — NOT NULL
- DataUsed — bit — NOT NULL
- DataSeqNo — int — NOT NULL
- DataKindCode — varchar(50) — NOT NULL
- DataPartCode — varchar(50)
- DataEditType — int — NOT NULL
- DataEditGroup — varchar(50)
- DataDisplayName — varchar(500)
- DataPrintName — varchar(500)
- DataShortName — varchar(500)
- DataStartDate — date — NOT NULL
- DataEndDate — date
- DataDescription — varchar(max)
- StandardCode — varchar(50)
- SampleCode — varchar(50)
- RelatedDiseases — varchar(50)
- CollectVolume — varchar(50)
- CollectUnit — varchar(50)
- CollectNotice — varchar(max)
- InsuranceCode — varchar(50)
- InsuranceCategory — varchar(50)
- InsurancePoint — decimal(9, 2) — NOT NULL
- PacsModality — varchar(50)
- PacsOption1 — varchar(50)
- PacsOption2 — varchar(50)
- PacsOption3 — varchar(50)
- PacsOption4 — varchar(50)
- PacsOption5 — varchar(50)
- PacsOption6 — varchar(50)
- DefaultValue — varchar(50)
- CheckColor — varchar(50)
- RegistedByName — varchar(50) — NOT NULL
- RegistedDate — datetime2(7) — NOT NULL
- ModifiedByName — varchar(50) — NOT NULL
- ModifiedDate — datetime2(7) — NOT NULL
HmisDataDown
- DataDownKindKey — uniqueidentifier — Primary key — NOT NULL
- DataDownName — varchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataDownColumn
- DataDownColumnKey — uniqueidentifier — Primary key — NOT NULL
- DataDownKindKey — uniqueidentifier — NOT NULL
- DataSeqNo — int
- DataGubun — varchar(50)
- DataCode — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataKind
- DataKindKey — uniqueidentifier — Primary key — NOT NULL
- DataKindCode — varchar(50) — NOT NULL
- DataKindSeqNo — int — NOT NULL
- DataKindType — int — NOT NULL
- DataKindName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataPart
- DataPartKey — uniqueidentifier — Primary key — NOT NULL
- DataPartCode — varchar(50) — NOT NULL
- DataPartSeqNo — int — NOT NULL
- DataKindType — int — NOT NULL
- DataPartName — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataPrice
- DataPriceKey — uniqueidentifier — Primary key — NOT NULL
- DataCode — varchar(50)
- PackageCode — varchar(50)
- ProfileCode — varchar(50)
- DataPriceDate — date — NOT NULL
- DataPriceMemo — varchar(max)
- DefaultPrice — money
- SelfPrice — money — NOT NULL
- NationalPrice — money — NOT NULL
- CustomerPrice — money — NOT NULL
- InsuranceCode — varchar(50)
- InsuranceCategory — varchar(50)
- InsurancePoint — decimal(9, 2)
- InsurancePrice — money — NOT NULL
- CostPrice — money
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDataRef
- DataRefKey — uniqueidentifier — Primary key — NOT NULL
- DataCode — varchar(50) — NOT NULL
- DataRefDate — date — NOT NULL
- DataRefAge — decimal(9, 2) — NOT NULL
- DataRefSex — varchar(50)
- DataRefPrint — varchar(max)
- DataRefMin — decimal(9, 3) — NOT NULL
- DataRefMax — decimal(9, 3) — NOT NULL
- ResultFormat — varchar(max)
- ResultUnit — varchar(50)
- ResultDecimal — int — NOT NULL
- ResultMin — varchar(50)
- ResultRange — varchar(50)
- ResultMax — varchar(50)
- MarkerMin — varchar(50)
- MarkerRange — varchar(50)
- MarkerMax — varchar(50)
- RegistedByName — varchar(50) — NOT NULL
- RegistedDate — datetime2(7) — NOT NULL
- ModifiedByName — varchar(50) — NOT NULL
- ModifiedDate — datetime2(7) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDay
- regdate — char(10)
- DayWeek — varchar(50)
HmisDecisionGroup
- GroupKey — uniqueidentifier — Primary key — NOT NULL
- GroupName — varchar(50)
- GroupSeq — int
- DecisionCode — varchar(50)
- ReTest — varchar(50)
- DiseaseSeverityCode — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
HmisDecisionGroupData
- GroupKey — uniqueidentifier — Primary key — NOT NULL
- DataCode — varchar(50) — Primary key — NOT NULL
- DataGubun — varchar(50)
- Sex — varchar(50)
- FromAge — int
- ToAge — int
- MinValue — decimal(8, 3)
- MaxValue — decimal(8, 3)
- RefValue — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
durgcheck
- F1 — float
- F2 — nvarchar(255)
- F3 — datetime
- F4 — nvarchar(255)
- F5 — nvarchar(255)
- F6 — nvarchar(255)
- F7 — nvarchar(255)
- F8 — nvarchar(255)
- F9 — float
- F10 — nvarchar(255)
- F11 — nvarchar(255)
- F12 — nvarchar(255)
- F13 — nvarchar(255)
- F14 — nvarchar(255)