1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
CREATE TABLE Skill ( -- omit Table Person sharing PRIMARY KEY (avoid duplicated info above)
id INT PRIMARY KEY, -- MD5 encoded
languages VARCHAR(255),
frameworks VARCHAR(255),
possessed_skills VARCHAR(255),
developing_skills VARCHAR(255)
);
INSERT INTO Skill (id, languages, frameworks, possessed_skills, developing_skills)
VALUES ('4aa37d1f4838986bc259354709bf2f5a',
'R,SQL,Python,JavaScript',
'PyTorch,vue.js,Xstate',
'Programming,Data Analysis,Product Development,Project Management',
'Natural Language Processing,Machine Learning,Full-Stack Engineering');
|