MIXERP-Table core.fiscal_year

#	Column Name	Nullable	Data Type	Max Length	Description
1	fiscal_year_code		character varying	12	The primary key of this table, which is also a serial field.
2	fiscal_year_name		character varying	50	Current fiscal year, which is a unique field.
3	starts_from		date	0	The date fiscal year begins.
4	ends_on		date	0	The date fiscal year ends.
5	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
6	audit_ts		timestamp with time zone	0	Contains the date and timestamp of the last insert or update action.

Foreign Keys

#	Column Name	Key Name	References
5	audit_user_id	fiscal_year_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
fiscal_year_pkey	postgres	btree	fiscal_year_code
fiscal_year_ends_on_uix	postgres	btree	ends_on
fiscal_year_starts_from_uix	postgres	btree	starts_from
fiscal_year_fiscal_year_name_uix	postgres	btree	upper(fiscal_year_name::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
6	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description