gistfile1.py

class ScanIP(Base):
    __tablename__='ScanIP'
    pk = Column(Integer,Sequence('pk'), primary_key=True)
    ip = Column(VARCHAR(39))
                                                                                                                                                                                                                                                                                 

class ScanPort(Base):
    __tablename__='ScanPort'
    pk = Column(Integer,Sequence('pk'), primary_key=True)
    ip_pk= Column(Integer, ForeignKey('ScanIP.pk'))
    portnum = Column(VARCHAR(5))
    dtime = Column(DATETIME)

#so; each ip scanned will have a uniq entry in ScanIP
#each scan, if the port is open, it'll be tossed into ScanPort