| 208 |
- |
1 |
## Table: department
|
|
|
2 |
#
|
|
|
3 |
# +-------------+---------------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +-------------+---------------------+------+-----+---------+-------+
|
|
|
6 |
# | TLA | char(5) | NO | PRI | NULL | |
|
|
|
7 |
# | name | varchar(45) | NO | | NULL | |
|
|
|
8 |
# | autoapprove | tinyint(3) unsigned | NO | | NULL | |
|
|
|
9 |
# | description | varchar(512) | YES | | NULL | |
|
|
|
10 |
# | link | varchar(45) | YES | | NULL | |
|
|
|
11 |
# +-------------+---------------------+------+-----+---------+-------+
|
|
|
12 |
|
|
|
13 |
CREATE TABLE `department` (
|
|
|
14 |
`TLA` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
15 |
`name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
16 |
`autoapprove` tinyint(3) unsigned NOT NULL,
|
|
|
17 |
`description` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
18 |
`link` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
19 |
PRIMARY KEY (`TLA`),
|
|
|
20 |
UNIQUE KEY `TLA_UNIQUE` (`TLA`)
|
|
|
21 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|