|
Lines 4089-4094
CREATE TABLE IF NOT EXISTS club_fields (
Link Here
|
| 4089 |
CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE |
4089 |
CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE |
| 4090 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4090 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 4091 |
|
4091 |
|
|
|
4092 |
-- |
| 4093 |
-- Table structure for table `illrequests` |
| 4094 |
-- |
| 4095 |
|
| 4096 |
DROP TABLE IF EXISTS `illrequests`; |
| 4097 |
CREATE TABLE illrequests ( |
| 4098 |
illrequest_id serial PRIMARY KEY, -- ILL request number |
| 4099 |
borrowernumber integer DEFAULT NULL, -- Patron associated with request |
| 4100 |
biblio_id integer DEFAULT NULL, -- Potential bib linked to request |
| 4101 |
branchcode varchar(50) NOT NULL, -- The branch associated with the request |
| 4102 |
status varchar(50) DEFAULT NULL, -- Current Koha status of request |
| 4103 |
placed date DEFAULT NULL, -- Date the request was placed |
| 4104 |
replied date DEFAULT NULL, -- Last API response |
| 4105 |
updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request |
| 4106 |
ON UPDATE CURRENT_TIMESTAMP, |
| 4107 |
completed date DEFAULT NULL, -- Date the request was completed |
| 4108 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
| 4109 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
| 4110 |
cost varchar(20) DEFAULT NULL, -- Cost of request |
| 4111 |
notesopac text DEFAULT NULL, -- Patron notes attached to request |
| 4112 |
notesstaff text DEFAULT NULL, -- Staff notes attached to request |
| 4113 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
| 4114 |
backend varchar(20) DEFAULT NULL, -- The backend used to create request |
| 4115 |
CONSTRAINT `illrequests_bnfk` |
| 4116 |
FOREIGN KEY (`borrowernumber`) |
| 4117 |
REFERENCES `borrowers` (`borrowernumber`) |
| 4118 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 4119 |
CONSTRAINT `illrequests_bcfk_2` |
| 4120 |
FOREIGN KEY (`branchcode`) |
| 4121 |
REFERENCES `branches` (`branchcode`) |
| 4122 |
ON UPDATE CASCADE ON DELETE CASCADE |
| 4123 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 4124 |
|
| 4125 |
-- |
| 4126 |
-- Table structure for table `illrequestattributes` |
| 4127 |
-- |
| 4128 |
|
| 4129 |
DROP TABLE IF EXISTS `illrequestattributes`; |
| 4130 |
CREATE TABLE illrequestattributes ( |
| 4131 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
| 4132 |
type varchar(200) NOT NULL, -- API ILL property name |
| 4133 |
value text NOT NULL, -- API ILL property value |
| 4134 |
PRIMARY KEY (`illrequest_id`,`type`), |
| 4135 |
CONSTRAINT `illrequestattributes_ifk` |
| 4136 |
FOREIGN KEY (illrequest_id) |
| 4137 |
REFERENCES `illrequests` (`illrequest_id`) |
| 4138 |
ON UPDATE CASCADE ON DELETE CASCADE |
| 4139 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 4140 |
|
| 4092 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4141 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 4093 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4142 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| 4094 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
4143 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |