raportointi_session


Columns

Column Type Size Nulls Auto Default Children Parents Comments
primary_id bpchar 36 null
raportointi_session_attributes.session_primary_id raportointi_session_attributes_fk C
session_id bpchar 36 null
raportointi_cas_client_session.raportointi_session_id raportointi_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)
raportointi_session_pk Primary key Asc primary_id
raportointi_session_ix1 Must be unique Asc session_id
raportointi_session_ix2 Performance Asc expiry_time
raportointi_session_ix3 Performance Asc principal_name

Relationships

Close relationships within degrees of separation