MIXERP-Table core.late_fee

#	Column Name	Nullable	Data Type	Max Length	Description
1	late_fee_id		integer	0	The primary key of this table, which is also a serial field.
2	late_fee_code		character varying	12	Late fee code.
3	late_fee_name		character varying	50	The name given to the late fee code, which is a unique field.
4	is_flat_amount		boolean	0	Select "Yes" if the late fee amount is fixed or vice-versa.
5	rate		numeric	1572868	The rate on which late fee will be charged.
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
6	audit_user_id	late_fee_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
late_fee_pkey	postgres	btree	late_fee_id
late_fee_is_flat_amount_inx	postgres	btree	is_flat_amount
late_fee_late_fee_name_uix	postgres	btree	upper(late_fee_name::text)
late_fee_late_fee_code_uix	postgres	btree	upper(late_fee_code::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	late_fee_id	nextval('core.late_fee_late_fee_id_seq'::regclass)
4	is_flat_amount	false
7	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description