wp_emplmasy_employees
StaticStores emplmasy employees data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| user_id | bigint(20) unsigned | NO |
| department | varchar(100) | NO |
| designation | varchar(100) | NO |
| join_date | date | NO |
| leave_date | date | YES |
| starting_salary | decimal(10,2) | NO |
| current_salary | decimal(10,2) | NO |
| phone | varchar(20) | YES |
| street_address | text | YES |
| city | varchar(100) | YES |
| state | varchar(100) | YES |
| postal_code | varchar(20) | YES |
| country | varchar(100) | YES |
| emergency_contact_name | varchar(100) | YES |
| emergency_contact_phone | varchar(20) | YES |
| emergency_contact_relation | varchar(50) | YES |
| marital_status | varchar(20) | YES |
| status | varchar(20) | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_emplmasy_employees ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, department varchar(100) NOT NULL, designation varchar(100) NOT NULL, join_date date NOT NULL, leave_date date NULL, starting_salary decimal(10,2) NOT NULL DEFAULT '0.00', current_salary decimal(10,2) NOT NULL DEFAULT '0.00', phone varchar(20) NULL, street_address text NULL, city varchar(100) NULL, state varchar(100) NULL, postal_code varchar(20) NULL, country varchar(100) NULL, emergency_contact_name varchar(100) NULL, emergency_contact_phone varchar(20) NULL, emergency_contact_relation varchar(50) NULL, marital_status varchar(20) DEFAULT 'single', status varchar(20) DEFAULT 'active', created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY department (department), KEY join_date (join_date), KEY leave_date (leave_date) ) $charset_collate;"; dbDelta($sql);
Safe to delete?
If you have uninstalled Employee Management System, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_emplmasy_employees`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Employee Management System