Table relationships

NEON does not make frequent use of generated integer columns for primary keys. Most primary keys are 15 character VARCHAR columns.

NEON makes frequent use of composite keys. For example an order line belongs to an order, which in turn belongs to an Order Set, so the primary key for the order line will consist of three columns.

All foreign keys, where practical, have well defined foreign key constraints to help ensure consistency. It's therefore not possible to for example delete an order without first deleting it's order lines.