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