# Column Name Nullable Data Type Max Length Description
1ageing_slab_idinteger0The primary key of this table, which is also a serial field.
2ageing_slab_namecharacter varying24
3from_daysinteger0
4to_daysinteger0
5audit_user_idinteger0
6audit_tstimestamp with time zone0

Foreign Keys

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

Indices

Index Name Owner Access Method Definition Description
ageing_slabs_pkey postgres btree ageing_slab_id
ageing_slabs_ageing_slab_name_uix postgres btree upper(ageing_slab_name::text)

Check Constraints

Constraint Name Description
ageing_slabs_to_days_check
CHECK (to_days > 0)

Default Values

# Column Name Default
1 ageing_slab_id nextval('core.ageing_slabs_ageing_slab_id_seq'::regclass)
6 audit_ts now()

Triggers

Trigger Name Targets On Event Timing Condition Order Orientation Description