Source code

001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.workrequirement;
005
006
007import com.echothree.model.data.party.common.pk.PartyPK;
008import com.echothree.model.data.workrequirement.common.pk.WorkAssignmentDetailPK;
009import com.echothree.model.data.workrequirement.common.pk.WorkAssignmentPK;
010import com.echothree.model.data.workrequirement.common.pk.WorkRequirementPK;
011import com.echothree.model.jooq.server.KeyRegistry;
012import com.echothree.model.jooq.server.tables.party.Parties.PartiesPath;
013import com.echothree.model.jooq.server.tables.workrequirement.WorkAssignments.WorkAssignmentsPath;
014import com.echothree.model.jooq.server.tables.workrequirement.WorkRequirements.WorkRequirementsPath;
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 WorkAssignmentDetails extends TableImpl<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> {
048
049    private static final long serialVersionUID = 1L;
050
051    /**
052     * The reference instance of <code>workassignmentdetails</code>
053     */
054    public static final WorkAssignmentDetails WorkAssignmentDetails = new WorkAssignmentDetails();
055
056    /**
057     * The class holding records for this type
058     */
059    @Override
060    public Class<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> getRecordType() {
061        return com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails.class;
062    }
063
064    /**
065     * The column
066     * <code>workassignmentdetails.wasgndt_workassignmentdetailid</code>.
067     */
068    public final TableField<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails, WorkAssignmentDetailPK> WORK_ASSIGNMENT_DETAIL = createField(DSL.name("wasgndt_workassignmentdetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, WorkAssignmentDetailPK.class, id -> new com.echothree.model.data.workrequirement.common.pk.WorkAssignmentDetailPK(id), primaryKey -> primaryKey.getEntityId()));
069
070    /**
071     * The column
072     * <code>workassignmentdetails.wasgndt_wasgn_workassignmentid</code>.
073     */
074    public final TableField<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails, WorkAssignmentPK> WORK_ASSIGNMENT = createField(DSL.name("wasgndt_wasgn_workassignmentid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, WorkAssignmentPK.class, id -> new com.echothree.model.data.workrequirement.common.pk.WorkAssignmentPK(id), primaryKey -> primaryKey.getEntityId()));
075
076    /**
077     * The column
078     * <code>workassignmentdetails.wasgndt_wr_workrequirementid</code>.
079     */
080    public final TableField<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails, WorkRequirementPK> WORK_REQUIREMENT = createField(DSL.name("wasgndt_wr_workrequirementid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, WorkRequirementPK.class, id -> new com.echothree.model.data.workrequirement.common.pk.WorkRequirementPK(id), primaryKey -> primaryKey.getEntityId()));
081
082    /**
083     * The column
084     * <code>workassignmentdetails.wasgndt_workassignmentsequence</code>.
085     */
086    public final TableField<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails, Integer> WORK_ASSIGNMENT_SEQUENCE = createField(DSL.name("wasgndt_workassignmentsequence"), SQLDataType.INTEGER.nullable(false), this, "");
087
088    /**
089     * The column <code>workassignmentdetails.wasgndt_par_partyid</code>.
090     */
091    public final TableField<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails, PartyPK> PARTY = createField(DSL.name("wasgndt_par_partyid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PartyPK.class, id -> new com.echothree.model.data.party.common.pk.PartyPK(id), primaryKey -> primaryKey.getEntityId()));
092
093    /**
094     * The column <code>workassignmentdetails.wasgndt_starttime</code>.
095     */
096    public final TableField<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails, Long> START_TIME = createField(DSL.name("wasgndt_starttime"), SQLDataType.BIGINT.nullable(false), this, "");
097
098    /**
099     * The column <code>workassignmentdetails.wasgndt_endtime</code>.
100     */
101    public final TableField<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails, Long> END_TIME = createField(DSL.name("wasgndt_endtime"), SQLDataType.BIGINT, this, "");
102
103    /**
104     * The column <code>workassignmentdetails.wasgndt_fromtime</code>.
105     */
106    public final TableField<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails, Long> FROM_TIME = createField(DSL.name("wasgndt_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
107
108    /**
109     * The column <code>workassignmentdetails.wasgndt_thrutime</code>.
110     */
111    public final TableField<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails, Long> THRU_TIME = createField(DSL.name("wasgndt_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
112
113    private WorkAssignmentDetails(Name alias, Table<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> aliased) {
114        this(alias, aliased, (Field<?>[]) null, null);
115    }
116
117    private WorkAssignmentDetails(Name alias, Table<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> aliased, Field<?>[] parameters, Condition where) {
118        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
119    }
120
121    /**
122     * Create an aliased <code>workassignmentdetails</code> table reference
123     */
124    public WorkAssignmentDetails(String alias) {
125        this(DSL.name(alias), WorkAssignmentDetails);
126    }
127
128    /**
129     * Create an aliased <code>workassignmentdetails</code> table reference
130     */
131    public WorkAssignmentDetails(Name alias) {
132        this(alias, WorkAssignmentDetails);
133    }
134
135    /**
136     * Create a <code>workassignmentdetails</code> table reference
137     */
138    public WorkAssignmentDetails() {
139        this(DSL.name("workassignmentdetails"), null);
140    }
141
142    public <O extends Record> WorkAssignmentDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> parentPath) {
143        super(path, childPath, parentPath, WorkAssignmentDetails);
144    }
145
146    /**
147     * A subtype implementing {@link Path} for simplified path-based joins.
148     */
149    public static class WorkAssignmentDetailsPath extends WorkAssignmentDetails implements Path<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> {
150
151        private static final long serialVersionUID = 1L;
152        public <O extends Record> WorkAssignmentDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> parentPath) {
153            super(path, childPath, parentPath);
154        }
155        private WorkAssignmentDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> aliased) {
156            super(alias, aliased);
157        }
158
159        @Override
160        public WorkAssignmentDetailsPath as(String alias) {
161            return new WorkAssignmentDetailsPath(DSL.name(alias), this);
162        }
163
164        @Override
165        public WorkAssignmentDetailsPath as(Name alias) {
166            return new WorkAssignmentDetailsPath(alias, this);
167        }
168
169        @Override
170        public WorkAssignmentDetailsPath as(Table<?> alias) {
171            return new WorkAssignmentDetailsPath(alias.getQualifiedName(), this);
172        }
173    }
174
175    @Override
176    public UniqueKey<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails> getPrimaryKey() {
177        return KeyRegistry.WORK_ASSIGNMENT_DETAILS_PK;
178    }
179
180    @Override
181    public List<UniqueKey<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails>> getUniqueKeys() {
182        return Arrays.asList(KeyRegistry.WORK_ASSIGNMENT_DETAILS_WORK_ASSIGNMENT_AND_THRU_TIME_UK, KeyRegistry.WORK_ASSIGNMENT_DETAILS_WORK_REQUIREMENT_AND_WORK_ASSIGNMENT_SEQUENCE_AND_THRU_TIME_UK);
183    }
184
185    @Override
186    public List<ForeignKey<com.echothree.model.jooq.server.records.workrequirement.WorkAssignmentDetails, ?>> getReferences() {
187        return Arrays.asList(KeyRegistry.WORK_ASSIGNMENT_DETAILS_PARTY_FK, KeyRegistry.WORK_ASSIGNMENT_DETAILS_WORK_ASSIGNMENT_FK, KeyRegistry.WORK_ASSIGNMENT_DETAILS_WORK_REQUIREMENT_FK);
188    }
189
190    private transient PartiesPath _wasgndt_par_partyid_fk;
191
192    /**
193     * Get the implicit join path to the <code>parties</code> table.
194     */
195    public PartiesPath wasgndt_par_partyid_fk() {
196        if (_wasgndt_par_partyid_fk == null)
197            _wasgndt_par_partyid_fk = new PartiesPath(this, KeyRegistry.WORK_ASSIGNMENT_DETAILS_PARTY_FK, null);
198
199        return _wasgndt_par_partyid_fk;
200    }
201
202    private transient WorkAssignmentsPath _wasgndt_wasgn_workassignmentid_fk;
203
204    /**
205     * Get the implicit join path to the <code>workassignments</code> table.
206     */
207    public WorkAssignmentsPath wasgndt_wasgn_workassignmentid_fk() {
208        if (_wasgndt_wasgn_workassignmentid_fk == null)
209            _wasgndt_wasgn_workassignmentid_fk = new WorkAssignmentsPath(this, KeyRegistry.WORK_ASSIGNMENT_DETAILS_WORK_ASSIGNMENT_FK, null);
210
211        return _wasgndt_wasgn_workassignmentid_fk;
212    }
213
214    private transient WorkRequirementsPath _wasgndt_wr_workrequirementid_fk;
215
216    /**
217     * Get the implicit join path to the <code>workrequirements</code> table.
218     */
219    public WorkRequirementsPath wasgndt_wr_workrequirementid_fk() {
220        if (_wasgndt_wr_workrequirementid_fk == null)
221            _wasgndt_wr_workrequirementid_fk = new WorkRequirementsPath(this, KeyRegistry.WORK_ASSIGNMENT_DETAILS_WORK_REQUIREMENT_FK, null);
222
223        return _wasgndt_wr_workrequirementid_fk;
224    }
225
226    @Override
227    public WorkAssignmentDetails as(String alias) {
228        return new WorkAssignmentDetails(DSL.name(alias), this);
229    }
230
231    @Override
232    public WorkAssignmentDetails as(Name alias) {
233        return new WorkAssignmentDetails(alias, this);
234    }
235
236    @Override
237    public WorkAssignmentDetails as(Table<?> alias) {
238        return new WorkAssignmentDetails(alias.getQualifiedName(), this);
239    }
240
241    /**
242     * Rename this table
243     */
244    @Override
245    public WorkAssignmentDetails rename(String name) {
246        return new WorkAssignmentDetails(DSL.name(name), null);
247    }
248
249    /**
250     * Rename this table
251     */
252    @Override
253    public WorkAssignmentDetails rename(Name name) {
254        return new WorkAssignmentDetails(name, null);
255    }
256
257    /**
258     * Rename this table
259     */
260    @Override
261    public WorkAssignmentDetails rename(Table<?> name) {
262        return new WorkAssignmentDetails(name.getQualifiedName(), null);
263    }
264
265    /**
266     * Create an inline derived table from this table
267     */
268    @Override
269    public WorkAssignmentDetails where(Condition condition) {
270        return new WorkAssignmentDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
271    }
272
273    /**
274     * Create an inline derived table from this table
275     */
276    @Override
277    public WorkAssignmentDetails where(Collection<? extends Condition> conditions) {
278        return where(DSL.and(conditions));
279    }
280
281    /**
282     * Create an inline derived table from this table
283     */
284    @Override
285    public WorkAssignmentDetails where(Condition... conditions) {
286        return where(DSL.and(conditions));
287    }
288
289    /**
290     * Create an inline derived table from this table
291     */
292    @Override
293    public WorkAssignmentDetails where(Field<Boolean> condition) {
294        return where(DSL.condition(condition));
295    }
296
297    /**
298     * Create an inline derived table from this table
299     */
300    @Override
301    @PlainSQL
302    public WorkAssignmentDetails where(SQL condition) {
303        return where(DSL.condition(condition));
304    }
305
306    /**
307     * Create an inline derived table from this table
308     */
309    @Override
310    @PlainSQL
311    public WorkAssignmentDetails where(@Stringly.SQL String condition) {
312        return where(DSL.condition(condition));
313    }
314
315    /**
316     * Create an inline derived table from this table
317     */
318    @Override
319    @PlainSQL
320    public WorkAssignmentDetails where(@Stringly.SQL String condition, Object... binds) {
321        return where(DSL.condition(condition, binds));
322    }
323
324    /**
325     * Create an inline derived table from this table
326     */
327    @Override
328    @PlainSQL
329    public WorkAssignmentDetails where(@Stringly.SQL String condition, QueryPart... parts) {
330        return where(DSL.condition(condition, parts));
331    }
332
333    /**
334     * Create an inline derived table from this table
335     */
336    @Override
337    public WorkAssignmentDetails whereExists(TableLike<?> select) {
338        return where(DSL.exists(select));
339    }
340
341    /**
342     * Create an inline derived table from this table
343     */
344    @Override
345    public WorkAssignmentDetails whereNotExists(TableLike<?> select) {
346        return where(DSL.notExists(select));
347    }
348}