커스터머
테이블 (3)
고객 (Customers)
- PK (customer_ID) — number — 기본 키 — NOT NULL
- PK (customer_name) — number
- PK (customer_customer) — number
- PK (other_customer_detalls) — number
고객_구애 (Customer_Addresses)
- PF (customer_ID) — number — 기본 키 — NOT NULL
- PF (address_ID) — number
- PK (date_address_from) — number
- PK (date_address_to) — number
- PK (other_details) — number
- PK (customer_ID2) — number — 외래 키 → 고객.PK — NOT NULL
- PK (address_ID2) — number — 외래 키 → 구애.PK — NOT NULL
구애 (ADDRESSES)
- PK (address_ID) — number — 기본 키 — NOT NULL
- PK (line_1_number_buliding) — number
- PK (line_2_number_street) — number
- PK (line_3_area_locatiity) — number
- PK (city) — varchar
- PK (zip_postcode) — varchar
- PK (state_province_county) — varchar
- PK (country) — number
- PK (other_address_details) — number