Lines 4425-4442
CREATE TABLE itemtypes_branches( -- association table between authorised_values
Link Here
|
4425 |
|
4425 |
|
4426 |
DROP TABLE IF EXISTS `return_claims`; |
4426 |
DROP TABLE IF EXISTS `return_claims`; |
4427 |
CREATE TABLE return_claims ( |
4427 |
CREATE TABLE return_claims ( |
4428 |
id int(11) auto_increment, |
4428 |
id int(11) auto_increment, -- Unique ID of the return claim |
4429 |
itemnumber int(11) NOT NULL, |
4429 |
itemnumber int(11) NOT NULL, -- ID of the item |
4430 |
issue_id int(11) NULL DEFAULT NULL, |
4430 |
issue_id int(11) NULL DEFAULT NULL, -- ID of the checkout that triggered the claim |
4431 |
borrowernumber int(11) NOT NULL, |
4431 |
borrowernumber int(11) NOT NULL, -- ID of the patron |
4432 |
notes MEDIUMTEXT DEFAULT NULL, |
4432 |
notes MEDIUMTEXT DEFAULT NULL, -- Notes about the claim |
4433 |
created_on TIMESTAMP NULL, |
4433 |
created_on TIMESTAMP NULL, -- Time and date the claim was created |
4434 |
created_by int(11) NULL DEFAULT NULL, |
4434 |
created_by int(11) NULL DEFAULT NULL, -- ID of the staff member that registered the claim |
4435 |
updated_on TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP, |
4435 |
updated_on TIMESTAMP NULL ON UPDATE CURRENT_TIMESTAMP, -- Time and date of the latest change on the claim (notes) |
4436 |
updated_by int(11) NULL DEFAULT NULL, |
4436 |
updated_by int(11) NULL DEFAULT NULL, -- ID of the staff member that updated the claim |
4437 |
resolution varchar(80) NULL DEFAULT NULL, |
4437 |
resolution varchar(80) NULL DEFAULT NULL, -- Resolution code (RETURN_CLAIM_RESOLUTION AVs) |
4438 |
resolved_on TIMESTAMP NULL DEFAULT NULL, |
4438 |
resolved_on TIMESTAMP NULL DEFAULT NULL, -- Time and date the claim was resolved |
4439 |
resolved_by int(11) NULL DEFAULT NULL, |
4439 |
resolved_by int(11) NULL DEFAULT NULL, -- ID of the staff member that resolved the claim |
4440 |
PRIMARY KEY (`id`), |
4440 |
PRIMARY KEY (`id`), |
4441 |
KEY `itemnumber` (`itemnumber`), |
4441 |
KEY `itemnumber` (`itemnumber`), |
4442 |
CONSTRAINT UNIQUE `issue_id` ( issue_id ), |
4442 |
CONSTRAINT UNIQUE `issue_id` ( issue_id ), |