Footprints Data Model

Table
Table Name Item
Table Definition The Item is the abstract class for Issue, Configuration Item, Address Book entry, and other information items that are the main information entities in FootPrints. The Item structure and behavior is defined by its Definition. The Item is namespaced, identified by, and logically stored in the single parent container. It can be referenced in the same manner both inside and outside the container. The Item is the storage model and the implementation for the Item Definition. There are many important specializations of the Item class, and there even more Template definitions of Container/Item that provide an end-user application experience to the End-User. The Item implementation must implement flexible schema in an easy to manage, well engineered, and high performing way. The item can store user-defined and user-named fields defined in its definition. The Item could implement the nice-to-have features such as an inheritance model for Item subtypes, and have the ability to represent collections of subordinate items. The Item data can be imported, exported, or synchronized with external data sources. The Item data can be linked and synchronized with other items in the same Instance.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Item Id The automatically generated primary key of the item table. LONG Yes
Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. LONG Yes
Item Key A search key for the Item, composed of letters and numbers. VARCHAR(255) No
Container Id A Foreign Key to the Container table. LONG No