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 |