Discussions
Entity Relationship Diagram (ERD)
over 1 year 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.