001package com.echothree.model.jooq.server.keys.letter; 002 003import com.echothree.model.jooq.server.KeyRegistry; 004import com.echothree.model.jooq.server.records.chain.ChainInstances; 005import com.echothree.model.jooq.server.records.chain.ChainTypes; 006import com.echothree.model.jooq.server.records.contact.ContactMechanismPurposes; 007import com.echothree.model.jooq.server.records.contact.PartyContactMechanisms; 008import com.echothree.model.jooq.server.records.contactlist.ContactLists; 009import com.echothree.model.jooq.server.records.letter.LetterContactMechanismPurposeDetails; 010import com.echothree.model.jooq.server.records.letter.LetterContactMechanismPurposes; 011import com.echothree.model.jooq.server.records.letter.LetterDescriptions; 012import com.echothree.model.jooq.server.records.letter.LetterDetails; 013import com.echothree.model.jooq.server.records.letter.LetterSourceDescriptions; 014import com.echothree.model.jooq.server.records.letter.LetterSourceDetails; 015import com.echothree.model.jooq.server.records.letter.LetterSources; 016import com.echothree.model.jooq.server.records.letter.Letters; 017import com.echothree.model.jooq.server.records.letter.QueuedLetters; 018import com.echothree.model.jooq.server.records.party.Languages; 019import com.echothree.model.jooq.server.records.party.Parties; 020 021import org.jooq.ForeignKey; 022import org.jooq.TableField; 023import org.jooq.impl.DSL; 024import org.jooq.impl.Internal; 025import org.jooq.impl.QOM.ForeignKeyRule; 026 027/** 028 * Key definitions for the LetterForeign component. 029 */ 030public interface LetterForeignKeys { 031 public static final ForeignKey<LetterContactMechanismPurposeDetails, ContactMechanismPurposes> LETTER_CONTACT_MECHANISM_PURPOSE_DETAILS_CONTACT_MECHANISM_PURPOSE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposeDetails.LetterContactMechanismPurposeDetails, DSL.name("lttrcmprdt_cmpr_contactmechanismpurposeid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposeDetails.LetterContactMechanismPurposeDetails.CONTACT_MECHANISM_PURPOSE }, KeyRegistry.CONTACT_MECHANISM_PURPOSES_PK, new TableField[] { com.echothree.model.jooq.server.tables.contact.ContactMechanismPurposes.ContactMechanismPurposes.CONTACT_MECHANISM_PURPOSE }, true, ForeignKeyRule.CASCADE, null); 032 public static final ForeignKey<LetterContactMechanismPurposeDetails, Letters> LETTER_CONTACT_MECHANISM_PURPOSE_DETAILS_LETTER_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposeDetails.LetterContactMechanismPurposeDetails, DSL.name("lttrcmprdt_lttr_letterid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposeDetails.LetterContactMechanismPurposeDetails.LETTER }, KeyRegistry.LETTERS_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.Letters.Letters.LETTER }, true, ForeignKeyRule.CASCADE, null); 033 public static final ForeignKey<LetterContactMechanismPurposeDetails, LetterContactMechanismPurposes> LETTER_CONTACT_MECHANISM_PURPOSE_DETAILS_LETTER_CONTACT_MECHANISM_PURPOSE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposeDetails.LetterContactMechanismPurposeDetails, DSL.name("lttrcmprdt_lttrcmpr_lettercontactmechanismpurposeid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposeDetails.LetterContactMechanismPurposeDetails.LETTER_CONTACT_MECHANISM_PURPOSE }, KeyRegistry.LETTER_CONTACT_MECHANISM_PURPOSES_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposes.LetterContactMechanismPurposes.LETTER_CONTACT_MECHANISM_PURPOSE }, true, ForeignKeyRule.CASCADE, null); 034 public static final ForeignKey<LetterContactMechanismPurposes, LetterContactMechanismPurposeDetails> LETTER_CONTACT_MECHANISM_PURPOSES_ACTIVE_DETAIL_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposes.LetterContactMechanismPurposes, DSL.name("lttrcmpr_activedetailid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposes.LetterContactMechanismPurposes.ACTIVE_DETAIL }, KeyRegistry.LETTER_CONTACT_MECHANISM_PURPOSE_DETAILS_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposeDetails.LetterContactMechanismPurposeDetails.LETTER_CONTACT_MECHANISM_PURPOSE_DETAIL }, true, ForeignKeyRule.CASCADE, null); 035 public static final ForeignKey<LetterContactMechanismPurposes, LetterContactMechanismPurposeDetails> LETTER_CONTACT_MECHANISM_PURPOSES_LAST_DETAIL_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposes.LetterContactMechanismPurposes, DSL.name("lttrcmpr_lastdetailid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposes.LetterContactMechanismPurposes.LAST_DETAIL }, KeyRegistry.LETTER_CONTACT_MECHANISM_PURPOSE_DETAILS_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterContactMechanismPurposeDetails.LetterContactMechanismPurposeDetails.LETTER_CONTACT_MECHANISM_PURPOSE_DETAIL }, true, ForeignKeyRule.CASCADE, null); 036 public static final ForeignKey<LetterDescriptions, Languages> LETTER_DESCRIPTIONS_LANGUAGE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterDescriptions.LetterDescriptions, DSL.name("lttrd_lang_languageid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterDescriptions.LetterDescriptions.LANGUAGE }, KeyRegistry.LANGUAGES_PK, new TableField[] { com.echothree.model.jooq.server.tables.party.Languages.Languages.LANGUAGE }, true, ForeignKeyRule.CASCADE, null); 037 public static final ForeignKey<LetterDescriptions, Letters> LETTER_DESCRIPTIONS_LETTER_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterDescriptions.LetterDescriptions, DSL.name("lttrd_lttr_letterid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterDescriptions.LetterDescriptions.LETTER }, KeyRegistry.LETTERS_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.Letters.Letters.LETTER }, true, ForeignKeyRule.CASCADE, null); 038 public static final ForeignKey<LetterDetails, ChainTypes> LETTER_DETAILS_CHAIN_TYPE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterDetails.LetterDetails, DSL.name("lttrdt_chntyp_chaintypeid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterDetails.LetterDetails.CHAIN_TYPE }, KeyRegistry.CHAIN_TYPES_PK, new TableField[] { com.echothree.model.jooq.server.tables.chain.ChainTypes.ChainTypes.CHAIN_TYPE }, true, ForeignKeyRule.CASCADE, null); 039 public static final ForeignKey<LetterDetails, ContactLists> LETTER_DETAILS_CONTACT_LIST_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterDetails.LetterDetails, DSL.name("lttrdt_clst_contactlistid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterDetails.LetterDetails.CONTACT_LIST }, KeyRegistry.CONTACT_LISTS_PK, new TableField[] { com.echothree.model.jooq.server.tables.contactlist.ContactLists.ContactLists.CONTACT_LIST }, true, ForeignKeyRule.CASCADE, null); 040 public static final ForeignKey<LetterDetails, Letters> LETTER_DETAILS_LETTER_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterDetails.LetterDetails, DSL.name("lttrdt_lttr_letterid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterDetails.LetterDetails.LETTER }, KeyRegistry.LETTERS_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.Letters.Letters.LETTER }, true, ForeignKeyRule.CASCADE, null); 041 public static final ForeignKey<LetterDetails, LetterSources> LETTER_DETAILS_LETTER_SOURCE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterDetails.LetterDetails, DSL.name("lttrdt_lttrsrc_lettersourceid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterDetails.LetterDetails.LETTER_SOURCE }, KeyRegistry.LETTER_SOURCES_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSources.LetterSources.LETTER_SOURCE }, true, ForeignKeyRule.CASCADE, null); 042 public static final ForeignKey<Letters, LetterDetails> LETTERS_ACTIVE_DETAIL_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.Letters.Letters, DSL.name("lttr_activedetailid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.Letters.Letters.ACTIVE_DETAIL }, KeyRegistry.LETTER_DETAILS_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterDetails.LetterDetails.LETTER_DETAIL }, true, ForeignKeyRule.CASCADE, null); 043 public static final ForeignKey<Letters, LetterDetails> LETTERS_LAST_DETAIL_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.Letters.Letters, DSL.name("lttr_lastdetailid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.Letters.Letters.LAST_DETAIL }, KeyRegistry.LETTER_DETAILS_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterDetails.LetterDetails.LETTER_DETAIL }, true, ForeignKeyRule.CASCADE, null); 044 public static final ForeignKey<LetterSourceDescriptions, Languages> LETTER_SOURCE_DESCRIPTIONS_LANGUAGE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterSourceDescriptions.LetterSourceDescriptions, DSL.name("lttrsrcd_lang_languageid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSourceDescriptions.LetterSourceDescriptions.LANGUAGE }, KeyRegistry.LANGUAGES_PK, new TableField[] { com.echothree.model.jooq.server.tables.party.Languages.Languages.LANGUAGE }, true, ForeignKeyRule.CASCADE, null); 045 public static final ForeignKey<LetterSourceDescriptions, LetterSources> LETTER_SOURCE_DESCRIPTIONS_LETTER_SOURCE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterSourceDescriptions.LetterSourceDescriptions, DSL.name("lttrsrcd_lttrsrc_lettersourceid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSourceDescriptions.LetterSourceDescriptions.LETTER_SOURCE }, KeyRegistry.LETTER_SOURCES_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSources.LetterSources.LETTER_SOURCE }, true, ForeignKeyRule.CASCADE, null); 046 public static final ForeignKey<LetterSourceDetails, Parties> LETTER_SOURCE_DETAILS_COMPANY_PARTY_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails, DSL.name("lttrsrcdt_companypartyid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails.COMPANY_PARTY }, KeyRegistry.PARTIES_PK, new TableField[] { com.echothree.model.jooq.server.tables.party.Parties.Parties.PARTY }, true, ForeignKeyRule.CASCADE, null); 047 public static final ForeignKey<LetterSourceDetails, PartyContactMechanisms> LETTER_SOURCE_DETAILS_EMAIL_ADDRESS_PARTY_CONTACT_MECHANISM_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails, DSL.name("lttrsrcdt_emailaddresspartycontactmechanismid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails.EMAIL_ADDRESS_PARTY_CONTACT_MECHANISM }, KeyRegistry.PARTY_CONTACT_MECHANISMS_PK, new TableField[] { com.echothree.model.jooq.server.tables.contact.PartyContactMechanisms.PartyContactMechanisms.PARTY_CONTACT_MECHANISM }, true, ForeignKeyRule.CASCADE, null); 048 public static final ForeignKey<LetterSourceDetails, PartyContactMechanisms> LETTER_SOURCE_DETAILS_LETTER_SOURCE_PARTY_CONTACT_MECHANISM_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails, DSL.name("lttrsrcdt_lettersourcepartycontactmechanismid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails.LETTER_SOURCE_PARTY_CONTACT_MECHANISM }, KeyRegistry.PARTY_CONTACT_MECHANISMS_PK, new TableField[] { com.echothree.model.jooq.server.tables.contact.PartyContactMechanisms.PartyContactMechanisms.PARTY_CONTACT_MECHANISM }, true, ForeignKeyRule.CASCADE, null); 049 public static final ForeignKey<LetterSourceDetails, LetterSources> LETTER_SOURCE_DETAILS_LETTER_SOURCE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails, DSL.name("lttrsrcdt_lttrsrc_lettersourceid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails.LETTER_SOURCE }, KeyRegistry.LETTER_SOURCES_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSources.LetterSources.LETTER_SOURCE }, true, ForeignKeyRule.CASCADE, null); 050 public static final ForeignKey<LetterSourceDetails, PartyContactMechanisms> LETTER_SOURCE_DETAILS_POSTAL_ADDRESS_PARTY_CONTACT_MECHANISM_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails, DSL.name("lttrsrcdt_postaladdresspartycontactmechanismid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails.POSTAL_ADDRESS_PARTY_CONTACT_MECHANISM }, KeyRegistry.PARTY_CONTACT_MECHANISMS_PK, new TableField[] { com.echothree.model.jooq.server.tables.contact.PartyContactMechanisms.PartyContactMechanisms.PARTY_CONTACT_MECHANISM }, true, ForeignKeyRule.CASCADE, null); 051 public static final ForeignKey<LetterSources, LetterSourceDetails> LETTER_SOURCES_ACTIVE_DETAIL_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterSources.LetterSources, DSL.name("lttrsrc_activedetailid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSources.LetterSources.ACTIVE_DETAIL }, KeyRegistry.LETTER_SOURCE_DETAILS_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails.LETTER_SOURCE_DETAIL }, true, ForeignKeyRule.CASCADE, null); 052 public static final ForeignKey<LetterSources, LetterSourceDetails> LETTER_SOURCES_LAST_DETAIL_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.LetterSources.LetterSources, DSL.name("lttrsrc_lastdetailid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSources.LetterSources.LAST_DETAIL }, KeyRegistry.LETTER_SOURCE_DETAILS_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.LetterSourceDetails.LetterSourceDetails.LETTER_SOURCE_DETAIL }, true, ForeignKeyRule.CASCADE, null); 053 public static final ForeignKey<QueuedLetters, ChainInstances> QUEUED_LETTERS_CHAIN_INSTANCE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.QueuedLetters.QueuedLetters, DSL.name("qlttr_chni_chaininstanceid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.QueuedLetters.QueuedLetters.CHAIN_INSTANCE }, KeyRegistry.CHAIN_INSTANCES_PK, new TableField[] { com.echothree.model.jooq.server.tables.chain.ChainInstances.ChainInstances.CHAIN_INSTANCE }, true, ForeignKeyRule.CASCADE, null); 054 public static final ForeignKey<QueuedLetters, Letters> QUEUED_LETTERS_LETTER_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.letter.QueuedLetters.QueuedLetters, DSL.name("qlttr_lttr_letterid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.letter.QueuedLetters.QueuedLetters.LETTER }, KeyRegistry.LETTERS_PK, new TableField[] { com.echothree.model.jooq.server.tables.letter.Letters.Letters.LETTER }, true, ForeignKeyRule.CASCADE, null); 055}