okayapi_course_apply - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_course_apply：/tablelist/okayapi_course_apply.html


-- MySQL Table okayapi_course_apply
-- From: OkayAPI.com
CREATE TABLE `okayapi_course_apply` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `contact_phone` varchar(20) NOT NULL COMMENT '授课教师电话',
    `teacher_name` varchar(20) NOT NULL COMMENT '预约教师名字',
    `appointed_phone` varchar(255) NOT NULL COMMENT '预约人电话',
    `appointed_time` datetime NOT NULL COMMENT '预约时间',
    `address` varchar(200) NOT NULL COMMENT '预约地址',
    `lesson_type` varchar(50) NOT NULL COMMENT '授课级别',
    `order_number` varchar(20) NOT NULL COMMENT '预约编号',
    `course_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '课程状态（0待确认 1已预约 3已完成 4已过期）',
    `appointed_sex` varchar(10) NOT NULL COMMENT '性别',
    KEY `contact_phone` (`contact_phone`),
    KEY `teacher_name` (`teacher_name`),
    KEY `appointed_phone` (`appointed_phone`),
    KEY `appointed_time` (`appointed_time`),
    KEY `address` (`address`),
    KEY `lesson_type` (`lesson_type`),
    KEY `order_number` (`order_number`),
    KEY `course_status` (`course_status`),
    KEY `appointed_sex` (`appointed_sex`),
    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 Name	Field Type	Default	IS NULL	Field Comment	Demo Data
contact_phone	varchar(20)		否	授课教师电话
teacher_name	varchar(20)		否	预约教师名字
appointed_phone	varchar(255)		否	预约人电话
appointed_time	datetime		是	预约时间
address	varchar(200)		是	预约地址
lesson_type	varchar(50)		是	授课级别
order_number	varchar(20)		否	预约编号
course_status	tinyint(4)	0	否	课程状态（0待确认 1已预约 3已完成 4已过期）	0
appointed_sex	varchar(10)		否	性别