customer address

Tables (3)

Addresses (addresses)

  • Address ID (address_id) — int — Primary key — NOT NULL
  • Line 1 Number Building (line_1_number_building) — int
  • Line 2 Number Street (line_2_number_street) — int
  • 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 (customer_addresses)

  • Date Address From (date_address_from) — date — Primary key — NOT NULL
  • Address ID (address_id) — int — Foreign key → Addresses.Address ID — NOT NULL
  • Customer ID (customer_id) — int — Foreign key → Customers.Customer ID — NOT NULL
  • Date Address To (date_address_to) — date
  • Other Details (other_details) — varchar

Customers (customers)

  • Customer ID (customer_id) — int — Primary key — NOT NULL
  • Customer Name (customer_name) — varchar
  • Date Became Customer (date_became_customer) — date
  • Other Customer Details (other_customer_details) — varchar