GSaha567/seq_level_training_data
052
1text,length,is_long_context,metric_val,label_metric2"// tag::HeaderFullDisplayName[]3= repo.RepoObject_RequiredRepoObjectMerge - V4// end::HeaderFullDisplayName[]5 6== existing_properties7 8// tag::existing_properties[]9 10:ExistsProperty--antorareferencedlist:11:ExistsProperty--antorareferencinglist:12:ExistsProperty--description:13:ExistsProperty--is_repo_managed:14:ExistsProperty--is_ssas:15:ExistsProperty--referencedobjectlist:16:ExistsProperty--sql_modules_definition:17:ExistsProperty--FK:18:ExistsProperty--AntoraIndexList:19:ExistsProperty--Columns:20// end::existing_properties[]21 22== RepoObject_guid23 24// tag::RepoObject_guid[]2552230F14-2E66-EB11-84DD-A81E8446D5B026// end::RepoObject_guid[]27 28== RepoObject_FullDisplayName229 30// tag::RepoObject_FullDisplayName2[]31repo.RepoObject_RequiredRepoObjectMerge32// end::RepoObject_FullDisplayName2[]33 34== SysObject_type35 36// tag::SysObject_type[]37V 38// end::SysObject_type[]39 40== SysObject_type_name41 42// tag::SysObject_type_name[]43view44// end::SysObject_type_name[]45 46== SysObject_id47 48// tag::SysObject_id[]49192839393950// end::SysObject_id[]51 52== SysObject_modify_date53 54// tag::SysObject_modify_date[]552021-10-02 13:23:3456// end::SysObject_modify_date[]57 58== AntoraColumnDetails59 60// tag::AntoraColumnDetails[]61[discrete]62== _63 64 65[#column-repoobjectunderlinefullname]66=== RepoObject_fullname67 68[cols=""d,8a,m,m,m""]69|===70|71|RepoObject_fullname72|nvarchar(261)73|NOT NULL74|75|===76 77.Description78--79(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))80--81{empty} +82 83.Referenced Columns84--85* xref:repo.repoobject.adoc#column-repoobjectunderlinefullname[+repo.RepoObject.RepoObject_fullname+]86--87 88 89[#column-repoobjectunderlineguid]90=== RepoObject_guid91 92[cols=""d,8a,m,m,m""]93|===94|95|RepoObject_guid96|uniqueidentifier97|NOT NULL98|99|===100 101.Referenced Columns102--103* xref:repo.repoobject.adoc#column-repoobjectunderlineguid[+repo.RepoObject.RepoObject_guid+]104--105 106 107[#column-repoobjectunderlinename]108=== RepoObject_name109 110[cols=""d,8a,m,m,m""]111|===112|113|RepoObject_name114|nvarchar(128)115|NOT NULL116|117|===118 119.Referenced Columns120--121* xref:repo.repoobject.adoc#column-repoobjectunderlinename[+repo.RepoObject.RepoObject_name+]122--123 124 125[#column-repoobjectunderlineschemaunderlinename]126=== RepoObject_schema_name127 128[cols=""d,8a,m,m,m""]129|===130|131|RepoObject_schema_name132|nvarchar(128)133|NOT NULL134|135|===136 137.Referenced Columns138--139* xref:repo.repoobject.adoc#column-repoobjectunderlineschemaunderlinename[+repo.RepoObject.RepoObject_schema_name+]140--141 142 143[#column-ro2underlinerepoobjectunderlinefullname]144=== ro2_RepoObject_fullname145 146[cols=""d,8a,m,m,m""]147|===148|149|ro2_RepoObject_fullname150|nvarchar(261)151|NOT NULL152|153|===154 155.Description156--157(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))158--159{empty} +160 161.Referenced Columns162--163* xref:repo.repoobject.adoc#column-repoobjectunderlinefullname[+repo.RepoObject.RepoObject_fullname+]164--165 166 167[#column-ro2underlinerepoobjectunderlineguid]168=== ro2_RepoObject_guid169 170[cols=""d,8a,m,m,m""]171|===172|173|ro2_RepoObject_guid174|uniqueidentifier175|NOT NULL176|177|===178 179.Referenced Columns180--181* xref:repo.repoobject.adoc#column-repoobjectunderlineguid[+repo.RepoObject.RepoObject_guid+]182--183 184 185[#column-ro2underlinerepoobjectunderlinename]186=== ro2_RepoObject_name187 188[cols=""d,8a,m,m,m""]189|===190|191|ro2_RepoObject_name192|nvarchar(128)193|NOT NULL194|195|===196 197.Referenced Columns198--199* xref:repo.repoobject.adoc#column-repoobjectunderlinename[+repo.RepoObject.RepoObject_name+]200--201 202 203[#column-ro2underlinerepoobjectunderlineschemaunderlinename]204=== ro2_RepoObject_schema_name205 206[cols=""d,8a,m,m,m""]207|===208|209|ro2_RepoObject_schema_name210|nvarchar(128)211|NOT NULL212|213|===214 215.Referenced Columns216--217* xref:repo.repoobject.adoc#column-repoobjectunderlineschemaunderlinename[+repo.RepoObject.RepoObject_schema_name+]218--219 220 221[#column-ro2underlinesysobjectunderlinefullname]222=== ro2_SysObject_fullname223 224[cols=""d,8a,m,m,m""]225|===226|227|ro2_SysObject_fullname228|nvarchar(261)229|NOT NULL230|231|===232 233.Description234--235(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))236--237{empty} +238 239.Referenced Columns240--241* xref:repo.repoobject.adoc#column-sysobjectunderlinefullname[+repo.RepoObject.SysObject_fullname+]242--243 244 245[#column-ro2underlinesysobjectunderlinename]246=== ro2_SysObject_name247 248[cols=""d,8a,m,m,m""]249|===250|251|ro2_SysObject_name252|nvarchar(128)253|NOT NULL254|255|===256 257.Referenced Columns258--259* xref:repo.repoobject.adoc#column-sysobjectunderlinename[+repo.RepoObject.SysObject_name+]260--261 262 263[#column-sysobjectunderlinefullname]264=== SysObject_fullname265 266[cols=""d,8a,m,m,m""]267|===268|269|SysObject_fullname270|nvarchar(261)271|NOT NULL272|273|===274 275.Description276--277(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))278--279{empty} +280 281.Referenced Columns282--283* xref:repo.repoobject.adoc#column-sysobjectunderlinefullname[+repo.RepoObject.SysObject_fullname+]284--285 286 287[#column-sysobjectunderlinename]288=== SysObject_name289 290[cols=""d,8a,m,m,m""]291|===292|293|SysObject_name294|nvarchar(128)295|NOT NULL296|297|===298 299.Referenced Columns300--301* xref:repo.repoobject.adoc#column-sysobjectunderlinename[+repo.RepoObject.SysObject_name+]302--303 304 305[#column-sysobjectunderlineschemaunderlinename]306=== SysObject_schema_name307 308[cols=""d,8a,m,m,m""]309|===310|311|SysObject_schema_name312|nvarchar(128)313|NOT NULL314|315|===316 317.Referenced Columns318--319* xref:repo.repoobject.adoc#column-sysobjectunderlineschemaunderlinename[+repo.RepoObject.SysObject_schema_name+]320--321 322 323// end::AntoraColumnDetails[]324 325== AntoraPkColumnTableRows326 327// tag::AntoraPkColumnTableRows[]328 329 330 331 332 333 334 335 336 337 338 339 340 341// end::AntoraPkColumnTableRows[]342 343== AntoraNonPkColumnTableRows344 345// tag::AntoraNonPkColumnTableRows[]346|347|<<column-repoobjectunderlinefullname>>348|nvarchar(261)349|NOT NULL350|351 352|353|<<column-repoobjectunderlineguid>>354|uniqueidentifier355|NOT NULL356|357 358|359|<<column-repoobjectunderlinename>>360|nvarchar(128)361|NOT NULL362|363 364|365|<<column-repoobjectunderlineschemaunderlinename>>366|nvarchar(128)367|NOT NULL368|369 370|371|<<column-ro2underlinerepoobjectunderlinefullname>>372|nvarchar(261)373|NOT NULL374|375 376|377|<<column-ro2underlinerepoobjectunderlineguid>>378|uniqueidentifier379|NOT NULL380|381 382|383|<<column-ro2underlinerepoobjectunderlinename>>384|nvarchar(128)385|NOT NULL386|387 388|389|<<column-ro2underlinerepoobjectunderlineschemaunderlinename>>390|nvarchar(128)391|NOT NULL392|393 394|395|<<column-ro2underlinesysobjectunderlinefullname>>396|nvarchar(261)397|NOT NULL398|399 400|401|<<column-ro2underlinesysobjectunderlinename>>402|nvarchar(128)403|NOT NULL404|405 406|407|<<column-sysobjectunderlinefullname>>408|nvarchar(261)409|NOT NULL410|411 412|413|<<column-sysobjectunderlinename>>414|nvarchar(128)415|NOT NULL416|417 418|419|<<column-sysobjectunderlineschemaunderlinename>>420|nvarchar(128)421|NOT NULL422|423 424// end::AntoraNonPkColumnTableRows[]425 426== AntoraIndexList427 428// tag::AntoraIndexList[]429 430[#index-idxunderlinerepoobjectunderlinerequiredrepoobjectmergeunderlineunderline1]431=== idx_RepoObject_RequiredRepoObjectMerge++__++1432 433* IndexSemanticGroup: xref:other/indexsemanticgroup.adoc#startbnoblankgroupendb[no_group]434+435--436* <<column-RepoObject_guid>>; uniqueidentifier437--438* PK, Unique, Real: 0, 0, 0439 440 441[#index-idxunderlinerepoobjectunderlinerequiredrepoobjectmergeunderlineunderline2]442=== idx_RepoObject_RequiredRepoObjectMerge++__++2443 444* IndexSemanticGroup: xref:other/indexsemanticgroup.adoc#startbnoblankgroupendb[no_group]445+446--447* <<column-ro2_RepoObject_guid>>; uniqueidentifier448--449* PK, Unique, Real: 0, 0, 0450 451 452[#index-idxunderlinerepoobjectunderlinerequiredrepoobjectmergeunderlineunderline3]453=== idx_RepoObject_RequiredRepoObjectMerge++__++3454 455* IndexSemanticGroup: xref:other/indexsemanticgroup.adoc#startbnoblankgroupendb[no_group]456+457--458* <<column-SysObject_schema_name>>; nvarchar(128)459* <<column-SysObject_name>>; nvarchar(128)460--461* PK, Unique, Real: 0, 0, 0462 463 464[#index-idxunderlinerepoobjectunderlinerequiredrepoobjectmergeunderlineunderline4]465=== idx_RepoObject_RequiredRepoObjectMerge++__++4466 467* IndexSemanticGroup: xref:other/indexsemanticgroup.adoc#startbnoblankgroupendb[no_group]468+469--470* <<column-ro2_SysObject_name>>; nvarchar(128)471--472* PK, Unique, Real: 0, 0, 0473 474 475[#index-idxunderlinerepoobjectunderlinerequiredrepoobjectmergeunderlineunderline5]476=== idx_RepoObject_RequiredRepoObjectMerge++__++5477 478* IndexSemanticGroup: xref:other/indexsemanticgroup.adoc#startbnoblankgroupendb[no_group]479+480--481* <<column-RepoObject_schema_name>>; nvarchar(128)482* <<column-RepoObject_name>>; nvarchar(128)483--484* PK, Unique, Real: 0, 0, 0485 486 487[#index-idxunderlinerepoobjectunderlinerequiredrepoobjectmergeunderlineunderline6]488=== idx_RepoObject_RequiredRepoObjectMerge++__++6489 490* IndexSemanticGroup: xref:other/indexsemanticgroup.adoc#startbnoblankgroupendb[no_group]491+492--493* <<column-ro2_RepoObject_schema_name>>; nvarchar(128)494* <<column-ro2_RepoObject_name>>; nvarchar(128)495--496* PK, Unique, Real: 0, 0, 0497 498// end::AntoraIndexList[]499 500== AntoraMeasureDetails501 502// tag::AntoraMeasureDetails[]503 504// end::AntoraMeasureDetails[]505 506== AntoraMeasureDescriptions507 508 509 510== AntoraParameterList511 512// tag::AntoraParameterList[]513 514// end::AntoraParameterList[]515 516== AntoraXrefCulturesList517 518// tag::AntoraXrefCulturesList[]519* xref:dhw:sqldb:repo.repoobject_requiredrepoobjectmerge.adoc[] - 520// end::AntoraXrefCulturesList[]521 522== cultures_count523 524// tag::cultures_count[]5251526// end::cultures_count[]527 528== Other tags529 530source: property.RepoObjectProperty_cross As rop_cross531 532 533=== additional_reference_csv534 535// tag::additional_reference_csv[]536 537// end::additional_reference_csv[]538 539 540=== AdocUspSteps541 542// tag::adocuspsteps[]543 544// end::adocuspsteps[]545 546 547=== AntoraReferencedList548 549// tag::antorareferencedlist[]550* xref:dhw:sqldb:repo.repoobject.adoc[]551// end::antorareferencedlist[]552 553 554=== AntoraReferencingList555 556// tag::antorareferencinglist[]557* xref:dhw:sqldb:repo.usp_sync_guid_repoobject.adoc[]558// end::antorareferencinglist[]559 560 561=== Description562 563// tag::description[]564 565list of conflicting entries which needs to be merged566 567mismatch of RepoObject_guid can create 2 entries per one RepoObject +568this can happen, if the guid exists in the database extended properties and a new guid will be created in the repo569 570* `RepoObject_guid` roc1 has the right RepoObject_fullname571* `ro2_RepoObject_guid` roc2 got a guid from database, but roc2 can't propagate the fullname into RepoObject because the RepoObject_fullname is occupied572 573now we have 2 entries, but we need to merge them574 575merge is done in `[repo].[usp_sync_guid_RepoObject]`576 577`'usp_id;Number;Parent_Number: ',8,';',710,';',700`578// end::description[]579 580 581=== exampleUsage582 583// tag::exampleusage[]584 585// end::exampleusage[]586 587 588=== exampleUsage_2589 590// tag::exampleusage_2[]591 592// end::exampleusage_2[]593 594 595=== exampleUsage_3596 597// tag::exampleusage_3[]598 599// end::exampleusage_3[]600 601 602=== exampleUsage_4603 604// tag::exampleusage_4[]605 606// end::exampleusage_4[]607 608 609=== exampleUsage_5610 611// tag::exampleusage_5[]612 613// end::exampleusage_5[]614 615 616=== exampleWrong_Usage617 618// tag::examplewrong_usage[]619 620// end::examplewrong_usage[]621 622 623=== has_execution_plan_issue624 625// tag::has_execution_plan_issue[]626 627// end::has_execution_plan_issue[]628 629 630=== has_get_referenced_issue631 632// tag::has_get_referenced_issue[]633 634// end::has_get_referenced_issue[]635 636 637=== has_history638 639// tag::has_history[]640 641// end::has_history[]642 643 644=== has_history_columns645 646// tag::has_history_columns[]647 648// end::has_history_columns[]649 650 651=== InheritanceType652 653// tag::inheritancetype[]654 655// end::inheritancetype[]656 657 658=== is_persistence659 660// tag::is_persistence[]661 662// end::is_persistence[]663 664 665=== is_persistence_check_duplicate_per_pk666 667// tag::is_persistence_check_duplicate_per_pk[]668 669// end::is_persistence_check_duplicate_per_pk[]670 671 672=== is_persistence_check_for_empty_source673 674// tag::is_persistence_check_for_empty_source[]675 676// end::is_persistence_check_for_empty_source[]677 678 679=== is_persistence_delete_changed680 681// tag::is_persistence_delete_changed[]682 683// end::is_persistence_delete_changed[]684 685 686=== is_persistence_delete_missing687 688// tag::is_persistence_delete_missing[]689 690// end::is_persistence_delete_missing[]691 692 693=== is_persistence_insert694 695// tag::is_persistence_insert[]696 697// end::is_persistence_insert[]698 699 700=== is_persistence_truncate701 702// tag::is_persistence_truncate[]703 704// end::is_persistence_truncate[]705 706 707=== is_persistence_update_changed708 709// tag::is_persistence_update_changed[]710 711// end::is_persistence_update_changed[]712 713 714=== is_repo_managed715 716// tag::is_repo_managed[]7170718// end::is_repo_managed[]719 720 721=== is_ssas722 723// tag::is_ssas[]7240725// end::is_ssas[]726 727 728=== microsoft_database_tools_support729 730// tag::microsoft_database_tools_support[]731 732// end::microsoft_database_tools_support[]733 734 735=== MS_Description736 737// tag::ms_description[]738 739// end::ms_description[]740 741 742=== persistence_source_RepoObject_fullname743 744// tag::persistence_source_repoobject_fullname[]745 746// end::persistence_source_repoobject_fullname[]747 748 749=== persistence_source_RepoObject_fullname2750 751// tag::persistence_source_repoobject_fullname2[]752 753// end::persistence_source_repoobject_fullname2[]754 755 756=== persistence_source_RepoObject_guid757 758// tag::persistence_source_repoobject_guid[]759 760// end::persistence_source_repoobject_guid[]761 762 763=== persistence_source_RepoObject_xref764 765// tag::persistence_source_repoobject_xref[]766 767// end::persistence_source_repoobject_xref[]768 769 770=== pk_index_guid771 772// tag::pk_index_guid[]773 774// end::pk_index_guid[]775 776 777=== pk_IndexPatternColumnDatatype778 779// tag::pk_indexpatterncolumndatatype[]780 781// end::pk_indexpatterncolumndatatype[]782 783 784=== pk_IndexPatternColumnName785 786// tag::pk_indexpatterncolumnname[]787 788// end::pk_indexpatterncolumnname[]789 790 791=== pk_IndexSemanticGroup792 793// tag::pk_indexsemanticgroup[]794 795// end::pk_indexsemanticgroup[]796 797 798=== ReferencedObjectList799 800// tag::referencedobjectlist[]801* [repo].[RepoObject]802// end::referencedobjectlist[]803 804 805=== usp_persistence_RepoObject_guid806 807// tag::usp_persistence_repoobject_guid[]808 809// end::usp_persistence_repoobject_guid[]810 811 812=== UspExamples813 814// tag::uspexamples[]815 816// end::uspexamples[]817 818 819=== uspgenerator_usp_id820 821// tag::uspgenerator_usp_id[]822 823// end::uspgenerator_usp_id[]824 825 826=== UspParameters827 828// tag::uspparameters[]829 830// end::uspparameters[]831 832== Boolean Attributes833 834source: property.RepoObjectProperty WHERE property_int = 1835 836// tag::boolean_attributes[]837 838 839// end::boolean_attributes[]840 841== PlantUML diagrams842 843=== PlantUML Entity844 845// tag::puml_entity[]846[plantuml, entity-{docname}, svg, subs=macros]847....848'Left to right direction849top to bottom direction850hide circle851'avoide ""."" issues:852set namespaceSeparator none853 854 855skinparam class {856 BackgroundColor White857 BackgroundColor<<FN>> Yellow858 BackgroundColor<<FS>> Yellow859 BackgroundColor<<FT>> LightGray860 BackgroundColor<<IF>> Yellow861 BackgroundColor<<IS>> Yellow862 BackgroundColor<<P>> Aqua863 BackgroundColor<<PC>> Aqua864 BackgroundColor<<SN>> Yellow865 BackgroundColor<<SO>> SlateBlue866 BackgroundColor<<TF>> LightGray867 BackgroundColor<<TR>> Tomato868 BackgroundColor<<U>> White869 BackgroundColor<<V>> WhiteSmoke870 BackgroundColor<<X>> Aqua871 BackgroundColor<<external>> AliceBlue872}873 874 875entity ""puml-link:dhw:sqldb:repo.repoobject_requiredrepoobjectmerge.adoc[]"" as repo.RepoObject_RequiredRepoObjectMerge << V >> {876 - RepoObject_fullname : (nvarchar(261))877 - RepoObject_guid : (uniqueidentifier)878 - RepoObject_name : (nvarchar(128))879 - RepoObject_schema_name : (nvarchar(128))880 - ro2_RepoObject_fullname : (nvarchar(261))881 - ro2_RepoObject_guid : (uniqueidentifier)882 - ro2_RepoObject_name : (nvarchar(128))883 - ro2_RepoObject_schema_name : (nvarchar(128))884 - ro2_SysObject_fullname : (nvarchar(261))885 - ro2_SysObject_name : (nvarchar(128))886 - SysObject_fullname : (nvarchar(261))887 - SysObject_name : (nvarchar(128))888 - SysObject_schema_name : (nvarchar(128))889 --890}891....892 893// end::puml_entity[]894 895=== PlantUML Entity 1 1 FK896 897// tag::puml_entity_1_1_fk[]898[plantuml, entity_1_1_fk-{docname}, svg, subs=macros]899....900@startuml901left to right direction902'top to bottom direction903hide circle904'avoide ""."" issues:905set namespaceSeparator none906 907 908skinparam class {909 BackgroundColor White910 BackgroundColor<<FN>> Yellow911 BackgroundColor<<FS>> Yellow912 BackgroundColor<<FT>> LightGray913 BackgroundColor<<IF>> Yellow914 BackgroundColor<<IS>> Yellow915 BackgroundColor<<P>> Aqua916 BackgroundColor<<PC>> Aqua917 BackgroundColor<<SN>> Yellow918 BackgroundColor<<SO>> SlateBlue919 BackgroundColor<<TF>> LightGray920 BackgroundColor<<TR>> Tomato921 BackgroundColor<<U>> White922 BackgroundColor<<V>> WhiteSmoke923 BackgroundColor<<X>> Aqua924 BackgroundColor<<external>> AliceBlue925}926 927 928entity ""puml-link:dhw:sqldb:repo.repoobject_requiredrepoobjectmerge.adoc[]"" as repo.RepoObject_RequiredRepoObjectMerge << V >> {929- idx_RepoObject_RequiredRepoObjectMerge__1930 931..932RepoObject_guid; uniqueidentifier933--934- idx_RepoObject_RequiredRepoObjectMerge__2935 936..937ro2_RepoObject_guid; uniqueidentifier938--939- idx_RepoObject_RequiredRepoObjectMerge__3940 941..942SysObject_schema_name; nvarchar(128)943SysObject_name; nvarchar(128)944--945- idx_RepoObject_RequiredRepoObjectMerge__4946 947..948ro2_SysObject_name; nvarchar(128)949--950- idx_RepoObject_RequiredRepoObjectMerge__5951 952..953RepoObject_schema_name; nvarchar(128)954RepoObject_name; nvarchar(128)955--956- idx_RepoObject_RequiredRepoObjectMerge__6957 958..959ro2_RepoObject_schema_name; nvarchar(128)960ro2_RepoObject_name; nvarchar(128)961}962 963 964 965footer The diagram is interactive and contains links.966 967@enduml968....969 970// end::puml_entity_1_1_fk[]971 972=== PlantUML 1 1 ObjectRef973 974// tag::puml_entity_1_1_objectref[]975[plantuml, entity_1_1_objectref-{docname}, svg, subs=macros]976....977@startuml978left to right direction979'top to bottom direction980hide circle981'avoide ""."" issues:982set namespaceSeparator none983 984 985skinparam class {986 BackgroundColor White987 BackgroundColor<<FN>> Yellow988 BackgroundColor<<FS>> Yellow989 BackgroundColor<<FT>> LightGray990 BackgroundColor<<IF>> Yellow991 BackgroundColor<<IS>> Yellow992 BackgroundColor<<P>> Aqua993 BackgroundColor<<PC>> Aqua994 BackgroundColor<<SN>> Yellow995 BackgroundColor<<SO>> SlateBlue996 BackgroundColor<<TF>> LightGray997 BackgroundColor<<TR>> Tomato998 BackgroundColor<<U>> White999 BackgroundColor<<V>> WhiteSmoke1000 BackgroundColor<<X>> Aqua1001 BackgroundColor<<external>> AliceBlue1002}1003 1004 1005entity ""puml-link:dhw:sqldb:repo.repoobject.adoc[]"" as repo.RepoObject << U >> {1006 - **RepoObject_guid** : (uniqueidentifier)1007 --1008}1009 1010entity ""puml-link:dhw:sqldb:repo.repoobject_requiredrepoobjectmerge.adoc[]"" as repo.RepoObject_RequiredRepoObjectMerge << V >> {1011 --1012}1013 1014entity ""puml-link:dhw:sqldb:repo.usp_sync_guid_repoobject.adoc[]"" as repo.usp_sync_guid_RepoObject << P >> {1015 --1016}1017 1018repo.RepoObject <.. repo.RepoObject_RequiredRepoObjectMerge1019repo.RepoObject_RequiredRepoObjectMerge <.. repo.usp_sync_guid_RepoObject1020 1021footer The diagram is interactive and contains links.1022 1023@enduml1024....1025 1026// end::puml_entity_1_1_objectref[]1027 1028=== PlantUML 30 0 ObjectRef1029 1030// tag::puml_entity_30_0_objectref[]1031[plantuml, entity_30_0_objectref-{docname}, svg, subs=macros]1032....1033@startuml1034'Left to right direction1035top to bottom direction1036hide circle1037'avoide ""."" issues:1038set namespaceSeparator none1039 1040 1041skinparam class {1042 BackgroundColor White1043 BackgroundColor<<FN>> Yellow1044 BackgroundColor<<FS>> Yellow1045 BackgroundColor<<FT>> LightGray1046 BackgroundColor<<IF>> Yellow1047 BackgroundColor<<IS>> Yellow1048 BackgroundColor<<P>> Aqua1049 BackgroundColor<<PC>> Aqua1050 BackgroundColor<<SN>> Yellow1051 BackgroundColor<<SO>> SlateBlue1052 BackgroundColor<<TF>> LightGray1053 BackgroundColor<<TR>> Tomato1054 BackgroundColor<<U>> White1055 BackgroundColor<<V>> WhiteSmoke1056 BackgroundColor<<X>> Aqua1057 BackgroundColor<<external>> AliceBlue1058}1059 1060 1061entity ""puml-link:dhw:sqldb:config.ftv_get_parameter_value.adoc[]"" as config.ftv_get_parameter_value << IF >> {1062 --1063}1064 1065entity ""puml-link:dhw:sqldb:config.parameter.adoc[]"" as config.Parameter << U >> {1066 - **Parameter_name** : (varchar(100))1067 - **sub_Parameter** : (nvarchar(128))1068 --1069}1070 1071entity ""puml-link:dhw:sqldb:configt.parameter_default.adoc[]"" as configT.Parameter_default << V >> {1072 - **Parameter_name** : (varchar(52))1073 - **sub_Parameter** : (nvarchar(26))1074 --1075}1076 1077entity ""puml-link:dhw:sqldb:property.external_repoobjectproperty.adoc[]"" as property.external_RepoObjectProperty << U >> {1078 - **RepoObject_guid** : (uniqueidentifier)1079 - **property_name** : (nvarchar(128))1080 --1081}1082 1083entity ""puml-link:dhw:sqldb:property.propertyname_repoobject.adoc[]"" as property.PropertyName_RepoObject << V >> {1084 **property_name** : (nvarchar(128))1085 --1086}1087 1088entity ""puml-link:dhw:sqldb:property.propertyname_repoobject_t.adoc[]"" as property.PropertyName_RepoObject_T << U >> {1089 **property_name** : (nvarchar(128))1090 --1091}1092 1093entity ""puml-link:dhw:sqldb:property.repoobjectproperty.adoc[]"" as property.RepoObjectProperty << U >> {1094 - **RepoObjectProperty_id** : (int)1095 --1096}1097 1098entity ""puml-link:dhw:sqldb:property.repoobjectproperty_external_src.adoc[]"" as property.RepoObjectProperty_external_src << V >> {1099 - **RepoObject_guid** : (uniqueidentifier)1100 - **property_name** : (nvarchar(128))1101 --1102}1103 1104entity ""puml-link:dhw:sqldb:property.repoobjectproperty_external_tgt.adoc[]"" as property.RepoObjectProperty_external_tgt << V >> {1105 - **RepoObject_guid** : (uniqueidentifier)1106 - **property_name** : (nvarchar(128))1107 --1108}1109 1110entity ""puml-link:dhw:sqldb:property.repoobjectproperty_selectedpropertyname_split.adoc[]"" as property.RepoObjectProperty_SelectedPropertyName_split << V >> {1111 --1112}1113 1114entity ""puml-link:dhw:sqldb:reference.additional_reference.adoc[]"" as reference.additional_Reference << U >> {1115 - **Id** : (int)1116 --1117}1118 1119entity ""puml-link:dhw:sqldb:reference.additional_reference_from_properties_src.adoc[]"" as reference.additional_Reference_from_properties_src << V >> {1120 **referenced_AntoraComponent** : (nvarchar(max))1121 **referenced_AntoraModule** : (nvarchar(max))1122 **referenced_Schema** : (nvarchar(max))1123 **referenced_Object** : (nvarchar(max))1124 **referenced_Column** : (nvarchar(max))1125 **referencing_AntoraComponent** : (nvarchar(max))1126 **referencing_AntoraModule** : (nvarchar(max))1127 **referencing_Schema** : (nvarchar(max))1128 **referencing_Object** : (nvarchar(max))1129 **referencing_Column** : (nvarchar(max))1130 --1131}1132 1133entity ""puml-link:dhw:sqldb:reference.additional_reference_from_properties_tgt.adoc[]"" as reference.additional_Reference_from_properties_tgt << V >> {1134 **referenced_AntoraComponent** : (nvarchar(max))1135 **referenced_AntoraModule** : (nvarchar(max))1136 **referenced_Schema** : (nvarchar(max))1137 **referenced_Object** : (nvarchar(max))1138 **referenced_Column** : (nvarchar(max))1139 **referencing_AntoraComponent** : (nvarchar(max))1140 **referencing_AntoraModule** : (nvarchar(max))1141 **referencing_Schema** : (nvarchar(max))1142 **referencing_Object** : (nvarchar(max))1143 **referencing_Column** : (nvarchar(max))1144 --1145}1146 1147entity ""puml-link:dhw:sqldb:reference.additional_reference_from_ssas_src.adoc[]"" as reference.additional_Reference_from_ssas_src << V >> {1148 **referenced_AntoraComponent** : (nvarchar(128))1149 **referenced_AntoraModule** : (nvarchar(128))1150 **referenced_Schema** : (nvarchar(max))1151 **referenced_Object** : (nvarchar(max))1152 **referenced_Column** : (nvarchar(500))1153 **referencing_AntoraComponent** : (nvarchar(max))1154 **referencing_AntoraModule** : (nvarchar(max))1155 - **referencing_Schema** : (nvarchar(128))1156 - **referencing_Object** : (nvarchar(128))1157 **referencing_Column** : (nvarchar(128))1158 --1159}1160 1161entity ""puml-link:dhw:sqldb:reference.additional_reference_from_ssas_tgt.adoc[]"" as reference.additional_Reference_from_ssas_tgt << V >> {1162 **referenced_AntoraComponent** : (nvarchar(128))1163 **referenced_AntoraModule** : (nvarchar(128))1164 **referenced_Schema** : (nvarchar(max))1165 **referenced_Object** : (nvarchar(max))1166 **referenced_Column** : (nvarchar(500))1167 **referencing_AntoraComponent** : (nvarchar(max))1168 **referencing_AntoraModule** : (nvarchar(max))1169 - **referencing_Schema** : (nvarchar(128))1170 - **referencing_Object** : (nvarchar(128))1171 **referencing_Column** : (nvarchar(128))1172 --1173}1174 1175entity ""puml-link:dhw:sqldb:reference.additional_reference_is_external.adoc[]"" as reference.additional_Reference_is_external << V >> {1176 --1177}1178 1179entity ""puml-link:dhw:sqldb:reference.additional_reference_object.adoc[]"" as reference.additional_Reference_Object << V >> {1180 - **AntoraComponent** : (nvarchar(128))1181 - **AntoraModule** : (nvarchar(128))1182 - **SchemaName** : (nvarchar(128))1183 - **ObjectName** : (nvarchar(128))1184 --1185}1186 1187entity ""puml-link:dhw:sqldb:reference.additional_reference_object_t.adoc[]"" as reference.additional_Reference_Object_T << U >> {1188 - **RepoObject_guid** : (uniqueidentifier)1189 --1190}1191 1192entity ""puml-link:dhw:sqldb:reference.additional_reference_wo_columns_from_properties_src.adoc[]"" as reference.additional_Reference_wo_columns_from_properties_src << V >> {1193 **referenced_AntoraComponent** : (nvarchar(max))1194 **referenced_AntoraModule** : (nvarchar(max))1195 **referenced_Schema** : (nvarchar(max))1196 **referenced_Object** : (nvarchar(max))1197 **referencing_AntoraComponent** : (nvarchar(max))1198 **referencing_AntoraModule** : (nvarchar(max))1199 **referencing_Schema** : (nvarchar(max))1200 **referencing_Object** : (nvarchar(max))