| 208 |
- |
1 |
## Table: class
|
|
|
2 |
#
|
|
|
3 |
# +------------+------------------+------+-----+---------+----------------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +------------+------------------+------+-----+---------+----------------+
|
|
|
6 |
# | id | int(10) unsigned | NO | PRI | NULL | auto_increment |
|
|
|
7 |
# | name | varchar(128) | YES | | NULL | |
|
|
|
8 |
# | coach | int(10) unsigned | YES | | NULL | |
|
|
|
9 |
# | assistant | int(10) unsigned | YES | | NULL | |
|
|
|
10 |
# | date | date | YES | | NULL | |
|
|
|
11 |
# | location | varchar(45) | YES | | NULL | |
|
|
|
12 |
# | level | varchar(45) | YES | | NULL | |
|
|
|
13 |
# | start_time | time | YES | | NULL | |
|
|
|
14 |
# | end_time | time | YES | | NULL | |
|
|
|
15 |
# | note | mediumtext | YES | | NULL | |
|
|
|
16 |
# | capacity | int(10) unsigned | YES | | NULL | |
|
|
|
17 |
# | wrstbnd_id | varchar(24) | YES | UNI | NULL | |
|
|
|
18 |
# +------------+------------------+------+-----+---------+----------------+
|
|
|
19 |
|
|
|
20 |
CREATE TABLE `class` (
|
|
|
21 |
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
|
22 |
`name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
23 |
`coach` int(10) unsigned DEFAULT NULL,
|
|
|
24 |
`assistant` int(10) unsigned DEFAULT NULL,
|
|
|
25 |
`date` date DEFAULT NULL,
|
|
|
26 |
`location` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
27 |
`level` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
28 |
`start_time` time DEFAULT NULL,
|
|
|
29 |
`end_time` time DEFAULT NULL,
|
|
|
30 |
`note` mediumtext COLLATE utf8mb4_unicode_ci,
|
|
|
31 |
`capacity` int(10) unsigned DEFAULT NULL,
|
|
|
32 |
`wrstbnd_id` varchar(24) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
33 |
PRIMARY KEY (`id`),
|
|
|
34 |
UNIQUE KEY `id_UNIQUE` (`id`),
|
|
|
35 |
UNIQUE KEY `wrstbnd_id_UNIQUE` (`wrstbnd_id`)
|
|
|
36 |
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|