1
2
Resulting Table Schema: Customers
Attribute Name | Data Type | Business Definition | Notes |
---|
Customer_ID | integer | A unique, universal identification for a customer. | Unique identifier |
---|
Name | text | The first and last name of a customer. | |
---|
Affiliate_Company | text | An organization a customer may be connected to. | |
---|
Email | text | A customer's email address, used for receipts, news, and promotional offerings. | |
---|
Address | text | A customer's mailing address, used for deliveries and secure statements. | |
---|
City | text | The city a customer resides in. | |
---|
Age | integer | A customer's age, in years. | |
---|
Loyalty_Plan | integer | Tells if a customer is a loyalty member. | FALSE is a keyword for 0TRUE is a keyword for 1
|
---|