001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.contactlist;
005
006
007import com.echothree.model.data.contact.common.pk.ContactMechanismPurposePK;
008import com.echothree.model.data.contactlist.common.pk.ContactListContactMechanismPurposeDetailPK;
009import com.echothree.model.data.contactlist.common.pk.ContactListContactMechanismPurposePK;
010import com.echothree.model.data.contactlist.common.pk.ContactListPK;
011import com.echothree.model.jooq.server.KeyRegistry;
012import com.echothree.model.jooq.server.tables.contact.ContactMechanismPurposes.ContactMechanismPurposesPath;
013import com.echothree.model.jooq.server.tables.contactlist.ContactListContactMechanismPurposes.ContactListContactMechanismPurposesPath;
014import com.echothree.model.jooq.server.tables.contactlist.ContactLists.ContactListsPath;
015
016import java.util.Arrays;
017import java.util.Collection;
018import java.util.List;
019
020import org.jooq.Condition;
021import org.jooq.Converter;
022import org.jooq.Field;
023import org.jooq.ForeignKey;
024import org.jooq.InverseForeignKey;
025import org.jooq.Name;
026import org.jooq.Path;
027import org.jooq.PlainSQL;
028import org.jooq.QueryPart;
029import org.jooq.Record;
030import org.jooq.SQL;
031import org.jooq.Stringly;
032import org.jooq.Table;
033import org.jooq.TableField;
034import org.jooq.TableLike;
035import org.jooq.TableOptions;
036import org.jooq.UniqueKey;
037import org.jooq.impl.DSL;
038import org.jooq.impl.Internal;
039import org.jooq.impl.SQLDataType;
040import org.jooq.impl.TableImpl;
041
042
043/**
044 * This class is generated by jOOQ.
045 */
046@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
047public class ContactListContactMechanismPurposeDetails extends TableImpl<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> {
048
049    private static final long serialVersionUID = 1L;
050
051    /**
052     * The reference instance of
053     * <code>contactlistcontactmechanismpurposedetails</code>
054     */
055    public static final ContactListContactMechanismPurposeDetails ContactListContactMechanismPurposeDetails = new ContactListContactMechanismPurposeDetails();
056
057    /**
058     * The class holding records for this type
059     */
060    @Override
061    public Class<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> getRecordType() {
062        return com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails.class;
063    }
064
065    /**
066     * The column
067     * <code>contactlistcontactmechanismpurposedetails.clstcmprdt_contactlistcontactmechanismpurposedetailid</code>.
068     */
069    public final TableField<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails, ContactListContactMechanismPurposeDetailPK> CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_DETAIL = createField(DSL.name("clstcmprdt_contactlistcontactmechanismpurposedetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ContactListContactMechanismPurposeDetailPK.class, id -> new com.echothree.model.data.contactlist.common.pk.ContactListContactMechanismPurposeDetailPK(id), primaryKey -> primaryKey.getEntityId()));
070
071    /**
072     * The column
073     * <code>contactlistcontactmechanismpurposedetails.clstcmprdt_clstcmpr_contactlistcontactmechanismpurposeid</code>.
074     */
075    public final TableField<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails, ContactListContactMechanismPurposePK> CONTACT_LIST_CONTACT_MECHANISM_PURPOSE = createField(DSL.name("clstcmprdt_clstcmpr_contactlistcontactmechanismpurposeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ContactListContactMechanismPurposePK.class, id -> new com.echothree.model.data.contactlist.common.pk.ContactListContactMechanismPurposePK(id), primaryKey -> primaryKey.getEntityId()));
076
077    /**
078     * The column
079     * <code>contactlistcontactmechanismpurposedetails.clstcmprdt_clst_contactlistid</code>.
080     */
081    public final TableField<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails, ContactListPK> CONTACT_LIST = createField(DSL.name("clstcmprdt_clst_contactlistid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ContactListPK.class, id -> new com.echothree.model.data.contactlist.common.pk.ContactListPK(id), primaryKey -> primaryKey.getEntityId()));
082
083    /**
084     * The column
085     * <code>contactlistcontactmechanismpurposedetails.clstcmprdt_cmpr_contactmechanismpurposeid</code>.
086     */
087    public final TableField<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails, ContactMechanismPurposePK> CONTACT_MECHANISM_PURPOSE = createField(DSL.name("clstcmprdt_cmpr_contactmechanismpurposeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ContactMechanismPurposePK.class, id -> new com.echothree.model.data.contact.common.pk.ContactMechanismPurposePK(id), primaryKey -> primaryKey.getEntityId()));
088
089    /**
090     * The column
091     * <code>contactlistcontactmechanismpurposedetails.clstcmprdt_isdefault</code>.
092     */
093    public final TableField<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails, Boolean> IS_DEFAULT = createField(DSL.name("clstcmprdt_isdefault"), SQLDataType.BIT.nullable(false), this, "");
094
095    /**
096     * The column
097     * <code>contactlistcontactmechanismpurposedetails.clstcmprdt_sortorder</code>.
098     */
099    public final TableField<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails, Integer> SORT_ORDER = createField(DSL.name("clstcmprdt_sortorder"), SQLDataType.INTEGER.nullable(false), this, "");
100
101    /**
102     * The column
103     * <code>contactlistcontactmechanismpurposedetails.clstcmprdt_fromtime</code>.
104     */
105    public final TableField<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails, Long> FROM_TIME = createField(DSL.name("clstcmprdt_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
106
107    /**
108     * The column
109     * <code>contactlistcontactmechanismpurposedetails.clstcmprdt_thrutime</code>.
110     */
111    public final TableField<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails, Long> THRU_TIME = createField(DSL.name("clstcmprdt_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
112
113    private ContactListContactMechanismPurposeDetails(Name alias, Table<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> aliased) {
114        this(alias, aliased, (Field<?>[]) null, null);
115    }
116
117    private ContactListContactMechanismPurposeDetails(Name alias, Table<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> aliased, Field<?>[] parameters, Condition where) {
118        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
119    }
120
121    /**
122     * Create an aliased <code>contactlistcontactmechanismpurposedetails</code>
123     * table reference
124     */
125    public ContactListContactMechanismPurposeDetails(String alias) {
126        this(DSL.name(alias), ContactListContactMechanismPurposeDetails);
127    }
128
129    /**
130     * Create an aliased <code>contactlistcontactmechanismpurposedetails</code>
131     * table reference
132     */
133    public ContactListContactMechanismPurposeDetails(Name alias) {
134        this(alias, ContactListContactMechanismPurposeDetails);
135    }
136
137    /**
138     * Create a <code>contactlistcontactmechanismpurposedetails</code> table
139     * reference
140     */
141    public ContactListContactMechanismPurposeDetails() {
142        this(DSL.name("contactlistcontactmechanismpurposedetails"), null);
143    }
144
145    public <O extends Record> ContactListContactMechanismPurposeDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> parentPath) {
146        super(path, childPath, parentPath, ContactListContactMechanismPurposeDetails);
147    }
148
149    /**
150     * A subtype implementing {@link Path} for simplified path-based joins.
151     */
152    public static class ContactListContactMechanismPurposeDetailsPath extends ContactListContactMechanismPurposeDetails implements Path<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> {
153
154        private static final long serialVersionUID = 1L;
155        public <O extends Record> ContactListContactMechanismPurposeDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> parentPath) {
156            super(path, childPath, parentPath);
157        }
158        private ContactListContactMechanismPurposeDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> aliased) {
159            super(alias, aliased);
160        }
161
162        @Override
163        public ContactListContactMechanismPurposeDetailsPath as(String alias) {
164            return new ContactListContactMechanismPurposeDetailsPath(DSL.name(alias), this);
165        }
166
167        @Override
168        public ContactListContactMechanismPurposeDetailsPath as(Name alias) {
169            return new ContactListContactMechanismPurposeDetailsPath(alias, this);
170        }
171
172        @Override
173        public ContactListContactMechanismPurposeDetailsPath as(Table<?> alias) {
174            return new ContactListContactMechanismPurposeDetailsPath(alias.getQualifiedName(), this);
175        }
176    }
177
178    @Override
179    public UniqueKey<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails> getPrimaryKey() {
180        return KeyRegistry.CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_DETAILS_PK;
181    }
182
183    @Override
184    public List<UniqueKey<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails>> getUniqueKeys() {
185        return Arrays.asList(KeyRegistry.CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_DETAILS_CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_AND_THRU_TIME_UK, KeyRegistry.CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_DETAILS_CONTACT_LIST_AND_CONTACT_MECHANISM_PURPOSE_AND_THRU_TIME_UK);
186    }
187
188    @Override
189    public List<ForeignKey<com.echothree.model.jooq.server.records.contactlist.ContactListContactMechanismPurposeDetails, ?>> getReferences() {
190        return Arrays.asList(KeyRegistry.CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_DETAILS_CONTACT_LIST_FK, KeyRegistry.CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_DETAILS_CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_FK, KeyRegistry.CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_DETAILS_CONTACT_MECHANISM_PURPOSE_FK);
191    }
192
193    private transient ContactListsPath _clstcmprdt_clst_contactlistid_fk;
194
195    /**
196     * Get the implicit join path to the <code>contactlists</code> table.
197     */
198    public ContactListsPath clstcmprdt_clst_contactlistid_fk() {
199        if (_clstcmprdt_clst_contactlistid_fk == null)
200            _clstcmprdt_clst_contactlistid_fk = new ContactListsPath(this, KeyRegistry.CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_DETAILS_CONTACT_LIST_FK, null);
201
202        return _clstcmprdt_clst_contactlistid_fk;
203    }
204
205    private transient ContactListContactMechanismPurposesPath _clstcmprdt_clstcmpr_contactlistcontactmechanismpurposeid_fk;
206
207    /**
208     * Get the implicit join path to the
209     * <code>contactlistcontactmechanismpurposes</code> table.
210     */
211    public ContactListContactMechanismPurposesPath clstcmprdt_clstcmpr_contactlistcontactmechanismpurposeid_fk() {
212        if (_clstcmprdt_clstcmpr_contactlistcontactmechanismpurposeid_fk == null)
213            _clstcmprdt_clstcmpr_contactlistcontactmechanismpurposeid_fk = new ContactListContactMechanismPurposesPath(this, KeyRegistry.CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_DETAILS_CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_FK, null);
214
215        return _clstcmprdt_clstcmpr_contactlistcontactmechanismpurposeid_fk;
216    }
217
218    private transient ContactMechanismPurposesPath _clstcmprdt_cmpr_contactmechanismpurposeid_fk;
219
220    /**
221     * Get the implicit join path to the <code>contactmechanismpurposes</code>
222     * table.
223     */
224    public ContactMechanismPurposesPath clstcmprdt_cmpr_contactmechanismpurposeid_fk() {
225        if (_clstcmprdt_cmpr_contactmechanismpurposeid_fk == null)
226            _clstcmprdt_cmpr_contactmechanismpurposeid_fk = new ContactMechanismPurposesPath(this, KeyRegistry.CONTACT_LIST_CONTACT_MECHANISM_PURPOSE_DETAILS_CONTACT_MECHANISM_PURPOSE_FK, null);
227
228        return _clstcmprdt_cmpr_contactmechanismpurposeid_fk;
229    }
230
231    @Override
232    public ContactListContactMechanismPurposeDetails as(String alias) {
233        return new ContactListContactMechanismPurposeDetails(DSL.name(alias), this);
234    }
235
236    @Override
237    public ContactListContactMechanismPurposeDetails as(Name alias) {
238        return new ContactListContactMechanismPurposeDetails(alias, this);
239    }
240
241    @Override
242    public ContactListContactMechanismPurposeDetails as(Table<?> alias) {
243        return new ContactListContactMechanismPurposeDetails(alias.getQualifiedName(), this);
244    }
245
246    /**
247     * Rename this table
248     */
249    @Override
250    public ContactListContactMechanismPurposeDetails rename(String name) {
251        return new ContactListContactMechanismPurposeDetails(DSL.name(name), null);
252    }
253
254    /**
255     * Rename this table
256     */
257    @Override
258    public ContactListContactMechanismPurposeDetails rename(Name name) {
259        return new ContactListContactMechanismPurposeDetails(name, null);
260    }
261
262    /**
263     * Rename this table
264     */
265    @Override
266    public ContactListContactMechanismPurposeDetails rename(Table<?> name) {
267        return new ContactListContactMechanismPurposeDetails(name.getQualifiedName(), null);
268    }
269
270    /**
271     * Create an inline derived table from this table
272     */
273    @Override
274    public ContactListContactMechanismPurposeDetails where(Condition condition) {
275        return new ContactListContactMechanismPurposeDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
276    }
277
278    /**
279     * Create an inline derived table from this table
280     */
281    @Override
282    public ContactListContactMechanismPurposeDetails where(Collection<? extends Condition> conditions) {
283        return where(DSL.and(conditions));
284    }
285
286    /**
287     * Create an inline derived table from this table
288     */
289    @Override
290    public ContactListContactMechanismPurposeDetails where(Condition... conditions) {
291        return where(DSL.and(conditions));
292    }
293
294    /**
295     * Create an inline derived table from this table
296     */
297    @Override
298    public ContactListContactMechanismPurposeDetails where(Field<Boolean> condition) {
299        return where(DSL.condition(condition));
300    }
301
302    /**
303     * Create an inline derived table from this table
304     */
305    @Override
306    @PlainSQL
307    public ContactListContactMechanismPurposeDetails where(SQL condition) {
308        return where(DSL.condition(condition));
309    }
310
311    /**
312     * Create an inline derived table from this table
313     */
314    @Override
315    @PlainSQL
316    public ContactListContactMechanismPurposeDetails where(@Stringly.SQL String condition) {
317        return where(DSL.condition(condition));
318    }
319
320    /**
321     * Create an inline derived table from this table
322     */
323    @Override
324    @PlainSQL
325    public ContactListContactMechanismPurposeDetails where(@Stringly.SQL String condition, Object... binds) {
326        return where(DSL.condition(condition, binds));
327    }
328
329    /**
330     * Create an inline derived table from this table
331     */
332    @Override
333    @PlainSQL
334    public ContactListContactMechanismPurposeDetails where(@Stringly.SQL String condition, QueryPart... parts) {
335        return where(DSL.condition(condition, parts));
336    }
337
338    /**
339     * Create an inline derived table from this table
340     */
341    @Override
342    public ContactListContactMechanismPurposeDetails whereExists(TableLike<?> select) {
343        return where(DSL.exists(select));
344    }
345
346    /**
347     * Create an inline derived table from this table
348     */
349    @Override
350    public ContactListContactMechanismPurposeDetails whereNotExists(TableLike<?> select) {
351        return where(DSL.notExists(select));
352    }
353}