MIXERP-Table core.shipping_package_shapes

#	Column Name	Nullable	Data Type	Max Length	Description
1	shipping_package_shape_id		integer	0	Primary key of the table.
2	shipping_package_shape_code		character varying	12	Code given to the shipping package shape.
3	shipping_package_shape_name		character varying	64	Name given to the shipping package shape, which is a unique field.
4	is_rectangular		boolean	0	Select "t" if the shape of the package is rectangular or vice-versa.
5	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
6	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
5	audit_user_id	shipping_package_shapes_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
shipping_package_shapes_pkey	postgres	btree	shipping_package_shape_id
shipping_package_shapes_shipping_package_shape_name_uix	postgres	btree	upper(shipping_package_shape_name::text)
shipping_package_shapes_shipping_package_shape_code_uix	postgres	btree	upper(shipping_package_shape_code::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	shipping_package_shape_id	nextval('core.shipping_package_shapes_shipping_package_shape_id_seq'::regclass)
4	is_rectangular	false
6	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description