"Ragged Hierarchy" or "Snowflake" Data Structure in Coda

[Agile_Dynamics]

sorry, its a naming convention we have used at Agile Dynamics for data modeling.

we use suffixes to help us see the data types in a model.

semicolon means an N:1 link.

an 1:N link uses the colon.

so MyCountry; links to a single country row.

but MyOrders: links to a number of Order rows.

it has no meaning in coda.

see the full topic here

Naming Conventions For Rapid Data Model Development

for may years we (Agile Dynamics) have been using the SSADM systems analysis & design methodology to design complex databases and workflows. down the years we have used the following notation or ‘naming convention’ to quickly define the data-types and table references in our data models. now that i am building data models in Coda, i still find the naming conventions make the task much faster. and, collaboration among several makers is greatly facilitated by this notation. the steps involved a…