customer address
Tables (3)
Address (Addresses)
- Address_id (address_id) — varchar — Primary key — NOT NULL
- Line_1_number_building (line_1_number_building) — varchar
- Line_2_number_street (line_2_number_street) — varchar
- 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
- Date_address_from (date_address_from) — date — Primary key — NOT NULL
- Customer_id (customer_id) — varchar — Foreign key → Customers.Customer_id — NOT NULL
- Address_id (address_id) — varchar — Foreign key → Address.Address_id — NOT NULL
- Date_address_to (date_address_to) — date
- other_details — varchar
Customers
- Customer_id (customer_id) — varchar — Primary key — NOT NULL
- customer_name — varchar
- data_became_customer — date
- other_customer_details — varchar