MIXERP-Table office.cashiers

#	Column Name	Nullable	Data Type	Max Length	Description
1	cashier_id		bigint	0	The primary key of this table, which is also a bigserial field.
2	counter_id		integer	0	Foreign key to the table office.counters.
3	user_id		integer	0	Foreign key to the table office.users.
4	assigned_by_user_id		integer	0	Foreign key to the table office.users.
5	transaction_date		date	0	The date on which the transaction occured.
6	closed		boolean	0

Foreign Keys

#	Column Name	Key Name	References
2	counter_id	cashiers_counter_id_fkey	office.counters.counter_id
3	user_id	cashiers_user_id_fkey	office.users.user_id
4	assigned_by_user_id	cashiers_assigned_by_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
cashiers_pkey	postgres	btree	cashier_id
cashiers_user_id_tdate_uix	postgres	btree	user_id transaction_date

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	cashier_id	nextval('office.cashiers_cashier_id_seq'::regclass)

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description