customer address

Tables (3)

Addresses (주소)

  • id (address_id) — int — Primary key — NOT NULL
  • building (line_1_number_building) — int
  • street (line_2_number_street) — int
  • locality (line_3_area_locality) — varchar
  • city — varchar
  • postcode (zip_postcode) — int
  • state (state_province_county) — varchar
  • country — varchar
  • details (other_address_details) — varchar

Customer_Addresses (고객_주소)

  • date_address_from — varchar — Primary key — NOT NULL
  • date_address_to — varchar
  • other_details — varchar
  • id (customer_id) — int — Foreign key → Customers.id — NOT NULL
  • id (address_id) — int — Foreign key → Addresses.id — NOT NULL

Customers (고객)

  • id (customer_id) — int — Primary key — NOT NULL
  • name (customer_name) — varchar
  • date (date_became_customer) — varchar
  • details (other_customer_details) — varchar