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
110     * <code>communicationemailsources.cmmnesrc_initializationvector</code>.
111     */
112    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, String> INITIALIZATION_VECTOR = createField(DSL.name("cmmnesrc_initializationvector"), SQLDataType.VARCHAR(200).nullable(false), this, "");
113
114    /**
115     * The column <code>communicationemailsources.cmmnesrc_fromtime</code>.
116     */
117    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, Long> FROM_TIME = createField(DSL.name("cmmnesrc_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
118
119    /**
120     * The column <code>communicationemailsources.cmmnesrc_thrutime</code>.
121     */
122    public final TableField<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, Long> THRU_TIME = createField(DSL.name("cmmnesrc_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
123
124    private CommunicationEmailSources(Name alias, Table<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources> aliased) {
125        this(alias, aliased, (Field<?>[]) null, null);
126    }
127
128    private CommunicationEmailSources(Name alias, Table<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources> aliased, Field<?>[] parameters, Condition where) {
129        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
130    }
131
132    /**
133     * Create an aliased <code>communicationemailsources</code> table reference
134     */
135    public CommunicationEmailSources(String alias) {
136        this(DSL.name(alias), CommunicationEmailSources);
137    }
138
139    /**
140     * Create an aliased <code>communicationemailsources</code> table reference
141     */
142    public CommunicationEmailSources(Name alias) {
143        this(alias, CommunicationEmailSources);
144    }
145
146    /**
147     * Create a <code>communicationemailsources</code> table reference
148     */
149    public CommunicationEmailSources() {
150        this(DSL.name("communicationemailsources"), null);
151    }
152
153    @Override
154    public UniqueKey<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources> getPrimaryKey() {
155        return KeyRegistry.COMMUNICATION_EMAIL_SOURCES_PK;
156    }
157
158    @Override
159    public List<UniqueKey<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources>> getUniqueKeys() {
160        return Arrays.asList(KeyRegistry.COMMUNICATION_EMAIL_SOURCES_COMMUNICATION_SOURCE_AND_THRU_TIME_UK);
161    }
162
163    @Override
164    public List<ForeignKey<com.echothree.model.jooq.server.records.communication.CommunicationEmailSources, ?>> getReferences() {
165        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);
166    }
167
168    private transient CommunicationSourcesPath _cmmnesrc_cmmnsrc_communicationsourceid_fk;
169
170    /**
171     * Get the implicit join path to the <code>communicationsources</code>
172     * table.
173     */
174    public CommunicationSourcesPath cmmnesrc_cmmnsrc_communicationsourceid_fk() {
175        if (_cmmnesrc_cmmnsrc_communicationsourceid_fk == null)
176            _cmmnesrc_cmmnsrc_communicationsourceid_fk = new CommunicationSourcesPath(this, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_COMMUNICATION_SOURCE_FK, null);
177
178        return _cmmnesrc_cmmnsrc_communicationsourceid_fk;
179    }
180
181    private transient WorkEffortScopesPath _cmmnesrc_receiveworkeffortscopeid_fk;
182
183    /**
184     * Get the implicit join path to the <code>workeffortscopes</code> table,
185     * via the <code>cmmnesrc_receiveworkeffortscopeid_fk</code> key.
186     */
187    public WorkEffortScopesPath cmmnesrc_receiveworkeffortscopeid_fk() {
188        if (_cmmnesrc_receiveworkeffortscopeid_fk == null)
189            _cmmnesrc_receiveworkeffortscopeid_fk = new WorkEffortScopesPath(this, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_RECEIVE_WORK_EFFORT_SCOPE_FK, null);
190
191        return _cmmnesrc_receiveworkeffortscopeid_fk;
192    }
193
194    private transient SelectorsPath _cmmnesrc_reviewemployeeselectorid_fk;
195
196    /**
197     * Get the implicit join path to the <code>selectors</code> table.
198     */
199    public SelectorsPath cmmnesrc_reviewemployeeselectorid_fk() {
200        if (_cmmnesrc_reviewemployeeselectorid_fk == null)
201            _cmmnesrc_reviewemployeeselectorid_fk = new SelectorsPath(this, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_REVIEW_EMPLOYEE_SELECTOR_FK, null);
202
203        return _cmmnesrc_reviewemployeeselectorid_fk;
204    }
205
206    private transient WorkEffortScopesPath _cmmnesrc_sendworkeffortscopeid_fk;
207
208    /**
209     * Get the implicit join path to the <code>workeffortscopes</code> table,
210     * via the <code>cmmnesrc_sendworkeffortscopeid_fk</code> key.
211     */
212    public WorkEffortScopesPath cmmnesrc_sendworkeffortscopeid_fk() {
213        if (_cmmnesrc_sendworkeffortscopeid_fk == null)
214            _cmmnesrc_sendworkeffortscopeid_fk = new WorkEffortScopesPath(this, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_SEND_WORK_EFFORT_SCOPE_FK, null);
215
216        return _cmmnesrc_sendworkeffortscopeid_fk;
217    }
218
219    private transient ServersPath _cmmnesrc_serv_serverid_fk;
220
221    /**
222     * Get the implicit join path to the <code>servers</code> table.
223     */
224    public ServersPath cmmnesrc_serv_serverid_fk() {
225        if (_cmmnesrc_serv_serverid_fk == null)
226            _cmmnesrc_serv_serverid_fk = new ServersPath(this, KeyRegistry.COMMUNICATION_EMAIL_SOURCES_SERVER_FK, null);
227
228        return _cmmnesrc_serv_serverid_fk;
229    }
230
231    @Override
232    public CommunicationEmailSources as(String alias) {
233        return new CommunicationEmailSources(DSL.name(alias), this);
234    }
235
236    @Override
237    public CommunicationEmailSources as(Name alias) {
238        return new CommunicationEmailSources(alias, this);
239    }
240
241    @Override
242    public CommunicationEmailSources as(Table<?> alias) {
243        return new CommunicationEmailSources(alias.getQualifiedName(), this);
244    }
245
246    /**
247     * Rename this table
248     */
249    @Override
250    public CommunicationEmailSources rename(String name) {
251        return new CommunicationEmailSources(DSL.name(name), null);
252    }
253
254    /**
255     * Rename this table
256     */
257    @Override
258    public CommunicationEmailSources rename(Name name) {
259        return new CommunicationEmailSources(name, null);
260    }
261
262    /**
263     * Rename this table
264     */
265    @Override
266    public CommunicationEmailSources rename(Table<?> name) {
267        return new CommunicationEmailSources(name.getQualifiedName(), null);
268    }
269
270    /**
271     * Create an inline derived table from this table
272     */
273    @Override
274    public CommunicationEmailSources where(Condition condition) {
275        return new CommunicationEmailSources(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 CommunicationEmailSources 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 CommunicationEmailSources 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 CommunicationEmailSources 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 CommunicationEmailSources 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 CommunicationEmailSources 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 CommunicationEmailSources 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 CommunicationEmailSources 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 CommunicationEmailSources 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 CommunicationEmailSources whereNotExists(TableLike<?> select) {
351        return where(DSL.notExists(select));
352    }
353}