Customer_address
Tables (3)
Addresses (Untitled)
- address_id — varchar — 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_country — varchar
- country — varchar
- other_address_details — varchar
Customer_Addresses (Untitled2)
- data_address_from — varchar — Primary key — NOT NULL
- data_address_to — varchar
- other_details — varchar
- Customer_id — varchar — Foreign key → Customers.아이디 — NOT NULL
- address_id — varchar — Foreign key → Addresses.address_id — NOT NULL
Customers
- 아이디 (customer_id) — varchar — Primary key — NOT NULL
- 고객명 (customer_name) — varchar
- 가입일 (date_became_customer) — date
- other_customer_details — varchar