0527

Tables (3)

Customers (고객)

  • 회원일련번호 (customer_number) — varchar2(5) — Primary key — NOT NULL
  • 이름 (name) — varchar2(50)
  • 주소 (address) — varchar2(100)
  • 이메일 (email) — varchar2(100)
  • 전화번호 (phone) — varchar2(20)

Orders (주문)

  • 주문일련번호 (order_number) — varchar2(5) — Primary key — NOT NULL
  • 주문 날짜 (order_date) — datetime
  • 배송지역 (order_address) — varchar2((100)
  • 상태 (status) — varchar2(50)
  • 배송알림방법 (order_alarm_method) — varchar2(10)
  • 제품일련번호 (product__number) — varchar2(5) — Foreign key → Products.제품일련번호 — NOT NULL
  • 회원일련번호 (customer_number2) — varchar2(5) — Foreign key → Customers.회원일련번호 — NOT NULL
  • 택배회사 (courier_company) — varchar2(20)

Products (제품)

  • 제품일련번호 (product__number) — varchar2(5) — Primary key — NOT NULL
  • 제품이름 (product_name) — varchar2(50)
  • 가격 (price) — number