|
Lines 3953-3958
CREATE TABLE deletedbiblio_metadata (
Link Here
|
| 3953 |
CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
3953 |
CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
| 3954 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3954 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3955 |
|
3955 |
|
|
|
3956 |
-- |
| 3957 |
-- Table structure for table `illrequests` |
| 3958 |
-- |
| 3959 |
|
| 3960 |
DROP TABLE IF EXISTS `illrequests`; |
| 3961 |
CREATE TABLE illrequests ( |
| 3962 |
illrequest_id serial PRIMARY KEY, -- ILL request number |
| 3963 |
borrowernumber integer DEFAULT NULL, -- Patron associated with request |
| 3964 |
biblio_id integer DEFAULT NULL, -- Potential bib linked to request |
| 3965 |
branchcode varchar(50) NOT NULL, -- The branch associated with the request |
| 3966 |
status varchar(50) DEFAULT NULL, -- Current Koha status of request |
| 3967 |
placed date DEFAULT NULL, -- Date the request was placed |
| 3968 |
replied date DEFAULT NULL, -- Last API response |
| 3969 |
updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request |
| 3970 |
ON UPDATE CURRENT_TIMESTAMP, |
| 3971 |
completed date DEFAULT NULL, -- Date the request was completed |
| 3972 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
| 3973 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
| 3974 |
cost varchar(20) DEFAULT NULL, -- Cost of request |
| 3975 |
notesopac text DEFAULT NULL, -- Patron notes attached to request |
| 3976 |
notesstaff text DEFAULT NULL, -- Staff notes attached to request |
| 3977 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
| 3978 |
backend varchar(20) DEFAULT NULL, -- The backend used to create request |
| 3979 |
CONSTRAINT `illrequests_bnfk` |
| 3980 |
FOREIGN KEY (`borrowernumber`) |
| 3981 |
REFERENCES `borrowers` (`borrowernumber`) |
| 3982 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 3983 |
CONSTRAINT `illrequests_bcfk_2` |
| 3984 |
FOREIGN KEY (`branchcode`) |
| 3985 |
REFERENCES `branches` (`branchcode`) |
| 3986 |
ON UPDATE CASCADE ON DELETE CASCADE |
| 3987 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3988 |
|
| 3989 |
-- |
| 3990 |
-- Table structure for table `illrequestattributes` |
| 3991 |
-- |
| 3992 |
|
| 3993 |
DROP TABLE IF EXISTS `illrequestattributes`; |
| 3994 |
CREATE TABLE illrequestattributes ( |
| 3995 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
| 3996 |
type varchar(200) NOT NULL, -- API ILL property name |
| 3997 |
value text NOT NULL, -- API ILL property value |
| 3998 |
PRIMARY KEY (`illrequest_id`,`type`), |
| 3999 |
CONSTRAINT `illrequestattributes_ifk` |
| 4000 |
FOREIGN KEY (illrequest_id) |
| 4001 |
REFERENCES `illrequests` (`illrequest_id`) |
| 4002 |
ON UPDATE CASCADE ON DELETE CASCADE |
| 4003 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 4004 |
|
| 3956 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4005 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 3957 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4006 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| 3958 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
4007 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |