Web Marketing Tool
Reseller
Chris B.
employees
Login

Table: employees

Additional metadata for members that are employees.

Tool: Employee Management
Associated Objects: Employees, Employee

Fields

mincreditsaminute TINYINT UNSIGNED DEFAULT 0 v4.94
id INT UNSIGNED NOT NULL AUTO_INCREMENT v2
name VARCHAR(255) NULL v2
Employee Name
email VARCHAR(255) NULL v2
Employee Email
password VARCHAR(255) NULL v2
Employee Password
maxhours TINYINT(4) NULL v2
Max Working Hours
hourlrate SMALLINT(5) UNSIGNED v2
Hourly Rate
etype TINYINT(4) v2
Employee Type
startdate INT(10) UNSIGNED v2
When employee start working
vacationhours FLOAT v2
Vacation hours
cashadvanced SMALLINT(5) UNSIGNED v2
bio VARCHAR(255) v2
lastname VARCHAR(60) v2
Employee Last Name
flexiblehours TINYINT(1) NULL DEFAULT 0 v2
minoutsideshift SMALLINT(6) v2
Minutes outside shift
notes VARCHAR(255) v2
Notes
getsbonus TINYINT(1) NULL DEFAULT 1 v2
Get Bonus
ftpaccess TINYINT(1) NULL DEFAULT 0 v2
FTP Access
skype VARCHAR(100) v2
SKYPE
city VARCHAR(25) v2
City
active TINYINT(1) NULL DEFAULT 1 v2
Active
onschedule TINYINT(1) NULL DEFAULT 1 v2
On Schedule
creditsaminute TINYINT(3) UNSIGNED DEFAULT 0 v2
Credits per minutes
lastactivity INT(10) UNSIGNED NOT NULL DEFAULT 0 v2
Last Activity
cellphone VARCHAR(30) v2
Cell Phone


Example PHP Usage

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


Other Employee Management Tables

employeebonus     employees     employeeschedule     managerscores     monitorimage     nudge     schedule     skillassign     skills     timesheet    



webmarketingtool.com Webutation DMCA.com Protection Status Authorize.net GoDaddy
Valid HTML! Valid CSS!


Reseller: Chris Brevig
|
Login
(502) 225-3237