Description

The report is useful for 3rd party developers to familiarize themselves with the structure of the Adonis database. It can afford to properly design the reports, data import, integration with 3rd party sources, etc, by presenting the main data properties & dependencies.

Dialog

Open

Select By - allows selecting the entity that will contribute to checklist box selections.

Names - you may refer to the physical name of an entity in the database or to its sensitive explanation.

Physical Name - listing the system names of the selected entity as in the database.

Logical Name - listing the names describing the actual content of the entity.

NOTE: logical and physical names' selections are independent.

Sample

Open

Fields/ Columns Specification

Column - physical field name as in the database.

Logical Name - sensitive naming for the content of the field.

Description - sensitive description of the field’s purpose.

Datatype / Length / Precision / Scale / Mandatory / Primary - listing the standard field property as contained in the database.

FK / FK Name / FK Table / FK Logical Table / FK Column - listing properties of relation to another table.

Attachment