Source code

001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.communication;
005
006
007import com.echothree.model.data.communication.common.pk.CommunicationEmailSourcePK;
008import com.echothree.model.data.communication.common.pk.CommunicationSourcePK;
009import com.echothree.model.data.core.common.pk.ServerPK;
010import com.echothree.model.data.selector.common.pk.SelectorPK;
011import com.echothree.model.data.workeffort.common.pk.WorkEffortScopePK;
012import com.echothree.model.jooq.server.KeyRegistry;
013import com.echothree.model.jooq.server.tables.communication.CommunicationSources.CommunicationSourcesPath;
014import com.echothree.model.jooq.server.tables.core.Servers.ServersPath;
015import com.echothree.model.jooq.server.tables.selector.Selectors.SelectorsPath;
016import com.echothree.model.jooq.server.tables.workeffort.WorkEffortScopes.WorkEffortScopesPath;
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 CommunicationEmailSources extends TableImpl<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources> {
047
048    private static final long serialVersionUID = 1L;
049
050    /**
051     * The reference instance of <code>communicationemailsources</code>
052     */
053    public static final CommunicationEmailSources CommunicationEmailSources = new CommunicationEmailSources();
054
055    /**
056     * The class holding records for this type
057     */
058    @Override
059    public Class<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources> getRecordType() {
060        return com.echothree.model.jooq.server.records.communication.CommunicationEmailSources.class;
061    }
062
063    /**
064     * The column
065     * <code>communicationemailsources.cmmnesrc_communicationemailsourceid</code>.
066     */
067    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, CommunicationEmailSourcePK> COMMUNICATION_EMAIL_SOURCE = createField(DSL.name("cmmnesrc_communicationemailsourceid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, CommunicationEmailSourcePK.class, id -> new com.echothree.model.data.communication.common.pk.CommunicationEmailSourcePK(id), primaryKey -> primaryKey.getEntityId()));
068
069    /**
070     * The column
071     * <code>communicationemailsources.cmmnesrc_cmmnsrc_communicationsourceid</code>.
072     */
073    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, CommunicationSourcePK> COMMUNICATION_SOURCE = createField(DSL.name("cmmnesrc_cmmnsrc_communicationsourceid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, CommunicationSourcePK.class, id -> new com.echothree.model.data.communication.common.pk.CommunicationSourcePK(id), primaryKey -> primaryKey.getEntityId()));
074
075    /**
076     * The column <code>communicationemailsources.cmmnesrc_serv_serverid</code>.
077     */
078    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, ServerPK> SERVER = createField(DSL.name("cmmnesrc_serv_serverid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ServerPK.class, id -> new com.echothree.model.data.core.common.pk.ServerPK(id), primaryKey -> primaryKey.getEntityId()));
079
080    /**
081     * The column <code>communicationemailsources.cmmnesrc_username</code>.
082     */
083    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, String> USERNAME = createField(DSL.name("cmmnesrc_username"), SQLDataType.VARCHAR(80).nullable(false), this, "");
084
085    /**
086     * The column <code>communicationemailsources.cmmnesrc_password</code>.
087     */
088    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, String> PASSWORD = createField(DSL.name("cmmnesrc_password"), SQLDataType.VARCHAR(200).nullable(false), this, "");
089
090    /**
091     * The column
092     * <code>communicationemailsources.cmmnesrc_receiveworkeffortscopeid</code>.
093     */
094    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, WorkEffortScopePK> RECEIVE_WORK_EFFORT_SCOPE = createField(DSL.name("cmmnesrc_receiveworkeffortscopeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, WorkEffortScopePK.class, id -> new com.echothree.model.data.workeffort.common.pk.WorkEffortScopePK(id), primaryKey -> primaryKey.getEntityId()));
095
096    /**
097     * The column
098     * <code>communicationemailsources.cmmnesrc_sendworkeffortscopeid</code>.
099     */
100    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, WorkEffortScopePK> SEND_WORK_EFFORT_SCOPE = createField(DSL.name("cmmnesrc_sendworkeffortscopeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, WorkEffortScopePK.class, id -> new com.echothree.model.data.workeffort.common.pk.WorkEffortScopePK(id), primaryKey -> primaryKey.getEntityId()));
101
102    /**
103     * The column
104     * <code>communicationemailsources.cmmnesrc_reviewemployeeselectorid</code>.
105     */
106    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, SelectorPK> REVIEW_EMPLOYEE_SELECTOR = createField(DSL.name("cmmnesrc_reviewemployeeselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
107
108    /**
109     * The column <code>communicationemailsources.cmmnesrc_fromtime</code>.
110     */
111    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, Long> FROM_TIME = createField(DSL.name("cmmnesrc_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
112
113    /**
114     * The column <code>communicationemailsources.cmmnesrc_thrutime</code>.
115     */
116    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, Long> THRU_TIME = createField(DSL.name("cmmnesrc_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
117
118    private CommunicationEmailSources(Name alias, Table<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources> aliased) {
119        this(alias, aliased, (Field<?>[]) null, null);
120    }
121
122    private CommunicationEmailSources(Name alias, Table<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources> aliased, Field<?>[] parameters, Condition where) {
123        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
124    }
125
126    /**
127     * Create an aliased <code>communicationemailsources</code> table reference
128     */
129    public CommunicationEmailSources(String alias) {
130        this(DSL.name(alias), CommunicationEmailSources);
131    }
132
133    /**
134     * Create an aliased <code>communicationemailsources</code> table reference
135     */
136    public CommunicationEmailSources(Name alias) {
137        this(alias, CommunicationEmailSources);
138    }
139
140    /**
141     * Create a <code>communicationemailsources</code> table reference
142     */
143    public CommunicationEmailSources() {
144        this(DSL.name("communicationemailsources"), null);
145    }
146
147    @Override
148    public UniqueKey<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources> getPrimaryKey() {
149        return KeyRegistry.COMMUNICATION_EMAIL_SOURCES_PK;
150    }
151
152    @Override
153    public List<UniqueKey<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources>> getUniqueKeys() {
154        return Arrays.asList(KeyRegistry.COMMUNICATION_EMAIL_SOURCES_COMMUNICATION_SOURCE_AND_THRU_TIME_UK);
155    }
156
157    @Override
158    public List<ForeignKey<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, ?>> getReferences() {
159        return Arrays.asList(KeyRegistry.COMMUNICATION_EMAIL_SOURCES_COMMUNICATION_SOURCE_FK, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_RECEIVE_WORK_EFFORT_SCOPE_FK, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_REVIEW_EMPLOYEE_SELECTOR_FK, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_SEND_WORK_EFFORT_SCOPE_FK, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_SERVER_FK);
160    }
161
162    private transient CommunicationSourcesPath _cmmnesrc_cmmnsrc_communicationsourceid_fk;
163
164    /**
165     * Get the implicit join path to the <code>communicationsources</code>
166     * table.
167     */
168    public CommunicationSourcesPath cmmnesrc_cmmnsrc_communicationsourceid_fk() {
169        if (_cmmnesrc_cmmnsrc_communicationsourceid_fk == null)
170            _cmmnesrc_cmmnsrc_communicationsourceid_fk = new CommunicationSourcesPath(this, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_COMMUNICATION_SOURCE_FK, null);
171
172        return _cmmnesrc_cmmnsrc_communicationsourceid_fk;
173    }
174
175    private transient WorkEffortScopesPath _cmmnesrc_receiveworkeffortscopeid_fk;
176
177    /**
178     * Get the implicit join path to the <code>workeffortscopes</code> table,
179     * via the <code>cmmnesrc_receiveworkeffortscopeid_fk</code> key.
180     */
181    public WorkEffortScopesPath cmmnesrc_receiveworkeffortscopeid_fk() {
182        if (_cmmnesrc_receiveworkeffortscopeid_fk == null)
183            _cmmnesrc_receiveworkeffortscopeid_fk = new WorkEffortScopesPath(this, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_RECEIVE_WORK_EFFORT_SCOPE_FK, null);
184
185        return _cmmnesrc_receiveworkeffortscopeid_fk;
186    }
187
188    private transient SelectorsPath _cmmnesrc_reviewemployeeselectorid_fk;
189
190    /**
191     * Get the implicit join path to the <code>selectors</code> table.
192     */
193    public SelectorsPath cmmnesrc_reviewemployeeselectorid_fk() {
194        if (_cmmnesrc_reviewemployeeselectorid_fk == null)
195            _cmmnesrc_reviewemployeeselectorid_fk = new SelectorsPath(this, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_REVIEW_EMPLOYEE_SELECTOR_FK, null);
196
197        return _cmmnesrc_reviewemployeeselectorid_fk;
198    }
199
200    private transient WorkEffortScopesPath _cmmnesrc_sendworkeffortscopeid_fk;
201
202    /**
203     * Get the implicit join path to the <code>workeffortscopes</code> table,
204     * via the <code>cmmnesrc_sendworkeffortscopeid_fk</code> key.
205     */
206    public WorkEffortScopesPath cmmnesrc_sendworkeffortscopeid_fk() {
207        if (_cmmnesrc_sendworkeffortscopeid_fk == null)
208            _cmmnesrc_sendworkeffortscopeid_fk = new WorkEffortScopesPath(this, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_SEND_WORK_EFFORT_SCOPE_FK, null);
209
210        return _cmmnesrc_sendworkeffortscopeid_fk;
211    }
212
213    private transient ServersPath _cmmnesrc_serv_serverid_fk;
214
215    /**
216     * Get the implicit join path to the <code>servers</code> table.
217     */
218    public ServersPath cmmnesrc_serv_serverid_fk() {
219        if (_cmmnesrc_serv_serverid_fk == null)
220            _cmmnesrc_serv_serverid_fk = new ServersPath(this, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_SERVER_FK, null);
221
222        return _cmmnesrc_serv_serverid_fk;
223    }
224
225    @Override
226    public CommunicationEmailSources as(String alias) {
227        return new CommunicationEmailSources(DSL.name(alias), this);
228    }
229
230    @Override
231    public CommunicationEmailSources as(Name alias) {
232        return new CommunicationEmailSources(alias, this);
233    }
234
235    @Override
236    public CommunicationEmailSources as(Table<?> alias) {
237        return new CommunicationEmailSources(alias.getQualifiedName(), this);
238    }
239
240    /**
241     * Rename this table
242     */
243    @Override
244    public CommunicationEmailSources rename(String name) {
245        return new CommunicationEmailSources(DSL.name(name), null);
246    }
247
248    /**
249     * Rename this table
250     */
251    @Override
252    public CommunicationEmailSources rename(Name name) {
253        return new CommunicationEmailSources(name, null);
254    }
255
256    /**
257     * Rename this table
258     */
259    @Override
260    public CommunicationEmailSources rename(Table<?> name) {
261        return new CommunicationEmailSources(name.getQualifiedName(), null);
262    }
263
264    /**
265     * Create an inline derived table from this table
266     */
267    @Override
268    public CommunicationEmailSources where(Condition condition) {
269        return new CommunicationEmailSources(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
270    }
271
272    /**
273     * Create an inline derived table from this table
274     */
275    @Override
276    public CommunicationEmailSources where(Collection<? extends Condition> conditions) {
277        return where(DSL.and(conditions));
278    }
279
280    /**
281     * Create an inline derived table from this table
282     */
283    @Override
284    public CommunicationEmailSources where(Condition... conditions) {
285        return where(DSL.and(conditions));
286    }
287
288    /**
289     * Create an inline derived table from this table
290     */
291    @Override
292    public CommunicationEmailSources where(Field<Boolean> condition) {
293        return where(DSL.condition(condition));
294    }
295
296    /**
297     * Create an inline derived table from this table
298     */
299    @Override
300    @PlainSQL
301    public CommunicationEmailSources where(SQL condition) {
302        return where(DSL.condition(condition));
303    }
304
305    /**
306     * Create an inline derived table from this table
307     */
308    @Override
309    @PlainSQL
310    public CommunicationEmailSources where(@Stringly.SQL String condition) {
311        return where(DSL.condition(condition));
312    }
313
314    /**
315     * Create an inline derived table from this table
316     */
317    @Override
318    @PlainSQL
319    public CommunicationEmailSources where(@Stringly.SQL String condition, Object... binds) {
320        return where(DSL.condition(condition, binds));
321    }
322
323    /**
324     * Create an inline derived table from this table
325     */
326    @Override
327    @PlainSQL
328    public CommunicationEmailSources where(@Stringly.SQL String condition, QueryPart... parts) {
329        return where(DSL.condition(condition, parts));
330    }
331
332    /**
333     * Create an inline derived table from this table
334     */
335    @Override
336    public CommunicationEmailSources whereExists(TableLike<?> select) {
337        return where(DSL.exists(select));
338    }
339
340    /**
341     * Create an inline derived table from this table
342     */
343    @Override
344    public CommunicationEmailSources whereNotExists(TableLike<?> select) {
345        return where(DSL.notExists(select));
346    }
347}