Database Table Specification Example: Customers Table

Table Name: `customers`

Columns

• customer_id – Primary key, auto-incrementing integer.
• first_name – String.
• last_name – String.
• email – String (unique).
• phone – String.
• address – String.
• city – String.
• state – String (2-letter abbreviation).
• zip – String.

Constraints

• PRIMARY KEY (customer_id) – Ensures unique IDs.
• UNIQUE (email) – Prevents duplicate emails.

This structure supports efficient customer data management with integrity guarantees.