#	Column Name	Nullable	Data Type	Max Length	Description
1	failed_login_id		bigint	0	The primary key of this table, which is also a serial field.
2	user_id		integer	0
3	user_name		character varying	50
4	office_id		integer	0
5	browser		character varying	500
6	ip_address		character varying	50
7	failed_date_time		timestamp with time zone	0
8	remote_user		character varying	50
9	details		character varying	250

Foreign Keys

#	Column Name	Key Name	References
2	user_id	failed_logins_user_id_fkey	office.users.user_id
4	office_id	failed_logins_office_id_fkey	office.offices.office_id

Indices

Index Name	Owner	Access Method	Definition	Description
failed_logins_pkey	postgres	btree	failed_login_id

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	failed_login_id	nextval('audit.failed_logins_failed_login_id_seq'::regclass)
7	failed_date_time	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description
audit.lockout_user	policy.perform_lock_out	INSERT	AFTER		0	ROW