Footprints Data Model

Table
Table Name Assignment
Table Definition The current state and historical record of responsibility for a ticket. Regular assignments involve all parties that share responsibility for the ticket and are interested potentially in notifications. Primary Assignments additionally indicate that one and only one userid is responsible for the ticket for a span of time. A userid will have a span of Primary Assignment that is within the boundaries of his regular non-Primary Assignment. It is expected that an individual would have a single large span of time, possibly the life of the ticket, as a regular assignment. The individual may have zero, one, or more periods of PrimaryAssignment, stored as additional records.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Assignment Id The automatically generated primary key of the asgnmt table. LONG Yes
Item Definition Id A Foreign Key to the Definition table. LONG No
Item Id A Foreign Key to the Item table. LONG No
Field Id A Foreign Key to the Definition table. LONG No
Application User Id A Foreign Key to the Application User table. LONG No
Team Id A Foreign Key to the Team table. LONG No
CC Email Address Cannot be used with TeamId,App_user_id, can only be used with CC Assignment VARCHAR(255) No
Assignment Type Id A Foreign Key to the Assignment Type table. INTEGER No
Begin Date The value of a Assignment, stored as a date. DATE No
End Date The value of a Assignment, stored as a date. DATE No
Is Team Special clarifying field of "Is Team Level Assignment" to state that the Team does not have to be immediately resolved to a Team+Individual. BOOLEAN Yes
Delete Transaction Id A unique incremental transaction identifier that indicates a soft delete. The id is generated via id generation, and may or may not correspond to the audit trail transaction id. This method of marking the soft delete allows for a unique index to be created on the Workspace Definition Id, Team Name, and Delete Transaction Id to enforce no duplicates in the live copies, and it allows multiple soft deleted rows with the same team name. LONG No
Sort Order The value of a Assignment stored as boolean. INTEGER No