Footprints Data Model

Table
Table Name Workspace Container
Table Definition A workspace is the principle architectural structure in Numara FootPrints for storing and tracking information. A Workspace is a separate sub-database or work area within the system with its own fields, forms, options, workflow, settings and users. Most of the behaviour of the Workspace comes from the Container Abstract class, and only things that are specific to the Workspace are implemented here. For Example, Current FootPrints allows a single CMDB to be referenced from a Workspace, and a single Address book, yet these are listed as features for improvement. So convenience methods that get and set Container Group Relationship might be appropriate.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Container Id A Foreign Key to the Container table. LONG Yes
Time Zone Region Name The name of the Time Zone Region. This is 2. The 'primary key' of the java timezone is the string region identifier in English, example 'America/Phoenix'. There is no numeric identifier. As the JRE is updated, or specific classes are updated, the list could change to include new entries, and the detail data behind the regions could change. VARCHAR(255) No
Container Type Id A Foreign Key to the Container Type table. INTEGER No