app_auth_approved_request

0 rows


Description

Self registration with approval details

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_auth_approved_request_id_seq'::regclass)
app_auth_approved_request_snapshots.requestid Defined in XML R
status int2 5 null
username varchar 100 ''::character varying
firstname varchar 100 ''::character varying
lastname varchar 100 ''::character varying
lastnamephonetic varchar 255 √ null
firstnamephonetic varchar 255 √ null
middlename varchar 255 √ null
alternatename varchar 255 √ null
email varchar 100 ''::character varying
password varchar 255 ''::character varying
city varchar 120 ''::character varying
country varchar 2 ''::character varying
lang varchar 30 ''::character varying
confirmed int2 5 null
confirmtoken varchar 100 ''::character varying
positionid int8 19 √ null
app_pos.id Defined in XML R
positionfreetext text 2147483647 √ null
organisationid int8 19 √ null
app_org.id Defined in XML R
organisationfreetext text 2147483647 √ null
managerjaid int8 19 √ null
app_job_assignment.id Defined in XML R
managerfreetext text 2147483647 √ null
profilefields text 2147483647 null
userid int8 19 √ null
app_user.id Defined in XML R
resolvedby int8 19 √ null
app_user.id Defined in XML R
timecreated int8 19 null
timemodified int8 19 √ null
timeresolved int8 19 √ null
extradata text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
app_authapprrequ_id_pk Primary key Asc id
app_authapprrequ_con_uix Must be unique Asc confirmtoken
app_authapprrequ_man_ix Performance Asc managerjaid
app_authapprrequ_org_ix Performance Asc organisationid
app_authapprrequ_pos_ix Performance Asc positionid
app_authapprrequ_res_ix Performance Asc resolvedby
app_authapprrequ_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation