Source code

001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.payment;
005
006
007import com.echothree.model.data.contact.common.pk.PartyContactMechanismPK;
008import com.echothree.model.data.party.common.pk.NameSuffixPK;
009import com.echothree.model.data.party.common.pk.PersonalTitlePK;
010import com.echothree.model.data.payment.common.pk.PartyPaymentMethodCreditCardPK;
011import com.echothree.model.data.payment.common.pk.PartyPaymentMethodPK;
012import com.echothree.model.jooq.server.KeyRegistry;
013import com.echothree.model.jooq.server.tables.contact.PartyContactMechanisms.PartyContactMechanismsPath;
014import com.echothree.model.jooq.server.tables.party.NameSuffixes.NameSuffixesPath;
015import com.echothree.model.jooq.server.tables.party.PersonalTitles.PersonalTitlesPath;
016import com.echothree.model.jooq.server.tables.payment.PartyPaymentMethods.PartyPaymentMethodsPath;
017
018import java.util.Arrays;
019import java.util.Collection;
020import java.util.List;
021
022import org.jooq.Condition;
023import org.jooq.Converter;
024import org.jooq.Field;
025import org.jooq.ForeignKey;
026import org.jooq.Name;
027import org.jooq.PlainSQL;
028import org.jooq.QueryPart;
029import org.jooq.SQL;
030import org.jooq.Stringly;
031import org.jooq.Table;
032import org.jooq.TableField;
033import org.jooq.TableLike;
034import org.jooq.TableOptions;
035import org.jooq.UniqueKey;
036import org.jooq.impl.DSL;
037import org.jooq.impl.Internal;
038import org.jooq.impl.SQLDataType;
039import org.jooq.impl.TableImpl;
040
041
042/**
043 * This class is generated by jOOQ.
044 */
045@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
046public class PartyPaymentMethodCreditCards extends TableImpl<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards> {
047
048    private static final long serialVersionUID = 1L;
049
050    /**
051     * The reference instance of <code>partypaymentmethodcreditcards</code>
052     */
053    public static final PartyPaymentMethodCreditCards PartyPaymentMethodCreditCards = new PartyPaymentMethodCreditCards();
054
055    /**
056     * The class holding records for this type
057     */
058    @Override
059    public Class<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards> getRecordType() {
060        return com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards.class;
061    }
062
063    /**
064     * The column
065     * <code>partypaymentmethodcreditcards.parpmcc_partypaymentmethodcreditcardid</code>.
066     */
067    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, PartyPaymentMethodCreditCardPK> PARTY_PAYMENT_METHOD_CREDIT_CARD = createField(DSL.name("parpmcc_partypaymentmethodcreditcardid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PartyPaymentMethodCreditCardPK.class, id -> new com.echothree.model.data.payment.common.pk.PartyPaymentMethodCreditCardPK(id), primaryKey -> primaryKey.getEntityId()));
068
069    /**
070     * The column
071     * <code>partypaymentmethodcreditcards.parpmcc_parpm_partypaymentmethodid</code>.
072     */
073    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, PartyPaymentMethodPK> PARTY_PAYMENT_METHOD = createField(DSL.name("parpmcc_parpm_partypaymentmethodid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PartyPaymentMethodPK.class, id -> new com.echothree.model.data.payment.common.pk.PartyPaymentMethodPK(id), primaryKey -> primaryKey.getEntityId()));
074
075    /**
076     * The column <code>partypaymentmethodcreditcards.parpmcc_number</code>.
077     */
078    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> NUMBER = createField(DSL.name("parpmcc_number"), SQLDataType.VARCHAR(200), this, "");
079
080    /**
081     * The column <code>partypaymentmethodcreditcards.parpmcc_numberhash</code>.
082     */
083    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> NUMBER_HASH = createField(DSL.name("parpmcc_numberhash"), SQLDataType.VARCHAR(44), this, "");
084
085    /**
086     * The column
087     * <code>partypaymentmethodcreditcards.parpmcc_expirationmonth</code>.
088     */
089    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, Integer> EXPIRATION_MONTH = createField(DSL.name("parpmcc_expirationmonth"), SQLDataType.INTEGER, this, "");
090
091    /**
092     * The column
093     * <code>partypaymentmethodcreditcards.parpmcc_expirationyear</code>.
094     */
095    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, Integer> EXPIRATION_YEAR = createField(DSL.name("parpmcc_expirationyear"), SQLDataType.INTEGER, this, "");
096
097    /**
098     * The column
099     * <code>partypaymentmethodcreditcards.parpmcc_pert_personaltitleid</code>.
100     */
101    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, PersonalTitlePK> PERSONAL_TITLE = createField(DSL.name("parpmcc_pert_personaltitleid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, PersonalTitlePK.class, id -> new com.echothree.model.data.party.common.pk.PersonalTitlePK(id), primaryKey -> primaryKey.getEntityId()));
102
103    /**
104     * The column <code>partypaymentmethodcreditcards.parpmcc_firstname</code>.
105     */
106    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> FIRST_NAME = createField(DSL.name("parpmcc_firstname"), SQLDataType.VARCHAR(20), this, "");
107
108    /**
109     * The column
110     * <code>partypaymentmethodcreditcards.parpmcc_firstnamesdx</code>.
111     */
112    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> FIRST_NAME_SDX = createField(DSL.name("parpmcc_firstnamesdx"), SQLDataType.VARCHAR(4), this, "");
113
114    /**
115     * The column <code>partypaymentmethodcreditcards.parpmcc_middlename</code>.
116     */
117    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> MIDDLE_NAME = createField(DSL.name("parpmcc_middlename"), SQLDataType.VARCHAR(20), this, "");
118
119    /**
120     * The column
121     * <code>partypaymentmethodcreditcards.parpmcc_middlenamesdx</code>.
122     */
123    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> MIDDLE_NAME_SDX = createField(DSL.name("parpmcc_middlenamesdx"), SQLDataType.VARCHAR(4), this, "");
124
125    /**
126     * The column <code>partypaymentmethodcreditcards.parpmcc_lastname</code>.
127     */
128    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> LAST_NAME = createField(DSL.name("parpmcc_lastname"), SQLDataType.VARCHAR(20), this, "");
129
130    /**
131     * The column
132     * <code>partypaymentmethodcreditcards.parpmcc_lastnamesdx</code>.
133     */
134    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> LAST_NAME_SDX = createField(DSL.name("parpmcc_lastnamesdx"), SQLDataType.VARCHAR(4), this, "");
135
136    /**
137     * The column
138     * <code>partypaymentmethodcreditcards.parpmcc_nsfx_namesuffixid</code>.
139     */
140    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, NameSuffixPK> NAME_SUFFIX = createField(DSL.name("parpmcc_nsfx_namesuffixid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, NameSuffixPK.class, id -> new com.echothree.model.data.party.common.pk.NameSuffixPK(id), primaryKey -> primaryKey.getEntityId()));
141
142    /**
143     * The column <code>partypaymentmethodcreditcards.parpmcc_name</code>.
144     */
145    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> NAME = createField(DSL.name("parpmcc_name"), SQLDataType.VARCHAR(60), this, "");
146
147    /**
148     * The column
149     * <code>partypaymentmethodcreditcards.parpmcc_billingpartycontactmechanismid</code>.
150     */
151    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, PartyContactMechanismPK> BILLING_PARTY_CONTACT_MECHANISM = createField(DSL.name("parpmcc_billingpartycontactmechanismid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, PartyContactMechanismPK.class, id -> new com.echothree.model.data.contact.common.pk.PartyContactMechanismPK(id), primaryKey -> primaryKey.getEntityId()));
152
153    /**
154     * The column <code>partypaymentmethodcreditcards.parpmcc_issuername</code>.
155     */
156    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> ISSUER_NAME = createField(DSL.name("parpmcc_issuername"), SQLDataType.VARCHAR(60), this, "");
157
158    /**
159     * The column
160     * <code>partypaymentmethodcreditcards.parpmcc_issuerpartycontactmechanismid</code>.
161     */
162    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, PartyContactMechanismPK> ISSUER_PARTY_CONTACT_MECHANISM = createField(DSL.name("parpmcc_issuerpartycontactmechanismid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, PartyContactMechanismPK.class, id -> new com.echothree.model.data.contact.common.pk.PartyContactMechanismPK(id), primaryKey -> primaryKey.getEntityId()));
163
164    /**
165     * The column
166     * <code>partypaymentmethodcreditcards.parpmcc_initializationvector</code>.
167     */
168    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, String> INITIALIZATION_VECTOR = createField(DSL.name("parpmcc_initializationvector"), SQLDataType.VARCHAR(200).nullable(false), this, "");
169
170    /**
171     * The column <code>partypaymentmethodcreditcards.parpmcc_fromtime</code>.
172     */
173    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, Long> FROM_TIME = createField(DSL.name("parpmcc_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
174
175    /**
176     * The column <code>partypaymentmethodcreditcards.parpmcc_thrutime</code>.
177     */
178    public final TableField<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, Long> THRU_TIME = createField(DSL.name("parpmcc_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
179
180    private PartyPaymentMethodCreditCards(Name alias, Table<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards> aliased) {
181        this(alias, aliased, (Field<?>[]) null, null);
182    }
183
184    private PartyPaymentMethodCreditCards(Name alias, Table<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards> aliased, Field<?>[] parameters, Condition where) {
185        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
186    }
187
188    /**
189     * Create an aliased <code>partypaymentmethodcreditcards</code> table
190     * reference
191     */
192    public PartyPaymentMethodCreditCards(String alias) {
193        this(DSL.name(alias), PartyPaymentMethodCreditCards);
194    }
195
196    /**
197     * Create an aliased <code>partypaymentmethodcreditcards</code> table
198     * reference
199     */
200    public PartyPaymentMethodCreditCards(Name alias) {
201        this(alias, PartyPaymentMethodCreditCards);
202    }
203
204    /**
205     * Create a <code>partypaymentmethodcreditcards</code> table reference
206     */
207    public PartyPaymentMethodCreditCards() {
208        this(DSL.name("partypaymentmethodcreditcards"), null);
209    }
210
211    @Override
212    public UniqueKey<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards> getPrimaryKey() {
213        return KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_PK;
214    }
215
216    @Override
217    public List<UniqueKey<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards>> getUniqueKeys() {
218        return Arrays.asList(KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_PARTY_PAYMENT_METHOD_AND_THRU_TIME_UK);
219    }
220
221    @Override
222    public List<ForeignKey<com.echothree.model.jooq.server.records.payment.PartyPaymentMethodCreditCards, ?>> getReferences() {
223        return Arrays.asList(KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_BILLING_PARTY_CONTACT_MECHANISM_FK, KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_ISSUER_PARTY_CONTACT_MECHANISM_FK, KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_NAME_SUFFIX_FK, KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_PARTY_PAYMENT_METHOD_FK, KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_PERSONAL_TITLE_FK);
224    }
225
226    private transient PartyContactMechanismsPath _parpmcc_billingpartycontactmechanismid_fk;
227
228    /**
229     * Get the implicit join path to the <code>partycontactmechanisms</code>
230     * table, via the <code>parpmcc_billingpartycontactmechanismid_fk</code>
231     * key.
232     */
233    public PartyContactMechanismsPath parpmcc_billingpartycontactmechanismid_fk() {
234        if (_parpmcc_billingpartycontactmechanismid_fk == null)
235            _parpmcc_billingpartycontactmechanismid_fk = new PartyContactMechanismsPath(this, KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_BILLING_PARTY_CONTACT_MECHANISM_FK, null);
236
237        return _parpmcc_billingpartycontactmechanismid_fk;
238    }
239
240    private transient PartyContactMechanismsPath _parpmcc_issuerpartycontactmechanismid_fk;
241
242    /**
243     * Get the implicit join path to the <code>partycontactmechanisms</code>
244     * table, via the <code>parpmcc_issuerpartycontactmechanismid_fk</code> key.
245     */
246    public PartyContactMechanismsPath parpmcc_issuerpartycontactmechanismid_fk() {
247        if (_parpmcc_issuerpartycontactmechanismid_fk == null)
248            _parpmcc_issuerpartycontactmechanismid_fk = new PartyContactMechanismsPath(this, KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_ISSUER_PARTY_CONTACT_MECHANISM_FK, null);
249
250        return _parpmcc_issuerpartycontactmechanismid_fk;
251    }
252
253    private transient NameSuffixesPath _parpmcc_nsfx_namesuffixid_fk;
254
255    /**
256     * Get the implicit join path to the <code>namesuffixes</code> table.
257     */
258    public NameSuffixesPath parpmcc_nsfx_namesuffixid_fk() {
259        if (_parpmcc_nsfx_namesuffixid_fk == null)
260            _parpmcc_nsfx_namesuffixid_fk = new NameSuffixesPath(this, KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_NAME_SUFFIX_FK, null);
261
262        return _parpmcc_nsfx_namesuffixid_fk;
263    }
264
265    private transient PartyPaymentMethodsPath _parpmcc_parpm_partypaymentmethodid_fk;
266
267    /**
268     * Get the implicit join path to the <code>partypaymentmethods</code> table.
269     */
270    public PartyPaymentMethodsPath parpmcc_parpm_partypaymentmethodid_fk() {
271        if (_parpmcc_parpm_partypaymentmethodid_fk == null)
272            _parpmcc_parpm_partypaymentmethodid_fk = new PartyPaymentMethodsPath(this, KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_PARTY_PAYMENT_METHOD_FK, null);
273
274        return _parpmcc_parpm_partypaymentmethodid_fk;
275    }
276
277    private transient PersonalTitlesPath _parpmcc_pert_personaltitleid_fk;
278
279    /**
280     * Get the implicit join path to the <code>personaltitles</code> table.
281     */
282    public PersonalTitlesPath parpmcc_pert_personaltitleid_fk() {
283        if (_parpmcc_pert_personaltitleid_fk == null)
284            _parpmcc_pert_personaltitleid_fk = new PersonalTitlesPath(this, KeyRegistry.PARTY_PAYMENT_METHOD_CREDIT_CARDS_PERSONAL_TITLE_FK, null);
285
286        return _parpmcc_pert_personaltitleid_fk;
287    }
288
289    @Override
290    public PartyPaymentMethodCreditCards as(String alias) {
291        return new PartyPaymentMethodCreditCards(DSL.name(alias), this);
292    }
293
294    @Override
295    public PartyPaymentMethodCreditCards as(Name alias) {
296        return new PartyPaymentMethodCreditCards(alias, this);
297    }
298
299    @Override
300    public PartyPaymentMethodCreditCards as(Table<?> alias) {
301        return new PartyPaymentMethodCreditCards(alias.getQualifiedName(), this);
302    }
303
304    /**
305     * Rename this table
306     */
307    @Override
308    public PartyPaymentMethodCreditCards rename(String name) {
309        return new PartyPaymentMethodCreditCards(DSL.name(name), null);
310    }
311
312    /**
313     * Rename this table
314     */
315    @Override
316    public PartyPaymentMethodCreditCards rename(Name name) {
317        return new PartyPaymentMethodCreditCards(name, null);
318    }
319
320    /**
321     * Rename this table
322     */
323    @Override
324    public PartyPaymentMethodCreditCards rename(Table<?> name) {
325        return new PartyPaymentMethodCreditCards(name.getQualifiedName(), null);
326    }
327
328    /**
329     * Create an inline derived table from this table
330     */
331    @Override
332    public PartyPaymentMethodCreditCards where(Condition condition) {
333        return new PartyPaymentMethodCreditCards(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
334    }
335
336    /**
337     * Create an inline derived table from this table
338     */
339    @Override
340    public PartyPaymentMethodCreditCards where(Collection<? extends Condition> conditions) {
341        return where(DSL.and(conditions));
342    }
343
344    /**
345     * Create an inline derived table from this table
346     */
347    @Override
348    public PartyPaymentMethodCreditCards where(Condition... conditions) {
349        return where(DSL.and(conditions));
350    }
351
352    /**
353     * Create an inline derived table from this table
354     */
355    @Override
356    public PartyPaymentMethodCreditCards where(Field<Boolean> condition) {
357        return where(DSL.condition(condition));
358    }
359
360    /**
361     * Create an inline derived table from this table
362     */
363    @Override
364    @PlainSQL
365    public PartyPaymentMethodCreditCards where(SQL condition) {
366        return where(DSL.condition(condition));
367    }
368
369    /**
370     * Create an inline derived table from this table
371     */
372    @Override
373    @PlainSQL
374    public PartyPaymentMethodCreditCards where(@Stringly.SQL String condition) {
375        return where(DSL.condition(condition));
376    }
377
378    /**
379     * Create an inline derived table from this table
380     */
381    @Override
382    @PlainSQL
383    public PartyPaymentMethodCreditCards where(@Stringly.SQL String condition, Object... binds) {
384        return where(DSL.condition(condition, binds));
385    }
386
387    /**
388     * Create an inline derived table from this table
389     */
390    @Override
391    @PlainSQL
392    public PartyPaymentMethodCreditCards where(@Stringly.SQL String condition, QueryPart... parts) {
393        return where(DSL.condition(condition, parts));
394    }
395
396    /**
397     * Create an inline derived table from this table
398     */
399    @Override
400    public PartyPaymentMethodCreditCards whereExists(TableLike<?> select) {
401        return where(DSL.exists(select));
402    }
403
404    /**
405     * Create an inline derived table from this table
406     */
407    @Override
408    public PartyPaymentMethodCreditCards whereNotExists(TableLike<?> select) {
409        return where(DSL.notExists(select));
410    }
411}