customer address
테이블 (3)
고객 (Customers)
- customer_id — number — 기본 키 — NOT NULL
- customer_name — varchar
- date_became_customer (date_became_custome) — date
- other_customer_details — varchar
고객_주소 (Customer_Addresses)
- date_address_from — number — 기본 키 — NOT NULL
- customer_id — number — 외래 키 → 고객.customer_id — NOT NULL
- address_id — number — 외래 키 → 주소.address_id — NOT NULL
- date_address_to — varchar
- other_details — varchar
주소 (Addresses)
- address_id — number — 기본 키 — NOT NULL
- line_1_number_building — number
- line_2_number_street — number
- line_3_area_locality — varchar
- city — varchar
- zip_postcode — number
- state_province_county — varchar
- country — varchar
- other_address_details — varchar