Skip to main content

I've created an ERD on LucidChart and exported it for PostgresSQL and tried to use this input to re create in LucidChart the same document with the ERD import but get an error. What is wrong with my input?


In fact I'm trying to find out which input I should give to the ERD Import format (but don't get any database to play with).


 


CREATE TABLE `Salesforce.Account (Account)` (
  `Account ID (Id)` id(18)
  `Master Record ID (MasterRecordId)` reference(18)
  `Record Type ID (RecordTypeId)` reference(18)
  `Parent Account ID (ParentId)` reference(18)
  `Owner ID (OwnerId)` reference(18)
  `Created By ID (CreatedById)` reference(18)
  `Last Modified By ID (LastModifiedById)` reference(18)
  `D&B Company ID (DandbCompanyId)` reference(18)
  `Operating Hour ID (OperatingHoursId)` reference(18)
  `Maps Assignment Rule (maps__AssignmentRule__c)` reference(18)
  PRIMARY KEY (`Account ID (Id)`)
  FOREIGN KEY (`Master Record ID (MasterRecordId)`) REFERENCES `Salesforce.Account (Account)`(`Account ID (Id)`)
  FOREIGN KEY (`Parent Account ID (ParentId)`) REFERENCES `Salesforce.Account (Account)`(`Account ID (Id)`)
  FOREIGN KEY (`Master Record ID (MasterRecordId)`) REFERENCES `Salesforce.Account (Account)`(`Account ID (Id)`)
  FOREIGN KEY (`Parent Account ID (ParentId)`) REFERENCES `Salesforce.Account (Account)`(`Account ID (Id)`)
);


CREATE TABLE `Salesforce.Contact (Contact)` (
  `Contact ID (Id)` id(18)
  `Master Record ID (MasterRecordId)` reference(18)
  `Account ID (AccountId)` reference(18)
  `Reports To ID (ReportsToId)` reference(18)
  `Owner ID (OwnerId)` reference(18)
  `Created By ID (CreatedById)` reference(18)
  `Last Modified By ID (LastModifiedById)` reference(18)
  `Individual ID (IndividualId)` reference(18)
  PRIMARY KEY (`Contact ID (Id)`)
  FOREIGN KEY (`Master Record ID (MasterRecordId)`) REFERENCES `Salesforce.Contact (Contact)`(`Contact ID (Id)`)
  FOREIGN KEY (`Reports To ID (ReportsToId)`) REFERENCES `Salesforce.Contact (Contact)`(`Contact ID (Id)`)
  FOREIGN KEY (`Master Record ID (MasterRecordId)`) REFERENCES `Salesforce.Contact (Contact)`(`Contact ID (Id)`)
  FOREIGN KEY (`Account ID (AccountId)`) REFERENCES `Salesforce.Account (Account)`(`Account ID (Id)`)
  FOREIGN KEY (`Reports To ID (ReportsToId)`) REFERENCES `Salesforce.Contact (Contact)`(`Contact ID (Id)`)
);


 

Hey Jean


Thank you for posting in the Lucid Community! So I've attached a photo of an example CSV output file from a PostGreSQL import for reference that is the format our importer will need your file to be in.



If this is the format your file is in and it still will not import please reach out to our amazing Support Team directly at support@lucidchart.com and we would be happy to take a closer look. Cheers! 🍻


Reply