customer address

Tables (3)

addresses (Untitled2)

  • address_id (add_id) — varchar — Primary key — NOT NULL
  • line_1_number_building (l1num) — int
  • line_2_number_street (l2num_street) — int
  • line_3_area_localilt (loc) — varchar
  • city — varchar
  • zip_postcode (postcode) — varchar
  • state_province_county (s_p_c) — varchar
  • country — varchar
  • other_address_details (adddetails) — varchar

customer_addresses (Untitled3)

  • date_address_from — date — Primary key
  • date_address_to — date
  • other_details — varchar
  • customer_id (id2) — varchar — Foreign key → customers.customer_id — NOT NULL
  • address_id (add2) — varchar — Foreign key → addresses.address_id — NOT NULL

customers (Untitled)

  • customer_id (cus_id) — varchar — Primary key — NOT NULL
  • customer_name (name) — varchar
  • date_become_customer — date
  • other_customer_details (details) — varchar