~2021.03.06
Tables (10)
AuthEmail
- emailId — int(20) — Primary key — NOT NULL
- userId (userId2) — int(20) — Foreign key → User.userId — NOT NULL — Create Date(8) + Random Number(12)
- expireDate — datetime
- email — varchar(255)
- authKey — varChar(255)
- sendDate — datetime
Contents
- contentId — Primary key — NOT NULL
- imageId — int(20) — Foreign key → Image.imageId — NOT NULL
- fileId — int(20) — Foreign key → File.fileId — NOT NULL
- title — varchar(255)
- startDate — datetime
- endDate — datetime
- organization — varchar(255)
- text — longtext
- selected — int(1)
- sequence — int(11)
- skillId — int(20) — Foreign key → SkillTag.skillId — NOT NULL
- iconPath — varchar(255) — Foreign key → SkillTag.iconPath — NOT NULL
File
- fileId — int(20) — Primary key — NOT NULL
- name — varchar(255)
- path — varchar(255)
- type — varchar(255)
- byteSize — int(11)
Image
- imageId — int(20) — Primary key — NOT NULL
- name — varchar(255)
- path — varchar(255)
- type — varchar(255)
- byteSize — int(11)
- width — int(11)
- height — int(11)
Login
- loginId — int(30) — Primary key — NOT NULL
- userId — int(20) — Foreign key → User.userId — NOT NULL — Create Date(8) + Random Number(12)
- success — int(1)
- loginDate — datetime
- loginIp — varchar(255)
Person
- personId — int(20) — Primary key — NOT NULL — Create Date(8) + Random Number(12)
- name — varchar(255)
- email — varchar(255)
- tel — varchar(255)
- homepageUrl — varchar(255)
- infoReceive — int(1) — 0 = nothing 1 = email 2 = sms 3 = email & sms
- profileImageId — int(20) — NOT NULL
Portfolio
- portfolioId — int(20) — Primary key — NOT NULL
- userId — int(20) — Foreign key → User.userId — NOT NULL — Create Date(8) + Random Number(12)
- lastUpdateIp — varchar(255)
- lastUpdateDate — varchar(255)
- title — varchar(255)
- nickname — varchar(255)
- Introduction — varchar(1000)
- contentId — Foreign key → Contents.contentId — NOT NULL
Role
- userId — int(20) — Foreign key → User.userId — NOT NULL — Create Date(8) + Random Number(12)
- authority — int(1) — 0 = admin 1 = user
SkillTag
- skillId — int(20) — Primary key — NOT NULL
- iconPath — varchar(255) — Primary key — NOT NULL
- name — varchar(255)
- description — varchar(255)
User
- userId — int(20) — Primary key — NOT NULL — Create Date(8) + Random Number(12)
- personId — int(20) — Foreign key → Person.personId — NOT NULL — Create Date(8) + Random Number(12)
- password — int(255) — default length = 12
- passwordUpdateDate — datetime
- userName — varChar(20)
- status — int(1) — 1 = enable 2 = disable
- createIp — varchar(255)
- lastUpdateIp — varchar(255) — NOT NULL
- lastUpdateDate — datetime
- userInfoUpdateCount — int(8)