Enneagram

Tables (8)

Untitled (member)

  • Key (mno) — int — Primary key — NOT NULL
  • Field (id) — varchar
  • Field (password) — varchar
  • Field (name) — varchar
  • Field (nickname) — varchar
  • Field (gender) — varchar
  • Field (tel) — varchar
  • Field (email) — varchar
  • Field (birth) — datetime
  • Field (regdate) — datetime
  • Field (moddate) — datetime
  • Field (category) — varchar — 사용자 관리자
  • Field (naver) — int

Untitled (board)

  • Key (bno) — int — Primary key — NOT NULL
  • Key (mno) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar
  • Field (category) — varchar
  • Field (content) — varchar
  • Field (regdate) — datetime
  • Field (moddate) — datetime
  • Field (id) — varchar
  • Field (nickname) — varchar
  • Field (cnt) — int
  • Field (rcnt) — int
  • Field (likey) — int

Untitled (reply)

  • Key (rno) — int — Primary key — NOT NULL
  • Key (mno) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (bno) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — varchar
  • Field (rname) — varchar
  • Field (rpassword) — varchar
  • Field (regdate) — datetime
  • Field (category) — int

Untitled (personality)

  • Key (pno) — int — Primary key — NOT NULL
  • Key (mno) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — int
  • Field (regdate) — datetime
  • Field (elcass) — int
  • Field (one) — int
  • Field (two) — int
  • Field (three) — int
  • Field (four) — int
  • Field (five) — int
  • Field (six) — int
  • Field (seven) — int
  • Field (eight) — int
  • Field (nine) — int

Untitled (enneagram)

  • Key (eno) — int — Primary key — NOT NULL
  • Field (category) — varchar — enneagram history eclass type
  • Field (title) — varchar
  • Field (content) — varchar
  • Field (type) — int
  • Field (eclass) — int — 1 : 머리형 2 : 가슴형 3 : 장형

Untitled (attach)

  • Key (atno) — int — Primary key — NOT NULL
  • Key (bno) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (mno) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (uuid) — varchar
  • Field (originalFileName) — varchar
  • Field (uploadPath) — varchar
  • Field (mappingURL) — varchar
  • Field (realName) — varchar

Untitled (likey)

  • Key (lno) — int — Primary key — NOT NULL
  • Key (bno) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (mno) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (regdata) — datetime

Untitled (query)

  • Key (qno) — int — Primary key — NOT NULL
  • Field (query) — varchar
  • Field (type) — int