Skip to content

Commit 92d3bb8

Browse files
authored
Create jobs.sql
1 parent 1f17ccf commit 92d3bb8

File tree

1 file changed

+15
-0
lines changed

1 file changed

+15
-0
lines changed

lagou/jobs.sql

Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,15 @@
1+
CREATE TABLE `jobs` (
2+
`id` int(11) NOT NULL AUTO_INCREMENT,
3+
`positionName` varchar(45) DEFAULT NULL,
4+
`workYear` varchar(45) DEFAULT NULL,
5+
`salary` varchar(45) DEFAULT NULL,
6+
`city` varchar(45) DEFAULT NULL,
7+
`education` varchar(100) DEFAULT NULL,
8+
`positionAdvantage` varchar(100) DEFAULT NULL,
9+
`companyLabelList` varchar(100) DEFAULT NULL,
10+
`financeStage` varchar(45) DEFAULT NULL,
11+
`companySize` varchar(45) DEFAULT NULL,
12+
`industryField` varchar(100) DEFAULT NULL,
13+
`firstType` varchar(100) DEFAULT NULL,
14+
PRIMARY KEY (`id`)
15+
)

0 commit comments

Comments
 (0)