Table audit.logins
# Column Name Nullable Data Type Max Length Description
1login_idbigint0The primary key of this table, which is also a serial field.
2user_idinteger0Foreign key to the table office.users.
3office_idinteger0Foreign key to the table office.offices.
4browsercharacter varying500The name of the broser used to run the application.
5ip_addresscharacter varying50The IP address of the of the computer network used.
6login_date_timetimestamp with time zone0
7remote_usercharacter varying50
8culturecharacter varying12

Foreign Keys

# Column Name Key Name References
2 user_id logins_user_id_fkey office.users.user_id
3 office_id logins_office_id_fkey office.offices.office_id

Indices

Index Name Owner Access Method Definition Description
logins_pkey postgres btree login_id

Check Constraints

Constraint Name Description

Default Values

# Column Name Default
1 login_id nextval('audit.logins_login_id_seq'::regclass)
6 login_date_time now()

Triggers

Trigger Name Targets On Event Timing Condition Order Orientation Description