Source code

001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.training;
005
006
007import com.echothree.model.data.training.common.pk.PartyTrainingClassSessionPK;
008import com.echothree.model.data.training.common.pk.PartyTrainingClassSessionQuestionDetailPK;
009import com.echothree.model.data.training.common.pk.PartyTrainingClassSessionQuestionPK;
010import com.echothree.model.data.training.common.pk.TrainingClassQuestionPK;
011import com.echothree.model.jooq.server.KeyRegistry;
012import com.echothree.model.jooq.server.tables.training.PartyTrainingClassSessionQuestions.PartyTrainingClassSessionQuestionsPath;
013import com.echothree.model.jooq.server.tables.training.PartyTrainingClassSessions.PartyTrainingClassSessionsPath;
014import com.echothree.model.jooq.server.tables.training.TrainingClassQuestions.TrainingClassQuestionsPath;
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 PartyTrainingClassSessionQuestionDetails extends TableImpl<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> {
048
049    private static final long serialVersionUID = 1L;
050
051    /**
052     * The reference instance of
053     * <code>partytrainingclasssessionquestiondetails</code>
054     */
055    public static final PartyTrainingClassSessionQuestionDetails PartyTrainingClassSessionQuestionDetails = new PartyTrainingClassSessionQuestionDetails();
056
057    /**
058     * The class holding records for this type
059     */
060    @Override
061    public Class<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> getRecordType() {
062        return com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails.class;
063    }
064
065    /**
066     * The column
067     * <code>partytrainingclasssessionquestiondetails.ptrnclsqusdt_partytrainingclasssessionquestiondetailid</code>.
068     */
069    public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails, PartyTrainingClassSessionQuestionDetailPK> PARTY_TRAINING_CLASS_SESSION_QUESTION_DETAIL = createField(DSL.name("ptrnclsqusdt_partytrainingclasssessionquestiondetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PartyTrainingClassSessionQuestionDetailPK.class, id -> new com.echothree.model.data.training.common.pk.PartyTrainingClassSessionQuestionDetailPK(id), primaryKey -> primaryKey.getEntityId()));
070
071    /**
072     * The column
073     * <code>partytrainingclasssessionquestiondetails.ptrnclsqusdt_ptrnclsqus_partytrainingclasssessionquestionid</code>.
074     */
075    public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails, PartyTrainingClassSessionQuestionPK> PARTY_TRAINING_CLASS_SESSION_QUESTION = createField(DSL.name("ptrnclsqusdt_ptrnclsqus_partytrainingclasssessionquestionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PartyTrainingClassSessionQuestionPK.class, id -> new com.echothree.model.data.training.common.pk.PartyTrainingClassSessionQuestionPK(id), primaryKey -> primaryKey.getEntityId()));
076
077    /**
078     * The column
079     * <code>partytrainingclasssessionquestiondetails.ptrnclsqusdt_ptrnclssess_partytrainingclasssessionid</code>.
080     */
081    public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails, PartyTrainingClassSessionPK> PARTY_TRAINING_CLASS_SESSION = createField(DSL.name("ptrnclsqusdt_ptrnclssess_partytrainingclasssessionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PartyTrainingClassSessionPK.class, id -> new com.echothree.model.data.training.common.pk.PartyTrainingClassSessionPK(id), primaryKey -> primaryKey.getEntityId()));
082
083    /**
084     * The column
085     * <code>partytrainingclasssessionquestiondetails.ptrnclsqusdt_trnclsqus_trainingclassquestionid</code>.
086     */
087    public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails, TrainingClassQuestionPK> TRAINING_CLASS_QUESTION = createField(DSL.name("ptrnclsqusdt_trnclsqus_trainingclassquestionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, TrainingClassQuestionPK.class, id -> new com.echothree.model.data.training.common.pk.TrainingClassQuestionPK(id), primaryKey -> primaryKey.getEntityId()));
088
089    /**
090     * The column
091     * <code>partytrainingclasssessionquestiondetails.ptrnclsqusdt_sortorder</code>.
092     */
093    public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails, Integer> SORT_ORDER = createField(DSL.name("ptrnclsqusdt_sortorder"), SQLDataType.INTEGER.nullable(false), this, "");
094
095    /**
096     * The column
097     * <code>partytrainingclasssessionquestiondetails.ptrnclsqusdt_fromtime</code>.
098     */
099    public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails, Long> FROM_TIME = createField(DSL.name("ptrnclsqusdt_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
100
101    /**
102     * The column
103     * <code>partytrainingclasssessionquestiondetails.ptrnclsqusdt_thrutime</code>.
104     */
105    public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails, Long> THRU_TIME = createField(DSL.name("ptrnclsqusdt_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
106
107    private PartyTrainingClassSessionQuestionDetails(Name alias, Table<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> aliased) {
108        this(alias, aliased, (Field<?>[]) null, null);
109    }
110
111    private PartyTrainingClassSessionQuestionDetails(Name alias, Table<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> aliased, Field<?>[] parameters, Condition where) {
112        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
113    }
114
115    /**
116     * Create an aliased <code>partytrainingclasssessionquestiondetails</code>
117     * table reference
118     */
119    public PartyTrainingClassSessionQuestionDetails(String alias) {
120        this(DSL.name(alias), PartyTrainingClassSessionQuestionDetails);
121    }
122
123    /**
124     * Create an aliased <code>partytrainingclasssessionquestiondetails</code>
125     * table reference
126     */
127    public PartyTrainingClassSessionQuestionDetails(Name alias) {
128        this(alias, PartyTrainingClassSessionQuestionDetails);
129    }
130
131    /**
132     * Create a <code>partytrainingclasssessionquestiondetails</code> table
133     * reference
134     */
135    public PartyTrainingClassSessionQuestionDetails() {
136        this(DSL.name("partytrainingclasssessionquestiondetails"), null);
137    }
138
139    public <O extends Record> PartyTrainingClassSessionQuestionDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> parentPath) {
140        super(path, childPath, parentPath, PartyTrainingClassSessionQuestionDetails);
141    }
142
143    /**
144     * A subtype implementing {@link Path} for simplified path-based joins.
145     */
146    public static class PartyTrainingClassSessionQuestionDetailsPath extends PartyTrainingClassSessionQuestionDetails implements Path<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> {
147
148        private static final long serialVersionUID = 1L;
149        public <O extends Record> PartyTrainingClassSessionQuestionDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> parentPath) {
150            super(path, childPath, parentPath);
151        }
152        private PartyTrainingClassSessionQuestionDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> aliased) {
153            super(alias, aliased);
154        }
155
156        @Override
157        public PartyTrainingClassSessionQuestionDetailsPath as(String alias) {
158            return new PartyTrainingClassSessionQuestionDetailsPath(DSL.name(alias), this);
159        }
160
161        @Override
162        public PartyTrainingClassSessionQuestionDetailsPath as(Name alias) {
163            return new PartyTrainingClassSessionQuestionDetailsPath(alias, this);
164        }
165
166        @Override
167        public PartyTrainingClassSessionQuestionDetailsPath as(Table<?> alias) {
168            return new PartyTrainingClassSessionQuestionDetailsPath(alias.getQualifiedName(), this);
169        }
170    }
171
172    @Override
173    public UniqueKey<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails> getPrimaryKey() {
174        return KeyRegistry.PARTY_TRAINING_CLASS_SESSION_QUESTION_DETAILS_PK;
175    }
176
177    @Override
178    public List<UniqueKey<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails>> getUniqueKeys() {
179        return Arrays.asList(KeyRegistry.PARTY_TRAINING_CLASS_SESSION_QUESTION_DETAILS_PARTY_TRAINING_CLASS_SESSION_QUESTION_AND_THRU_TIME_UK, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_QUESTION_DETAILS_PARTY_TRAINING_CLASS_SESSION_AND_TRAINING_CLASS_QUESTION_AND_THRU_TIME_UK);
180    }
181
182    @Override
183    public List<ForeignKey<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionQuestionDetails, ?>> getReferences() {
184        return Arrays.asList(KeyRegistry.PARTY_TRAINING_CLASS_SESSION_QUESTION_DETAILS_PARTY_TRAINING_CLASS_SESSION_QUESTION_FK, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_QUESTION_DETAILS_PARTY_TRAINING_CLASS_SESSION_FK, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_QUESTION_DETAILS_TRAINING_CLASS_QUESTION_FK);
185    }
186
187    private transient PartyTrainingClassSessionQuestionsPath _ptrnclsqusdt_ptrnclsqus_partytrainingclasssessionquestionid_fk;
188
189    /**
190     * Get the implicit join path to the
191     * <code>partytrainingclasssessionquestions</code> table.
192     */
193    public PartyTrainingClassSessionQuestionsPath ptrnclsqusdt_ptrnclsqus_partytrainingclasssessionquestionid_fk() {
194        if (_ptrnclsqusdt_ptrnclsqus_partytrainingclasssessionquestionid_fk == null)
195            _ptrnclsqusdt_ptrnclsqus_partytrainingclasssessionquestionid_fk = new PartyTrainingClassSessionQuestionsPath(this, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_QUESTION_DETAILS_PARTY_TRAINING_CLASS_SESSION_QUESTION_FK, null);
196
197        return _ptrnclsqusdt_ptrnclsqus_partytrainingclasssessionquestionid_fk;
198    }
199
200    private transient PartyTrainingClassSessionsPath _ptrnclsqusdt_ptrnclssess_partytrainingclasssessionid_fk;
201
202    /**
203     * Get the implicit join path to the <code>partytrainingclasssessions</code>
204     * table.
205     */
206    public PartyTrainingClassSessionsPath ptrnclsqusdt_ptrnclssess_partytrainingclasssessionid_fk() {
207        if (_ptrnclsqusdt_ptrnclssess_partytrainingclasssessionid_fk == null)
208            _ptrnclsqusdt_ptrnclssess_partytrainingclasssessionid_fk = new PartyTrainingClassSessionsPath(this, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_QUESTION_DETAILS_PARTY_TRAINING_CLASS_SESSION_FK, null);
209
210        return _ptrnclsqusdt_ptrnclssess_partytrainingclasssessionid_fk;
211    }
212
213    private transient TrainingClassQuestionsPath _ptrnclsqusdt_trnclsqus_trainingclassquestionid_fk;
214
215    /**
216     * Get the implicit join path to the <code>trainingclassquestions</code>
217     * table.
218     */
219    public TrainingClassQuestionsPath ptrnclsqusdt_trnclsqus_trainingclassquestionid_fk() {
220        if (_ptrnclsqusdt_trnclsqus_trainingclassquestionid_fk == null)
221            _ptrnclsqusdt_trnclsqus_trainingclassquestionid_fk = new TrainingClassQuestionsPath(this, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_QUESTION_DETAILS_TRAINING_CLASS_QUESTION_FK, null);
222
223        return _ptrnclsqusdt_trnclsqus_trainingclassquestionid_fk;
224    }
225
226    @Override
227    public PartyTrainingClassSessionQuestionDetails as(String alias) {
228        return new PartyTrainingClassSessionQuestionDetails(DSL.name(alias), this);
229    }
230
231    @Override
232    public PartyTrainingClassSessionQuestionDetails as(Name alias) {
233        return new PartyTrainingClassSessionQuestionDetails(alias, this);
234    }
235
236    @Override
237    public PartyTrainingClassSessionQuestionDetails as(Table<?> alias) {
238        return new PartyTrainingClassSessionQuestionDetails(alias.getQualifiedName(), this);
239    }
240
241    /**
242     * Rename this table
243     */
244    @Override
245    public PartyTrainingClassSessionQuestionDetails rename(String name) {
246        return new PartyTrainingClassSessionQuestionDetails(DSL.name(name), null);
247    }
248
249    /**
250     * Rename this table
251     */
252    @Override
253    public PartyTrainingClassSessionQuestionDetails rename(Name name) {
254        return new PartyTrainingClassSessionQuestionDetails(name, null);
255    }
256
257    /**
258     * Rename this table
259     */
260    @Override
261    public PartyTrainingClassSessionQuestionDetails rename(Table<?> name) {
262        return new PartyTrainingClassSessionQuestionDetails(name.getQualifiedName(), null);
263    }
264
265    /**
266     * Create an inline derived table from this table
267     */
268    @Override
269    public PartyTrainingClassSessionQuestionDetails where(Condition condition) {
270        return new PartyTrainingClassSessionQuestionDetails(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 PartyTrainingClassSessionQuestionDetails 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 PartyTrainingClassSessionQuestionDetails 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 PartyTrainingClassSessionQuestionDetails 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 PartyTrainingClassSessionQuestionDetails 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 PartyTrainingClassSessionQuestionDetails 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 PartyTrainingClassSessionQuestionDetails 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 PartyTrainingClassSessionQuestionDetails 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 PartyTrainingClassSessionQuestionDetails 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 PartyTrainingClassSessionQuestionDetails whereNotExists(TableLike<?> select) {
346        return where(DSL.notExists(select));
347    }
348}