Skip to main content
Idea

ERD page Config to simplify full model for Logical diagrams

Related products:Lucidchart
  • 10 September 2024
  • 1 reply
  • 9 views

Forum|alt.badge.img+2

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";"";""

 

Comments

Kelsey Gaag
Forum|alt.badge.img+14
  • Lucid community team
  • 764 replies
  • September 10, 2024

Hi, thanks for this idea! We encourage anyone else who’s interested in this to upvote this post and share any additional details about your use case or what you’d like to see in this experience. For more information about how we manage feedback in this community, please take a look at this post:

 


Reply