+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_ssm_allege:/tablelist/okayapi_ssm_allege.html


-- MySQL Table okayapi_ssm_allege
-- From: OkayAPI.com
CREATE TABLE `okayapi_ssm_allege` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `allId` int(11) NULL COMMENT '',
    `email` varchar(80) NULL COMMENT '',
    `allEmail` varchar(80) NULL COMMENT '',
    `allReason` varchar(100) NULL COMMENT '',
    `allText` varchar(400) NULL COMMENT '',
    `allState` varchar(20) NULL COMMENT '',
    `allTime` varchar(40) NULL COMMENT '',
    `dealText` varchar(255) NULL COMMENT '',
    `dealTime` varchar(40) NULL COMMENT '',
    KEY `allId` (`allId`),
    KEY `email` (`email`),
    KEY `allEmail` (`allEmail`),
    KEY `allReason` (`allReason`),
    KEY `allText` (`allText`),
    KEY `allState` (`allState`),
    KEY `allTime` (`allTime`),
    KEY `dealText` (`dealText`),
    KEY `dealTime` (`dealTime`),
    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
allIdint(11)
emailvarchar(80)
allEmailvarchar(80)
allReasonvarchar(100)
allTextvarchar(400)
allStatevarchar(20)
allTimevarchar(40)
dealTextvarchar(255)
dealTimevarchar(40)

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_apply

MySQL Table Design okayapi_ssm_company

MySQL Table Design okayapi_ssm_resume

MySQL Table Design okayapi_ssm_stuinfo

MySQL Table Design okayapi_ssm_user

TOP ↑