0 rows


Self registration with approval details


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 XMLR
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 Defined in XMLR
positionfreetext text 2147483647 null
organisationid int8 19 null Defined in XMLR
organisationfreetext text 2147483647 null
managerjaid int8 19 null Defined in XMLR
managerfreetext text 2147483647 null
profilefields text 2147483647 null
userid int8 19 null Defined in XMLR
resolvedby int8 19 null Defined in XMLR
timecreated int8 19 null
timemodified int8 19 null
timeresolved int8 19 null
extradata text 2147483647 null


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