ActivityAssignmentTypes


Description

Activity assignment type definitions defining different types of activity assignments and their data storage configurations. This table manages the various types of assignments that can be linked to activities, including their database table mappings and SQL query configurations for dynamic data retrieval.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkAssignmentTypeID int identity 4 √ null
ActivityAssignmentTypeControls.fkActivityAssignmentType FK_ActivityAssignmentTypeControls_ActivityAssignmentTypes R
ActivityCategory.fkAATID FK_ActivityCategory_ActivityAssignmentTypes R

Primary key - Unique identifier for each assignment type
AssignmentTable varchar 100 null

Assignment table name - Database table name where assignment data is stored
StorageTable varchar 100 null

Storage table name - Database table name for storing assignment-specific data
SQLselect varchar 3000 √ null

SQL query - Custom SQL query for retrieving assignment data

Indexes

Constraint Name Type Sort Column(s)
PK__ActivityAssignme__2D6ADC87 Primary key Asc pkAssignmentTypeID

Relationships

Close relationships within degrees of separation