soonil1

테이블 (16)

item (Untitled4)

  • item_code (Key2) — varchar2(10) — 기본 키 — NOT NULL
  • small_code (Key) — char(2) — 외래 키 → small_code.small_code — NOT NULL
  • mid_code (Key22) — char(2) — 외래 키 → small_code.mid_code — NOT NULL
  • Large_code (Key222) — char(2) — 외래 키 → small_code.Large_code — NOT NULL
  • option_code (Key32) — char(4) — 외래 키 → option.option_code — NOT NULL
  • name (Field13) — varchar2(20)
  • price (Field17) — number(10)
  • date (Field) — char(6)
  • discount (Field2) — number(2)
  • like_code (Key3) — varchar2(10) — 외래 키 → 찜.like_code — NOT NULL

large_code (Untitled)

  • Large_code (Key) — char(2) — 기본 키 — NOT NULL
  • large_name (Field) — varchar2(2)

mid_code (untitled)

  • mid_code (Key) — char(2) — 기본 키 — NOT NULL
  • Large_code (Key2) — char(2) — 외래 키 → large_code.Large_code — NOT NULL
  • mid_name (Field) — varchar(10)

option (Untitled3)

  • option_code (Key3) — char(4) — 기본 키 — NOT NULL
  • category_code (Key32) — char(4) — 외래 키 → option_category.category_code — NOT NULL

option_category (Untitled7)

  • category_code (Key3) — char(4) — 기본 키 — NOT NULL
  • small_code (Key4) — char(2) — 외래 키 → small_code.small_code — NOT NULL
  • mid_code (Key23) — char(2) — 외래 키 → small_code.mid_code — NOT NULL
  • Large_code (Key222) — char(2) — 외래 키 → small_code.Large_code — NOT NULL
  • category_name (Field2) — varchar2(10)
  • option_name (Field3) — varchar2(10)
  • option_code (Key) — char(4) — NOT NULL

small_code (CopyOfUntitled2)

  • small_code (Key) — char(2) — 기본 키 — NOT NULL
  • mid_code (Key2) — char(2) — 외래 키 → mid_code.mid_code — NOT NULL
  • Large_code (Key22) — char(2) — 외래 키 → mid_code.Large_code — NOT NULL
  • small_name (Field) — varchar(10)

결제 (Untitled10)

  • pay_code (Key) — varchar2(20) — 기본 키 — NOT NULL
  • order_code (Key2) — varchar2(10) — 외래 키 → 주문.order_code — NOT NULL
  • pay_price (Field) — number(10)
  • pay_date (Field3) — varchar2(6)
  • pay_method (Field2) — varchar2(10)

리뷰 (Untitled12)

  • review_code (Key) — varchar2(10) — 기본 키 — NOT NULL
  • member_code (Key2) — varchar2(10) — 외래 키 → 회원.member_code — NOT NULL
  • review_content (Field) — clob()
  • review_date (Field2) — varchar2(6)
  • order_item_code (Key3) — varchar2(10) — 외래 키 → 주문상품.order_item_code — NOT NULL

배송지 목록 (Untitled11)

  • loc_code (Key) — varchar2(10) — 기본 키 — NOT NULL
  • member_code (Key2) — varchar2(10) — 외래 키 → 회원.member_code — NOT NULL
  • loc_name (Field3) — varchar2(10)
  • loc (Field) — varchar2(20)
  • loc_detail (Field2) — varchar2(20)

장바구니 (Untitled8)

  • member_code (Key) — varchar2(10) — 외래 키 → 회원.member_code — NOT NULL
  • like_list_code (Key23) — varchar2(10) — 외래 키 — NOT NULL
  • amount (Field) — number(5)

주문 (Untitled2)

  • order_code (Key) — varchar2(10) — 기본 키 — NOT NULL
  • loc_code (Key3) — varchar2(10) — 외래 키 → 배송지 목록.loc_code — NOT NULL
  • order_list_code (Key4) — varchar2(10) — 외래 키 → 주문목록.order_list_code — NOT NULL
  • order_name (Field) — varchar2(20)
  • order_addr (Field2) — varchar2(20)
  • order_phone (Field3) — varchar2(11)
  • total_price (Field4) — number(10)
  • discounted_price (Field5) — number(10)
  • order_date (Field7) — varchar2(6)
  • order_stat (Field6) — varchar2(10)
  • member_code (Key2) — varchar2(10) — 외래 키 → 회원.member_code — NOT NULL

주문목록 (Untitled13)

  • order_list_code (Key) — varchar2(10) — 기본 키 — NOT NULL
  • member_code (Key2) — varchar2(10) — 외래 키 → 회원.member_code — NOT NULL

주문상품 (Untitled9)

  • order_item_code (Key) — varchar2(10) — 기본 키 — NOT NULL
  • item_code (Key2) — char(10) — 외래 키 → item.item_code — NOT NULL
  • order_code (Key4) — varchar2(10) — 외래 키 → 주문.order_code — NOT NULL
  • amount (Field) — number(5)
  • price (Field2) — number(10)

찜 (Untitled6)

  • like_code (Key) — varchar2(10) — 기본 키 — NOT NULL
  • like_list_code (Key2) — varchar2(10) — 외래 키 → 찜목록.like_list_code — NOT NULL

찜목록 (Untitled14)

  • like_list_code (Key) — varchar2(10) — 기본 키 — NOT NULL
  • member_code (Key2) — varchar2(10) — 외래 키 → 회원.member_code — NOT NULL

회원 (Untitled5)

  • member_code (Key) — varchar2(10) — 기본 키 — NOT NULL
  • member_id (Field) — varchar2(20)
  • member_pwd (Field2) — varchar2(20)
  • member_eaddr (Field4) — varchar2(20)
  • mpmber_phone (Field5) — varchar2(11)
  • member_name (Field6) — varchar2(10)
  • member_jumin (Field7) — varchar2(13)