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

Untitled

    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