#	Column Name	Nullable	Data Type	Max Length	Description
1	recurring_invoice_setup_id		integer	0	The primary key of this table, which is also a serial field.
2	recurring_invoice_id		integer	0
3	party_id		bigint	0
4	starts_from		date	0
5	ends_on		date	0
6	recurring_amount		money_strict	0
7	payment_term_id		integer	0
8	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
9	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	recurring_invoice_id	recurring_invoice_setup_recurring_invoice_id_fkey	core.recurring_invoices.recurring_invoice_id
3	party_id	recurring_invoice_setup_party_id_fkey	core.parties.party_id
7	payment_term_id	recurring_invoice_setup_payment_term_id_fkey	core.payment_terms.payment_term_id
8	audit_user_id	recurring_invoice_setup_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
recurring_invoice_setup_pkey	postgres	btree	recurring_invoice_setup_id

Check Constraints

Constraint Name	Description
recurring_invoice_setup_recurring_amount_chk CHECK (recurring_amount::numeric > 0::numeric)
recurring_invoice_setup_date_chk CHECK (ends_on >= starts_from)

Default Values

#	Column Name	Default
1	recurring_invoice_setup_id	nextval('core.recurring_invoice_setup_recurring_invoice_setup_id_seq'::regclass)
9	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description