# Column Name Nullable Data Type Max Length Description
1configuration_idinteger0The primary key of this table, which is also a serial field.
2config_idinteger0Foreign key to the table core.config.
3office_idinteger0
4valuetext0
5configuration_detailstext0Details on configuration.
6audit_user_idinteger0Contains the id of the user who last inserted or updated the corresponding row.
7audit_tstimestamp with time zone0Contains the date and timestamp of the last insert or update action.

Foreign Keys

# Column Name Key Name References
2 config_id configuration_config_id_fkey core.config.config_id
6 audit_user_id configuration_audit_user_id_fkey office.users.user_id

Indices

Index Name Owner Access Method Definition Description
configuration_pkey postgres btree configuration_id

Check Constraints

Constraint Name Description

Default Values

# Column Name Default
1 configuration_id nextval('office.configuration_configuration_id_seq'::regclass)
7 audit_ts now()

Triggers

Trigger Name Targets On Event Timing Condition Order Orientation Description