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
  • zipcode — varchar2(7) — Foreign key → tb_zipcode.zipcode — NOT NULL

orders

  • o_seq — VARCHAR(255) — Primary key — NOT NULL
  • product_size — varchar2(5)
  • quantity — varchar2(5)
  • result — char(1)
  • indate — date
  • id — varchar2(20) — Foreign key → member.id — NOT NULL
  • product_code — varchar2(20) — Foreign key → product.product_code — NOT NULL

product

  • product_code — varchar2(20) — Primary key — NOT NULL
  • product_name — varchar2(100 NULL, "product_kind" char(1)
  • product_price1 — varchar2(10)
  • product_pricce2 — varchar2(10)
  • product_content — varchar2(1000)
  • product_image — varchar2(50)
  • sizeSt — varchar2(5)
  • sizeEt — varchar2(5)
  • product_quantity — varchar2(5)
  • useryn — char(1)
  • indate — date

sample

  • Field
  • Field2

tb_zipcode

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