|
id
|
bigint(20) unsigned
|
|
|
|
|
position_id
|
int(10) unsigned
|
|
|
|
|
job_summary
|
text
|
|
|
|
|
duties
|
text
|
|
|
|
|
education_requirement
|
text
|
|
|
|
|
training_requirement
|
text
|
|
|
|
|
experience_requirement
|
text
|
|
|
|
|
eligibility_requirement
|
text
|
|
|
|
|
competency_notes
|
text
|
|
|
|
|
document_version
|
varchar(40)
|
|
|
|
|
effective_from
|
date
|
|
|
|
|
effective_to
|
date
|
|
|
|
|
updated_by
|
int(10) unsigned
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|