amer-sabah / bookshelf

0 stars 5 forks source link

Database schema & data scripts #37

Closed AsemLab closed 2 years ago

AsemLab commented 2 years ago

Schema EDITED.txt

AsemLab commented 2 years ago

books.txt

MohammadNidal99 commented 2 years ago

Library_Owners.txt Books_in_Library.txt

maiqamaj commented 2 years ago

customer.txt

maiqamaj commented 2 years ago

buy_operations.txt

Amalqazaq commented 2 years ago

borrow_operations.txt

ahmaddrabkah commented 2 years ago

Final update on schema (add id to books_in_library) and all data

Schema_final.txt data.txt

AsemLab commented 2 years ago

UPDATE

Add AUTO_INCREAMENT to all primary keys and update the data script according to this edit.

Schema_final.txt

data.txt

maiqamaj commented 2 years ago

UPDATE Add new table booksbag

Schema_final.txt data.txt

Leenaiman98 commented 2 years ago

data.txt

ahmaddrabkah commented 2 years ago

Last update of the schema Schema_last_update.txt data_last_update.txt

AsemLab commented 2 years ago

Books & categories tables data

books_&_categories.txt

ahmaddrabkah commented 2 years ago

Last update for schema (add id column to permission table) and last update for data (add books and categories) Schema_last_update.txt data_last_update.txt

Amalqazaq commented 2 years ago

last update on data (add books_in_library and borrow_op data_last_update.txt erations )

Leenaiman98 commented 2 years ago

data_last_last_updated.txt

ahmaddrabkah commented 2 years ago

Last update for schema (add status column to libraries table) and last update for data (books_ratings and libraries_ratings )

data_last_updated.txt Schema_last_update.txt

maiqamaj commented 2 years ago

buy_operations.txt

last update on data (add to buy_operations)

maiqamaj commented 2 years ago

data_last_updated.txt

Schema_last_update (1).txt

Last update for schema (change column in buy_operations) and last update for data (buy_operations)

ahmaddrabkah commented 2 years ago

Last update for schema (borrow_operations table as BorrowOperation entity) and last update for data (borrow_operations )

Schema_last_update.1.txt data_last_updated.txt

AsemLab commented 2 years ago

Update the borrow operations data

data_last_updated.txt

Amalqazaq commented 2 years ago

Last update on schema (add status column in borrow_operations) and update data for week 1 (not include update from @AsemLab ) new_data.txt

AsemLab commented 2 years ago

Update the data accorrding to @Amalqazaq modifications

data_last_updated.txt