+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_pt_tab_user:/tablelist/okayapi_pt_tab_user.html


-- MySQL Table okayapi_pt_tab_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_pt_tab_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `sid` int(11) NOT NULL COMMENT '学校编号',
    `username` varchar(255) NOT NULL COMMENT '用户名',
    `okayapi_pt_tab_user_password` varchar(255) NOT NULL COMMENT '密码',
    `gender` varchar(10) NOT NULL COMMENT '性别',
    `phone` varchar(255) NOT NULL COMMENT '手机号',
    `email` varchar(255) NOT NULL COMMENT '邮箱地址',
    `totalscore` int(11) NOT NULL COMMENT '被评总分',
    `appraisenum` int(255) NOT NULL COMMENT '评价人数',
    `permission` int(11) NOT NULL COMMENT '权限 0为普通用户 99为管理员',
    KEY `sid` (`sid`),
    KEY `username` (`username`),
    KEY `okayapi_pt_tab_user_password` (`okayapi_pt_tab_user_password`),
    KEY `gender` (`gender`),
    KEY `phone` (`phone`),
    KEY `email` (`email`),
    KEY `totalscore` (`totalscore`),
    KEY `appraisenum` (`appraisenum`),
    KEY `permission` (`permission`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'pt校园兼职-用户';

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
sidint(11)学校编号
usernamevarchar(255)用户名
okayapi_pt_tab_user_passwordvarchar(255)密码
gendervarchar(10)性别
phonevarchar(255)手机号
emailvarchar(255)邮箱地址
totalscoreint(11)被评总分
appraisenumint(255)评价人数
permissionint(11)权限 0为普通用户 99为管理员

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_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

MySQL Table Design okayapi_ssm_user

TOP ↑