lahetys_session


Columns

Column Type Size Nulls Auto Default Children Parents Comments
primary_id bpchar 36 null
lahetys_session_attributes.session_primary_id lahetys_session_attributes_fk C
session_id bpchar 36 null
lahetys_cas_client_session.lahetys_session_id lahetys_cas_client_session_fk C
creation_time int8 19 null
last_access_time int8 19 null
max_inactive_interval int4 10 null
expiry_time int8 19 null
principal_name varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
lahetys_session_pk Primary key Asc primary_id
lahetys_session_ix1 Must be unique Asc session_id
lahetys_session_ix2 Performance Asc expiry_time
lahetys_session_ix3 Performance Asc principal_name

Relationships

Close relationships within degrees of separation