MIXERP-Table core.shippers

#	Column Name	Data Type	Max Length	Description
1	shipper_id	integer	0	The primary key of the table, which is also a bigserial field.
2	shipper_code	character varying	12	The code of the shipper.
3	company_name	character varying	128	Tha name of the shipping company.
4	shipper_name	character varying	150	The name of the shipper.
5	po_box	character varying	128	The P.O Box number of the shipper.
6	address_line_1	character varying	128	Address 1.
7	address_line_2	character varying	128	Address 2.
8	street	character varying	50	The street name where the shipper operates.
9	city	character varying	50	The city name of the city where the shipper operates.
10	state	character varying	50	The name of the state where the shipper operates.
11	country	character varying	50	The name of the county where the shipper operates.
12	phone	character varying	50	The phone number of the shipper.
13	fax	character varying	50	The fax number of the shipper.
14	cell	character varying	50	The cell number of the shipper.
15	email	character varying	128	The e-mail address of the shipper.
16	url	character varying	50	The web address of the shipper.
17	contact_person	character varying	50	The contact person or agent of the shipping company.
18	contact_po_box	character varying	128	The P.O. Box number of the agent.
19	contact_address_line_1	character varying	128	Address 1 of the shipping agent.
20	contact_address_line_2	character varying	128	Address 2 of the shipping agent.
21	contact_street	character varying	50	The street name where the shipping agent resides.
22	contact_city	character varying	50	THe city name where the shipping agent resides.
23	contact_state	character varying	50
24	contact_country	character varying	50
25	contact_email	character varying	128
26	contact_phone	character varying	50
27	contact_cell	character varying	50
28	factory_address	character varying	250
29	pan_number	character varying	50
30	sst_number	character varying	50
31	cst_number	character varying	50
32	account_id	bigint	0	Foreign key to the table core.accounts.
33	audit_user_id	integer	0	Contains the id of the user who last inserted or updated the corresponding row.
34	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
32	account_id	shippers_account_id_fkey	core.accounts.account_id
33	audit_user_id	shippers_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
shippers_pkey	postgres	btree	shipper_id
shippers_shipper_code_uix	postgres	btree	upper(shipper_code::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	shipper_id	nextval('core.shippers_shipper_id_seq'::regclass)
34	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description
core.shippers_after_insert_trigger	core.shippers_after_insert_trigger	INSERT	AFTER		0	ROW