customer address

Tables (3)

Addresses (Untitled3)

  • address_id — varchar — Primary key — NOT NULL
  • line_1_number_building — int
  • line_2_number_street — int
  • line_3_area_localilty — varchar
  • city — varchar
  • zip_postcode — varchar
  • state_province_county — varchar
  • country — varchar
  • other_address_details — varchar

Customer_Addresses (Untitled2)

  • date_address_from — date — Primary key — NOT NULL
  • date_address_to — date
  • other_details — varchar
  • customer_id — varchar — Foreign key → Customers.customer_id — NOT NULL
  • address_id — varchar — Foreign key → Addresses.address_id — NOT NULL

Customers (Untitled)

  • customer_id — varchar — Primary key — NOT NULL
  • customer_name — varchar
  • date_became_customer — date
  • other_customer_details (Field2) — varchar