| id |
bigint(20)
|
|
|
|
| company_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| department |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| mobile |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| room |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| role |
enum('superadmin', 'manager', 'member')
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('active', 'inactive')
|
utf8mb4_unicode_ci
|
|
|
| emp_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| erp_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| designation |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| unit |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| sub_unit |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| date_of_join |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| emp_category |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| shift_in_time |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|