def __init__(self): clientid = PkNum('clientid') clientid.set_fk('clients') name = PkName('name') value = Text('value') cols = [clientid, name, value] Table.__init__(self, 'clientdata', cols)
def __init__(self): clientid = PkNum('clientid') clientid.set_fk('clients') ticketid = PkNum('ticketid') ticketid.set_fk('tickets') status = Name('status') Table.__init__(self, 'client_tickets', [clientid, ticketid, status])
def __init__(self, idcol, idtable, name): id_ = PkNum(idcol) id_.set_fk(idtable) tagname = PkName('tag') tagname.set_fk('tagnames') tagval = Text('value') cols = [id_, tagname, tagval] Table.__init__(self, name, cols)
def __init__(self): troubleid = PkNum('troubleid') troubleid.set_fk('troubles') actionid = AutoId('actionid', 'troubleaction_ident', pk=True) instatus = Name('instatus') outstatus = Name('outstatus') action = Name('action') workdone = Text('workdone') posted = Now('posted') cols = [troubleid, actionid, instatus, outstatus, action, workdone, posted] Table.__init__(self, 'troubleaction', cols)
def __init__(self): idcol = AutoId('locationid', 'location_ident') name = PkName('name') name.constraint.default = 'main office' addressid = PkNum('addressid') addressid.set_fk('addresses', 'addressid') isp = PkName('isp') conn = PkName('connection') ip = PkName('ip') static = Bool('static') static.constraint.pk = True serviced = Bool('serviced') serviced.constraint.pk = True cols = [idcol, name, addressid, isp, conn, ip, static, serviced] Table.__init__(self, 'locations', cols)
def __init__(self): ticketid = PkNum('ticketid') ticketid.set_fk('tickets') status = Name('status') Table.__init__(self, 'ticketstatus', [ticketid, status])
def __init__(self): actionid = PkNum('actionid') actionid.set_fk('ticketactions', 'actionid') parent = PkNum('parent') parent.set_fk('ticketactions') Table.__init__(self, 'ticketactionparent', [actionid, parent])
def __init__(self): taskid = PkNum('taskid') taskid.set_fk('tasks') locationid = PkNum('locationid') locationid.set_fk('locations', 'locationid') Table.__init__(self, 'locationtask', [taskid, locationid])
def __init__(self): taskid = PkNum('taskid') taskid.set_fk('tasks') clientid = PkNum('clientid') clientid.set_fk('clients') Table.__init__(self, 'clienttask', [taskid, clientid])