Key.py

from sqlalchemy import Column, Integer, ForeignKey, String

from pilab.database import Base, MAC, SERIAL, IP



class KeyType(Base):
    __tablename__ = "keys"
    id = Column(Integer, primary_key=True)
    owner = Column(String)
    host_key = Column(String)

class KeyBindingType(Base):
    __tablename__ = "key_bindings"
    key_id = Column(Integer, ForeignKey('keys.id'), primary_key=True)
    pi_id = Column(Integer, ForeignKey('pis.host_id'), primary_key=True)