CUSTOMER

Description

This table stores the customers.

Columns

Column Name Data Type Description
ID bigint The unique identifier for the customer.
ADDRESS varchar The address of the customer.
CUSTOMER_ID varchar The ID of the customer.
CUSTOMERS_OFFER_ID_AND_CUSTO_0 bigint The ID of the offer and customer.
CUSTOMERS_HJORDER int The HJ (Hypothetical Join) order for the customer.

Foreign Key Relationships

  • CUSTOMERS_OFFER_ID_AND_CUSTO_0 references OFFER_ID_AND_CUSTOMERS(ID)