create table application (
current_process integer not null,
deleted bit not null,
deadline datetime(6),
id bigint not null auto_increment,
recruitment_id bigint,
user_id bigint,
career_requirement varchar(255),
company_name varchar(255),
contact varchar(255),
duty varchar(255),
employment_type enum ('INTERN','PERMANENT','TEMPORARY'),
job_description varchar(255),
location varchar(255),
position varchar(255),
preferred_qualification varchar(255),
required_capability varchar(255),
team varchar(255),
url varchar(255),
work_type varchar(255),
primary key (id)
);
insert into application
(
current_process, deleted, deadline, id, recruitment_id, user_id,
career_requirement, company_name, contact, duty, employment_type,
job_description, location, detailed_duty, preferred_qualification,
required_capability, team, url, work_type
)
values
(
null, false, null, 1, null, null, null, null, null, null,
"INTERN", null, null, null, null, null, null, null, null
)