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