손님
테이블 (3)
Addresses
- address_id — number — 기본 키
- line_1_number_building — varchar
- line_2_number_street — varchar
- line_3_area_locality — varchar
- city — varchar
- zip_postcode — varchar
- state_province_county — varchar
- other_address_details — varchar
- country — varchar
Customers
- customer_id — number — 기본 키
- customer_name — varchar
- date_became_customer — DATE
- other_customer_details — varchar
손님주소 (Customer_Address)
- date_address_form (date_adress_form) — varchar — 기본 키 — NOT NULL
- address_id — number — 외래 키 → Addresses.address_id
- customer_id — number — 외래 키 → Customers.customer_id
- date_address_to — varchar
- other_details — varchar