shoppingmall
Tables (8)
Untitled (item_detail)
- Key (itemdtno) — int — Primary key — NOT NULL
- Key (itemno) — int — Foreign key → Untitled.Key — NOT NULL
- Field2 (color) — varchar — NOT NULL
- Field3 (size) — varchar — NOT NULL
- Field5 (quantity) — int — NOT NULL
Untitled (item)
- Key (itemno) — int — Primary key — NOT NULL
- Field (category1) — varchar — NOT NULL
- Field2 (category2) — varchar — NOT NULL
- Field3 (name) — varchar — NOT NULL
- Field4 (price) — varchar — NOT NULL
- Field (info) — text
Untitled (commoncode)
- Key (code) — varchar — Primary key — NOT NULL
- Field (supercode) — varchar
- Field2 (enname) — varchar
- Field3 (koname) — varchar
- Field6 (info) — varchar
Untitled (qna)
- Key (qnano) — int — Primary key — NOT NULL
- Key (userno) — varchar — Foreign key → Untitled2.Key — NOT NULL
- Key (itemdtno) — int — Foreign key → Untitled.Key — NOT NULL
- Key (itemno) — int — Foreign key → Untitled.Key — NOT NULL
- 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 — NOT NULL
- Field (depth) — int — NOT NULL
- Field (step) — int — NOT NULL
Untitled2 (user)
- Key (userno) — varchar — 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
- Field2 (privilege) — tinyint — NOT NULL
Untitled2 (notice)
- Key (noticeno) — int — Primary key — NOT NULL
- Key (userno) — varchar — Foreign key → Untitled2.Key — NOT NULL
- Field (title) — varchar — NOT NULL
- Field2 (content) — varchar — NOT NULL
- Field3 (top) — tinyint — NOT NULL
- Field (regdate) — datetime — NOT NULL
- Field (update) — datetime — NOT NULL
- Field (hit) — int — NOT NULL
order
- orderno — int — Primary key — NOT NULL
- Key (itemdtno) — int — Foreign key → Untitled.Key — NOT NULL
- Key (itemno2) — int — Foreign key → Untitled.Key — NOT NULL
- Key (userno) — varchar — Foreign key → Untitled2.Key — NOT NULL