001package com.echothree.model.jooq.server.keys.customer; 002 003import com.echothree.model.jooq.server.KeyRegistry; 004import com.echothree.model.jooq.server.records.accounting.GlAccounts; 005import com.echothree.model.jooq.server.records.cancellationpolicy.CancellationPolicies; 006import com.echothree.model.jooq.server.records.customer.CustomerTypeDescriptions; 007import com.echothree.model.jooq.server.records.customer.CustomerTypeDetails; 008import com.echothree.model.jooq.server.records.customer.CustomerTypePaymentMethods; 009import com.echothree.model.jooq.server.records.customer.CustomerTypeShippingMethods; 010import com.echothree.model.jooq.server.records.customer.CustomerTypes; 011import com.echothree.model.jooq.server.records.customer.Customers; 012import com.echothree.model.jooq.server.records.inventory.AllocationPriorities; 013import com.echothree.model.jooq.server.records.offer.OfferUses; 014import com.echothree.model.jooq.server.records.party.Languages; 015import com.echothree.model.jooq.server.records.party.Parties; 016import com.echothree.model.jooq.server.records.payment.PaymentMethods; 017import com.echothree.model.jooq.server.records.returnpolicy.ReturnPolicies; 018import com.echothree.model.jooq.server.records.sequence.Sequences; 019import com.echothree.model.jooq.server.records.shipment.FreeOnBoards; 020import com.echothree.model.jooq.server.records.shipping.ShippingMethods; 021import com.echothree.model.jooq.server.records.term.Terms; 022import com.echothree.model.jooq.server.records.workflow.WorkflowEntrances; 023 024import org.jooq.ForeignKey; 025import org.jooq.TableField; 026import org.jooq.impl.DSL; 027import org.jooq.impl.Internal; 028import org.jooq.impl.QOM.ForeignKeyRule; 029 030/** 031 * Key definitions for the CustomerForeign component. 032 */ 033public interface CustomerForeignKeys { 034 public static final ForeignKey<Customers, GlAccounts> CUSTOMERS_AR_GL_ACCOUNT_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.Customers.Customers, DSL.name("cu_arglaccountid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.Customers.Customers.AR_GL_ACCOUNT }, KeyRegistry.GL_ACCOUNTS_PK, new TableField[] { com.echothree.model.jooq.server.tables.accounting.GlAccounts.GlAccounts.GL_ACCOUNT }, true, ForeignKeyRule.CASCADE, null); 035 public static final ForeignKey<Customers, CancellationPolicies> CUSTOMERS_CANCELLATION_POLICY_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.Customers.Customers, DSL.name("cu_cnclplcy_cancellationpolicyid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.Customers.Customers.CANCELLATION_POLICY }, KeyRegistry.CANCELLATION_POLICIES_PK, new TableField[] { com.echothree.model.jooq.server.tables.cancellationpolicy.CancellationPolicies.CancellationPolicies.CANCELLATION_POLICY }, true, ForeignKeyRule.CASCADE, null); 036 public static final ForeignKey<Customers, CustomerTypes> CUSTOMERS_CUSTOMER_TYPE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.Customers.Customers, DSL.name("cu_cuty_customertypeid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.Customers.Customers.CUSTOMER_TYPE }, KeyRegistry.CUSTOMER_TYPES_PK, new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypes.CustomerTypes.CUSTOMER_TYPE }, true, ForeignKeyRule.CASCADE, null); 037 public static final ForeignKey<Customers, OfferUses> CUSTOMERS_INITIAL_OFFER_USE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.Customers.Customers, DSL.name("cu_initialofferuseid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.Customers.Customers.INITIAL_OFFER_USE }, KeyRegistry.OFFER_USES_PK, new TableField[] { com.echothree.model.jooq.server.tables.offer.OfferUses.OfferUses.OFFER_USE }, true, ForeignKeyRule.CASCADE, null); 038 public static final ForeignKey<Customers, Parties> CUSTOMERS_PARTY_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.Customers.Customers, DSL.name("cu_par_partyid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.Customers.Customers.PARTY }, KeyRegistry.PARTIES_PK, new TableField[] { com.echothree.model.jooq.server.tables.party.Parties.Parties.PARTY }, true, ForeignKeyRule.CASCADE, null); 039 public static final ForeignKey<Customers, ReturnPolicies> CUSTOMERS_RETURN_POLICY_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.Customers.Customers, DSL.name("cu_rtnplcy_returnpolicyid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.Customers.Customers.RETURN_POLICY }, KeyRegistry.RETURN_POLICIES_PK, new TableField[] { com.echothree.model.jooq.server.tables.returnpolicy.ReturnPolicies.ReturnPolicies.RETURN_POLICY }, true, ForeignKeyRule.CASCADE, null); 040 public static final ForeignKey<CustomerTypeDescriptions, CustomerTypes> CUSTOMER_TYPE_DESCRIPTIONS_CUSTOMER_TYPE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDescriptions.CustomerTypeDescriptions, DSL.name("cutyd_cuty_customertypeid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDescriptions.CustomerTypeDescriptions.CUSTOMER_TYPE }, KeyRegistry.CUSTOMER_TYPES_PK, new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypes.CustomerTypes.CUSTOMER_TYPE }, true, ForeignKeyRule.CASCADE, null); 041 public static final ForeignKey<CustomerTypeDescriptions, Languages> CUSTOMER_TYPE_DESCRIPTIONS_LANGUAGE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDescriptions.CustomerTypeDescriptions, DSL.name("cutyd_lang_languageid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDescriptions.CustomerTypeDescriptions.LANGUAGE }, KeyRegistry.LANGUAGES_PK, new TableField[] { com.echothree.model.jooq.server.tables.party.Languages.Languages.LANGUAGE }, true, ForeignKeyRule.CASCADE, null); 042 public static final ForeignKey<CustomerTypeDetails, AllocationPriorities> CUSTOMER_TYPE_DETAILS_ALLOCATION_PRIORITY_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_allocpr_allocationpriorityid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.ALLOCATION_PRIORITY }, KeyRegistry.ALLOCATION_PRIORITIES_PK, new TableField[] { com.echothree.model.jooq.server.tables.inventory.AllocationPriorities.AllocationPriorities.ALLOCATION_PRIORITY }, true, ForeignKeyRule.CASCADE, null); 043 public static final ForeignKey<CustomerTypeDetails, Sequences> CUSTOMER_TYPE_DETAILS_CUSTOMER_SEQUENCE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_customersequenceid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.CUSTOMER_SEQUENCE }, KeyRegistry.SEQUENCES_PK, new TableField[] { com.echothree.model.jooq.server.tables.sequence.Sequences.Sequences.SEQUENCE }, true, ForeignKeyRule.CASCADE, null); 044 public static final ForeignKey<CustomerTypeDetails, CustomerTypes> CUSTOMER_TYPE_DETAILS_CUSTOMER_TYPE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_cuty_customertypeid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.CUSTOMER_TYPE }, KeyRegistry.CUSTOMER_TYPES_PK, new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypes.CustomerTypes.CUSTOMER_TYPE }, true, ForeignKeyRule.CASCADE, null); 045 public static final ForeignKey<CustomerTypeDetails, GlAccounts> CUSTOMER_TYPE_DETAILS_DEFAULT_AR_GL_ACCOUNT_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_defaultarglaccountid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.DEFAULT_AR_GL_ACCOUNT }, KeyRegistry.GL_ACCOUNTS_PK, new TableField[] { com.echothree.model.jooq.server.tables.accounting.GlAccounts.GlAccounts.GL_ACCOUNT }, true, ForeignKeyRule.CASCADE, null); 046 public static final ForeignKey<CustomerTypeDetails, CancellationPolicies> CUSTOMER_TYPE_DETAILS_DEFAULT_CANCELLATION_POLICY_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_defaultcancellationpolicyid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.DEFAULT_CANCELLATION_POLICY }, KeyRegistry.CANCELLATION_POLICIES_PK, new TableField[] { com.echothree.model.jooq.server.tables.cancellationpolicy.CancellationPolicies.CancellationPolicies.CANCELLATION_POLICY }, true, ForeignKeyRule.CASCADE, null); 047 public static final ForeignKey<CustomerTypeDetails, WorkflowEntrances> CUSTOMER_TYPE_DETAILS_DEFAULT_CUSTOMER_CREDIT_STATUS_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_defaultcustomercreditstatusid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.DEFAULT_CUSTOMER_CREDIT_STATUS }, KeyRegistry.WORKFLOW_ENTRANCES_PK, new TableField[] { com.echothree.model.jooq.server.tables.workflow.WorkflowEntrances.WorkflowEntrances.WORKFLOW_ENTRANCE }, true, ForeignKeyRule.CASCADE, null); 048 public static final ForeignKey<CustomerTypeDetails, WorkflowEntrances> CUSTOMER_TYPE_DETAILS_DEFAULT_CUSTOMER_STATUS_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_defaultcustomerstatusid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.DEFAULT_CUSTOMER_STATUS }, KeyRegistry.WORKFLOW_ENTRANCES_PK, new TableField[] { com.echothree.model.jooq.server.tables.workflow.WorkflowEntrances.WorkflowEntrances.WORKFLOW_ENTRANCE }, true, ForeignKeyRule.CASCADE, null); 049 public static final ForeignKey<CustomerTypeDetails, FreeOnBoards> CUSTOMER_TYPE_DETAILS_DEFAULT_FREE_ON_BOARD_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_defaultfreeonboardid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.DEFAULT_FREE_ON_BOARD }, KeyRegistry.FREE_ON_BOARDS_PK, new TableField[] { com.echothree.model.jooq.server.tables.shipment.FreeOnBoards.FreeOnBoards.FREE_ON_BOARD }, true, ForeignKeyRule.CASCADE, null); 050 public static final ForeignKey<CustomerTypeDetails, OfferUses> CUSTOMER_TYPE_DETAILS_DEFAULT_OFFER_USE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_defaultofferuseid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.DEFAULT_OFFER_USE }, KeyRegistry.OFFER_USES_PK, new TableField[] { com.echothree.model.jooq.server.tables.offer.OfferUses.OfferUses.OFFER_USE }, true, ForeignKeyRule.CASCADE, null); 051 public static final ForeignKey<CustomerTypeDetails, ReturnPolicies> CUSTOMER_TYPE_DETAILS_DEFAULT_RETURN_POLICY_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_defaultreturnpolicyid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.DEFAULT_RETURN_POLICY }, KeyRegistry.RETURN_POLICIES_PK, new TableField[] { com.echothree.model.jooq.server.tables.returnpolicy.ReturnPolicies.ReturnPolicies.RETURN_POLICY }, true, ForeignKeyRule.CASCADE, null); 052 public static final ForeignKey<CustomerTypeDetails, Terms> CUSTOMER_TYPE_DETAILS_DEFAULT_TERM_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails, DSL.name("cutydt_defaulttermid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.DEFAULT_TERM }, KeyRegistry.TERMS_PK, new TableField[] { com.echothree.model.jooq.server.tables.term.Terms.Terms.TERM }, true, ForeignKeyRule.CASCADE, null); 053 public static final ForeignKey<CustomerTypePaymentMethods, CustomerTypes> CUSTOMER_TYPE_PAYMENT_METHODS_CUSTOMER_TYPE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypePaymentMethods.CustomerTypePaymentMethods, DSL.name("cutypm_cuty_customertypeid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypePaymentMethods.CustomerTypePaymentMethods.CUSTOMER_TYPE }, KeyRegistry.CUSTOMER_TYPES_PK, new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypes.CustomerTypes.CUSTOMER_TYPE }, true, ForeignKeyRule.CASCADE, null); 054 public static final ForeignKey<CustomerTypePaymentMethods, PaymentMethods> CUSTOMER_TYPE_PAYMENT_METHODS_PAYMENT_METHOD_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypePaymentMethods.CustomerTypePaymentMethods, DSL.name("cutypm_pm_paymentmethodid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypePaymentMethods.CustomerTypePaymentMethods.PAYMENT_METHOD }, KeyRegistry.PAYMENT_METHODS_PK, new TableField[] { com.echothree.model.jooq.server.tables.payment.PaymentMethods.PaymentMethods.PAYMENT_METHOD }, true, ForeignKeyRule.CASCADE, null); 055 public static final ForeignKey<CustomerTypes, CustomerTypeDetails> CUSTOMER_TYPES_ACTIVE_DETAIL_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypes.CustomerTypes, DSL.name("cuty_activedetailid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypes.CustomerTypes.ACTIVE_DETAIL }, KeyRegistry.CUSTOMER_TYPE_DETAILS_PK, new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.CUSTOMER_TYPE_DETAIL }, true, ForeignKeyRule.CASCADE, null); 056 public static final ForeignKey<CustomerTypes, CustomerTypeDetails> CUSTOMER_TYPES_LAST_DETAIL_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypes.CustomerTypes, DSL.name("cuty_lastdetailid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypes.CustomerTypes.LAST_DETAIL }, KeyRegistry.CUSTOMER_TYPE_DETAILS_PK, new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeDetails.CustomerTypeDetails.CUSTOMER_TYPE_DETAIL }, true, ForeignKeyRule.CASCADE, null); 057 public static final ForeignKey<CustomerTypeShippingMethods, CustomerTypes> CUSTOMER_TYPE_SHIPPING_METHODS_CUSTOMER_TYPE_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeShippingMethods.CustomerTypeShippingMethods, DSL.name("cutyshm_cuty_customertypeid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeShippingMethods.CustomerTypeShippingMethods.CUSTOMER_TYPE }, KeyRegistry.CUSTOMER_TYPES_PK, new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypes.CustomerTypes.CUSTOMER_TYPE }, true, ForeignKeyRule.CASCADE, null); 058 public static final ForeignKey<CustomerTypeShippingMethods, ShippingMethods> CUSTOMER_TYPE_SHIPPING_METHODS_SHIPPING_METHOD_FK = Internal.createForeignKey(com.echothree.model.jooq.server.tables.customer.CustomerTypeShippingMethods.CustomerTypeShippingMethods, DSL.name("cutyshm_shm_shippingmethodid_fk"), new TableField[] { com.echothree.model.jooq.server.tables.customer.CustomerTypeShippingMethods.CustomerTypeShippingMethods.SHIPPING_METHOD }, KeyRegistry.SHIPPING_METHODS_PK, new TableField[] { com.echothree.model.jooq.server.tables.shipping.ShippingMethods.ShippingMethods.SHIPPING_METHOD }, true, ForeignKeyRule.CASCADE, null); 059}