Lines 3137-3145
DROP TABLE IF EXISTS `issues`;
Link Here
|
3137 |
/*!40101 SET character_set_client = utf8 */; |
3137 |
/*!40101 SET character_set_client = utf8 */; |
3138 |
CREATE TABLE `issues` ( |
3138 |
CREATE TABLE `issues` ( |
3139 |
`issue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key for issues table', |
3139 |
`issue_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key for issues table', |
3140 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table for the patron this item was checked out to', |
3140 |
`borrowernumber` int(11) NOT NULL COMMENT 'foreign key, linking this to the borrowers table for the patron this item was checked out to', |
3141 |
`issuer_id` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table for the user who checked out this item', |
3141 |
`issuer_id` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the borrowers table for the user who checked out this item', |
3142 |
`itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key, linking this to the items table for the item that was checked out', |
3142 |
`itemnumber` int(11) NOT NULL COMMENT 'foreign key, linking this to the items table for the item that was checked out', |
3143 |
`date_due` datetime DEFAULT NULL COMMENT 'datetime the item is due (yyyy-mm-dd hh:mm::ss)', |
3143 |
`date_due` datetime DEFAULT NULL COMMENT 'datetime the item is due (yyyy-mm-dd hh:mm::ss)', |
3144 |
`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', |
3144 |
`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', |
3145 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues', |
3145 |
`returndate` datetime DEFAULT NULL COMMENT 'date the item was returned, will be NULL until moved to old_issues', |
3146 |
- |
|
|