Untitled
unknown
plain_text
a year ago
339 B
5
Indexable
CREATE TABLE Book_Return (
Issue_id INT(10) PRIMARY KEY,
Actual_date_of_return DATE,
Late_days INT(10),
Late_fee INT(10),
FOREIGN KEY (Issue_id) REFERENCES Book_Issue (Issue_id)
);
CREATE TABLE Late_Fee_Rule (
From_days INT(5),
To_days INT(5),
Amount INT(5),
PRIMARY KEY (From_days, To_days, Amount)
);Editor is loading...
Leave a Comment