Customer
Tables (3)
Addresses (Untitled2)
- 주소아이디 (address_id) — varchar2 — Primary key — NOT NULL
- 빌딩 (line_1_number_building) — varchar2
- 스트릿 (line_2_number_street) — varchar2
- 지역 (line_3_area_locality) — varchar2
- 도시 (city) — vrachar2
- 우편번호 (zip_postcode) — number
- 도시2 (state_province_country) — varchar2
- 마을 (country) — varchar2
- 상세주소 (other_address_details) — varchar2
Customer (Addresses)
- 보내는주소 (date_adress_from) — varchar2 — Primary key — NOT NULL
- 아이디 (customer_id) — varchar2 — Foreign key → Customers.아이디 — NOT NULL
- 주소아이디 (address_id) — varchar2 — Foreign key → Addresses.주소아이디 — NOT NULL
- 받는주소 (date_adress_to) — varchar2
- 상세정보 (other_details) — varchar2
Customers (Untitled)
- 아이디 (customer_id) — varchar2 — Primary key — NOT NULL
- 이름 (customer_name) — varchar2
- 날짜 (date_became_customer) — date
- 상세정보 (other_customer_details) — varchar2