employees Database Table

Table: employees

Tool: Employee Management
Associated Objects: Employees, Employee

Fields

mincreditsaminute TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

name VARCHAR(255) NOT NULL v5

email VARCHAR(255) NOT NULL v5

password VARCHAR(255) NULL v2

maxhours TINYINT NOT NULL v5

hourlrate SMALLINT UNSIGNED NOT NULL v5

vacationhours DECIMAL(8,2) NOT NULL v5

cashadvanced SMALLINT UNSIGNED NOT NULL v5

bio VARCHAR(255) NOT NULL v5

flexiblehours BIT(1) NOT NULL DEFAULT 0 v5

minoutsideshift SMALLINT NOT NULL v5

getsbonus BIT(1) NOT NULL DEFAULT 1 v5

ftpaccess BIT(1) NOT NULL DEFAULT 0 v5

skype VARCHAR(100) NOT NULL v5

active BIT(1) NOT NULL DEFAULT 1 v5

onschedule BIT(1) NOT NULL DEFAULT 1 v5

creditsaminute TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

lastactivity INT UNSIGNED NOT NULL DEFAULT 0 v5

cellphone VARCHAR(30) NOT NULL v5

added INT UNSIGNED NOT NULL v5

description VARCHAR(255) NOT NULL v5

manager BIT(1) 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 employees");
while ($resRow = $results->fetch_assoc())
{
 $mincreditsaminute = $resRow["mincreditsaminute"];  //
 $id = $resRow["id"];  //
 $name = $resRow["name"];  //
 $email = $resRow["email"];  //
 $password = $resRow["password"];  //
 $maxhours = $resRow["maxhours"];  //
 $hourlrate = $resRow["hourlrate"];  //
 $vacationhours = $resRow["vacationhours"];  //
 $cashadvanced = $resRow["cashadvanced"];  //
 $bio = $resRow["bio"];  //
 $flexiblehours = $resRow["flexiblehours"];  //
 $minoutsideshift = $resRow["minoutsideshift"];  //
 $getsbonus = $resRow["getsbonus"];  //
 $ftpaccess = $resRow["ftpaccess"];  //
 $skype = $resRow["skype"];  //
 $active = $resRow["active"];  //
 $onschedule = $resRow["onschedule"];  //
 $creditsaminute = $resRow["creditsaminute"];  //
 $lastactivity = $resRow["lastactivity"];  //
 $cellphone = $resRow["cellphone"];  //
 $added = $resRow["added"];  //
 $description = $resRow["description"];  //
 $manager = $resRow["manager"];  //
}

Other Employee Management Tables

employeebonuses employees employeeschedule managerscores monitorimages nudges timesheet timesheets

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us