MIXERP-Table core.shipping_addresses

#	Column Name	Nullable	Data Type	Max Length	Description
1	shipping_address_id		bigint	0
2	shipping_address_code		character varying	24
3	party_id		bigint	0
4	country_id		integer	0
5	state_id		integer	0
6	zip_code		character varying	12
7	address_line_1		character varying	128
8	address_line_2		character varying	128
9	street		character varying	128
10	city		character varying	128
11	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
12	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
3	party_id	shipping_addresses_party_id_fkey	core.parties.party_id
4	country_id	shipping_addresses_country_id_fkey	core.countries.country_id
5	state_id	shipping_addresses_state_id_fkey	core.states.state_id
11	audit_user_id	shipping_addresses_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
shipping_addresses_pkey	postgres	btree	shipping_address_id
shipping_addresses_shipping_address_code_uix	postgres	btree	upper(shipping_address_code::text) party_id

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	shipping_address_id	nextval('core.shipping_addresses_shipping_address_id_seq'::regclass)
12	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description
core.update_shipping_address_code_trigger	core.update_shipping_address_code_trigger	INSERT	BEFORE		0	ROW