/*
 * This file is generated by jOOQ.
 */
package ervu_dashboard.ervu_dashboard.db_beans.recruitment_campaign;


import ervu_dashboard.ervu_dashboard.db_beans.ervu_dashboard.tables.Recruitment;
import ervu_dashboard.ervu_dashboard.db_beans.ervu_dashboard.tables.records.RecruitmentRecord;
import ervu_dashboard.ervu_dashboard.db_beans.recruitment_campaign.tables.Appeals;
import ervu_dashboard.ervu_dashboard.db_beans.recruitment_campaign.tables.PostponementInfo;
import ervu_dashboard.ervu_dashboard.db_beans.recruitment_campaign.tables.Subpoenas;
import ervu_dashboard.ervu_dashboard.db_beans.recruitment_campaign.tables.records.AppealsRecord;
import ervu_dashboard.ervu_dashboard.db_beans.recruitment_campaign.tables.records.PostponementInfoRecord;
import ervu_dashboard.ervu_dashboard.db_beans.recruitment_campaign.tables.records.SubpoenasRecord;

import org.jooq.ForeignKey;
import org.jooq.TableField;
import org.jooq.UniqueKey;
import org.jooq.impl.DSL;
import org.jooq.impl.Internal;


/**
 * A class modelling foreign key relationships and constraints of tables in
 * recruitment_campaign.
 */
@SuppressWarnings({ "all", "unchecked", "rawtypes" })
public class Keys {

    // -------------------------------------------------------------------------
    // UNIQUE and PRIMARY KEY definitions
    // -------------------------------------------------------------------------

    public static final UniqueKey<AppealsRecord> PK_APPEAL = Internal.createUniqueKey(Appeals.APPEALS, DSL.name("pk_appeal"), new TableField[] { Appeals.APPEALS.ID_APPEAL }, true);
    public static final UniqueKey<PostponementInfoRecord> PK_POSTPONEMENT_INFO = Internal.createUniqueKey(PostponementInfo.POSTPONEMENT_INFO, DSL.name("pk_postponement_info"), new TableField[] { PostponementInfo.POSTPONEMENT_INFO.POSTPONEMENT_INFO_ID }, true);
    public static final UniqueKey<SubpoenasRecord> SUBPOENAS_PKEY = Internal.createUniqueKey(Subpoenas.SUBPOENAS, DSL.name("subpoenas_pkey"), new TableField[] { Subpoenas.SUBPOENAS.SPRING_AUTUMN, Subpoenas.SUBPOENAS.RECRUITMENT_ID, Subpoenas.SUBPOENAS.RECORDING_DATE }, true);

    // -------------------------------------------------------------------------
    // FOREIGN KEY definitions
    // -------------------------------------------------------------------------

    public static final ForeignKey<AppealsRecord, RecruitmentRecord> APPEALS__RC_APPEALS_FK1 = Internal.createForeignKey(Appeals.APPEALS, DSL.name("rc_appeals_fk1"), new TableField[] { Appeals.APPEALS.RECRUITMENT_ID }, ervu_dashboard.ervu_dashboard.db_beans.ervu_dashboard.Keys.RECRUITMENT_PKEY, new TableField[] { Recruitment.RECRUITMENT.ID }, true);
    public static final ForeignKey<PostponementInfoRecord, RecruitmentRecord> POSTPONEMENT_INFO__POSTPONEMENT_INFO_FK1 = Internal.createForeignKey(PostponementInfo.POSTPONEMENT_INFO, DSL.name("postponement_info_fk1"), new TableField[] { PostponementInfo.POSTPONEMENT_INFO.RECRUITMENT_ID }, ervu_dashboard.ervu_dashboard.db_beans.ervu_dashboard.Keys.RECRUITMENT_PKEY, new TableField[] { Recruitment.RECRUITMENT.ID }, true);
}
