Auth Approved Request Snapshots Table Schema (auth_approved_request_snapshots)


Description

History of auth_approved_request records

auth_approved_request_snapshots table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
requestid BIGINT 19 null
auth_approved_request.id authapprrequsnap_req2_fk R
timesnapshot BIGINT 19 null
usersnapshot BIGINT 19 null
user.id authapprrequsnap_use2_fk R
status TINYINT 3 √ null
username VARCHAR 100 √ null
firstname VARCHAR 100 √ null
lastname VARCHAR 100 √ null
lastnamephonetic VARCHAR 255 √ null
firstnamephonetic VARCHAR 255 √ null
middlename VARCHAR 255 √ null
alternatename VARCHAR 255 √ null
email VARCHAR 100 √ null
password VARCHAR 255 √ null
city VARCHAR 120 √ null
country VARCHAR 2 √ null
lang VARCHAR 30 √ null
confirmed BIT 1 √ null
confirmtoken VARCHAR 100 √ null
positionid BIGINT 19 √ null
pos.id Implied Constraint R
positionfreetext LONGTEXT 2147483647 √ null
organisationid BIGINT 19 √ null
org.id Implied Constraint R
organisationfreetext LONGTEXT 2147483647 √ null
managerjaid BIGINT 19 √ null
managerfreetext LONGTEXT 2147483647 √ null
profilefields LONGTEXT 2147483647 √ null
userid BIGINT 19 √ null
user.id Implied Constraint R
resolvedby BIGINT 19 √ null
timecreated BIGINT 19 √ null
timemodified BIGINT 19 √ null
timeresolved BIGINT 19 √ null

Table contained -1 rows

auth_approved_request_snapshots table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
authapprrequsnap_req_ix Performance Asc requestid
authapprrequsnap_use_ix Performance Asc usersnapshot

auth_approved_request_snapshots table relationships

Close relationships within degrees of separation