Customer Addresses
Tables (3)
Addresses (addresses)
- Addresses_ID (addresses_id) — int — Primary key — NOT NULL
- Line_1_Number_Building (line_1_number_building) — int — Primary key
- Line_2_Number_Street (line_2_number_street) — int
- Line_3_Area_Locality (line_3_area_locality) — varchar(255)
- City (city) — varchar(255)
- Zip_Postcode (zip_postcode) — varchar(255)
- Field — varchar(255)
- Country (country) — varchar(255)
- Other_Address_Details (other_address_details) — varchar(255)
Customer_Addresses (customer_addresses)
- Date_Address_From (date_address_from) — date — Primary key — NOT NULL
- Date_Address_To (date_address_to) — date
- Other_Details (other_details) — varchar(255)
- Customer_ID (customer_id) — int — Foreign key → Customers.Customer_ID — NOT NULL
- Key — Foreign key → Addresses.Addresses_ID — NOT NULL
- Line_1_Number_Building (line_1_number_building) — int — Foreign key → Addresses.Line_1_Number_Building
Customers (customers)
- Customer_ID (customer_id) — int — Primary key — NOT NULL
- Customer_Name (customer_name) — varchar(255)
- Date_Became_Customer (date_became_customer) — date
- Other_Customer_Details (other_customer_details) — int