| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /nginx/html/JimMartinson/CST2146/_Archive/ExampleFiles/ |
Upload File : |
costcenter costcenterId departmentId costcenterNumber costcenterDescription department departmentId departmentCode departmentName departmentDescription department_user departmentId userId department_user_relationshiptypeId department_userComment department_user_relationshiptype department_user_relationshiptypeId department_user_relationshiptypeName department_user_relationshiptypeDescription equipment - equipment data equipmentId - (int auto) unique record Id for an equipment locationId projectId equipmentstatusId equipmentName equipmentDescription equipmentValue equipmentComment equipmentReceivedDate equipmenttype equipmenttypeId equipmenttypeName equipmenttypeDescription equipmentstatus - the status of an equipment equipmentstatusId equipmentstatusName - The short name of the equipmentstatus. (pre-bid out-for-bid never-to-be-ordered on-order on-site disposed) equipmentstatusDescription - longer equipmentstatus description equipmentstatusInactive location - location data locationId locationcampusId locationName locationDescription locationInactive locationComment locationcampus locationcampusId locationcampusName locationcampusDescription locationcampusInactive locationcampusComment project - project data (for ordering and use) projectId projectName projectDescription projectstatusgroupId locationId projectComment projectOwnerId project_department projectId departmentId project_departmentComment AddedOn AddedBy projectstatus projectstatusId projectstatusName In progress. On hold, Completed, Abandoned, Closed, Not started, Bid out, Bid in, Order out, Order in, Scrapped projectstatusDescription projectstatusgroupId projectstatusInactive AddedOn AddedBy ModifiedOn ModifiedBy projectstatusgroup projectstatusgroupId projectstatusgroupName projectstatusgroupDescription projectstatusgroupInactive AddedOn AddedBy ModifiedOn ModifiedBy project_user projectId userId project_user_relationshiptypeId project_userComment project_user_relationshiptype project_user_relationshiptypeId project_user_relationshiptypeName project_user_relationshiptypeDescription vendor - vendor data vendorId vendorstatusId vendor_equipmenttype vendorId equipmenttypeId vendor_equipmenttypeComment order orderId userId bidId orderRfaDate (request-for-authorization) orderAuthDate (authorized) orderOrderDate (ordered) orderPOno (Purchase Order Number) order_biditem - link the order to the items ordered - starts with all bid items. orderId biditemId order_biditemReceivedDate bid bidId projectId vendorId bidShippingCost bidTax userId bidSentDate bidReceivedDate biditem biditemId bidId equipmentId biditemCost biditemComment