Organisation Contact¶

This table stores information about individual organisation contact linked to vendor company with whom user can share shipment.

orgContactId: Primary key for the table.

companyName: Name of the vendor company.

contactName: Name of the contact user inside vendor company.

contactEmail: Email id of the contact user inside vendor company.

contactPhoneNo: Phone number of the contact user.

contactCountryCode: Country code of the contact user.

contactAddress: Address of the contact user.

contactDesignation: Designation of the contact user inside vendor company.

comment: Comment given by organisation user, while adding contact.

orgId: Foreign key of Organisation table. This field stores the information of the organisation where external user is being added.

venSupId: Foreign key of Organisation table. This field stores the information of the organisation where external user is being added.

isNotifyEnabled: Boolean value indicating whether the notification should be sent to user or not.

tags: Array of tags.

Organisation Contact always belongs any one Organisation.

Organisation Contact always belongs any one Vendor company.