id | int(6) |
|
|
|
dept_code | varchar(6) |
|
|
|
desc | varchar(50) |
|
|
|
head_emp_no | varchar(6) |
|
|
|
phone | varchar(15) |
|
|
|
dept_type | varchar(11) |
|
|
|
from_age | int(5) |
|
|
0
|
to_age | int(5) |
|
|
120
|
gender | varchar(20) |
|
|
both
|
created_date | timestamp |
|
|
CURRENT_TIMESTAMP
|
created_by | int(11) |
|
|
|
modified_date | timestamp |
|
|
0000-00-00 00:00:00.000000
|
modified_by | int(11) |
|
|
|
locationname | varchar(20) |
|
|
|