customer address

테이블 (3)

고객 (Customers)

  • customer_id — number — 기본 키 — NOT NULL
  • customer_name — varchar
  • date_became_customer (date_became_custome) — date
  • other_customer_details — varchar

고객_주소 (Customer_Addresses)

  • date_address_from — number — 기본 키 — NOT NULL
  • customer_id — number — 외래 키 → 고객.customer_id — NOT NULL
  • address_id — number — 외래 키 → 주소.address_id — NOT NULL
  • date_address_to — varchar
  • other_details — varchar

주소 (Addresses)

  • address_id — number — 기본 키 — NOT NULL
  • line_1_number_building — number
  • line_2_number_street — number
  • line_3_area_locality — varchar
  • city — varchar
  • zip_postcode — number
  • state_province_county — varchar
  • country — varchar
  • other_address_details — varchar