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