Discussions
Entity Relationship Diagram (ERD)
26 days ago by Matthew Rodriguez
Hi. Is there an ERD available for the Corrigo API?
Typically, it would include more details such as table relationships (one-to-one, one-to-many, etc.), primary/foreign keys for referential integrity, data types and more laid out in a visual diagram.
The "Data Model of Entities" page in the API Developer site either doesn't provide all of those details or not consistently. For example, the [WorkOrder] table has a [Priority] field with a note to reference the [WoPriority] table. However, it doesn’t specify which field has the relationship and whether it’s a one-to-one/many.
Another example is the String data type. It is listed for some fields but doesn’t disclose whether there’s a character limit or it’s a max string type.