customer address
Tables (3)
Addresses
- address_id — varchar — Primary key — NOT NULL
- line_1_number_building — varchar
- line_2_number_street — varchar
- line_3_area_locality — varchar
- city — varchar
- zip_postcode — int
- state_province_country — varchar
- country — varchar
- other_address_details — varchar
Customer_Addresses
- date_address_form — varchar — Primary key
- address_id — varchar
- date_address_to — varchar
- other_details — varchar
- customer_id — varchar — NOT NULL
- customer_id (customer_id2) — varchar — Foreign key → Customers.customer_id — NOT NULL
- address_id (address_id2) — varchar — Foreign key → Addresses.address_id — NOT NULL
Customers
- customer_id — varchar — Primary key — NOT NULL
- customer_name — varchar
- date_became_customer — varchar
- other_customer_details — varchar