ojt

테이블 (4)

상품 사이즈 재고관리 (size)

  • ID (id) — INT(100) — 기본 키 — NOT NULL
  • PRODUCTID (productid) — INT(100) — 외래 키 → 상품관리.ID — NOT NULL
  • PRODUCTSIZE (productsize) — VARCHAR(255)
  • STOCK (stock) — INT(11)
  • CRE_DATE (cre_date) — DATETIME
  • MOD_DATE (mod_date) — DATETIME

상품관리 (product)

  • ID (id) — INT(100) — 기본 키 — NOT NULL
  • MOLLNAME (mollname) — VARCHAR(255)
  • PRODUCTNAME (productname) — VARCHAR(255)
  • PRICE (price) — INT(11)
  • PROFIT (profit) — INT(11)
  • DETAIL (detail) — VARCHAR(255)
  • IMGURL (imgurl) — VARCHAR(255)
  • CRE_DATE (cre_date) — DATETIME
  • MOD_DATE (mod_date) — DATETIME

유저 거래내역 관리 (user_product)

  • ID (id) — VARCHAR(255) — 기본 키 — NOT NULL
  • USERPRODUCTID (userproductid) — INT(100) — 외래 키 → 상품관리.ID — NOT NULL
  • NICKNAME (nickname) — VARCHAR(255)
  • PRODUCTNAME (productname) — VARCHAR(255)
  • SIZE (size) — VARCHAR(255)
  • NUMBER (number) — INT(11)
  • TOTALPRICE (totalprice) — INT(11)
  • CRE_DATE (cre_date) — DATETIME
  • MOD_DATE (mod_date) — DATETIME

유저관리 (users)

  • ID (id) — VARCHAR(255) — 기본 키 — NOT NULL
  • NICKNAME (nickname) — VARCHAR(255) — 기본 키 — NOT NULL
  • PASSWORD (password) — VARCHAR(255)
  • NAME (name) — VARCHAR(255)
  • ADDRESS (address) — VARCHAR(255)
  • ADMIN (admin) — INT(11)
  • CRE_DATE (cre_date) — DATETIME
  • MOD_DATE (mod_date) — DATETIME