# Column Name Nullable Data Type Max Length Description
1store_policy_detail_idbigint0
2store_policy_idbigint0
3user_idinteger0
4store_idinteger0
5audit_user_idinteger0Contains the id of the user who last inserted or updated the corresponding row.
6audit_tstimestamp with time zone0Contains the date and timestamp of the last insert or update action.

Foreign Keys

# Column Name Key Name References
2 store_policy_id store_policy_details_store_policy_id_fkey policy.store_policies.store_policy_id
3 user_id store_policy_details_user_id_fkey office.users.user_id
4 store_id store_policy_details_store_id_fkey office.stores.store_id
5 audit_user_id store_policy_details_audit_user_id_fkey office.users.user_id

Indices

Index Name Owner Access Method Definition Description
store_policy_details_pkey postgres btree store_policy_detail_id

Check Constraints

Constraint Name Description

Default Values

# Column Name Default
1 store_policy_detail_id nextval('policy.store_policy_details_store_policy_detail_id_seq'::regclass)
6 audit_ts now()

Triggers

Trigger Name Targets On Event Timing Condition Order Orientation Description