MIXERP-Table transactions.day_operation

#	Column Name	Nullable	Data Type	Max Length	Description
1	day_id		bigint	0	The primary key of this table, which is also a serial field.
2	office_id		integer	0	Foreign key to the table office.offices.
3	value_date		date	0
4	started_on		timestamp with time zone	0	Date & Time when the transaction was started.
5	started_by		integer	0	Foreign key to the table office.users.
6	completed_on		timestamp with time zone	0	Date & Time when the tranaction was completed.
7	completed_by		integer	0	Foreign key to the table office.users.
8	completed		boolean	0	Select "Yes" if the opration is completed or vice-versa.

Foreign Keys

#	Column Name	Key Name	References
2	office_id	day_operation_office_id_fkey	office.offices.office_id
5	started_by	day_operation_started_by_fkey	office.users.user_id
7	completed_by	day_operation_completed_by_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
day_operation_pkey	postgres	btree	day_id
day_operation_completed_on_inx	postgres	btree	completed_on
day_operation_value_date_uix	postgres	btree	value_date

Check Constraints

Constraint Name	Description
day_operation_completed_chk CHECK (completed OR completed_on IS NOT NULL OR NOT completed OR completed_on IS NULL)

Default Values

#	Column Name	Default
1	day_id	nextval('transactions.day_operation_day_id_seq'::regclass)
8	completed	false

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description