class bs_dia_diem_nha_sach(db.Model):
__tablename__ = 'bs_dia_diem_nha_sach'
ma_dia_diem = db.Column(Integer, primary_key=True)
ten_dia_diem = db.Column(String(100), nullable=False)
vi_do = db.Column(String, nullable=False)
kinh_do = db.Column(String, nullable=False)
trang_thai = db.Column(db.Boolean)
class bs_loai_nguoi_dung(db.Model):
__tablename__ = "bs_loai_nguoi_dung"
id = db.Column(Integer, nullable=False, primary_key=True)
ten_loai_nguoi_dung = db.Column(String(255), nullable=False)
def __str__(self):
return self.ten_loai_nguoi_dung
class bs_loai_tin_tuc(db.Model):
__tablename__ = 'bs_loai_tin_tuc'
id = db.Column(Integer, primary_key=True)
ten_loai_tin = db.Column(String(200), nullable=False)
alias = db.Column(String(200), nullable=True)
def __str__(self):
return self.ten_loai_tin
class bs_tac_gia(db.Model):
__tablename__ = 'bs_tac_gia'
id = db.Column(Integer, primary_key=True)
ten_tac_gia = db.Column(String(200), nullable=False)
ngay_sinh = db.Column(String(200), nullable=False)
gioi_thieu = db.Column(String(500), nullable=True)
def __str__(self):
return self.ten_tac_gia
class bs_loai_sach(db.Model):
__tablename__ = "bs_loai_sach"
id = db.Column(Integer, nullable=False, primary_key=True)
ten_loai_sach = db.Column(String(255), nullable=False)
id_loai_cha = db.Column(Integer, nullable=False)
sap_xep = db.Column(String(255), nullable=True)
trang_thai = db.Column(db.Boolean, nullable=False)
def __str__(self):
return self.ten_loai_sach
class bs_nha_xuat_ban(db.Model):
__tablename__ = 'bs_nha_xuat_ban'
id = db.Column(Integer, primary_key=True)
ten_nha_xuat_ban = db.Column(String(100), nullable=False)
dia_chi = db.Column(String(200), nullable=False)
dien_thoai = db.Column(String(50), nullable=False)
email = db.Column(String(100), nullable=False)
def __str__(self):
return self.ten_nha_xuat_ban
class bs_khach_hang(db.Model):
__tablename__ = "bs_khach_hang"
ma_khach_hang = db.Column(db.Integer, primary_key=True)
ten_khach_hang = db.Column(db.String(100), nullable=False)
phai = db.Column(db.Boolean)
ngay_sinh = db.Column(db.DateTime)
dia_chi = db.Column(db.String(200))
dien_thoai = db.Column(db.String(20))
email = db.Column(db.String(120))
ngay_mua = db.Column(db.DateTime)
sach_mua = db.Column(db.String)
ghi_chu = db.Column(db.String)
def __str__(self):
return self.ten_khach_hang
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(100))
last_name = db.Column(db.String(100))
ma_loai_nguoi_dung = db.Column(db.String(50),
db.ForeignKey('bs_loai_nguoi_dung.id'))
loai_nguoi_dung = db.relationship('bs_loai_nguoi_dung',
backref=db.backref('user', lazy=True))
login = db.Column(db.String(80), unique=True)
email = db.Column(db.String(120))
password = db.Column(db.String(64))
@property
def is_authenticated(self):
return True
@property
def is_active(self):
return True
@property
def is_anonymous(self):
return False
def get_id(self):
return self.id
# Required for administrative interface
def __unicode__(self):
return self.last_name
def __str__(self):
return self.ho_ten
class bs_tin_tuc(db.Model):
__tablename__ = 'bs_tin_tuc'
id = db.Column(Integer, primary_key=True)
tieu_de_tin = db.Column(String(225), nullable=False)
noi_dung_tom_tat = db.Column(String(500), nullable=False)
noi_dung_chi_tiet = db.Column(String(1000), nullable=False)
trang_thai = db.Column(db.Boolean, nullable=False)
hinh_dai_dien = db.Column(String(200), nullable=False)
id_loai_tin_tuc = db.Column(Integer,
db.ForeignKey('bs_loai_tin_tuc.id'),
nullable=False)
loai_tin_tuc = db.relationship('bs_loai_tin_tuc',
backref=db.backref('bs_tin_tuc'),
lazy=True)
ngay_dang = db.Column(db.DateTime, nullable=False)
class bs_slide_banner(db.Model):
__tablename__ = 'bs_slide_banner'
id = db.Column(Integer, primary_key=True)
ten_slide = db.Column(String(255), nullable=False)
hinh = db.Column(String(255), nullable=False)
trang_thai = db.Column(db.Boolean, nullable=False)
class bs_sach(db.Model):
__tablename__ = 'bs_sach'
id = db.Column(Integer, primary_key=True)
ten_sach = db.Column(String(255), nullable=False)
id_tac_gia = db.Column(String(255),
db.ForeignKey('bs_tac_gia.id'),
nullable=False)
tac_gia = db.relationship('bs_tac_gia',
backref=db.backref('bs_sach'),
lazy=True)
gioi_thieu = db.Column(String(500), nullable=False)
doc_thu = db.Column(String(255), nullable=True)
id_loai_sach = db.Column(Integer,
db.ForeignKey('bs_loai_sach.id'),
nullable=False)
loai_sach = db.relationship('bs_loai_sach',
backref=db.backref('bs_sach'),
lazy=True)
id_nha_xuat_ban = db.Column(Integer,
db.ForeignKey('bs_nha_xuat_ban.id'),
nullable=False)
nha_xuat_ban = db.relationship('bs_nha_xuat_ban',
backref=db.backref('bs_sach'),
lazy=True)
so_trang = db.Column(Integer, nullable=True)
ngay_xuat_ban = db.Column(String(50), nullable=True)
kich_thuoc = db.Column(String(255), nullable=True)
sku = db.Column(String(255), nullable=True)
trong_luong = db.Column(String(255), nullable=True)
trang_thai = db.Column(db.Boolean, nullable=False)
hinh = db.Column(String(255), nullable=False)
don_gia = db.Column(Integer, nullable=False)
gia_bia = db.Column(Integer, nullable=False)
noi_bat = db.Column(db.Boolean, nullable=False)
def __str__(self):
return self.ten_sach
