| 208 |
- |
1 |
## Table: ticket
|
|
|
2 |
#
|
|
|
3 |
# +-------------------+--------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +-------------------+--------------+------+-----+---------+-------+
|
|
|
6 |
# | id | varchar(24) | NO | PRI | NULL | |
|
|
|
7 |
# | event_name | varchar(45) | YES | | NULL | |
|
|
|
8 |
# | order_date | datetime | YES | | NULL | |
|
|
|
9 |
# | ticket_type | varchar(45) | YES | | NULL | |
|
|
|
10 |
# | first_name | varchar(45) | YES | | NULL | |
|
|
|
11 |
# | last_name | varchar(45) | YES | | NULL | |
|
|
|
12 |
# | email | varchar(45) | YES | | NULL | |
|
|
|
13 |
# | derby_name | varchar(255) | YES | | NULL | |
|
|
|
14 |
# | wrstbnd_accountid | varchar(24) | YES | UNI | NULL | |
|
|
|
15 |
# +-------------------+--------------+------+-----+---------+-------+
|
|
|
16 |
|
|
|
17 |
CREATE TABLE `ticket` (
|
|
|
18 |
`id` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
19 |
`event_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
20 |
`order_date` datetime DEFAULT NULL,
|
|
|
21 |
`ticket_type` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
22 |
`first_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
23 |
`last_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
24 |
`email` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
25 |
`derby_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
26 |
`wrstbnd_accountid` varchar(24) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
27 |
PRIMARY KEY (`id`),
|
|
|
28 |
UNIQUE KEY `id_UNIQUE` (`id`),
|
|
|
29 |
UNIQUE KEY `wrstbnd_accountid_UNIQUE` (`wrstbnd_accountid`)
|
|
|
30 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|