work_log

13179 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('work_log_id_seq'::regclass)
user_session.work_log_id fk_user_session_work_log C
prop_id int4 10 √ null
property.id fk_work_log_prop_id C
user_id int4 10 √ null
users.id fk_work_log_user_id N
user_name citext 2147483647 √ null
device_name text 2147483647 null

Text with maximum 50 characters
login_time timestamptz 35,6 √ now()
logout_time timestamptz 35,6 √ null
last_seen timestamptz 35,6 √ null
shift bpchar 1 √ null
reactivate bool 1 √ false
login_token citext 2147483647 √ null
login_date date 13 √ null
create_time timestamptz 35,6 √ CURRENT_TIMESTAMP
jti uuid 2147483647 √ null
app_code text 2147483647 'pms'::text

Indexes

Constraint Name Type Sort Column(s)
work_log_pkey Primary key Asc id
idx_work_log_active_app Performance Asc/Asc/Asc prop_id + login_date + app_code
idx_work_log_app_code Performance Asc app_code
idx_work_log_jti Performance Asc jti
idx_work_log_login_date Performance Asc login_date
idx_work_log_prop_id Performance Asc prop_id
idx_work_log_prop_user_app Performance Asc/Asc/Asc prop_id + user_id + app_code
idx_work_log_user_id Performance Asc user_id

Check Constraints

Constraint Name Constraint
chk_work_log_app_code_lower (app_code = lower(app_code))

Relationships

Close relationships within degrees of separation