shop2

Tables (5)

member

  • ID — varchar2(20) — Primary key — NOT NULL
  • Pwd — varchar2(20)
  • name — varchar2(20)
  • address — varchar2(20)
  • tel — varchar2(13)
  • indate — date
  • zipcode2 — varchar2(7) — Foreign key → tb_zipcode.zipcode — NOT NULL

orders

  • sale_date — date — Primary key — NOT NULL
  • product_code — varchar2(260 NOT NULL, `ID` varchar2(20) — Foreign key → product.product_code — NOT NULL
  • sale_amount — varchar2(5) — NOT NULL
  • sale_price — varchar2(6) — NOT NULL
  • sale_tot_price — varchar2(15) — NOT NULL

product

  • product_code — varchar2(260 NOT NULL, `product_name` varchar2(100) — Primary key — NOT NULL
  • product_url — blob
  • nation_code — varchar2(6)
  • product_type_code — varchar2(6)
  • product_price — number(15) — NOT NULL
  • product_vintage — date
  • theme_code — varchar2(6 )
  • today_code — varchar2(6)

sample

  • id — date
  • name — varchat2(30)
  • Field

tb_zipcode

  • zipcode — varchar2(7) — Primary key — NOT NULL
  • sido — varchar2(30)
  • gugun — varchar2(30)
  • dong — varchat2(30)
  • bungi — varchar2(30)