Lines 3127-3135
DROP TABLE IF EXISTS `issues`;
Link Here
|
3127 |
/*!40101 SET character_set_client = utf8 */; |
3127 |
/*!40101 SET character_set_client = utf8 */; |
3128 |
CREATE TABLE `issues` ( |
3128 |
CREATE TABLE `issues` ( |
3129 |
`issue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key for issues table', |
3129 |
`issue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key for issues table', |
3130 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table for the patron this item was checked out to', |
3130 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key, linking this to the borrowers table for the patron this item was checked out to', |
3131 |
`issuer_id` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table for the user who checked out this item', |
3131 |
`issuer_id` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table for the user who checked out this item', |
3132 |
`itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the items table for the item that was checked out', |
3132 |
`itemnumber` int(11) NOT NULL COMMENT 'foreign key, linking this to the items table for the item that was checked out', |
3133 |
`date_due` datetime DEFAULT NULL COMMENT 'datetime the item is due (yyyy-mm-dd hh:mm::ss)', |
3133 |
`date_due` datetime DEFAULT NULL COMMENT 'datetime the item is due (yyyy-mm-dd hh:mm::ss)', |
3134 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out', |
3134 |
`branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out', |
3135 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues', |
3135 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues', |
3136 |
- |
|
|