MIXERP-Table core.frequency_setups

#	Column Name	Nullable	Data Type	Max Length	Description
1	frequency_setup_id		integer	0	The primary key of this table, which is also a serial field.
2	fiscal_year_code		character varying	12	Foreign key to the table core.fiscal_year.
3	frequency_setup_code		character varying	12
4	value_date		date	0
5	frequency_id		integer	0	Foreign key to the table core.frequencies.
6	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
7	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
2	fiscal_year_code	frequency_setups_fiscal_year_code_fkey	core.fiscal_year.fiscal_year_code
5	frequency_id	frequency_setups_frequency_id_fkey	core.frequencies.frequency_id
6	audit_user_id	frequency_setups_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
frequency_setups_pkey	postgres	btree	frequency_setup_id
frequency_setups_frequency_setup_code_uix	postgres	btree	upper(frequency_setup_code::text)
frequency_setups_value_date_key	postgres	btree	value_date

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	frequency_setup_id	nextval('core.frequency_setups_frequency_setup_id_seq'::regclass)
7	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description