Chanyeong

Tables (7)

Untitled (userInfo)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (level) — ADMIN — NOT NULL
  • Field (userId) — VARCHAR(20) — NOT NULL
  • Field (password) — VARCHAR(200) — NOT NULL
  • Field (familyName) — VARCHAR(15) — NOT NULL
  • Field (firstName) — VARCHAR(20) — NOT NULL
  • Field2 (refreshToken) — VARCHAR(200)

Untitled (skill)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(30) — NOT NULL
  • Field (level) — INT — NOT NULL
  • Field (description) — TEXT — NOT NULL
  • Field (icon) — VARCHAR(200) — NOT NULL

Untitled (post)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (category) — VARCHAR(20) — NOT NULL
  • Field (title) — VARCHAR(40) — NOT NULL
  • Field (content) — TEXT — NOT NULL
  • Field (titleImage) — VARCHAR(200)
  • Field (createdAt) — DATETIME — NOT NULL
  • Field (updatedAt) — DATETIME — NOT NULL

Untitled (tag)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL

postTag

  • Key (postId) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (tagId) — INT — Foreign key → Untitled.Key — NOT NULL

project

  • Key (id) — INT — Primary key — NOT NULL
  • Field (type) — INDIVIDUAL | GROUP — NOT NULL
  • Field (groupName) — VARCHAR(20)
  • Field (title) — VARCHAR(100) — NOT NULL
  • Field (subTitle) — TEXT — NOT NULL
  • Field (content) — TEXT — NOT NULL
  • Field (startDate) — DATE — NOT NULL
  • Field (endDate) — DATE
  • Field (githubAddr) — VARCHAR(200)
  • Field (titleImage) — VARCHAR(200)
  • Field (contribution) — INT — NOT NULL
  • Field (picked) — BOOLEAN — NOT NULL
  • Field (createdAt) — DATETIME — NOT NULL
  • Field (updatedAt) — DATETIME

projectSkill

  • Key (projectId) — INT — Foreign key → project.Key — NOT NULL
  • Key (skillId) — INT — Foreign key → Untitled.Key — NOT NULL