Library-management-system/models.py at main · AJAY2-R/Library-management-system · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
from flask_sqlalchemy import SQLAlchemy
db=SQLAlchemy()


class Book(db.Model):
    id=db.Column(db.Integer,primary_key=True)
    title=db.Column(db.String(200),nullable=False)
    author=db.Column(db.String(200))
    isbn=db.Column(db.String(20))
    publisher=db.Column(db.String(100))
    page=db.Column(db.Integer,default=0)
    stocks = db.relationship('Stock', back_populates='book', cascade='all, delete-orphan')

class Member(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), nullable=False)
    email = db.Column(db.String(100))
    phone = db.Column(db.String(15))
    address = db.Column(db.String(200))

class Transaction(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    member_id = db.Column(db.Integer, db.ForeignKey('member.id'), nullable=False)
    book_id = db.Column(db.Integer, db.ForeignKey('book.id'), nullable=False)
    issue_date = db.Column(db.DateTime, nullable=False)
    return_date = db.Column(db.DateTime)
    rent_fee = db.Column(db.Float, default=0.0)

class Stock(db.Model):
    id=db.Column(db.Integer,primary_key=True)
    book_id=db.Column(db.Integer,db.ForeignKey('book.id'),nullable=False)
    total_quantity=db.Column(db.Integer,default=0)
    available_quantity=db.Column(db.Integer,default=0)
    borrowed_quantity=db.Column(db.Integer,default=0)
    total_borrowed=db.Column(db.Integer,default=0)
    book = db.relationship('Book', back_populates='stocks')

class Charges(db.Model):
    id=db.Column(db.Integer,primary_key=True)
    rentfee=db.Column(db.Integer)