Return to:
Database Reference Home Page
Return to:
Table Definitions Master List
*Table Name*
customer_contacts
*Description*
The customer to contacts table creates a relationship between a customer code and a contact's ID which is subsequently related to contact_master.contact_id to retrieve full details about a customer contact.
*Schema*
CREATE TABLE customer_contacts (
"company_id" int
NOT NULL, -- Company ID (company_master.company_id)
"customer_code" varchar(128)
NOT NULL, -- Customer Code (customer_master.customer_code)
"contact_id" int
NOT NULL, -- Contact ID (contact_master.contact_id)
"emergency_contact" BOOLEAN -- Primary use is to identify emergency contacts in bold or color coding from the Venture client.
DEFAULT false,
UNIQUE (company_id, customer_code, contact_id),
FOREIGN KEY (company_id, customer_code)
REFERENCES customer_master (company_id, customer_code)
ON UPDATE cascade
);
There are no comments on this page. [Add comment]