class Account(Base):

    __tablename__ = 'account'


    account_id = Column(Integer, primary_key=True)
    username = Column(String(256), index=True)
    password = Column(String(256))
    status = Column(String(64)) # locked / needs activation / active etc..
    address_id = Column(Integer, ForeignKey('address.address_id'))
    created_on = Column(TIMESTAMP, server_default=func.now())

    account_address = association_proxy('account_address', 'address',
        creator=lambda address: AccountAddress(address=address)


class AccountAddress(Base):
    """ `AccountAddress` links an `Account` to an `Address`. """
    __tablename__ = 'account_address'

    account_id = Column(Integer, ForeignKey('account.account_id'), primary_key=True)
    address_id = Column(Integer, ForeignKey('address.address_id'), primary_key=True)

    address = relation('Address')
    account = relation('Account', backref=backref('account_address'))


class Address(Base):
    """ `Address` holds contact information for payments and accounts. """
    __tablename__ = 'address'

    address_id = Column(Integer, primary_key=True)
    firstname = Column(String(256))
    lastname = Column(String(256))
    email = Column(String(256))
    address1 = Column(String(256))
    address2 = Column(String(256))
    zipcode = Column(String(16))
    company = Column(String(256))
    telephone = Column(String(256))
    mobile = Column(String(256))

    created_on = Column(TIMESTAMP, server_default=func.now())
    account_address = relation('Account', secondary=AccountAddress, backref='address')