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)`)
);