| Attribute | Type | |
| Customer ID | Numeric(10) | |
| Last_Name | Character(30) | |
| First_Name | Character(20) | |
| Address | Character(30) | |
| City | Character(20) | |
| State | Character(2) | |
| Zip | Numeric(5) | |
| Phone | Character(13) | |
| Fax | Character(13) | |
| Character(30) | ||
| Sex | Character(1) | |
| Customer_Since | Date | |
| Marital_Status | Character(1) | |
| Children | Character(1) | |
| Likes | Character(30) | |
| Credit_Card | Character(19) | |
| Credit_Card_Expire | Date | |
| Outstanding_Balance | Numeric(4.2) | |
| Restriction | Character(1) | |
| Tapes_Out | Numeric(1) |