DDL.txt

CREATE TABLE profile(
    profile_id INTEGER NOT NULL AUTO_INCREMENT,
    mergious_id INTEGER,
    name VARCHAR(255),
    address VARCHAR(1024),
    city VARCHAR(255),
    district VARCHAR(255),
    pincode VARCHAR(255),
    mobile_number VARCHAR(255),
    alternate_mobile_number VARCHAR(255),
    email VARCHAR(255),
    gender VARCHAR(255),
    dob VARCHAR(255),
    community VARCHAR(1024),
    father_education VARCHAR(255),
    father_field_of_study VARCHAR(1024),
    mother_education VARCHAR(255),
    mother_field_of_study VARCHAR(1024),
    included_in_psc_ranklist VARCHAR(255),
    PRIMARY KEY(profile_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE education(
    education_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    type VARCHAR(255),
    course VARCHAR(255),
    subject VARCHAR(1024),
    institution VARCHAR(1024),
    completed VARCHAR(255),
    grade VARCHAR(255),
    PRIMARY KEY(education_id),
    FOREIGN KEY (profile_id) REFERENCES profile(profile_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE it_proficiency(
    it_proficiency_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    degree VARCHAR(1024),
    course VARCHAR(1024),
    institution VARCHAR(1024),
    programing_language VARCHAR(1024),
    web_social_media VARCHAR(1024),
    other VARCHAR(1024),
    PRIMARY KEY(it_proficiency_id),
    FOREIGN KEY (profile_id) REFERENCES profile(profile_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE language_proficiency(
    language_proficiency_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    language_name VARCHAR(255),
    read_proficiency VARCHAR(255),
    write_proficiency VARCHAR(255),
    speak_proficiency VARCHAR(255),
    PRIMARY KEY(language_proficiency_id), 
    FOREIGN KEY(profile_id)REFERENCES profile(profile_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE skill_training(
    skill_training_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    training VARCHAR(1024),
    topic VARCHAR(1024),
    agency VARCHAR(1024),
    duration VARCHAR(255),
    sector VARCHAR(1024),
    completed_year VARCHAR(255),
    reason_for_discontinuation VARCHAR(1024),
    PRIMARY KEY(skill_training_id), 
    FOREIGN KEY(profile_id)REFERENCES profile(profile_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE training_programs(
    training_program_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    priority_1 VARCHAR(255),
    priority_2 VARCHAR(255),
    priority_3 VARCHAR(255),
    priority_4 VARCHAR(255),
    priority_5 VARCHAR(255),
    PRIMARY KEY(training_program_id),
    FOREIGN KEY(profile_id)REFERENCES profile(profile_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE traditional_skill(
    traditional_skill_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    tribal_agriculture INTEGER,
    animal_husbandry INTEGER,
    handloom INTEGER,
    food_processing INTEGER,
    honey_collection INTEGER,
    bamboo_craft INTEGER,
    tribal_housing INTEGER,
    treatment INTEGER,
    identification INTEGER,
    medicine_preparation INTEGER,
    PRIMARY KEY(traditional_skill_id),
    FOREIGN KEY (profile_id) REFERENCES profile(profile_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE employement_data(
    employment_data_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    position VARCHAR(1024),
    employer VARCHAR(1024),
    nature VARCHAR(255),
    income VARCHAR(255),
    reason_for_discontinuation VARCHAR(1024),
    PRIMARY KEY(employment_data_id),
    FOREIGN KEY(profile_id)REFERENCES profile(profile_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE informal_sector(
    informal_sector_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    sector VARCHAR(255),
    position VARCHAR(255),
    years INTEGER,
    skills VARCHAR(255),
    community_service VARCHAR(255),
    roles_in_community_service VARCHAR(255),
    guarantee_scheme VARCHAR(255),
    PRIMARY KEY(informal_sector_id), 
    FOREIGN KEY(profile_id)REFERENCES profile(profile_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE employement_interest(
    employment_interest_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    interested_field VARCHAR(1024),
    relocate VARCHAR(255),
    outside_state VARCHAR(255),
    outside_country VARCHAR(255),
    job_role VARCHAR(255),
    PRIMARY KEY(employment_interest_id),
    FOREIGN KEY(profile_id)REFERENCES profile(profile_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE capacity_development(
    capacity_development_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    communication INTEGER,
    computer INTEGER,
    job_skill INTEGER,
    soft_skill INTEGER,
    specific_skill_training VARCHAR(1024),
    PRIMARY KEY(capacity_development_id),
    FOREIGN KEY (profile_id) REFERENCES profile(profile_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE cultural_interests(
    cultural_interests_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    singing VARCHAR(255),
    dancing VARCHAR(255),
    performing_arts VARCHAR(255),
    other VARCHAR(1024),
    PRIMARY KEY(cultural_interests_id),
    FOREIGN KEY (profile_id) REFERENCES profile(profile_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE entrepreneurship(
    entrepreneurship_id INTEGER NOT NULL AUTO_INCREMENT,
    profile_id INTEGER,
    field VARCHAR(1024),
    description VARCHAR(5000),
    sector VARCHAR(255),
    years VARCHAR(255),
    activities VARCHAR(2048),
    PRIMARY KEY(entrepreneurship_id),
    FOREIGN KEY(profile_id)REFERENCES profile(profile_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE config(
    config_id INTEGER NOT NULL AUTO_INCREMENT,
    authority VARCHAR(1024),
    unencodedPath VARCHAR(1024),
    maintenance INTEGER,
    flag INTEGER,
    PRIMARY KEY(config_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE training_programs_alternate(
    training_program_alternate_id INTEGER NOT NULL AUTO_INCREMENT,
    mergious_id INTEGER,
    priority_1 VARCHAR(255),
    priority_2 VARCHAR(255),
    priority_3 VARCHAR(255),
    priority_4 VARCHAR(255),
    priority_5 VARCHAR(255),
    PRIMARY KEY(training_program_alternate_id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;