스킨공작소

테이블 (16)

Member

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Field (AVATAR_ID) — NOT NULL
  • Field (NICKNAME) — NOT NULL
  • Field

Untitled (Catagory)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Field (CATE_NAME) — NOT NULL

Untitled (Sell)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (ITEM_ID) — NOT NULL — 외래 키 → Untitled2.Key — NOT NULL
  • Key (MEMBER_ID) — NOT NULL — 외래 키 → Member.Key — NOT NULL
  • Field (TEXT) — NULL
  • Field (TITLE) — NOT NULL
  • Field (CREATED) — NOT NULL
  • Field (STATUS) — NOT NULL
  • Field (LIKE_CNT) — NOT NULL
  • Field (VIEW_CNT) — NOT NULL

Untitled (Sell_Image)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (SELL_ID) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (PICTURE_PATH) — NOT NULL

Untitled (VIEWER_HISTORY)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (MEMBER_ID) — NOT NULL — 외래 키 → Member.Key — NOT NULL
  • Key (SELL_ID) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL

Untitled (LIKE_HISTORY)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (MEMBER_ID) — NOT NULL — 외래 키 → Member.Key — NOT NULL
  • Key (SELL_ID) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL

Untitled (Review)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (MEMBER_ID) — NOT NULL — 외래 키 → Member.Key — NOT NULL
  • Field (Text) — NOT NULL
  • Field (Star) — NOT NULL

Untitled (Shop)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (member) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (created) — NOT NULL
  • Field (hello) — NULL

Untitled (sale)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (shop) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Key (item) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (created) — NOT NULL
  • Field (status) — NOT NULL
  • Field (text) — NOT NULL

Untitled (member)

  • Key — 기본 키 — NOT NULL

Untitled (item)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (cate) — 외래 키 → Untitled.Key — NOT NULL
  • Field (item_name) — NOT NULL
  • Field (price) — NOT NULL

Untitled (like_history)

  • Key — 기본 키 — NOT NULL
  • Key (Key2) — 외래 키 → Untitled.Key — NOT NULL
  • Key (Key3) — 외래 키 → Untitled.Key — NOT NULL

Untitled (review)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (member) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Key (sale) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (star) — NOT NULL
  • Field (text) — NOT NULL

Untitled (Category)

  • Key — 기본 키 — NOT NULL

Untitled (Images)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (sale_id) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (imgPath) — NOT NULL

Untitled2 (Item)

  • Key (id) — NOT NULL — 기본 키 — NOT NULL
  • Key (CATE_ID) — NOT NULL — 외래 키 → Untitled.Key — NOT NULL
  • Field (NAME) — NOT NULL
  • Field (PRICE) — NOT NULL