search

sjasthi / learnandhelp

Learn and Help: Learn programming and help different causes.
MIT License
0 stars 10 forks source link

(FP3) Refactoring of "book" table (schema changes) #20

Closed sjasthi closed 1 year ago

sjasthi commented 1 year ago

[1] change the "book" table name to "books" table.

[2] Remove these 4 columns from the "books" table.

library_id createdByLibraryID contribution_id donatedBy

[3] add "available' field to the table (0 = not available [ 1 = available)

[4] Add "date_created" and "date_modified" columns to "books" table. These are auto-filled by the database.These should not show up on any form.