Data Structure

1. eRegulations data

Table name Model Column Type DbType Null
able
Admin_Block Block Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Block Block Name String NVarChar(100) NOT NULL FALSE
Admin_Block Block Description String NText TRUE
Admin_Block Block IsOptional Bool Bit NOT NULL FALSE
Admin_Block Block PhysicalPresence Int32 Int NOT NULL FALSE
Admin_Block Block RepresentationThirdParty Int32 Int TRUE
Admin_Block Block CreatedDate DateTime DateTime NOT NULL FALSE
Admin_Block Block CreatedUser String NVarChar(50) NOT NULL FALSE
Admin_Block Block ModifiedDate DateTime DateTime NOT NULL FALSE
Admin_Block Block ModifiedUser String NVarChar(50) NOT NULL FALSE
Admin_Block Block IsInRecycleBin Bool Bit NOT NULL FALSE
Admin_Block Block Deleted Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility Id Int32 Int NOT NULL IDENTITY FALSE
Admin_StepSectionVisibility StepSectionVisibility Step_Id Int32 Int NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsExpectedResultsVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsEntityInChargeVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsUnitInChargeVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsPersonInChargeVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsRequirementsVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsCostsVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsCostsCommentsVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsTimeframeVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsTimeframeWaintingTimeInLineVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsTimeframeTimeSpentAtTheCounterVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsTimeframeWaitingTimeUntilNextStepVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsTimeframeCommentsVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsLegalJustificationVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsLegalJustificationCommentsVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsAdditionalInfoVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsRecoursesVisible Bool Bit NOT NULL FALSE
Admin_StepSectionVisibility StepSectionVisibility IsCertificationVisible Bool Bit NOT NULL FALSE
Admin_Block_i18n Block_i18n Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Block_i18n Block_i18n Block_Id Int32 Int NOT NULL FALSE
Admin_Block_i18n Block_i18n Lang String Char(2) NOT NULL FALSE
Admin_Block_i18n Block_i18n Name String NVarChar(100) NOT NULL FALSE
Admin_Block_i18n Block_i18n Description String NText TRUE
Admin_Block_Step Block_Step Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Block_Step Block_Step Block_Id Int32 Int NOT NULL FALSE
Admin_Block_Step Block_Step Step_Id Int32 Int NOT NULL FALSE
Admin_Block_Step Block_Step [Order] Int32 Int NOT NULL FALSE
Admin_Block_Step Block_Step IsParallele Bool Bit NOT NULL FALSE
Admin_Block_Step Block_Step IsAlternative Bool Bit NOT NULL FALSE
Admin_Menu Menu Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Menu Menu Name String NVarChar(100) NOT NULL FALSE
Admin_Menu Menu MappingType String VarChar(20) NOT NULL FALSE
Admin_Menu Menu Objective_ID Int32 Int TRUE
Admin_Menu Menu Block_ID Int32 Int TRUE
Admin_Menu Menu ExplanatoryText String NText TRUE
Admin_Menu Menu WebPageKeywords String NVarChar(250) NOT NULL FALSE
Admin_Menu Menu WebPageDescription String NVarChar(250) NOT NULL FALSE
Admin_Menu Menu CreatedDate DateTime DateTime NOT NULL FALSE
Admin_Menu Menu CreatedUser String NVarChar(50) NOT NULL FALSE
Admin_Menu Menu ModifiedDate DateTime DateTime NOT NULL FALSE
Admin_Menu Menu ModifiedUser String NVarChar(50) NOT NULL FALSE
Admin_Menu Menu IsInRecycleBin Bool Bit NOT NULL FALSE
Admin_Menu Menu Deleted Bool Bit NOT NULL FALSE
Admin_Menu Menu IsVisibleInPublicMenu Bool Bit FALSE
Admin_Menu Menu IsVisibleToGuest Bool Bit FALSE
Admin_Menu Menu Image1 String NVarChar(255) TRUE
Admin_Menu Menu Image2 String NVarChar(255) TRUE
Admin_Menu Menu Image3 String NVarChar(255) TRUE
Admin_Menu Menu IconURL String NVarChar(255) TRUE
Admin_Menu Menu IconActiveURL String NVarChar(255) TRUE
Admin_Menu Menu PublicLayoutNbCols Int32 Int TRUE
Admin_Menu_i18n Menu_i18n Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Menu_i18n Menu_i18n Menu_Id Int32 Int NOT NULL FALSE
Admin_Menu_i18n Menu_i18n Lang String Char(2) NOT NULL FALSE
Admin_Menu_i18n Menu_i18n Name String NVarChar(100) NOT NULL FALSE
Admin_Menu_i18n Menu_i18n ExplanatoryText String NText TRUE
Admin_Menu_i18n Menu_i18n WebPageKeywords String NVarChar(250) TRUE
Admin_Menu_i18n Menu_i18n WebPageDescription String NVarChar(250) TRUE
Admin_MenuHierarchicalData MenuHierarchicalData Id Int32 Int NOT NULL IDENTITY FALSE
Admin_MenuHierarchicalData MenuHierarchicalData Parent_Id Int32 Int TRUE
Admin_MenuHierarchicalData MenuHierarchicalData Child_Id Int32 Int NOT NULL FALSE
Admin_MenuHierarchicalData MenuHierarchicalData [Order] Int32 Int NOT NULL FALSE
Admin_MenuPerLangVisibility MenuPerLangVisibility Id Int32 Int NOT NULL IDENTITY FALSE
Admin_MenuPerLangVisibility MenuPerLangVisibility Menu_Id Int32 Int NOT NULL FALSE
Admin_MenuPerLangVisibility MenuPerLangVisibility Lang String Char(2) NOT NULL FALSE
Admin_MenuPerLangVisibility MenuPerLangVisibility Visible Bool Bit NOT NULL FALSE
Admin_Object_Media Object_Media Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Object_Media Object_Media Object_Id Int32 Int NOT NULL FALSE
Admin_Object_Media Object_Media Type String VarChar(100) NOT NULL FALSE
Admin_Object_Media Object_Media Media_Id Int32 Int NOT NULL FALSE
Admin_Object_Media Object_Media [Order] Int32 Int NOT NULL FALSE
Admin_Objective Objective Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Objective Objective Name String NVarChar(100) NOT NULL FALSE
Admin_Objective Objective CreatedDate DateTime DateTime NOT NULL FALSE
Admin_Objective Objective CreatedUser String NVarChar(50) NOT NULL FALSE
Admin_Objective Objective ModifiedDate DateTime DateTime NOT NULL FALSE
Admin_Objective Objective ModifiedUser String NVarChar(50) NOT NULL FALSE
Admin_Objective Objective IsInRecycleBin Bool Bit NOT NULL FALSE
Admin_Objective Objective Deleted Bool Bit NOT NULL FALSE
Admin_Objective Objective AdditionalInfo String NVarChar(1000) TRUE
Admin_Objective_Block Objective_Block Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Objective_Block Objective_Block Objective_Id Int32 Int NOT NULL FALSE
Admin_Objective_Block Objective_Block Block_Id Int32 Int NOT NULL FALSE
Admin_Objective_Block Objective_Block [Order] Int32 Int NOT NULL FALSE
Admin_Objective_i18n Objective_i18n Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Objective_i18n Objective_i18n Objective_Id Int32 Int NOT NULL FALSE
Admin_Objective_i18n Objective_i18n Lang String Char(2) NOT NULL FALSE
Admin_Objective_i18n Objective_i18n Name String NVarChar(100) NOT NULL FALSE
Admin_Objective_i18n Objective_i18n AdditionalInfo String NVarChar(1000) TRUE
Admin_ObjectiveHierarchicalData ObjectiveHierarchicalData Id Int32 Int NOT NULL IDENTITY FALSE
Admin_ObjectiveHierarchicalData ObjectiveHierarchicalData Parent_Id Int32 Int TRUE
Admin_ObjectiveHierarchicalData ObjectiveHierarchicalData Child_Id Int32 Int NOT NULL FALSE
Admin_ObjectiveHierarchicalData ObjectiveHierarchicalData [Order] Int32 Int NOT NULL FALSE
Admin_Step Step Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Step Step PublishedStatus Bool Bit NOT NULL FALSE
Admin_Step Step IsRecourse Bool Bit NOT NULL FALSE
Admin_Step Step Certified Bool Bit NOT NULL FALSE
Admin_Step Step CertificationDate DateTime DateTime TRUE
Admin_Step Step CertificationUser String NVarChar(50) TRUE
Admin_Step Step CertificationEntityInCharge_Id Int32 Int TRUE
Admin_Step Step Name String NVarChar(300) NOT NULL FALSE
Admin_Step Step PhysicalPresence Int32 Int NOT NULL FALSE
Admin_Step Step RepresentationThirdParty Int32 Int TRUE
Admin_Step Step IsOnline Bool Bit NOT NULL FALSE
Admin_Step Step OnlineStepURL String NVarChar(200) TRUE
Admin_Step Step IsOptional Bool Bit NOT NULL FALSE
Admin_Step Step EntityInCharge_Id Int32 Int TRUE
Admin_Step Step UnitInCharge_Id Int32 Int TRUE
Admin_Step Step PersonInCharge_Id Int32 Int TRUE
Admin_Step Step Contact_Law_Id Int32 Int TRUE
Admin_Step Step Contact_Articles String NVarChar(400) TRUE
Admin_Step Step RequirementsPhysicalPresence String VarChar(75) TRUE
Admin_Step Step HasCosts Bool Bit NOT NULL FALSE
Admin_Step Step NoCostsReason String VarChar(75) TRUE
Admin_Step Step IsPayMethodCash Bool Bit NOT NULL FALSE
Admin_Step Step IsPayMethodCheck Bool Bit NOT NULL FALSE
Admin_Step Step IsPayMethodCard Bool Bit NOT NULL FALSE
Admin_Step Step IsPayMethodOther Bool Bit NOT NULL FALSE
Admin_Step Step PayMethodOtherText String NVarChar(200) TRUE
Admin_Step Step CostsComments String NText TRUE
Admin_Step Step WaintingTimeInLineMin Decimal Decimal(18,6) NOT NULL FALSE
Admin_Step Step WaintingTimeInLineMax Decimal Decimal(18,6) NOT NULL FALSE
Admin_Step Step TimeSpentAtTheCounterMin Decimal Decimal(18,6) NOT NULL FALSE
Admin_Step Step TimeSpentAtTheCounterMax Decimal Decimal(18,6) NOT NULL FALSE
Admin_Step Step WaitingTimeUntilNextStepMin Decimal Decimal(18,6) NOT NULL FALSE
Admin_Step Step WaitingTimeUntilNextStepMax Decimal Decimal(18,6) NOT NULL FALSE
Admin_Step Step TimeframeComments String NText TRUE
Admin_Step Step Timeframe_Law_Id Int32 Int TRUE
Admin_Step Step Timeframe_Articles String NVarChar(400) TRUE
Admin_Step Step LawsComments String NText TRUE
Admin_Step Step AdditionalInfo String NText TRUE
Admin_Step Step CreatedDate DateTime DateTime NOT NULL FALSE
Admin_Step Step CreatedUser String NVarChar(50) NOT NULL FALSE
Admin_Step Step ModifiedDate DateTime DateTime NOT NULL FALSE
Admin_Step Step ModifiedUser String NVarChar(50) NOT NULL FALSE
Admin_Step Step IsInRecycleBin Bool Bit NOT NULL FALSE
Admin_Step Step Deleted Bool Bit NOT NULL FALSE
Admin_Step_i18n Step_i18n Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Step_i18n Step_i18n Step_Id Int32 Int NOT NULL FALSE
Admin_Step_i18n Step_i18n Lang String Char(2) NOT NULL FALSE
Admin_Step_i18n Step_i18n Name String NVarChar(300) NOT NULL FALSE
Admin_Step_i18n Step_i18n PayMethodOtherText String NVarChar(200) TRUE
Admin_Step_i18n Step_i18n CostsComments String NText TRUE
Admin_Step_i18n Step_i18n TimeframeComments String NText TRUE
Admin_Step_i18n Step_i18n LawsComments String NText TRUE
Admin_Step_i18n Step_i18n AdditionalInfo String NText TRUE
Admin_Step_i18n Step_i18n Contact_Articles String NVarChar(400) TRUE
Admin_Step_i18n Step_i18n Timeframe_Articles String NVarChar(400) TRUE
Admin_Step_Recourse Step_Recourse Id Int32 Int NOT NULL IDENTITY FALSE
Admin_Step_Recourse Step_Recourse Step_Id Int32 Int NOT NULL FALSE
Admin_Step_Recourse Step_Recourse Recourse_Id Int32 Int NOT NULL FALSE
Admin_Step_Recourse Step_Recourse [Order] Int32 Int NOT NULL FALSE
Admin_StepCost StepCost Id Int32 Int NOT NULL IDENTITY FALSE
Admin_StepCost StepCost Step_Id Int32 Int NOT NULL FALSE
Admin_StepCost StepCost [Order] Int32 Int NOT NULL FALSE
Admin_StepCost StepCost AggregateOperator String NVarChar(2) NOT NULL FALSE
Admin_StepCost StepCost IsSeparator Bool Bit NOT NULL FALSE
Admin_StepCost StepCost Value Decimal Decimal(19,4) NOT NULL FALSE
Admin_StepCost StepCost Unit String NVarChar(10) TRUE
Admin_StepCost StepCost Operator String NVarChar(20) NOT NULL FALSE
Admin_StepCost StepCost Parameter String NVarChar(100) TRUE
Admin_StepCost StepCost Type String NVarChar(50) NOT NULL FALSE
Admin_StepCost StepCost AverageValue Decimal Decimal(19,4) TRUE
Admin_StepCost StepCost Comments String NVarChar(400) TRUE
Admin_StepCost StepCost AverageValueComments String NVarChar(1000) TRUE
Admin_StepCost StepCost FilterGlobalOption Int32 Int TRUE
Admin_StepCost StepCost Law_Id Int32 Int TRUE
Admin_StepCost StepCost Articles String NVarChar(400) TRUE
Admin_StepCost_i18n StepCost_i18n Id Int32 Int NOT NULL IDENTITY FALSE
Admin_StepCost_i18n StepCost_i18n StepCost_Id Int32 Int NOT NULL FALSE
Admin_StepCost_i18n StepCost_i18n Lang String Char(2) NOT NULL FALSE
Admin_StepCost_i18n StepCost_i18n Comments String NVarChar(400) TRUE
Admin_StepCost_i18n StepCost_i18n AverageValueComments String NVarChar(1000) TRUE
Admin_StepCost_i18n StepCost_i18n Articles String NVarChar(400) TRUE
Admin_StepLaw StepLaw Id Int32 Int NOT NULL IDENTITY FALSE
Admin_StepLaw StepLaw Step_Id Int32 Int NOT NULL FALSE
Admin_StepLaw StepLaw [Order] Int32 Int NOT NULL FALSE
Admin_StepLaw StepLaw AggregateOperator String NVarChar(2) NOT NULL FALSE
Admin_StepLaw StepLaw Law_Id Int32 Int NOT NULL FALSE
Admin_StepLaw StepLaw Articles String NVarChar(400) TRUE
Admin_StepLaw StepLaw Comments String NVarChar(400) TRUE
Admin_StepLaw_i18n StepLaw_i18n Id Int32 Int NOT NULL IDENTITY FALSE
Admin_StepLaw_i18n StepLaw_i18n StepLaw_Id Int32 Int NOT NULL FALSE
Admin_StepLaw_i18n StepLaw_i18n Lang String Char(2) NOT NULL FALSE
Admin_StepLaw_i18n StepLaw_i18n Articles String NVarChar(400) TRUE
Admin_StepLaw_i18n StepLaw_i18n Comments String NVarChar(400) TRUE
Admin_StepRequirement StepRequirement Id Int32 Int NOT NULL IDENTITY FALSE
Admin_StepRequirement StepRequirement Step_Id Int32 Int NOT NULL FALSE
Admin_StepRequirement StepRequirement [Order] Int32 Int NOT NULL FALSE
Admin_StepRequirement StepRequirement AggregateOperator String NVarChar(2) NOT NULL FALSE
Admin_StepRequirement StepRequirement Type Int32 Int NOT NULL FALSE
Admin_StepRequirement StepRequirement GenericRequirement_Id Int32 Int TRUE
Admin_StepRequirement StepRequirement StepResult_Id Int32 Int TRUE
Admin_StepRequirement StepRequirement NbOriginal Int32 Int NOT NULL FALSE
Admin_StepRequirement StepRequirement NbCopy Int32 Int NOT NULL FALSE
Admin_StepRequirement StepRequirement NbAuthenticated Int32 Int NOT NULL FALSE
Admin_StepRequirement StepRequirement Comments String NText TRUE
Admin_StepRequirement StepRequirement FilterGlobalOption Int32 Int TRUE
Admin_StepRequirement StepRequirement Law_Id Int32 Int TRUE
Admin_StepRequirement StepRequirement Articles String NVarChar(400) TRUE
Admin_StepRequirement_i18n StepRequirement_i18n Id Int32 Int NOT NULL IDENTITY FALSE
Admin_StepRequirement_i18n StepRequirement_i18n StepRequirement_Id Int32 Int NOT NULL FALSE
Admin_StepRequirement_i18n StepRequirement_i18n Lang String Char(2) NOT NULL FALSE
Admin_StepRequirement_i18n StepRequirement_i18n Comments String NText TRUE
Admin_StepRequirement_i18n StepRequirement_i18n Articles String NVarChar(400) TRUE
Admin_StepResult StepResult Id Int32 Int NOT NULL IDENTITY FALSE
Admin_StepResult StepResult Step_Id Int32 Int NOT NULL FALSE
Admin_StepResult StepResult [Order] Int32 Int NOT NULL FALSE
Admin_StepResult StepResult Name String NVarChar(100) NOT NULL FALSE
Admin_StepResult StepResult NbOriginal Int32 Int NOT NULL FALSE
Admin_StepResult StepResult NbCopy Int32 Int NOT NULL FALSE
Admin_StepResult StepResult NbAuthenticated Int32 Int NOT NULL FALSE
Admin_StepResult StepResult Type String NVarChar(50) NOT NULL FALSE
Admin_StepResult StepResult Law_Id Int32 Int TRUE
Admin_StepResult StepResult Articles String NVarChar(400) TRUE
Admin_StepResult StepResult IsDocumentPresent Bool Bit NOT NULL FALSE
Admin_StepResult_i18n StepResult_i18n Id Int32 Int NOT NULL IDENTITY FALSE
Admin_StepResult_i18n StepResult_i18n StepResult_Id Int32 Int NOT NULL FALSE
Admin_StepResult_i18n StepResult_i18n Lang String Char(2) NOT NULL FALSE
Admin_StepResult_i18n StepResult_i18n Name String NVarChar(100) NOT NULL FALSE
Admin_StepResult_i18n StepResult_i18n Articles String NVarChar(400) TRUE
EntityInCharge EntityInCharge Id Int32 Int NOT NULL IDENTITY FALSE
EntityInCharge EntityInCharge Name String NVarChar(100) NOT NULL FALSE
EntityInCharge EntityInCharge Address String NVarChar(250) TRUE
EntityInCharge EntityInCharge City String NVarChar(50) TRUE
EntityInCharge EntityInCharge PostalCode String NVarChar(50) TRUE
EntityInCharge EntityInCharge CountryCode String NVarChar(50) TRUE
EntityInCharge EntityInCharge Phone1 String NVarChar(50) TRUE
EntityInCharge EntityInCharge Phone2 String NVarChar(50) TRUE
EntityInCharge EntityInCharge Fax1 String NVarChar(50) TRUE
EntityInCharge EntityInCharge Fax2 String NVarChar(50) TRUE
EntityInCharge EntityInCharge Email1 String NVarChar(100) TRUE
EntityInCharge EntityInCharge Email2 String NVarChar(100) TRUE
EntityInCharge EntityInCharge Website1 String NVarChar(250) TRUE
EntityInCharge EntityInCharge Website2 String NVarChar(250) TRUE
EntityInCharge EntityInCharge Image String NVarChar(255) TRUE
EntityInCharge EntityInCharge ScheduleDay1MorningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay1MorningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay1EveningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay1EveningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay1IsClosed Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay1IsNotAvailable Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay2MorningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay2MorningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay2EveningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay2EveningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay2IsClosed Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay2IsNotAvailable Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay3MorningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay3MorningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay3EveningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay3EveningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay3IsClosed Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay3IsNotAvailable Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay4MorningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay4MorningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay4EveningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay4EveningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay4IsClosed Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay4IsNotAvailable Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay5MorningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay5MorningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay5EveningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay5EveningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay5IsClosed Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay5IsNotAvailable Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay6MorningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay6MorningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay6EveningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay6EveningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay6IsClosed Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay6IsNotAvailable Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay7MorningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay7MorningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay7EveningStart String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay7EveningEnd String NVarChar(5) NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay7IsClosed Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleDay7IsNotAvailable Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge ScheduleComments String NVarChar(500) TRUE
EntityInCharge EntityInCharge CreatedDate DateTime DateTime NOT NULL FALSE
EntityInCharge EntityInCharge CreatedUser String NVarChar(50) NOT NULL FALSE
EntityInCharge EntityInCharge ModifiedDate DateTime DateTime NOT NULL FALSE
EntityInCharge EntityInCharge ModifiedUser String NVarChar(50) NOT NULL FALSE
EntityInCharge EntityInCharge OwnershipStatus String VarChar(50) NOT NULL FALSE
EntityInCharge EntityInCharge Deleted Bool Bit NOT NULL FALSE
EntityInCharge EntityInCharge IsVisibleInPublicDirectory Bool Bit FALSE
EntityInCharge EntityInCharge GoogleMapsURL String NVarChar(800) TRUE
EntityInCharge_i18n EntityInCharge_i18n Id Int32 Int NOT NULL IDENTITY FALSE
EntityInCharge_i18n EntityInCharge_i18n EntityInCharge_Id Int32 Int NOT NULL FALSE
EntityInCharge_i18n EntityInCharge_i18n Lang String Char(2) NOT NULL FALSE
EntityInCharge_i18n EntityInCharge_i18n Name String NVarChar(100) NOT NULL FALSE
EntityInCharge_i18n EntityInCharge_i18n Address String NVarChar(250) TRUE
EntityInCharge_i18n EntityInCharge_i18n City String NVarChar(50) TRUE
EntityInCharge_i18n EntityInCharge_i18n Website1 String NVarChar(250) TRUE
EntityInCharge_i18n EntityInCharge_i18n Website2 String NVarChar(250) TRUE
EntityInCharge_i18n EntityInCharge_i18n ScheduleComments String NVarChar(500) TRUE
GenericRequirement GenericRequirement Id Int32 Int NOT NULL IDENTITY FALSE
GenericRequirement GenericRequirement Name String NVarChar(100) NOT NULL FALSE
GenericRequirement GenericRequirement Description String NText TRUE
GenericRequirement GenericRequirement Type String NVarChar(50) NOT NULL FALSE
GenericRequirement GenericRequirement CreatedDate DateTime DateTime NOT NULL FALSE
GenericRequirement GenericRequirement CreatedUser String NVarChar(50) NOT NULL FALSE
GenericRequirement GenericRequirement ModifiedDate DateTime DateTime NOT NULL FALSE
GenericRequirement GenericRequirement ModifiedUser String NVarChar(50) NOT NULL FALSE
GenericRequirement GenericRequirement OwnershipStatus String VarChar(50) NOT NULL FALSE
GenericRequirement GenericRequirement Deleted Bool Bit NOT NULL FALSE
GenericRequirement GenericRequirement IsDocumentPresent Bool Bit NOT NULL FALSE
GenericRequirement GenericRequirement IsVisibleInPublicDirectory Bool Bit FALSE
GenericRequirement_i18n GenericRequirement_i18n Id Int32 Int NOT NULL IDENTITY FALSE
GenericRequirement_i18n GenericRequirement_i18n GenericRequirement_Id Int32 Int NOT NULL FALSE
GenericRequirement_i18n GenericRequirement_i18n Lang String Char(2) NOT NULL FALSE
GenericRequirement_i18n GenericRequirement_i18n Name String NVarChar(100) NOT NULL FALSE
GenericRequirement_i18n GenericRequirement_i18n Description String NText TRUE
Law Law Id Int32 Int NOT NULL IDENTITY FALSE
Law Law Name String NVarChar(300) NOT NULL FALSE
Law Law Description String NText TRUE
Law Law CreatedDate DateTime DateTime NOT NULL FALSE
Law Law CreatedUser String NVarChar(50) NOT NULL FALSE
Law Law ModifiedDate DateTime DateTime NOT NULL FALSE
Law Law ModifiedUser String NVarChar(50) NOT NULL FALSE
Law Law OwnershipStatus String VarChar(50) NOT NULL FALSE
Law Law Deleted Bool Bit NOT NULL FALSE
Law Law IsDocumentPresent Bool Bit NOT NULL FALSE
Law Law IsVisibleInPublicDirectory Bool Bit FALSE
Law_i18n Law_i18n Id Int32 Int NOT NULL IDENTITY FALSE
Law_i18n Law_i18n Law_Id Int32 Int NOT NULL FALSE
Law_i18n Law_i18n Lang String Char(2) NOT NULL FALSE
Law_i18n Law_i18n Name String NVarChar(300) NOT NULL FALSE
Law_i18n Law_i18n Description String NText TRUE
Media Media Id Int32 Int NOT NULL IDENTITY FALSE
Media Media Name String NVarChar(300) NOT NULL FALSE
Media Media FileName String NVarChar(500) TRUE
Media Media Extention String NVarChar(15) TRUE
Media Media Description String NText TRUE
Media Media Length Decimal Decimal(18,0) TRUE
Media Media PreviewImageName String NVarChar(100) TRUE
Media Media CreatedDate DateTime DateTime NOT NULL FALSE
Media Media CreatedUser String NVarChar(50) NOT NULL FALSE
Media Media ModifiedDate DateTime DateTime NOT NULL FALSE
Media Media ModifiedUser String NVarChar(50) NOT NULL FALSE
Media Media Deleted Bool Bit NOT NULL FALSE
Media Media IsDocumentPresent Bool Bit NOT NULL FALSE
Media_i18n Media_i18n Id Int32 Int NOT NULL IDENTITY FALSE
Media_i18n Media_i18n Media_Id Int32 Int NOT NULL FALSE
Media_i18n Media_i18n Lang String Char(2) NOT NULL FALSE
Media_i18n Media_i18n Name String NVarChar(300) NOT NULL FALSE
PersonInCharge PersonInCharge Id Int32 Int NOT NULL IDENTITY FALSE
PersonInCharge PersonInCharge UnitInCharge_Id Int32 Int TRUE
PersonInCharge PersonInCharge Name String NVarChar(100) NOT NULL FALSE
PersonInCharge PersonInCharge Profession String NVarChar(300) TRUE
PersonInCharge PersonInCharge Phone1 String NVarChar(50) TRUE
PersonInCharge PersonInCharge Phone2 String NVarChar(50) TRUE
PersonInCharge PersonInCharge Email1 String NVarChar(100) TRUE
PersonInCharge PersonInCharge Email2 String NVarChar(100) TRUE
PersonInCharge PersonInCharge Image String NVarChar(255) TRUE
PersonInCharge PersonInCharge CreatedDate DateTime DateTime NOT NULL FALSE
PersonInCharge PersonInCharge CreatedUser String NVarChar(50) NOT NULL FALSE
PersonInCharge PersonInCharge ModifiedDate DateTime DateTime NOT NULL FALSE
PersonInCharge PersonInCharge ModifiedUser String NVarChar(50) NOT NULL FALSE
PersonInCharge PersonInCharge OwnershipStatus String VarChar(50) NOT NULL FALSE
PersonInCharge PersonInCharge Deleted Bool Bit NOT NULL FALSE
PersonInCharge PersonInCharge IsVisibleInPublicDirectory Bool Bit FALSE
PersonInCharge_i18n PersonInCharge_i18n Id Int32 Int NOT NULL IDENTITY FALSE
PersonInCharge_i18n PersonInCharge_i18n PersonInCharge_Id Int32 Int NOT NULL FALSE
PersonInCharge_i18n PersonInCharge_i18n Lang String Char(2) NOT NULL FALSE
PersonInCharge_i18n PersonInCharge_i18n Name String NVarChar(100) NOT NULL FALSE
PersonInCharge_i18n PersonInCharge_i18n Profession String NVarChar(300) TRUE
UnitInCharge UnitInCharge Id Int32 Int NOT NULL IDENTITY FALSE
UnitInCharge UnitInCharge EntityInCharge_Id Int32 Int TRUE
UnitInCharge UnitInCharge Name String NVarChar(100) NOT NULL FALSE
UnitInCharge UnitInCharge Image String NVarChar(255) TRUE
UnitInCharge UnitInCharge ScheduleIsInherited Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay1MorningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay1MorningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay1EveningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay1EveningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay1IsClosed Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay1IsNotAvailable Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay2MorningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay2MorningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay2EveningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay2EveningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay2IsClosed Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay2IsNotAvailable Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay3MorningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay3MorningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay3EveningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay3EveningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay3IsClosed Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay3IsNotAvailable Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay4MorningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay4MorningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay4EveningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay4EveningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay4IsClosed Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay4IsNotAvailable Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay5MorningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay5MorningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay5EveningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay5EveningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay5IsClosed Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay5IsNotAvailable Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay6MorningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay6MorningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay6EveningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay6EveningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay6IsClosed Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay6IsNotAvailable Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay7MorningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay7MorningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay7EveningStart String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay7EveningEnd String NVarChar(5) NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay7IsClosed Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleDay7IsNotAvailable Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge ScheduleComments String NVarChar(500) TRUE
UnitInCharge UnitInCharge CreatedDate DateTime DateTime NOT NULL FALSE
UnitInCharge UnitInCharge CreatedUser String NVarChar(50) NOT NULL FALSE
UnitInCharge UnitInCharge ModifiedDate DateTime DateTime NOT NULL FALSE
UnitInCharge UnitInCharge ModifiedUser String NVarChar(50) NOT NULL FALSE
UnitInCharge UnitInCharge OwnershipStatus String VarChar(50) NOT NULL FALSE
UnitInCharge UnitInCharge Deleted Bool Bit NOT NULL FALSE
UnitInCharge UnitInCharge IsVisibleInPublicDirectory Bool Bit FALSE
UnitInCharge_i18n UnitInCharge_i18n Id Int32 Int NOT NULL IDENTITY FALSE
UnitInCharge_i18n UnitInCharge_i18n UnitInCharge_Id Int32 Int NOT NULL FALSE
UnitInCharge_i18n UnitInCharge_i18n Lang String Char(2) NOT NULL FALSE
UnitInCharge_i18n UnitInCharge_i18n Name String NVarChar(100) NOT NULL FALSE
UnitInCharge_i18n UnitInCharge_i18n ScheduleComments String NVarChar(500) TRUE
SystemLanguage SystemLanguage Code String VarChar(2) NOT NULL FALSE
SystemLanguage SystemLanguage Name String NVarChar(20) NOT NULL FALSE
SystemLanguage SystemLanguage IsActive Bool Bit NOT NULL FALSE
SystemLanguage SystemLanguage IsPrincipal Bool Bit NOT NULL FALSE

2. Snapshots

Table name Column name DbType Null
able
SnapshotRegistry Id Int NOT NULL IDENTITY FALSE
SnapshotRegistry Objective_id Int NOT NULL FALSE
SnapshotRegistry SnapshotVersion Int NOT NULL FALSE
SnapshotRegistry SnapshotDate DateTime NOT NULL FALSE
SnapshotRegistry IsCurrent Bit NOT NULL FALSE
SnapshotStep Registry_Id Int NOT NULL FALSE
SnapshotStep Objective_Id Int NOT NULL FALSE
SnapshotStep Block_Id Int NOT NULL FALSE
SnapshotStep IsRecourse Bit NOT NULL FALSE
SnapshotStep Step_Id Int TRUE
SnapshotStep [Order] Int NOT NULL FALSE
SnapshotStep IsParallele Bit NOT NULL FALSE
SnapshotStep IsAlternative Bit NOT NULL FALSE
SnapshotStep Certified Bit NOT NULL FALSE
SnapshotStep CertificationDate DateTime TRUE
SnapshotStep CertificationUser NVarChar(50) TRUE
SnapshotStep Id Int NOT NULL FALSE
SnapshotStep Lang VarChar(2) NOT NULL FALSE
SnapshotStep Name NVarChar(100) NOT NULL FALSE
SnapshotStep PhysicalPresence Int NOT NULL FALSE
SnapshotStep RepresentationThirdParty Int TRUE
SnapshotStep IsOnline Bit NOT NULL FALSE
SnapshotStep OnlineStepURL NVarChar(200) TRUE
SnapshotStep IsOptional Bit NOT NULL FALSE
SnapshotStep Contact_Law_Id Int TRUE
SnapshotStep Contact_Law_Name NVarChar(300) TRUE
SnapshotStep Contact_Law_Description NVarChar(400) TRUE
SnapshotStep Contact_Articles NVarChar(400) TRUE
SnapshotStep RequirementsPhysicalPresence VarChar(75) TRUE
SnapshotStep HasCosts Bit NOT NULL FALSE
SnapshotStep NoCostsReason VarChar(75) TRUE
SnapshotStep IsPayMethodCash Bit NOT NULL FALSE
SnapshotStep IsPayMethodCheck Bit NOT NULL FALSE
SnapshotStep IsPayMethodCard Bit NOT NULL FALSE
SnapshotStep IsPayMethodOther Bit NOT NULL FALSE
SnapshotStep PayMethodOtherText NVarChar(200) TRUE
SnapshotStep CostsComments NText TRUE
SnapshotStep WaintingTimeInLineMin Decimal(18,6) NOT NULL FALSE
SnapshotStep WaintingTimeInLineMax Decimal(18,6) NOT NULL FALSE
SnapshotStep TimeSpentAtTheCounterMin Decimal(18,6) NOT NULL FALSE
SnapshotStep TimeSpentAtTheCounterMax Decimal(18,6) NOT NULL FALSE
SnapshotStep WaitingTimeUntilNextStepMin Decimal(18,6) NOT NULL FALSE
SnapshotStep WaitingTimeUntilNextStepMax Decimal(18,6) NOT NULL FALSE
SnapshotStep TimeframeComments NText TRUE
SnapshotStep Timeframe_Law_Id Int TRUE
SnapshotStep Timeframe_Law_Name NVarChar(300) TRUE
SnapshotStep Timeframe_Law_Description NVarChar(400) TRUE
SnapshotStep Timeframe_Articles NVarChar(400) TRUE
SnapshotStep LawsComments NText TRUE
SnapshotStep AdditionalInfo NText TRUE
SnapshotStep CertificationEntityInCharge_Id Int TRUE
SnapshotStep CertificationEntityInCharge_Name NVarChar(100) TRUE
SnapshotStep Status Int TRUE
SnapshotStep Version Int TRUE
SnapshotStep StatusDate DateTime TRUE
SnapshotStepCost Registry_Id Int NOT NULL FALSE
SnapshotStepCost Objective_Id Int NOT NULL FALSE
SnapshotStepCost Block_Id Int NOT NULL FALSE
SnapshotStepCost Step_Id Int NOT NULL FALSE
SnapshotStepCost [Order] Int NOT NULL FALSE
SnapshotStepCost Id Int NOT NULL FALSE
SnapshotStepCost Lang VarChar(2) NOT NULL FALSE
SnapshotStepCost AggregateOperator NVarChar(2) NOT NULL FALSE
SnapshotStepCost IsSeparator Bit NOT NULL FALSE
SnapshotStepCost Value Decimal(19,4) NOT NULL FALSE
SnapshotStepCost Unit NVarChar(10) TRUE
SnapshotStepCost Operator NVarChar(20) NOT NULL FALSE
SnapshotStepCost Parameter NVarChar(100) TRUE
SnapshotStepCost Type NVarChar(50) NOT NULL FALSE
SnapshotStepCost AverageValue Decimal(19,4) TRUE
SnapshotStepCost Comments NVarChar(400) TRUE
SnapshotStepCost AverageValueComments NVarChar(1000) TRUE
SnapshotStepCost FilterGlobalOption Int TRUE
SnapshotStepCost Law_Id Int TRUE
SnapshotStepCost Law_Name NVarChar(300) TRUE
SnapshotStepCost Law_Description NVarChar(400) TRUE
SnapshotStepCost Articles NVarChar(400) TRUE
SnapshotStepCost CalculatedValue Decimal(19,4) TRUE
SnapshotStepEntityInCharge Registry_Id Int NOT NULL FALSE
SnapshotStepEntityInCharge Objective_Id Int NOT NULL FALSE
SnapshotStepEntityInCharge Block_Id Int NOT NULL FALSE
SnapshotStepEntityInCharge Step_Id Int NOT NULL FALSE
SnapshotStepEntityInCharge Id Int NOT NULL FALSE
SnapshotStepEntityInCharge Lang VarChar(2) NOT NULL FALSE
SnapshotStepEntityInCharge Name NVarChar(100) NOT NULL FALSE
SnapshotStepEntityInCharge Address NVarChar(250) TRUE
SnapshotStepEntityInCharge City NVarChar(50) TRUE
SnapshotStepEntityInCharge PostalCode NVarChar(50) TRUE
SnapshotStepEntityInCharge CountryCode NVarChar(50) TRUE
SnapshotStepEntityInCharge Phone1 NVarChar(50) TRUE
SnapshotStepEntityInCharge Phone2 NVarChar(50) TRUE
SnapshotStepEntityInCharge Fax1 NVarChar(50) TRUE
SnapshotStepEntityInCharge Fax2 NVarChar(50) TRUE
SnapshotStepEntityInCharge Email1 NVarChar(100) TRUE
SnapshotStepEntityInCharge Email2 NVarChar(100) TRUE
SnapshotStepEntityInCharge Website1 NVarChar(250) TRUE
SnapshotStepEntityInCharge Website2 NVarChar(250) TRUE
SnapshotStepEntityInCharge Image NVarChar(255) TRUE
SnapshotStepEntityInCharge ScheduleDay1MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay1MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay1EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay1EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay1IsClosed Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay1IsNotAvailable Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay2MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay2MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay2EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay2EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay2IsClosed Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay2IsNotAvailable Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay3MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay3MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay3EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay3EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay3IsClosed Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay3IsNotAvailable Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay4MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay4MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay4EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay4EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay4IsClosed Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay4IsNotAvailable Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay5MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay5MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay5EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay5EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay5IsClosed Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay5IsNotAvailable Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay6MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay6MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay6EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay6EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay6IsClosed Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay6IsNotAvailable Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay7MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay7MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay7EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay7EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay7IsClosed Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleDay7IsNotAvailable Bit NOT NULL FALSE
SnapshotStepEntityInCharge ScheduleComments NVarChar(500) TRUE
SnapshotStepLaw Registry_Id Int NOT NULL FALSE
SnapshotStepLaw Objective_Id Int NOT NULL FALSE
SnapshotStepLaw Block_Id Int NOT NULL FALSE
SnapshotStepLaw Step_Id Int NOT NULL FALSE
SnapshotStepLaw [Order] Int NOT NULL FALSE
SnapshotStepLaw Id Int NOT NULL FALSE
SnapshotStepLaw Lang VarChar(2) NOT NULL FALSE
SnapshotStepLaw AggregateOperator NVarChar(2) NOT NULL FALSE
SnapshotStepLaw Law_Id Int NOT NULL FALSE
SnapshotStepLaw Law_Name NVarChar(300) NOT NULL FALSE
SnapshotStepLaw Law_Description NText TRUE
SnapshotStepLaw Articles NVarChar(400) TRUE
SnapshotStepLaw Comments NVarChar(400) TRUE
SnapshotStepLaw Law_IsDocumentPresent Bit NOT NULL FALSE
SnapshotStepPersonInCharge Registry_Id Int NOT NULL FALSE
SnapshotStepPersonInCharge Objective_Id Int NOT NULL FALSE
SnapshotStepPersonInCharge Block_Id Int NOT NULL FALSE
SnapshotStepPersonInCharge Step_Id Int NOT NULL FALSE
SnapshotStepPersonInCharge Id Int NOT NULL FALSE
SnapshotStepPersonInCharge Lang VarChar(2) NOT NULL FALSE
SnapshotStepPersonInCharge Name NVarChar(100) NOT NULL FALSE
SnapshotStepPersonInCharge Profession NVarChar(300) TRUE
SnapshotStepPersonInCharge Phone1 NVarChar(50) TRUE
SnapshotStepPersonInCharge Phone2 NVarChar(50) TRUE
SnapshotStepPersonInCharge Email1 NVarChar(100) TRUE
SnapshotStepPersonInCharge Email2 NVarChar(100) TRUE
SnapshotStepPersonInCharge Image NVarChar(255) TRUE
SnapshotStepRequirement Registry_Id Int NOT NULL FALSE
SnapshotStepRequirement Objective_Id Int NOT NULL FALSE
SnapshotStepRequirement Block_Id Int NOT NULL FALSE
SnapshotStepRequirement Step_Id Int NOT NULL FALSE
SnapshotStepRequirement [Order] Int NOT NULL FALSE
SnapshotStepRequirement Id Int NOT NULL FALSE
SnapshotStepRequirement Lang VarChar(2) NOT NULL FALSE
SnapshotStepRequirement AggregateOperator NVarChar(2) NOT NULL FALSE
SnapshotStepRequirement Type Int NOT NULL FALSE
SnapshotStepRequirement GenericRequirement_Id Int TRUE
SnapshotStepRequirement GenericRequirement_Name NVarChar(100) TRUE
SnapshotStepRequirement GenericRequirement_Description NText TRUE
SnapshotStepRequirement GenericRequirement_Type NVarChar(50) TRUE
SnapshotStepRequirement StepResult_Id Int TRUE
SnapshotStepRequirement StepResult_Step_Id Int TRUE
SnapshotStepRequirement NbOriginal Int NOT NULL FALSE
SnapshotStepRequirement NbCopy Int NOT NULL FALSE
SnapshotStepRequirement NbAuthenticated Int NOT NULL FALSE
SnapshotStepRequirement Comments NText TRUE
SnapshotStepRequirement FilterGlobalOption Int TRUE
SnapshotStepRequirement Law_Id Int TRUE
SnapshotStepRequirement Law_Name NVarChar(300) TRUE
SnapshotStepRequirement Law_Description NVarChar(400) TRUE
SnapshotStepRequirement Articles NVarChar(400) TRUE
SnapshotStepRequirement GenericRequirement_IsDocumentPresent Bit TRUE
SnapshotStepResult Registry_Id Int NOT NULL FALSE
SnapshotStepResult Objective_Id Int NOT NULL FALSE
SnapshotStepResult Block_Id Int NOT NULL FALSE
SnapshotStepResult Step_Id Int NOT NULL FALSE
SnapshotStepResult [Order] Int NOT NULL FALSE
SnapshotStepResult Id Int NOT NULL FALSE
SnapshotStepResult Lang VarChar(2) NOT NULL FALSE
SnapshotStepResult Name NVarChar(100) NOT NULL FALSE
SnapshotStepResult NbOriginal Int NOT NULL FALSE
SnapshotStepResult NbCopy Int NOT NULL FALSE
SnapshotStepResult NbAuthenticated Int NOT NULL FALSE
SnapshotStepResult Type NVarChar(50) NOT NULL FALSE
SnapshotStepResult Law_Id Int TRUE
SnapshotStepResult Law_Name NVarChar(300) TRUE
SnapshotStepResult Law_Description NVarChar(400) TRUE
SnapshotStepResult Articles NVarChar(400) TRUE
SnapshotStepResult IsDocumentPresent Bit NOT NULL FALSE
SnapshotStepSectionVisibility Registry_Id Int NOT NULL FALSE
SnapshotStepSectionVisibility Objective_Id Int NOT NULL FALSE
SnapshotStepSectionVisibility Block_Id Int NOT NULL FALSE
SnapshotStepSectionVisibility Step_Id Int NOT NULL FALSE
SnapshotStepSectionVisibility IsExpectedResultsVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsEntityInChargeVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsUnitInChargeVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsPersonInChargeVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsRequirementsVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsCostsVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsCostsCommentsVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsTimeframeVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsTimeframeWaintingTimeInLineVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsTimeframeTimeSpentAtTheCounterVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsTimeframeWaitingTimeUntilNextStepVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsTimeframeCommentsVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsLegalJustificationVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsLegalJustificationCommentsVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsAdditionalInfoVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsRecoursesVisible Bit NOT NULL FALSE
SnapshotStepSectionVisibility IsCertificationVisible Bit NOT NULL FALSE
SnapshotStepUnitInCharge Registry_Id Int NOT NULL FALSE
SnapshotStepUnitInCharge Objective_Id Int NOT NULL FALSE
SnapshotStepUnitInCharge Block_Id Int NOT NULL FALSE
SnapshotStepUnitInCharge Step_Id Int NOT NULL FALSE
SnapshotStepUnitInCharge Id Int NOT NULL FALSE
SnapshotStepUnitInCharge Lang VarChar(2) NOT NULL FALSE
SnapshotStepUnitInCharge Name NVarChar(100) NOT NULL FALSE
SnapshotStepUnitInCharge Image NVarChar(255) TRUE
SnapshotStepUnitInCharge ScheduleIsInherited Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay1MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay1MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay1EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay1EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay1IsClosed Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay1IsNotAvailable Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay2MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay2MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay2EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay2EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay2IsClosed Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay2IsNotAvailable Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay3MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay3MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay3EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay3EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay3IsClosed Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay3IsNotAvailable Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay4MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay4MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay4EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay4EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay4IsClosed Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay4IsNotAvailable Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay5MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay5MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay5EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay5EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay5IsClosed Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay5IsNotAvailable Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay6MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay6MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay6EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay6EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay6IsClosed Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay6IsNotAvailable Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay7MorningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay7MorningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay7EveningStart NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay7EveningEnd NVarChar(5) NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay7IsClosed Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleDay7IsNotAvailable Bit NOT NULL FALSE
SnapshotStepUnitInCharge ScheduleComments NVarChar(500) TRUE
SnapshotObjective Registry_Id Int NOT NULL FALSE
SnapshotObjective Id Int NOT NULL FALSE
SnapshotObjective Lang VarChar(2) NOT NULL FALSE
SnapshotObjective Name NVarChar(100) NOT NULL FALSE
SnapshotObjective AdditionalInfo NVarChar(1000) TRUE
SnapshotObject_Media Registry_Id Int NOT NULL FALSE
SnapshotObject_Media Objective_Id Int NOT NULL FALSE
SnapshotObject_Media Block_Id Int NOT NULL FALSE
SnapshotObject_Media Step_Id Int NOT NULL FALSE
SnapshotObject_Media Lang VarChar(2) NOT NULL FALSE
SnapshotObject_Media Object_Id Int NOT NULL FALSE
SnapshotObject_Media Type VarChar(100) NOT NULL FALSE
SnapshotObject_Media [Order] Int NOT NULL FALSE
SnapshotObject_Media Media_Id Int NOT NULL FALSE
SnapshotObject_Media Media_Name NVarChar(300) NOT NULL FALSE
SnapshotObject_Media Media_FileName NVarChar(500) TRUE
SnapshotObject_Media Media_Extention NVarChar(15) TRUE
SnapshotObject_Media Media_Description NText TRUE
SnapshotObject_Media Media_Length Decimal(18,0) TRUE
SnapshotObject_Media Media_PreviewImageName NVarChar(100) TRUE
SnapshotObject_Media Media_IsDocumentPresent Bit NOT NULL FALSE
SnapshotBlock Registry_Id Int NOT NULL FALSE
SnapshotBlock Objective_Id Int NOT NULL FALSE
SnapshotBlock [Order] Int NOT NULL FALSE
SnapshotBlock Id Int NOT NULL FALSE
SnapshotBlock Lang VarChar(2) NOT NULL FALSE
SnapshotBlock Name NVarChar(100) NOT NULL FALSE
SnapshotBlock Description NText TRUE
SnapshotBlock IsOptional Bit NOT NULL FALSE
SnapshotBlock PhysicalPresence Int NOT NULL FALSE
SnapshotBlock RepresentationThirdParty Int TRUE

3. Tracking

Table name Model Column Type DbType Null
able
AuditRecordFields AuditRecordField Id System.Int32 Int NOT NULL IDENTITY FALSE
AuditRecordFields AuditRecordField AuditRecordId System.Int32 Int NOT NULL FALSE
AuditRecordFields AuditRecordField FieldName System.String VarChar(100) NOT NULL FALSE
AuditRecordFields AuditRecordField FieldType System.String VarChar(100) NOT NULL FALSE
AuditRecordFields AuditRecordField OldValue_asInteger System.Int32 Int TRUE
AuditRecordFields AuditRecordField NewValue_asInteger System.Int32 Int TRUE
AuditRecordFields AuditRecordField OldValue_asDecimal System.Decimal Decimal(19,4) TRUE
AuditRecordFields AuditRecordField NewValue_asDecimal System.Decimal Decimal(19,4) TRUE
AuditRecordFields AuditRecordField OldValue_asText System.String NText TRUE
AuditRecordFields AuditRecordField NewValue_asText System.String NText TRUE
AuditRecordFields AuditRecordField OldValue_asDateTime System.DateTime DateTime TRUE
AuditRecordFields AuditRecordField NewValue_asDateTime System.DateTime DateTime TRUE
AuditRecordFields AuditRecordField OldValue_asBoolean System.Boolean Bit TRUE
AuditRecordFields AuditRecordField NewValue_asBoolean System.Boolean Bit TRUE
AuditRecords AuditRecord Id System.Int32 Int NOT NULL IDENTITY FALSE
AuditRecords AuditRecord Action System.Byte TinyInt NOT NULL FALSE
AuditRecords AuditRecord EntityTable System.String VarChar(50) NOT NULL FALSE
AuditRecords AuditRecord EntityTableKey System.Int32 Int NOT NULL FALSE
AuditRecords AuditRecord AssociationTable System.String VarChar(50) TRUE
AuditRecords AuditRecord AssociationTableKey System.Int32 Int TRUE
AuditRecords AuditRecord IsAssociationTranslated System.Boolean Bit TRUE
AuditRecords AuditRecord TranslationTable System.String VarChar(50) TRUE
AuditRecords AuditRecord TranslationTableKey System.Int32 Int TRUE
AuditRecords AuditRecord AuditDate System.DateTime DateTime NOT NULL FALSE
AuditRecords AuditRecord UserName System.String VarChar(50) NOT NULL FALSE


Relationship

Table name ThisKey OtherKey Reference
AuditRecordFields AuditRecordId Id AuditRecord

4. Translator

Table name Model Column Type DbType Null
able
Workspace Workspace Id System.Int32 Int NOT NULL IDENTITY FALSE
Workspace Workspace Username System.String NVarChar(50) TRUE
Workspace Workspace XMLSerializedItem_Id System.Int32 Int NOT NULL FALSE
Workspace Workspace XMLSerializedItem_Name System.String NVarChar(1000) TRUE
Workspace Workspace StartDate System.DateTime DateTime TRUE
XMLSerializedItem XMLSerializedItem Id System.Int32 Int NOT NULL IDENTITY FALSE
XMLSerializedItem XMLSerializedItem ObjectType System.String NVarChar(300) NOT NULL FALSE
XMLSerializedItem XMLSerializedItem ObjectId System.Int32 Int NOT NULL FALSE
XMLSerializedItem XMLSerializedItem ObjectVersion System.Int32 Int NOT NULL FALSE
XMLSerializedItem XMLSerializedItem Data System.Xml.Linq.XElement Xml NOT NULL FALSE
XMLSerializedItem XMLSerializedItem WordsDeleted System.Int32 Int TRUE
XMLSerializedItem XMLSerializedItem WordsAdded System.Int32 Int TRUE
XMLSerializedItem XMLSerializedItem CreatedDate System.DateTime DateTime NOT NULL FALSE
XMLSerializedItem XMLSerializedItem CreatedUser System.String NVarChar(50) NOT NULL FALSE
XMLSerializedItem_i18n XMLSerializedItem_i18n Id System.Int32 Int NOT NULL IDENTITY FALSE
XMLSerializedItem_i18n XMLSerializedItem_i18n XMLSerializedItem_Id System.Int32 Int NOT NULL FALSE
XMLSerializedItem_i18n XMLSerializedItem_i18n Lang System.String Char(2) NOT NULL FALSE
XMLSerializedItem_i18n XMLSerializedItem_i18n TranslationVersion System.Int32 Int NOT NULL FALSE
XMLSerializedItem_i18n XMLSerializedItem_i18n Data System.Xml.Linq.XElement Xml TRUE
XMLSerializedItem_i18n XMLSerializedItem_i18n ModifiedDate System.DateTime DateTime TRUE
XMLSerializedItem_i18n XMLSerializedItem_i18n ModifiedUser System.String NVarChar(50) TRUE
XMLSerializedItem_i18n XMLSerializedItem_i18n CommitDate System.DateTime DateTime TRUE
ProcedureContext ProcedureContext Id System.Int32 Int NOT NULL IDENTITY FALSE
ProcedureContext ProcedureContext ProcedureId System.Int32 Int NOT NULL FALSE
ProcedureContext ProcedureContext ProcedureName System.String NVarChar(300) NOT NULL FALSE
ProcedureContext ProcedureContext ObjectType System.String NVarChar(300) NOT NULL FALSE
ProcedureContext ProcedureContext ObjectId System.Int32 Int NOT NULL FALSE

5. Consistency review

Table name Model Column Type DbType Null
able
consistency_status Consistency_Status id System.Int32 Int NO T NULL IDENTITY FALSE
consistency_status Consistency_Status systemId System.Int32 Int NOT NULL FALSE
consistency_status Consistency_Status pagename System.String NVarChar(30) TRUE
consistency_status Consistency_Status menuid System.Int32 Int TRUE
consistency_status Consistency_Status objectiveId System.Int32 Int TRUE
consistency_status Consistency_Status stepId System.Int32 Int TRUE
consistency_status Consistency_Status status System.Int32 Int TRUE
consistency_status Consistency_Status version System.Int32 Int TRUE
consistency_status Consistency_Status cycle System.Int32 Int TRUE
consistency_status Consistency_Status content System.String NVarChar(1000) TRUE
consistency_status Consistency_Status dateCreated System.DateTime SmallDateTime TRUE
consistency_status Consistency_Status creatorId System.Int32 Int TRUE
consistency_status Consistency_Status isLast System.Int32 Int TRUE
consistency_status Consistency_Status oldid System.Int32 Int TRUE
consistency_tickets Consistency_Ticket id System.Int32 Int NOT NULL IDENTITY FALSE
consistency_tickets Consistency_Ticket systemId System.Int32 Int NOT NULL FALSE
consistency_tickets Consistency_Ticket objectiveId System.Int32 Int TRUE
consistency_tickets Consistency_Ticket stepId System.Int32 Int TRUE
consistency_tickets Consistency_Ticket stepGuid System.Guid UniqueIdentifier TRUE
consistency_tickets Consistency_Ticket section System.String NVarChar(50) TRUE
consistency_tickets Consistency_Ticket objectId System.Int32 Int TRUE
consistency_tickets Consistency_Ticket priority System.Int32 Int TRUE
consistency_tickets Consistency_Ticket status System.Int32 Int TRUE
consistency_tickets Consistency_Ticket content System.String NVarChar(1000) TRUE
consistency_tickets Consistency_Ticket dateCreated System.DateTime SmallDateTime TRUE
consistency_tickets Consistency_Ticket creatorId System.Int32 Int TRUE
consistency_tickets Consistency_Ticket lastModified System.DateTime SmallDateTime TRUE
consistency_tickets Consistency_Ticket modifierId System.Int32 Int TRUE
consistency_tickets Consistency_Ticket commentsCounter System.Int32 Int TRUE
consistency_tickets Consistency_Ticket commentLastStatus System.Int32 Int TRUE
consistency_tickets Consistency_Ticket SEID System.String NVarChar(40) TRUE
consistency_tickets Consistency_Ticket responsibleId System.Int32 Int TRUE
consistency_tickets Consistency_Ticket pagename System.String NVarChar(30) TRUE
consistency_tickets Consistency_Ticket menuid System.Int32 Int TRUE
consistency_tickets Consistency_Ticket oldid System.Int32 Int TRUE
consistency_comments Consistency_Comment id System.Int32 Int NOT NULL IDENTITY FALSE
consistency_comments Consistency_Comment ticketId System.Int32 Int TRUE
consistency_comments Consistency_Comment dateCreated System.DateTime SmallDateTime TRUE
consistency_comments Consistency_Comment userId System.Int32 Int TRUE
consistency_comments Consistency_Comment comment System.String NVarChar(1000) TRUE
consistency_comments Consistency_Comment status System.Int32 Int TRUE
consistency_comments Consistency_Comment SEID System.String NVarChar(40) TRUE
consistency_comments Consistency_Comment oldid System.Int32 Int TRUE

6. Statistics

</tr>
Table name Model Column Type DbType Null
able
StatisticSet StatisticSet Id System.Int32 Int NOT NULL IDENTITY FALSE
StatisticSet StatisticSet SystemId System.Int32 Int NOT NULL FALSE
StatisticSet StatisticSet CreatedDate System.DateTime DateTime NOT NULL FALSE
StatisticSet StatisticSet Type System.String NVarChar(200) TRUE
StatisticSet StatisticSet Value System.Decimal Decimal(19,4) TRUE
StatisticSet StatisticSet OptionalField1 System.String NVarChar(200) TRUE
StatisticSet StatisticSet OptionalValue1 System.String NVarChar(200) TRUE
StatisticSet StatisticSet OptionalField2 System.String NVarChar(200) TRUE
StatisticSet StatisticSet OptionalValue2 System.String NVarChar(200) TRUE
StatisticSet StatisticSet OptionalField3 System.String NVarChar(200) TRUE
StatisticSet StatisticSet OptionalValue3 System.String NVarChar(200) TRUE
StatisticSet StatisticSet OptionalField4 System.String NVarChar(200) TRUE
StatisticSet StatisticSet OptionalValue4 System.String NVarChar(200) TRUE
StatisticSet StatisticSet OptionalField5 System.String NVarChar(200) TRUE
StatisticSet StatisticSet OptionalValue5 System.String NVarChar(200) TRUE
StatisticSet StatisticSet SystemImageDate System.DateTime DateTime NOT NULL FALSE

Feedback