+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
emailvarchar(100)Normal Index
okayapi_ssm_company_namevarchar(100)
websitevarchar(100)
cityvarchar(100)
select_industry_hiddenvarchar(100)
select_scale_hiddenvarchar(100)
temptationvarchar(300)
principalvarchar(100)
phonevarchar(100)

Guess You Like

MySQL Table Design okayapi_pt_tab_position

MySQL Table Design okayapi_pt_tab_receiveorders

MySQL Table Design okayapi_pt_tab_releaseorders

MySQL Table Design okayapi_pt_tab_school

MySQL Table Design okayapi_pt_tab_user

MySQL Table Design okayapi_ssm_allege

MySQL Table Design okayapi_ssm_apply

MySQL Table Design okayapi_ssm_resume

MySQL Table Design okayapi_ssm_stuinfo

MySQL Table Design okayapi_ssm_user

TOP ↑