CREATE TABLE IF NOT EXISTS `issue_reservation` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`issue_id` bigint(20) DEFAULT NULL,
|
`workspace_id` bigint(20) DEFAULT NULL,
|
`reservation` varchar(10) DEFAULT NULL,
|
`issue_reservation_type` varchar(10) DEFAULT NULL,
|
`register_id` bigint(20) NOT NULL,
|
`register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`modify_id` bigint(20) NOT NULL,
|
`modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
PRIMARY KEY (`id`),
|
KEY `workspaceIdIndex` (`workspace_id`),
|
KEY `issueIdIndex` (`issue_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
