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