customer address
Tables (3)
Addresses (addresses)
- Address ID (address_id) — int — Primary key — NOT NULL
- Line 1 Number Building (line_1_number_building) — int
- Line 2 Number Street (line_2_number_street) — int
- Line 3 Area Locality (line_3_area_locality) — varchar
- City (city) — varchar
- Zip Postcode (zip_postcode) — int
- State Province County (state_province_county) — varchar
- Country (country) — varchar
- Other Address Details (other_address_details) — varchar
Customer Addresses (customer_addresses)
- Date Address From (date_address_from) — date — Primary key — NOT NULL
- Address ID (address_id) — int — Foreign key → Addresses.Address ID — NOT NULL
- Customer ID (customer_id) — int — Foreign key → Customers.Customer ID — NOT NULL
- Date Address To (date_address_to) — date
- Other Details (other_details) — varchar
Customers (customers)
- Customer ID (customer_id) — int — Primary key — NOT NULL
- Customer Name (customer_name) — varchar
- Date Became Customer (date_became_customer) — date
- Other Customer Details (other_customer_details) — varchar