애옹

테이블 (8)

Untitled (skill)

  • Field (id) — varchar — 외래 키 → user_info.Field
  • Key (category_no) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name)

Untitled (board)

  • Key (board_no) — 기본 키 — NOT NULL
  • Field (id) — varchar — 외래 키 → user_info.Field
  • Field2 (title) — varchar
  • Field (name) — varchar
  • Field3 (content) — varchar
  • Field (rgst_dt) — DATETIME

Untitled (reply)

  • Key (reply_no) — INT — 기본 키 — NOT NULL
  • Key (board_no) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Field (id) — varchar — 외래 키 → Untitled.Field
  • Field (text) — varchar
  • Field2 (rgst_dt) — DATETIME

Untitled (buy)

  • Key (buy_no) — INT — 기본 키 — NOT NULL
  • Field (id) — varchar — 외래 키 → user_info.Field
  • Key (type_no) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name)
  • Field (price) — INT
  • Field (state) — char

Untitled (sell)

  • Key (sell_no) — INT — 기본 키 — NOT NULL
  • Field (id) — varchar — 외래 키 → user_info.Field
  • Key (type_no) — 외래 키 → Untitled.Key — NOT NULL
  • Field (name)
  • Field (prive) — INT
  • Field (state) — char

Untitled (book_type)

  • Key (type_no) — 기본 키 — NOT NULL
  • Field (type)

Untitled (skill_category)

  • Key (category_no) — 기본 키 — NOT NULL
  • Field (category_nm)

user_info

  • Field (id) — varchar — 기본 키
  • Field2 (pw) — varchar
  • Field (name) — varchar
  • Field (dept) — varchar
  • Field (state) — varchar
  • Field (objective)
  • Field (profile_url)
  • Field (email)
  • Field (github)
  • Field (phone)