Skip to content

Latest commit

 

History

History
73 lines (65 loc) · 2.41 KB

README.md

File metadata and controls

73 lines (65 loc) · 2.41 KB

Library-Management System

there are several services :

Entity-Relationship Diagram (ERD) :

this is the schema of database design systems Screenshot 2024-08-09 at 20 33 12

  • book_db: database for book-svc only have book table

book
id
title
author_id
description
category_id
stock
created_at
updated_at

  • author_db: database for author-svc only have author table

author
id
name
biography
created_at
updated_at

  • category_db: database for category-svc only have category table

category
id
name
description
created_at
updated_at

  • user_db: database for user-svc have two tables (borrowing and user)

borrowing
id
user_id
book_id
borrow_date
due_date
return_date
status

  • UserService

user
id
username
password_hash
email
created_at
updated_at