models.py 660 B

123456789101112131415161718
  1. # Database Models
  2. from . import db # that SQLAlchemy Object in __init__.py
  3. from flask_login import UserMixin
  4. from sqlalchemy.sql import func
  5. class User(db.Model, UserMixin): # User Database
  6. id = db.Column(db.Integer, primary_key=True)
  7. email = db.Column(db.String(150), unique=True)
  8. password = db.Column(db.String(150))
  9. username = db.Column(db.String(150))
  10. class Bookmark(db.Model, UserMixin):
  11. id = db.Column(db.Integer, primary_key=True)
  12. owner = db.Column(db.Integer) # owner id
  13. status = db.Column(db.String(8)) # public/private
  14. name = db.Column(db.String(150))
  15. group = db.Column(db.String(150))
  16. link = db.Column(db.String(150))