monthlytest1
Tables (5)
BBS
- bbsSeq — int — Primary key — NOT NULL
- userEmail — varchar(50) — Foreign key → User.userEmail — NOT NULL — userId
- title — varchar(100) — NOT NULL
- threePoem — varchar(100) — NOT NULL
- experience — longtext
- profile — longBlob
- salary — int — NOT NULL
MEMBER
- 아이디 (id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(255) — NOT NULL
TechStack
- techSeq — int — Primary key — NOT NULL
- java — int
- javaScript — int
- python — int
- kotlin — int
- swift — int
- typeScript — int
- c — int
- c++ — int
- reactJS — int
- redux — int
- vueJS — int
- angularJS — int
- nextJS — int
- spring — int
- nodeJS — int
- nestJS — int
- unity — int
- flask — int
- mySQL — int
- mongoDB — int
User
- userEmail — varchar(50) — Primary key — NOT NULL — userId
- userName — varchar(20) — NOT NULL — userName
- userPwd — varchar(20) — NOT NULL — userPwd
- userBirth — varchar(10) — NOT NULL — userBirth
- userPhone — varchar(20) — NOT NULL — userPhone
UserSkill
- userEmail — varchar(50) — Foreign key → User.userEmail — NOT NULL — userId
- techSeq — int — Foreign key → TechStack.techSeq — NOT NULL