Customer_address

Tables (3)

Addresses (Untitled)

  • address_id — varchar — Primary key — NOT NULL
  • line_1_number_building — varchar
  • line_2_number_street — varchar
  • line_3_area_locality — varchar
  • city — varchar
  • zip_postcode — varchar
  • state_province_country — varchar
  • country — varchar
  • other_address_details — varchar

Customer_Addresses (Untitled2)

  • data_address_from — varchar — Primary key — NOT NULL
  • data_address_to — varchar
  • other_details — varchar
  • Customer_id — varchar — Foreign key → Customers.아이디 — NOT NULL
  • address_id — varchar — Foreign key → Addresses.address_id — NOT NULL

Customers

  • 아이디 (customer_id) — varchar — Primary key — NOT NULL
  • 고객명 (customer_name) — varchar
  • 가입일 (date_became_customer) — date
  • other_customer_details — varchar