class User(UserMixin, db.Model):
    __tablename__ = 'user'
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(15), unique=True)
    email = db.Column(db.String(50), unique=True)
    password = db.Column(db.String(80))
    role= db.Column(db.String(20));
    usersessiontoken = db.Column(db.String(500), unique=True)
    hasstorage = db.Column(db.Integer, db.ForeignKey('storageinformation.allocatedstorage'))
    hasavailablestorage = db.Column(db.Integer, db.ForeignKey('storageinformation.availablestorage'))

    storageinformation = db.relationship('StorageInformation', backref='user')

class StorageInformation(UserMixin, db.Model):
    __tablename__ = 'storageinformation'
    id = db.Column(db.Integer, primary_key=True)
    allocatedstorage = db.Column(db.Integer)
    availablestorage = db.Column(db.Integer)

sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1215, 'Cannot add foreign key constraint') [SQL: 'nCREATE TABLE user (ntid INTEGER NOT NULL AUTO_INCREMENT, ntusername VARCHAR(15), ntemail VARCHAR(50), ntpassword VARCHAR(80), nt`role` VARCHAR(20), ntusersessiontoken VARCHAR(500), nthasstorage INTEGER, nthasavailablestorage INTEGER, ntPRIMARY KEY (id), ntUNIQUE (username), ntUNIQUE (email), ntUNIQUE (usersessiontoken), ntFOREIGN KEY(hasstorage) REFERENCES storageinformation (allocatedstorage), ntFOREIGN KEY(hasavailablestorage) REFERENCES storageinformation (availablestorage)n)nn']