tasks Database Table

Table: tasks

Tool: Task Management
Associated Objects: Task, Tasks2

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

tasktemplate INT UNSIGNED NOT NULL v5

tasktype INT UNSIGNED NOT NULL v5

tasktypeid INT UNSIGNED NOT NULL v5

title VARCHAR(255) NOT NULL v5

description TEXT NOT NULL v5

complete INT UNSIGNED NOT NULL DEFAULT 0 v5

taskbefore INT UNSIGNED NOT NULL DEFAULT 0 v5

active BOOL v5

added INT UNSIGNED NOT NULL v5

performby TINYINT NOT NULL v5

bonus SMALLINT UNSIGNED NOT NULL DEFAULT 0 v5

membership TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

readytoapprove BIT(1) NOT NULL DEFAULT 0 v5

priority TINYINT NOT NULL DEFAULT 5 v5

approvedby INT UNSIGNED NOT NULL DEFAULT 0 v5

ratetype SMALLINT NOT NULL DEFAULT 0 v5

hasquestion BIT(1) NOT NULL DEFAULT 0 v5

updated INT UNSIGNED NOT NULL DEFAULT 0 v5

tasklevel INT UNSIGNED NOT NULL DEFAULT 1 v5

maxcredits SMALLINT UNSIGNED NOT NULL DEFAULT 0 v5

adminapprove BIT(1) NOT NULL DEFAULT 1 v5

minutesneeded SMALL INT UNSIGNED NOT NULL DEFAULT 0 v5

awaiting TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM tasks");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $tasktemplate = $resRow["tasktemplate"];  //
 $tasktype = $resRow["tasktype"];  //
 $tasktypeid = $resRow["tasktypeid"];  //
 $title = $resRow["title"];  //
 $description = $resRow["description"];  //
 $complete = $resRow["complete"];  //
 $taskbefore = $resRow["taskbefore"];  //
 $active = $resRow["active"];  //
 $added = $resRow["added"];  //
 $performby = $resRow["performby"];  //
 $bonus = $resRow["bonus"];  //
 $membership = $resRow["membership"];  //
 $readytoapprove = $resRow["readytoapprove"];  //
 $priority = $resRow["priority"];  //
 $approvedby = $resRow["approvedby"];  //
 $ratetype = $resRow["ratetype"];  //
 $hasquestion = $resRow["hasquestion"];  //
 $updated = $resRow["updated"];  //
 $tasklevel = $resRow["tasklevel"];  //
 $maxcredits = $resRow["maxcredits"];  //
 $adminapprove = $resRow["adminapprove"];  //
 $minutesneeded = $resRow["minutesneeded"];  //
 $awaiting = $resRow["awaiting"];  //
}

Other Task Management Tables

skillassign skills supportrequests taskclientratings taskgroups taskissues tasklevels taskrecurs tasks tasksettings taskskills tasktemplates tasktimesheets

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us