MySQL Create Table SQL
Table Structure: okayapi_pt_tab_school：/tablelist/okayapi_pt_tab_school.html
-- MySQL Table okayapi_pt_tab_school
-- From: OkayAPI.com
CREATE TABLE `okayapi_pt_tab_school` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`sid` int(11) NOT NULL COMMENT '学校编号',
`sname` varchar(255) NOT NULL COMMENT '学校名',
KEY `sid` (`sid`),
KEY `sname` (`sname`),
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-2 of 2 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| sid | int(11) | 否 | 学校编号 | |||
| sname | varchar(255) | 否 | 学校名 |
