Footprints Data Model

Table
Table Name Field Definition
Table Definition The definition of a Field, including persistence information and default UI information. Some fields will be defined as database fields, and other fields will be defined as calculated fields. The field will have data types and associations to business rule definitions. Some fields are built-in, some are defaults from templates, and some are custom fields. See the database view v_cntnr_item_field.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Field Definition Id A Foreign Key to the Definition table. LONG Yes
Field Datatype Id A Foreign Key to the Field Datatype table. LONG Yes
Field Column Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. VARCHAR(30) Yes
Field Description Field Description. VARCHAR(255) No