shoppingmall

Tables (7)

account

  • Key (accountNo) — bigInteger — Primary key — NOT NULL
  • Field (id) — varchar — NOT NULL
  • Field3 (name) — varchar — NOT NULL
  • Field (password) — varchar — NOT NULL
  • Field (addresss) — varchar
  • Field (phone) — varchar — NOT NULL
  • Field (email) — varchar — NOT NULL
  • Field (joindate) — datetime — NOT NULL
  • Field (pwdConfirmQuestion) — varchar — NOT NULL
  • Field (pwdConfirmAnswer) — varchar — NOT NULL
  • Field (addressZipCode) — int — NOT NULL
  • Field (birth) — date
  • Field (role) — varchar — NOT NULL

commoncode

  • Key (code) — varchar — Primary key — NOT NULL
  • Field (superCode) — varchar
  • Field2 (enName) — varchar — NOT NULL
  • Field3 (koName) — varchar — NOT NULL
  • Field6 (info) — text

notice

  • Key (noticeNo) — int — Primary key — NOT NULL
  • Key (accountNo) — bigInteger — Foreign key → account.Key — NOT NULL
  • Field (title) — varchar — NOT NULL
  • Field2 (content) — varchar — NOT NULL
  • Field3 (top) — tinyint
  • Field (regdate) — datetime — NOT NULL
  • Field (update) — datetime — NOT NULL
  • Field (hit) — int — NOT NULL

order

  • orderno (orderNo) — varchar — Primary key — NOT NULL
  • Key (accountNo) — bigInteger — Foreign key → account.Key — NOT NULL
  • Key (productNo) — int — Foreign key → product.Key — NOT NULL
  • Field (regDate) — datetime — NOT NULL

product

  • Key (productNo) — int — Primary key — NOT NULL
  • Field (category1) — varchar — NOT NULL
  • Field2 (category2) — varchar — NOT NULL
  • Field3 (name) — varchar — NOT NULL
  • Field4 (price) — int — NOT NULL
  • Field (saleYN) — char — NOT NULL
  • Field (info) — text — NOT NULL
  • Field (label) — text — NOT NULL
  • Field (color) — text — NOT NULL
  • Field (size) — text — NOT NULL
  • Field (regdate) — datetime — NOT NULL
  • Field (imgPath) — varchar

qna

  • Key (qnaNo) — int — Primary key — NOT NULL
  • Key (accountNo) — bigInteger — Foreign key → account.Key — NOT NULL
  • Key (productNo) — int — Foreign key → product.Key
  • Field (title) — varchar — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (regdate) — datetime — NOT NULL
  • Field (update) — datetime — NOT NULL
  • Field (hit) — int — NOT NULL
  • Field (group) — int
  • Field (depth) — int
  • Field (step) — int
  • Field (password) — varchar

saleInfo

  • Key (productNo) — int — Foreign key → product.Key — NOT NULL
  • Field (saleStartDay) — date — NOT NULL
  • Field (saleEndDay) — date — NOT NULL
  • Field2 (salePrice) — int — NOT NULL