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