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)