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 = 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])