数据表属性
列名 | 数据类型 | 长度 | 默认 | 主键 | 非空 | 自增 |
---|
pi_id | int | 11 | | 主键 | | |
pi_account_id | varchar | 14 | | | | |
pi_student_id | varchar | 10 | | | | |
pi_name | varchar | 30 | | | | |
pi_email | varchar | 30 | | | | |
pi_phone | varchar | 30 | | | | |
pi_password | varchar | 30 | | | | |
pi_department | varchar | 30 | | | | |
pi_verifyCode | varchar | 10 | | | | |
pi_position | int | 11 | | | | |
pi_privilege | varchar | 11 | | | | |
pi_level | int | 11 | | | | |
pi_personalsignature | varchar | 255 | | | | |
pi_gender | varchar | 2 | | | | |
sql语句
CREATE DATABASE project;
USE project;
CREATE TABLE information(
pi_id INT PRIMARY KEY AUTO_INCREMENT,
pi_account_id VARCHAR(14),
pi_student_id VARCHAR(10),
pi_name VARCHAR(30),
pi_email VARCHAR(30),
pi_phone VARCHAR(30),
pi_password VARCHAR(30),
pi_department VARCHAR(30),
pi_verifyCode VARCHAR(10),
pi_position INT,
pi_privilege INT,
pi_level INT,
pi_personalsignature VARCHAR(255),
pi_gender VARCHAR(2)
)