def __init__(selff):
dbClass = dbTable('abstract_of_canvass')
dbClass.column('canvassnum', 'character varying(50)', True)
dbClass.column('bidnum', 'character varying(50)', False)
dbClass.column('dateofquotation', 'date', False)
dbClass.column('dateopen', 'date', False)
dbClass.column('recomendation', 'text', False)
dbClass.column('sel_approval', 'boolean', False)
#====================================================================
dbClassItems = dbTable('abstract_of_canvass_items')
dbClassItems.column('canvassnum', 'character varying(15)', False)
dbClassItems.column('itemnum', 'integer', False)
dbClassItems.column('description', 'character varying(250)', False)
dbClassItems.column('unit', 'character varying(150)', False)
dbClassItems.column('quantity', 'double precision', False)
#====================================================================
dbClassSupp = dbTable('abstract_of_canvass_supplier_price')
dbClassSupp.column('canvassnum', 'character varying(50)', False)
dbClassSupp.column('supplier', 'character varying(150)', False)
dbClassSupp.column('itemnum', 'integer', False)
dbClassSupp.column('unitprice', 'double precision', False)
dbClassSupp.column('sel_approval', 'boolean', False)
dbClassSupp.column('reason', 'character varying(250)', False)
dbClassSupp.column('bid_item_descrip', 'character varying(250)', False)
def __init__(self):
dbClass = dbTable('req_for_quotation')
dbClass.column('quotationnum','character varying(15)', True)
dbClass.column('refnum','character varying(50)', False)
dbClass.column('projname','character varying(255)', False)
dbClass.column('projlocation','character varying(255)', False)
dbClass.column('datecreated','date', False)
dbClass.column('canvasser','character varying(150)', False)
dbClass.column('counter','integer', False)
#=============================================================
dbClassItems = dbTable('req_for_quotation_items')
dbClassItems.column('quotationnum','character varying(25)', False)
dbClassItems.column('itemnum','integer', False)
dbClassItems.column('description','character varying(250)', False)
dbClassItems.column('quantity','double precision', False)
dbClassItems.column('unit','character varying(50)', False)
dbClassItems.column('unitprice','double precision', False)
#=============================================================
dbClassSupp = dbTable('req_for_quotation_suppliers')
dbClassSupp.column('quotationnum','character varying(15)', False)
dbClassSupp.column('compid','character varying(15)', False)
dbClassSupp.column('warrantyper','double precision', False)
dbClassSupp.column('delperiod','double precision', False)
dbClassSupp.column('pricevalidity','double precision', False)
def __init__(self):
dbClass = dbTable('asset')
dbClass.column('asset_id','character varying(10)',True)
dbClass.column('itemid','character varying(15)',False)
dbClass.column('description','character varying(250)',False)
dbClass.column('brand','character varying(150)',False)
dbClass.column('type','character varying(80)',False)
dbClass.column('class','character varying(80)',False)
dbClass.column('unit','character varying(50)',False)
dbClass.column('unit_price','double precision',False)
dbClass.column('date_of_update','date',False)
#==========================================================
dbClassInv = dbTable('inventory')
dbClassInv.column('invnum','integer', True)
dbClassInv.column('parnum','character varying(25)', False)
dbClassInv.column('description','character varying(255)', False)
dbClassInv.column('unit','character varying(50)', False)
dbClassInv.column('unitprice','double precision', False)
dbClassInv.column('quantity','double precision', False)
dbClassInv.column('status','boolean', False)
dbClassInv.column('assetid','character varying(10)', False)
dbClassInv.column('serialnum','character varying(50)', False)
dbClassInv.column('iarnum','character varying(15)', False)
#==========================================================
dbClassInvW = dbTable('inventory_without_invnum')
dbClassInvW.column('invnum','integer', True)
dbClassInvW.column('parnum','character varying(25)', False)
dbClassInvW.column('description','character varying(255)', False)
dbClassInvW.column('unit','character varying(50)', False)
dbClassInvW.column('unitprice','double precision', False)
dbClassInvW.column('quantity','double precision', False)
dbClassInvW.column('status','boolean', False)
dbClassInvW.column('assetid','character varying(10)', False)
dbClassInvW.column('serialnum','character varying(50)', False)
dbClassInvW.column('iarnum','character varying(15)', False)
#==========================================================
dbClassEquiP = dbTable('equip_particulars')
dbClassEquiP.column('idname','character varying(15)', True)
dbClassEquiP.column('name','character varying(255)', False)
dbClassEquiP.column('subhead','character varying(15)', False)
dbClassEquiP.column('itemnum','character varying(10)', False)
def __init__(self):
dbClass = dbTable('log')
dbClass.column('logid','varchar(15)',True)
dbClass.column('idnum','varchar(15)',False)
dbClass.column('accttype','integer',False)
dbClass.column('datetimeloggoed','date',False)
def __init__(self):
dbClass = dbTable('insp_and_accept_report')
dbClass.column('iarnum', 'character varying(15)', True)
dbClass.column('ponum', 'character varying(15)', False)
dbClass.column('reqoff', 'character varying(180)', False)
dbClass.column('podate', 'date', False)
dbClass.column('recieptnum', 'character varying(150)', False)
dbClass.column('recieptdate', 'date', False)
dbClass.column('insstatus', 'boolean', False)
dbClass.column('insdate', 'date', False)
dbClass.column('insofficer', 'character varying(255)', False)
dbClass.column('isitemcomplete', 'boolean', False)
dbClass.column('receivedate', 'date', False)
dbClass.column('receiveofficer', 'character varying(255)', False)
dbClass.column('counter', 'integer', False)
#==========================================================================
dbClassItems = dbTable('iar_items')
dbClassItems.column('iarnum', 'character varying(15)', False)
dbClassItems.column('stocknum', 'integer', False)
dbClassItems.column('unit', 'character varying(50)', False)
dbClassItems.column('description', 'character varying(255)', False)
dbClassItems.column('quantity', 'double precision', False)
dbClassItems.column('itemid', 'character varying(15)', False)
dbClassItems.column('assetid', 'character varying(15)', False)
dbClassItems.column('serialid', 'character varying(100)', False)
dbClassItems.column('workdate', 'character varying(15)', False)
dbClassItems.column('unitcost', 'double precision', False)
dbClassItems.column('workstatmiss', 'double precision', False)
dbClassItems.column('compltstatus', 'boolean', False)
#=============================================================================
dbClassItems = dbTable('liquidating_damages')
dbClassItems.column('ldcode', 'character varying(10)', False)
dbClassItems.column('ponum', 'character varying(10)', False)
dbClassItems.column('iarnum', 'character varying(10)', False)
dbClassItems.column('damage_cost', 'double precision', False)
dbClassItems.column('delay_days', 'integer', False)
dbClassItems.column('datecreated', 'date', False)
def __init__(self):
dbClass = dbTable('purchase_order')
dbClass.column('ponum', 'character varying(50)', True)
dbClass.column('supplier', 'character varying(255)', False)
dbClass.column('datecreated', 'date', False)
dbClass.column('procmode', 'character varying(150)', False)
dbClass.column('dateofdelivery', 'date', False)
dbClass.column('placeofdelivery', 'character varying(250)', False)
dbClass.column('deliveryterm', 'integer', False)
dbClass.column('paymentterm', 'character varying(25)', False)
dbClass.column('amount', 'double precision', False)
dbClass.column('status', 'boolean', False)
dbClass.column('deliverystatus', 'boolean', False)
dbClass.column('paymentstatus', 'boolean', False)
dbClass.column('conforme', 'character varying(255)', False)
dbClass.column('prref', 'character varying(15)', False)
dbClass.column('counter', 'integer', False)
dbClass.column('fundref', 'character varying', False)
dbClass.column('approval_date', 'date', False)
dbClass.column('serve_date', 'date', False)
dbClass.column('poappnum', 'character varying(10)', False)
#=================================================================================
dbClassItems = dbTable('purchase_order_items')
dbClassItems.column('ponum', 'character varying(15)', False)
dbClassItems.column('itemnum', 'integer', False)
dbClassItems.column('quantity', 'double precision', False)
dbClassItems.column('unit', 'character varying(50)', False)
dbClassItems.column('description', 'text', False)
dbClassItems.column('unitcost', 'double precision', False)
#======================================================================================
dbClassItemChk = dbTable('purchase_order_items_checker')
dbClassItemChk.column('ponum', 'character varying(10)', False)
dbClassItemChk.column('itemnum', 'integer', False)
dbClassItemChk.column('profiledcheck', 'boolean', False)
dbClassItemChk.column('deliveredcomplete', 'boolean', False)
dbClassItemChk.column('deliveredmiss', 'double precision', False)
def __init__(self):
self.dbClass = dbTable('users')
self.dbClass.column('uname', 'varchar(50)', True)
self.dbClass.column('pass', 'varchar(50)', False)
self.dbClass.column('idnum', 'varchar(15)', False)
self.dbClass.column('access_type', 'integer[]', False)
self.dbClass.column('profile_pic', 'bytea', False)
self.dbClass.column('status', 'boolean', False)
#===================================================================
dbClassDev = dbTable('devusers')
dbClassDev.column('uname', 'character varying(25)', True)
dbClassDev.column('password', 'character varying(50)', False)
dbClassDev.column('acctype', 'integer', False)
dbClassDev.column('name', 'character varying(255)', False)
def __init__(self):
dbClass = dbTable('waste_mat_report')
dbClass.column('reqnum', 'character varying(10)', True)
dbClass.column('wmrnum', 'character varying(10)', False)
dbClass.column('datecreated', 'date', False)
dbClass.column('requestid', 'character varying(10)', False)
dbClass.column('parref', 'character varying(10)', False)
dbClass.column('status', 'boolean', False)
dbClass.column('status_date', 'date', False)
dbClass.column('inspetor', 'character varying(10)', False)
dbClass.column('counter', 'integer', False)
#=============================================================================
dbClassItems = dbTable('wmr_items')
dbClassItems.column('reqnum', 'character varying(10)', False)
dbClassItems.column('invnum', 'integer', False)
def __init__(self):
dbClass = dbTable('req_iss_slip')
dbClass.column('slipnum','character varying(10)',True)
dbClass.column('risnum','character varying(10)',False)
dbClass.column('purpose','text',False)
dbClass.column('datecreated','date',False)
dbClass.column('requestid','character varying(10)',False)
dbClass.column('status','boolean',False)
dbClass.column('statusreason','character varying(255)',False)
dbClass.column('statusdate','date',False)
dbClass.column('counter','integer',False)
dbClass.column('releasestatus','boolean',False)
dbClass.column('releasedate','date',False)
dbClass.column('receivedby','character varying(10)',False)
#=========================================================================
dbClassItems = dbTable('ris_items')
dbClassItems.column('slipnum','character varying(10)', True)
dbClassItems.column('stocknum','integer', False)
dbClassItems.column('description','character varying(250)', False)
dbClassItems.column('unit','character varying(50)', False)
dbClassItems.column('quantity','double precision', False)
dbClassItems.column('quantityapproved','double precision', False)
#==========================================================================
dbClassSuppInv = dbTable('supply_inventory')
dbClassSuppInv.column('id','character varying(10)', True)
dbClassSuppInv.column('description','character varying(250)', False)
dbClassSuppInv.column('type','character varying(50)', False)
dbClassSuppInv.column('unit','character varying(50)', False)
dbClassSuppInv.column('itemid','character varying(10)', False)
dbClassSuppInv.column('quantity','double precision', False)
dbClassSuppInv.column('initquantity','double precision', False)
dbClassSuppInv.column('latestup','date', False)
def __init__(self):
dbClass = dbTable('transactions')
dbClass.column('id', 'character varying(15)', True)
dbClass.column('transtype', 'character varying(25)', False)
dbClass.column('by', 'character varying(15)', False)
dbClass.column('transdate', 'date', False)
dbClass.column('transtime', 'time without time zone', False)
dbClass.column('title', 'character varying(255)', False)
dbClass.column('msg1', 'character varying(255)', False)
dbClass.column('msg2', 'character varying(255)', False)
dbClass.column('reftransnum', 'character varying(15)', False)
def __init__(self):
self.dbClass = dbTable('employees')
self.dbClass.column('idnum', 'varchar(15)', True)
self.dbClass.column('fname', 'varchar(100)', False)
self.dbClass.column('sname', 'varchar(100)', False)
self.dbClass.column('designation', 'varchar(100)', False)
self.dbClass.column('dept', 'varchar(50)', False)
self.dbClass.column('rank', 'varchar(25)', False)
self.dbClass.column('title', 'varchar(25)', False)
self.dbClass.column('mname', 'varchar(100)', False)
self.dbClass.column('suffix', 'varchar(10)', False)
self.dbClass.column('picfile', 'varchar(255)', False)
def __init__(self):
dbClass = dbTable('items')
dbClass.column('itemid', 'character varying(10)', True)
dbClass.column('description', 'character varying(255)', False)
dbClass.column('type', 'character varying(15)', False)
dbClass.column('class', 'character varying(15)', False)
dbClass.column('unit', 'character varying(10)', False)
dbClass.column('price', 'double precision', False)
dbClass.column('prcounter', 'integer', False)
dbClass.column('riscounter', 'integer', False)
dbClass.column('quantityonrequest', 'double precision', False)
dbClass.column('category', 'character varying(10)', False)
def __init__(self):
dbClass = dbTable('property_acc_receipt')
dbClass.column('parnum', 'character varying(15)', True)
dbClass.column('dateofpar', 'date', False)
dbClass.column('receiveby', 'character varying(25)', False)
dbClass.column('datereceiveby', 'date', False)
dbClass.column('receivefrom', 'character varying(25)', False)
dbClass.column('datereceivefrom', 'date', False)
dbClass.column('ponum', 'character varying(15)', False)
dbClass.column('counter', 'integer', False)
dbClass.column('partype', 'character varying(15)', False)
dbClass.column('iarnumref', 'character varying(15)', False)
def __init__(self):
self.dbClass = dbTable('suppliers')
self.dbClass.column('compid','character varying(25)', True)
self.dbClass.column('name','character varying(255)',False)
self.dbClass.column('address','character varying(250)',False)
self.dbClass.column('comprep','character varying(250)',False)
self.dbClass.column('reptel','character varying(50)',False)
self.dbClass.column('repemail','character varying(50)',False)
self.dbClass.column('comptin','character varying(50)',False)
self.dbClass.column('dateadded','date',False)
self.dbClass.column('rating','integer',False)
self.dbClass.column('ratingupdate','date',False)
def __init__(self):
dbClass = dbTable('notifications')
dbClass.column('notifnum', 'character varying(15)', True)
dbClass.column('fromid', 'character varying(15)', False)
dbClass.column('toid', 'character varying(15)', False)
dbClass.column('status', 'boolean', False)
dbClass.column('priority', 'integer', False)
dbClass.column('notifref', 'character varying(30)', False)
dbClass.column('details', 'character varying(250)[]', False)
dbClass.column('dateofnotif', 'date', False)
dbClass.column('timeofnotif', 'time without time zone', False)
dbClass.column('type', 'integer', False)
dbClass.column('reftype', 'character varying(25)', False)
dbClass.column('linkred', 'character varying(150)', False)
def __init__(self):
dbClass = dbTable('keypositions')
dbClass.column('id','varchar(10)',True)
dbClass.column('empid','varchar(15)',False)
def __init__(self):
dbClass = dbTable('insp_and_accept_report_2')
dbClass.column('iarnum', 'character varying(15)', True)
dbClass.column('iardate', 'date', False)
dbClass.column('ponum', 'character varying(15)', False)
dbClass.column('expdate', 'date', False)
dbClass.column('asses', 'boolean', False)
dbClass.column('recieptnum', 'character varying(150)', False)
dbClass.column('recieptdate', 'date', False)
dbClass.column('supplier', 'character varying(255)', False)
dbClass.column('insdate', 'date', False)
dbClass.column('insofficer', 'character varying(255)', False)
dbClass.column('receivedate', 'date', False)
dbClass.column('receiveofficer', 'character varying(255)', False)
dbClass.column('isitemcomplete', 'boolean', False)
dbClass.column('counter', 'integer', False)
#==========================================================================
dbClassItems = dbTable('iar_items')
dbClassItems.column('iarnum', 'character varying(15)', False)
dbClassItems.column('stocknum', 'integer', False)
dbClassItems.column('unit', 'character varying(50)', False)
dbClassItems.column('description', 'character varying(255)', False)
dbClassItems.column('quantity', 'double precision', False)
dbClassItems.column('itemid', 'character varying(15)', False)
dbClassItems.column('assetid', 'character varying(15)', False)
dbClassItems.column('serialid', 'character varying(100)', False)
dbClassItems.column('workdate', 'character varying(15)', False)
dbClassItems.column('unitcost', 'double precision', False)
dbClassItems.column('workstatmiss', 'double precision', False)
dbClassItems.column('compltstatus', 'boolean', False)
#==========================================================================
dbClassLiqDam = dbTable('liquidating_damages')
dbClassLiqDam.column('ldcode', 'character varying(10)', False)
dbClassLiqDam.column('ponum', 'character varying(10)', False)
dbClassLiqDam.column('iarnum', 'character varying(10)', False)
dbClassLiqDam.column('damage_cost', 'double precision', False)
dbClassLiqDam.column('delay_days', 'integer', False)
dbClassLiqDam.column('datecreated', 'date', False)
#===============================================================================
dbClassLatSupUp = dbTable('latest_supply_update')
dbClassLatSupUp.column('iarnum', 'character varying(15)', False)
dbClassLatSupUp.column('update', 'date', False)
#===============================================================================
dbClassRecItem = dbTable('received_items')
dbClassRecItem.column('iarnum', 'character varying(15)', False)
dbClassRecItem.column('availability', 'boolean', False)
dbClassRecItem.column('description', 'character varying(255)', False)
dbClassRecItem.column('quantity', 'double precision', False)
dbClassRecItem.column('price', 'double precision', False)
dbClassRecItem.column('itemnum', 'integer', False)