MySQL Create Table SQL
Table Structure: okayapi_ssm_company:/tablelist/okayapi_ssm_company.html
-- MySQL Table okayapi_ssm_company
-- From: OkayAPI.com
CREATE TABLE `okayapi_ssm_company` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`email` varchar(100) NULL COMMENT '',
`okayapi_ssm_company_name` varchar(100) NULL COMMENT '',
`website` varchar(100) NULL COMMENT '',
`city` varchar(100) NULL COMMENT '',
`select_industry_hidden` varchar(100) NULL COMMENT '',
`select_scale_hidden` varchar(100) NULL COMMENT '',
`temptation` varchar(300) NULL COMMENT '',
`principal` varchar(100) NULL COMMENT '',
`phone` varchar(100) NULL COMMENT '',
KEY `email` (`email`),
KEY `okayapi_ssm_company_name` (`okayapi_ssm_company_name`),
KEY `website` (`website`),
KEY `city` (`city`),
KEY `select_industry_hidden` (`select_industry_hidden`),
KEY `select_scale_hidden` (`select_scale_hidden`),
KEY `temptation` (`temptation`),
KEY `principal` (`principal`),
KEY `phone` (`phone`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '大学生兼职-公司';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-9 of 9 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
varchar(100) | 否 | Normal Index | ||||
okayapi_ssm_company_name | varchar(100) | 是 | ||||
website | varchar(100) | 是 | ||||
city | varchar(100) | 是 | ||||
select_industry_hidden | varchar(100) | 是 | ||||
select_scale_hidden | varchar(100) | 是 | ||||
temptation | varchar(300) | 是 | ||||
principal | varchar(100) | 是 | ||||
phone | varchar(100) | 是 |