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