shop2

Tables (4)

member

  • id — Primary key — NOT NULL
  • pwd
  • name
  • address
  • tel
  • indate
  • zipcod — NOT NULL

orders

  • o_seq — Primary key — NOT NULL
  • product_code
  • id
  • product_size
  • quantity
  • result
  • indate
  • product_code2 — NOT NULL
  • id2 — NOT NULL

products

  • product_code — Primary key — NOT NULL
  • product_name
  • product_kind
  • product_price1
  • product_price2
  • product_content
  • product_image
  • sizeSt
  • sizeEt
  • product_quantity
  • useyn
  • indate

tb_zipcode

  • zipcode — Primary key — NOT NULL
  • sido
  • gugun
  • dong
  • bungi