customer address
Tables (3)
Customer_Addresses (고객정보 및 주소)
- date_address_from — int — Primary key — NOT NULL
- date_address_to — varchar
- other_details — varchar
- customer_id — int — Foreign key → customers.customer_id — NOT NULL
- address_id — int — Foreign key → addresses.address_id — NOT NULL
addresses (고객주소)
- address_id — int — 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_county
- country — varchar
- other_address_details — varchar
customers (고객정보)
- customer_id — int — Primary key — NOT NULL
- customer_name — varchar
- date_became_customer — date
- other_customer_details — varchar