NoForeignKeys

class User(db.Model):
    __tablename__ = 'User'
    can_create = False
    id = db.Column('id', db.Integer, primary_key=True)
    first = db.Column('first', db.String(15), nullable=False)
    last = db.Column('last', db.String(25), nullable=False)
    username = db.Column('username', db.String(80), unique=True, nullable=False)
    password = db.Column('password', db.String(80), nullable=False)
    phonenumber = db.Column('phonenumber', db.Integer, nullable=False)
    dob = db.Column('dob', db.DateTime, nullable=False)
    admin = db.Column('isadmin', db.Boolean, default=False, nullable=False)

    def __init__(self, first=None, last=None, username=None, password=None, phonenumber=None, dob=None):
        self.first = first
        self.last = last
        self.username = username
        self.password = password
        self.phonenumber = phonenumber
        self.dob = dob

    def type_formatter(view, value):
        pass

    def is_authenticated(self):
        return True

    def is_active(self):
        return True

    def is_anonymous(self):
        return False

    def get_id(self):
        return unicode(self.id)

    def __repr__(self):
        return '<User %r>' % self.username


class Contact(db.Model):
    __tablename__ = 'Contact'
    id = db.Column('id', db.Integer, primary_key=True)
    first = db.Column('first', db.String(15), nullable=False)
    last = db.Column('last', db.String(25), nullable=False)
    street = db.Column('street', db.String(80), nullable=False)
    city = db.Column('city', db.String(80), nullable=False)
    state = db.Column('state', db.String(80), nullable=False)
    zipcode = db.Column('zipcode', db.String(80), nullable=False)
    phonenumber = db.Column('phonenumber', db.Integer, nullable=False)
    Policy = db.relationship('Policy', backref='policy', lazy='dynamic')

    def __repr__(self):
        return '<Contact %r>' % self.id


class Policy(db.Model):
    __tablename__ = 'Policy'
    id = db.Column('id', db.Integer, primary_key=True)
    policy_number = db.Column('policy_number', db.Integer)
    policy_type = db.Column('policy_type', db.String(25))
    contact_id = db.Column(db.Integer, db.ForeignKey('contact.id'))

    def __repr__(self):
        return '<Policy %r>' % self.id


class Letter(db.Model):
    __tablename__ = 'Letter'
    id = db.Column('id', db.Integer, primary_key=True)
    title = db.Column('title', db.String)
    description = db.Column('description', db.String)
    template = db.Column('template', db.Text)

    def __repr__(self):
        return '<Letter %r>' % self.id


admin.add_view(ModelView(User, db.session))
admin.add_view(ModelView(Contact, db.session))
admin.add_view(ModelView(Policy, db.session))
admin.add_view(ModelView(Letter, db.session))