Source code

001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.offer;
005
006
007import com.echothree.model.data.offer.common.pk.OfferPK;
008import com.echothree.model.data.offer.common.pk.OfferUseDetailPK;
009import com.echothree.model.data.offer.common.pk.OfferUsePK;
010import com.echothree.model.data.offer.common.pk.UsePK;
011import com.echothree.model.data.sequence.common.pk.SequencePK;
012import com.echothree.model.jooq.server.KeyRegistry;
013import com.echothree.model.jooq.server.tables.offer.OfferUses.OfferUsesPath;
014import com.echothree.model.jooq.server.tables.offer.Offers.OffersPath;
015import com.echothree.model.jooq.server.tables.offer.Uses.UsesPath;
016import com.echothree.model.jooq.server.tables.sequence.Sequences.SequencesPath;
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.InverseForeignKey;
027import org.jooq.Name;
028import org.jooq.Path;
029import org.jooq.PlainSQL;
030import org.jooq.QueryPart;
031import org.jooq.Record;
032import org.jooq.SQL;
033import org.jooq.Stringly;
034import org.jooq.Table;
035import org.jooq.TableField;
036import org.jooq.TableLike;
037import org.jooq.TableOptions;
038import org.jooq.UniqueKey;
039import org.jooq.impl.DSL;
040import org.jooq.impl.Internal;
041import org.jooq.impl.SQLDataType;
042import org.jooq.impl.TableImpl;
043
044
045/**
046 * This class is generated by jOOQ.
047 */
048@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
049public class OfferUseDetails extends TableImpl<com.echothree.model.jooq.server.records.offer.OfferUseDetails> {
050
051    private static final long serialVersionUID = 1L;
052
053    /**
054     * The reference instance of <code>offerusedetails</code>
055     */
056    public static final OfferUseDetails OfferUseDetails = new OfferUseDetails();
057
058    /**
059     * The class holding records for this type
060     */
061    @Override
062    public Class<com.echothree.model.jooq.server.records.offer.OfferUseDetails> getRecordType() {
063        return com.echothree.model.jooq.server.records.offer.OfferUseDetails.class;
064    }
065
066    /**
067     * The column <code>offerusedetails.ofrusedt_offerusedetailid</code>.
068     */
069    public final TableField<com.echothree.model.jooq.server.records.offer.OfferUseDetails, OfferUseDetailPK> OFFER_USE_DETAIL = createField(DSL.name("ofrusedt_offerusedetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, OfferUseDetailPK.class, id -> new com.echothree.model.data.offer.common.pk.OfferUseDetailPK(id), primaryKey -> primaryKey.getEntityId()));
070
071    /**
072     * The column <code>offerusedetails.ofrusedt_ofruse_offeruseid</code>.
073     */
074    public final TableField<com.echothree.model.jooq.server.records.offer.OfferUseDetails, OfferUsePK> OFFER_USE = createField(DSL.name("ofrusedt_ofruse_offeruseid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, OfferUsePK.class, id -> new com.echothree.model.data.offer.common.pk.OfferUsePK(id), primaryKey -> primaryKey.getEntityId()));
075
076    /**
077     * The column <code>offerusedetails.ofrusedt_ofr_offerid</code>.
078     */
079    public final TableField<com.echothree.model.jooq.server.records.offer.OfferUseDetails, OfferPK> OFFER = createField(DSL.name("ofrusedt_ofr_offerid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, OfferPK.class, id -> new com.echothree.model.data.offer.common.pk.OfferPK(id), primaryKey -> primaryKey.getEntityId()));
080
081    /**
082     * The column <code>offerusedetails.ofrusedt_use_useid</code>.
083     */
084    public final TableField<com.echothree.model.jooq.server.records.offer.OfferUseDetails, UsePK> USE = createField(DSL.name("ofrusedt_use_useid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, UsePK.class, id -> new com.echothree.model.data.offer.common.pk.UsePK(id), primaryKey -> primaryKey.getEntityId()));
085
086    /**
087     * The column <code>offerusedetails.ofrusedt_salesordersequenceid</code>.
088     */
089    public final TableField<com.echothree.model.jooq.server.records.offer.OfferUseDetails, SequencePK> SALES_ORDER_SEQUENCE = createField(DSL.name("ofrusedt_salesordersequenceid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SequencePK.class, id -> new com.echothree.model.data.sequence.common.pk.SequencePK(id), primaryKey -> primaryKey.getEntityId()));
090
091    /**
092     * The column <code>offerusedetails.ofrusedt_fromtime</code>.
093     */
094    public final TableField<com.echothree.model.jooq.server.records.offer.OfferUseDetails, Long> FROM_TIME = createField(DSL.name("ofrusedt_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
095
096    /**
097     * The column <code>offerusedetails.ofrusedt_thrutime</code>.
098     */
099    public final TableField<com.echothree.model.jooq.server.records.offer.OfferUseDetails, Long> THRU_TIME = createField(DSL.name("ofrusedt_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
100
101    private OfferUseDetails(Name alias, Table<com.echothree.model.jooq.server.records.offer.OfferUseDetails> aliased) {
102        this(alias, aliased, (Field<?>[]) null, null);
103    }
104
105    private OfferUseDetails(Name alias, Table<com.echothree.model.jooq.server.records.offer.OfferUseDetails> aliased, Field<?>[] parameters, Condition where) {
106        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
107    }
108
109    /**
110     * Create an aliased <code>offerusedetails</code> table reference
111     */
112    public OfferUseDetails(String alias) {
113        this(DSL.name(alias), OfferUseDetails);
114    }
115
116    /**
117     * Create an aliased <code>offerusedetails</code> table reference
118     */
119    public OfferUseDetails(Name alias) {
120        this(alias, OfferUseDetails);
121    }
122
123    /**
124     * Create a <code>offerusedetails</code> table reference
125     */
126    public OfferUseDetails() {
127        this(DSL.name("offerusedetails"), null);
128    }
129
130    public <O extends Record> OfferUseDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.offer.OfferUseDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.offer.OfferUseDetails> parentPath) {
131        super(path, childPath, parentPath, OfferUseDetails);
132    }
133
134    /**
135     * A subtype implementing {@link Path} for simplified path-based joins.
136     */
137    public static class OfferUseDetailsPath extends OfferUseDetails implements Path<com.echothree.model.jooq.server.records.offer.OfferUseDetails> {
138
139        private static final long serialVersionUID = 1L;
140        public <O extends Record> OfferUseDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.offer.OfferUseDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.offer.OfferUseDetails> parentPath) {
141            super(path, childPath, parentPath);
142        }
143        private OfferUseDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.offer.OfferUseDetails> aliased) {
144            super(alias, aliased);
145        }
146
147        @Override
148        public OfferUseDetailsPath as(String alias) {
149            return new OfferUseDetailsPath(DSL.name(alias), this);
150        }
151
152        @Override
153        public OfferUseDetailsPath as(Name alias) {
154            return new OfferUseDetailsPath(alias, this);
155        }
156
157        @Override
158        public OfferUseDetailsPath as(Table<?> alias) {
159            return new OfferUseDetailsPath(alias.getQualifiedName(), this);
160        }
161    }
162
163    @Override
164    public UniqueKey<com.echothree.model.jooq.server.records.offer.OfferUseDetails> getPrimaryKey() {
165        return KeyRegistry.OFFER_USE_DETAILS_PK;
166    }
167
168    @Override
169    public List<UniqueKey<com.echothree.model.jooq.server.records.offer.OfferUseDetails>> getUniqueKeys() {
170        return Arrays.asList(KeyRegistry.OFFER_USE_DETAILS_OFFER_USE_AND_THRU_TIME_UK, KeyRegistry.OFFER_USE_DETAILS_OFFER_AND_USE_AND_THRU_TIME_UK);
171    }
172
173    @Override
174    public List<ForeignKey<com.echothree.model.jooq.server.records.offer.OfferUseDetails, ?>> getReferences() {
175        return Arrays.asList(KeyRegistry.OFFER_USE_DETAILS_OFFER_FK, KeyRegistry.OFFER_USE_DETAILS_OFFER_USE_FK, KeyRegistry.OFFER_USE_DETAILS_SALES_ORDER_SEQUENCE_FK, KeyRegistry.OFFER_USE_DETAILS_USE_FK);
176    }
177
178    private transient OffersPath _ofrusedt_ofr_offerid_fk;
179
180    /**
181     * Get the implicit join path to the <code>offers</code> table.
182     */
183    public OffersPath ofrusedt_ofr_offerid_fk() {
184        if (_ofrusedt_ofr_offerid_fk == null)
185            _ofrusedt_ofr_offerid_fk = new OffersPath(this, KeyRegistry.OFFER_USE_DETAILS_OFFER_FK, null);
186
187        return _ofrusedt_ofr_offerid_fk;
188    }
189
190    private transient OfferUsesPath _ofrusedt_ofruse_offeruseid_fk;
191
192    /**
193     * Get the implicit join path to the <code>offeruses</code> table.
194     */
195    public OfferUsesPath ofrusedt_ofruse_offeruseid_fk() {
196        if (_ofrusedt_ofruse_offeruseid_fk == null)
197            _ofrusedt_ofruse_offeruseid_fk = new OfferUsesPath(this, KeyRegistry.OFFER_USE_DETAILS_OFFER_USE_FK, null);
198
199        return _ofrusedt_ofruse_offeruseid_fk;
200    }
201
202    private transient SequencesPath _ofrusedt_salesordersequenceid_fk;
203
204    /**
205     * Get the implicit join path to the <code>sequences</code> table.
206     */
207    public SequencesPath ofrusedt_salesordersequenceid_fk() {
208        if (_ofrusedt_salesordersequenceid_fk == null)
209            _ofrusedt_salesordersequenceid_fk = new SequencesPath(this, KeyRegistry.OFFER_USE_DETAILS_SALES_ORDER_SEQUENCE_FK, null);
210
211        return _ofrusedt_salesordersequenceid_fk;
212    }
213
214    private transient UsesPath _ofrusedt_use_useid_fk;
215
216    /**
217     * Get the implicit join path to the <code>uses</code> table.
218     */
219    public UsesPath ofrusedt_use_useid_fk() {
220        if (_ofrusedt_use_useid_fk == null)
221            _ofrusedt_use_useid_fk = new UsesPath(this, KeyRegistry.OFFER_USE_DETAILS_USE_FK, null);
222
223        return _ofrusedt_use_useid_fk;
224    }
225
226    @Override
227    public OfferUseDetails as(String alias) {
228        return new OfferUseDetails(DSL.name(alias), this);
229    }
230
231    @Override
232    public OfferUseDetails as(Name alias) {
233        return new OfferUseDetails(alias, this);
234    }
235
236    @Override
237    public OfferUseDetails as(Table<?> alias) {
238        return new OfferUseDetails(alias.getQualifiedName(), this);
239    }
240
241    /**
242     * Rename this table
243     */
244    @Override
245    public OfferUseDetails rename(String name) {
246        return new OfferUseDetails(DSL.name(name), null);
247    }
248
249    /**
250     * Rename this table
251     */
252    @Override
253    public OfferUseDetails rename(Name name) {
254        return new OfferUseDetails(name, null);
255    }
256
257    /**
258     * Rename this table
259     */
260    @Override
261    public OfferUseDetails rename(Table<?> name) {
262        return new OfferUseDetails(name.getQualifiedName(), null);
263    }
264
265    /**
266     * Create an inline derived table from this table
267     */
268    @Override
269    public OfferUseDetails where(Condition condition) {
270        return new OfferUseDetails(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 OfferUseDetails 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 OfferUseDetails 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 OfferUseDetails 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 OfferUseDetails 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 OfferUseDetails 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 OfferUseDetails 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 OfferUseDetails 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 OfferUseDetails 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 OfferUseDetails whereNotExists(TableLike<?> select) {
346        return where(DSL.notExists(select));
347    }
348}