-
Notifications
You must be signed in to change notification settings - Fork 0
/
models.py
26 lines (22 loc) · 969 Bytes
/
models.py
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
from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
class Book(db.Model):
__tablename__ = "books"
id = db.Column(db.Integer, primary_key=True)
isbn = db.Column(db.String, nullable=False)
title = db.Column(db.String, nullable=False)
author = db.Column(db.String, nullable=False)
year = db.Column(db.Integer, nullable=False)
class User(db.Model):
__tablename__ = "users"
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String, nullable=False)
email = db.Column(db.String, nullable=False)
password = db.Column(db.String, nullable=False)
class Review(db.Model):
__tablename__ = "reviews"
id = db.Column(db.Integer, primary_key=True)
isbn = db.Column(db.String, nullable=False)
user = db.Column(db.String, nullable=False)
rating = db.Column(db.Integer, nullable=False)
review = db.Column(db.String, nullable=False)