On a page in Lucid I have physical data models which extend from the external ERD CSV data. On one page I want all data shown. On Another view of the data on a page I want to limit the number of property fields show so that the diagram is tighter. I would like to do this by default on the specific table or on the page so anything on the page only shows primary keys and foreign keys.
Irrespective of available tables in the CSV any field marked as an FK should be marked as an FK on the diagram. TableD > TableEId not having and FK is an error.
postgresql;"TEST";"public";"TableA";"TableAId";"1";"UniqueId";;"PRIMARY KEY";"public";"";""
postgresql;"TEST";"public";"TableA";"ObjectId";"2";"Lookup";;"FOREIGN KEY";"public";"TableB";"TableBId"
postgresql;"TEST";"public";"TableA";"ObjectId";"2";"Lookup";;"FOREIGN KEY";"public";"TableC";"TableCId"
postgresql;"TEST";"public";"TableA";"Feild1";"3";"Choice";;"""";;;
postgresql;"TEST";"public";"TableB";"TableBId";"1";"UniqueId";;"PRIMARY KEY";"public";"";""
postgresql;"TEST";"public";"TableC";"TableCId";"1";"UniqueId";;"PRIMARY KEY";"public";"";""
postgresql;"TEST";"public";"TableD";"TableDId";"1";"UniqueId";;"PRIMARY KEY";"public";"";""
postgresql;"TEST";"public";"TableD";"TableEId";"2";"Lookup";;"FOREIGN KEY";"public";"TableE";"TableEId"
postgresql;"TEST";"public";"TableD";"TableFId";"2";"Lookup";;"FOREIGN KEY";"public";"TableF";"TableFId"
postgresql;"TEST";"public";"TableD";"Feild1";"3";"Text";;"""";;;
postgresql;"TEST";"public";"TableD";"Feild2";"3";"Text";;"""";;;
postgresql;"TEST";"public";"TableD";"Feild3";"3";"Text";;"""";;;
postgresql;"TEST";"public";"TableD";"Feild4";"3";"Text";;"""";;;
postgresql;"TEST";"public";"TableD";"Feild5";"3";"Text";;"""";;;
postgresql;"TEST";"public";"TableF";"TableFId";"1";"UniqueId";;"PRIMARY KEY";"public";"";""