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