+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_ssm_user:/tablelist/okayapi_ssm_user.html


-- MySQL Table okayapi_ssm_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_ssm_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `email` varchar(255) NULL COMMENT '',
    `okayapi_ssm_user_password` varchar(255) NULL COMMENT '',
    `okayapi_ssm_user_type` varchar(255) NULL COMMENT '',
    `state` varchar(255) NULL COMMENT '',
    KEY `email` (`email`),
    KEY `okayapi_ssm_user_password` (`okayapi_ssm_user_password`),
    KEY `okayapi_ssm_user_type` (`okayapi_ssm_user_type`),
    KEY `state` (`state`),
    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-4 of 4 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
emailvarchar(255)Normal Index
okayapi_ssm_user_passwordvarchar(255)
okayapi_ssm_user_typevarchar(255)
statevarchar(255)

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_company

MySQL Table Design okayapi_ssm_resume

MySQL Table Design okayapi_ssm_stuinfo

TOP ↑