catissue_user_aud

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 null
REV BIGINT 19 null
os_revisions.REV FK_m9slxw75ecrvrk31nwwamd7ngR
REVTYPE TINYINT 3 √ null
EMAIL_ADDRESS VARCHAR 255 √ null
emailAddress_MOD BIT 1 √ null
FIRST_NAME VARCHAR 255 √ null
firstName_MOD BIT 1 √ null
LAST_NAME VARCHAR 255 √ null
lastName_MOD BIT 1 √ null
LOGIN_NAME VARCHAR 255 √ null
loginName_MOD BIT 1 √ null
START_DATE DATETIME 19 √ null
creationDate_MOD BIT 1 √ null
ACTIVITY_STATUS VARCHAR 255 √ null
activityStatus_MOD BIT 1 √ null
STATUS_COMMENT VARCHAR 255 √ null
comments_MOD BIT 1 √ null
IS_ADMIN BIT 1 √ null
admin_MOD BIT 1 √ null
DEPARTMENT_ID BIGINT 19 √ null
department_MOD BIT 1 √ null
ADDRESS TEXT 65535 √ null
address_MOD BIT 1 √ null
PHONE_NUMBER VARCHAR 63 √ null
phonenumber_MOD BIT 1 √ null
MANAGE_FORMS BIT 1 √ null
manageForms_MOD BIT 1 √ null
INSTITUTE_ID BIGINT 19 √ null
INSTITUTE_MOD BIT 1 √ null
TYPE VARCHAR 16 √ null
type_MOD BIT 1 √ null
PRIMARY_SITE_ID BIGINT 19 √ null
primarySite_MOD BIT 1 √ null
TIME_ZONE VARCHAR 32 √ null
timeZone_MOD BIT 1 √ null
DND BIT 1 √ null
dnd_MOD BIT 1 √ null
API_USER BIT 1 √ null
apiUser_MOD BIT 1 √ null
IP_RANGE VARCHAR 255 √ null
ipRange_MOD BIT 1 √ null
FORCE_PASSWORD_RESET BIT 1 √ null
forcePasswordReset_MOD BIT 1 √ null
MANAGE_WFS BIT 1 √ null
manageWfs_MOD BIT 1 √ null
DOWNLOAD_LABELS_PRINT_FILE BIT 1 √ null
downloadLabelsPrintFile_MOD BIT 1 √ null
DEFAULT_PRINTER_ID BIGINT 19 √ null
defaultPrinter_MOD BIT 1 √ null
MANAGE_PRINT_JOBS BIT 1 √ null
managePrintJobs_MOD BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc IDENTIFIER + REV
FK_m9slxw75ecrvrk31nwwamd7ng Performance Asc REV

Relationships

Close relationships within degrees of separation