ad_session

1395 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_session_id numeric 10 null
ad_changelog_v.ad_session_id Implied Constraint R
ad_pinstance.ad_session_id adsession_adpinstance R
ad_sessioninfo_v.ad_session_id Implied Constraint R
k_comment.ad_session_id adsession_kcomment R
k_entry.ad_session_id adsession_kentry R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
websession varchar 40 √ null
remote_addr varchar 60 √ null
remote_host varchar 120 √ null
processed bpchar 1 'N'::bpchar
description varchar 2000 √ null
ad_role_id numeric 10 √ null
ad_role.ad_role_id adrole_adsession R
logindate timestamp 29,6 √ null
ad_session_uu varchar 36 √ NULL::character varying
servername varchar 80 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
ad_session_pkey Primary key Asc ad_session_id
ad_session_uu_idx Must be unique Asc ad_session_uu
ad_session_websession_servername_processed Performance Asc/Asc/Asc websession + servername + processed

Relationships

Close relationships within degrees of separation