Source code

001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.carrier;
005
006
007import com.echothree.model.data.carrier.common.pk.CarrierOptionDetailPK;
008import com.echothree.model.data.carrier.common.pk.CarrierOptionPK;
009import com.echothree.model.data.party.common.pk.PartyPK;
010import com.echothree.model.data.selector.common.pk.SelectorPK;
011import com.echothree.model.jooq.server.KeyRegistry;
012import com.echothree.model.jooq.server.tables.carrier.CarrierOptions.CarrierOptionsPath;
013import com.echothree.model.jooq.server.tables.party.Parties.PartiesPath;
014import com.echothree.model.jooq.server.tables.selector.Selectors.SelectorsPath;
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 CarrierOptionDetails extends TableImpl<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> {
048
049    private static final long serialVersionUID = 1L;
050
051    /**
052     * The reference instance of <code>carrieroptiondetails</code>
053     */
054    public static final CarrierOptionDetails CarrierOptionDetails = new CarrierOptionDetails();
055
056    /**
057     * The class holding records for this type
058     */
059    @Override
060    public Class<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> getRecordType() {
061        return com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails.class;
062    }
063
064    /**
065     * The column
066     * <code>carrieroptiondetails.crroptdt_carrieroptiondetailid</code>.
067     */
068    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, CarrierOptionDetailPK> CARRIER_OPTION_DETAIL = createField(DSL.name("crroptdt_carrieroptiondetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, CarrierOptionDetailPK.class, id -> new com.echothree.model.data.carrier.common.pk.CarrierOptionDetailPK(id), primaryKey -> primaryKey.getEntityId()));
069
070    /**
071     * The column
072     * <code>carrieroptiondetails.crroptdt_crropt_carrieroptionid</code>.
073     */
074    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, CarrierOptionPK> CARRIER_OPTION = createField(DSL.name("crroptdt_crropt_carrieroptionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, CarrierOptionPK.class, id -> new com.echothree.model.data.carrier.common.pk.CarrierOptionPK(id), primaryKey -> primaryKey.getEntityId()));
075
076    /**
077     * The column <code>carrieroptiondetails.crroptdt_carrierpartyid</code>.
078     */
079    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, PartyPK> CARRIER_PARTY = createField(DSL.name("crroptdt_carrierpartyid"), 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()));
080
081    /**
082     * The column <code>carrieroptiondetails.crroptdt_carrieroptionname</code>.
083     */
084    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, String> CARRIER_OPTION_NAME = createField(DSL.name("crroptdt_carrieroptionname"), SQLDataType.VARCHAR(40).nullable(false), this, "");
085
086    /**
087     * The column <code>carrieroptiondetails.crroptdt_isrecommended</code>.
088     */
089    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, Boolean> IS_RECOMMENDED = createField(DSL.name("crroptdt_isrecommended"), SQLDataType.BIT.nullable(false), this, "");
090
091    /**
092     * The column <code>carrieroptiondetails.crroptdt_isrequired</code>.
093     */
094    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, Boolean> IS_REQUIRED = createField(DSL.name("crroptdt_isrequired"), SQLDataType.BIT.nullable(false), this, "");
095
096    /**
097     * The column
098     * <code>carrieroptiondetails.crroptdt_recommendedgeocodeselectorid</code>.
099     */
100    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, SelectorPK> RECOMMENDED_GEO_CODE_SELECTOR = createField(DSL.name("crroptdt_recommendedgeocodeselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
101
102    /**
103     * The column
104     * <code>carrieroptiondetails.crroptdt_requiredgeocodeselectorid</code>.
105     */
106    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, SelectorPK> REQUIRED_GEO_CODE_SELECTOR = createField(DSL.name("crroptdt_requiredgeocodeselectorid"), 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>carrieroptiondetails.crroptdt_recommendeditemselectorid</code>.
111     */
112    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, SelectorPK> RECOMMENDED_ITEM_SELECTOR = createField(DSL.name("crroptdt_recommendeditemselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
113
114    /**
115     * The column
116     * <code>carrieroptiondetails.crroptdt_requireditemselectorid</code>.
117     */
118    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, SelectorPK> REQUIRED_ITEM_SELECTOR = createField(DSL.name("crroptdt_requireditemselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
119
120    /**
121     * The column
122     * <code>carrieroptiondetails.crroptdt_recommendedorderselectorid</code>.
123     */
124    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, SelectorPK> RECOMMENDED_ORDER_SELECTOR = createField(DSL.name("crroptdt_recommendedorderselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
125
126    /**
127     * The column
128     * <code>carrieroptiondetails.crroptdt_requiredorderselectorid</code>.
129     */
130    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, SelectorPK> REQUIRED_ORDER_SELECTOR = createField(DSL.name("crroptdt_requiredorderselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
131
132    /**
133     * The column
134     * <code>carrieroptiondetails.crroptdt_recommendedshipmentselectorid</code>.
135     */
136    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, SelectorPK> RECOMMENDED_SHIPMENT_SELECTOR = createField(DSL.name("crroptdt_recommendedshipmentselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
137
138    /**
139     * The column
140     * <code>carrieroptiondetails.crroptdt_requiredshipmentselectorid</code>.
141     */
142    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, SelectorPK> REQUIRED_SHIPMENT_SELECTOR = createField(DSL.name("crroptdt_requiredshipmentselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
143
144    /**
145     * The column <code>carrieroptiondetails.crroptdt_isdefault</code>.
146     */
147    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, Boolean> IS_DEFAULT = createField(DSL.name("crroptdt_isdefault"), SQLDataType.BIT.nullable(false), this, "");
148
149    /**
150     * The column <code>carrieroptiondetails.crroptdt_sortorder</code>.
151     */
152    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, Integer> SORT_ORDER = createField(DSL.name("crroptdt_sortorder"), SQLDataType.INTEGER.nullable(false), this, "");
153
154    /**
155     * The column <code>carrieroptiondetails.crroptdt_fromtime</code>.
156     */
157    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, Long> FROM_TIME = createField(DSL.name("crroptdt_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
158
159    /**
160     * The column <code>carrieroptiondetails.crroptdt_thrutime</code>.
161     */
162    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, Long> THRU_TIME = createField(DSL.name("crroptdt_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
163
164    private CarrierOptionDetails(Name alias, Table<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> aliased) {
165        this(alias, aliased, (Field<?>[]) null, null);
166    }
167
168    private CarrierOptionDetails(Name alias, Table<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> aliased, Field<?>[] parameters, Condition where) {
169        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
170    }
171
172    /**
173     * Create an aliased <code>carrieroptiondetails</code> table reference
174     */
175    public CarrierOptionDetails(String alias) {
176        this(DSL.name(alias), CarrierOptionDetails);
177    }
178
179    /**
180     * Create an aliased <code>carrieroptiondetails</code> table reference
181     */
182    public CarrierOptionDetails(Name alias) {
183        this(alias, CarrierOptionDetails);
184    }
185
186    /**
187     * Create a <code>carrieroptiondetails</code> table reference
188     */
189    public CarrierOptionDetails() {
190        this(DSL.name("carrieroptiondetails"), null);
191    }
192
193    public <O extends Record> CarrierOptionDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> parentPath) {
194        super(path, childPath, parentPath, CarrierOptionDetails);
195    }
196
197    /**
198     * A subtype implementing {@link Path} for simplified path-based joins.
199     */
200    public static class CarrierOptionDetailsPath extends CarrierOptionDetails implements Path<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> {
201
202        private static final long serialVersionUID = 1L;
203        public <O extends Record> CarrierOptionDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> parentPath) {
204            super(path, childPath, parentPath);
205        }
206        private CarrierOptionDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> aliased) {
207            super(alias, aliased);
208        }
209
210        @Override
211        public CarrierOptionDetailsPath as(String alias) {
212            return new CarrierOptionDetailsPath(DSL.name(alias), this);
213        }
214
215        @Override
216        public CarrierOptionDetailsPath as(Name alias) {
217            return new CarrierOptionDetailsPath(alias, this);
218        }
219
220        @Override
221        public CarrierOptionDetailsPath as(Table<?> alias) {
222            return new CarrierOptionDetailsPath(alias.getQualifiedName(), this);
223        }
224    }
225
226    @Override
227    public UniqueKey<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails> getPrimaryKey() {
228        return KeyRegistry.CARRIER_OPTION_DETAILS_PK;
229    }
230
231    @Override
232    public List<UniqueKey<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails>> getUniqueKeys() {
233        return Arrays.asList(KeyRegistry.CARRIER_OPTION_DETAILS_CARRIER_OPTION_AND_THRU_TIME_UK, KeyRegistry.CARRIER_OPTION_DETAILS_CARRIER_PARTY_AND_CARRIER_OPTION_NAME_AND_THRU_TIME_UK);
234    }
235
236    @Override
237    public List<ForeignKey<com.echothree.model.jooq.server.records.carrier.CarrierOptionDetails, ?>> getReferences() {
238        return Arrays.asList(KeyRegistry.CARRIER_OPTION_DETAILS_CARRIER_PARTY_FK, KeyRegistry.CARRIER_OPTION_DETAILS_CARRIER_OPTION_FK, KeyRegistry.CARRIER_OPTION_DETAILS_RECOMMENDED_GEO_CODE_SELECTOR_FK, KeyRegistry.CARRIER_OPTION_DETAILS_RECOMMENDED_ITEM_SELECTOR_FK, KeyRegistry.CARRIER_OPTION_DETAILS_RECOMMENDED_ORDER_SELECTOR_FK, KeyRegistry.CARRIER_OPTION_DETAILS_RECOMMENDED_SHIPMENT_SELECTOR_FK, KeyRegistry.CARRIER_OPTION_DETAILS_REQUIRED_GEO_CODE_SELECTOR_FK, KeyRegistry.CARRIER_OPTION_DETAILS_REQUIRED_ITEM_SELECTOR_FK, KeyRegistry.CARRIER_OPTION_DETAILS_REQUIRED_ORDER_SELECTOR_FK, KeyRegistry.CARRIER_OPTION_DETAILS_REQUIRED_SHIPMENT_SELECTOR_FK);
239    }
240
241    private transient PartiesPath _crroptdt_carrierpartyid_fk;
242
243    /**
244     * Get the implicit join path to the <code>parties</code> table.
245     */
246    public PartiesPath crroptdt_carrierpartyid_fk() {
247        if (_crroptdt_carrierpartyid_fk == null)
248            _crroptdt_carrierpartyid_fk = new PartiesPath(this, KeyRegistry.CARRIER_OPTION_DETAILS_CARRIER_PARTY_FK, null);
249
250        return _crroptdt_carrierpartyid_fk;
251    }
252
253    private transient CarrierOptionsPath _crroptdt_crropt_carrieroptionid_fk;
254
255    /**
256     * Get the implicit join path to the <code>carrieroptions</code> table.
257     */
258    public CarrierOptionsPath crroptdt_crropt_carrieroptionid_fk() {
259        if (_crroptdt_crropt_carrieroptionid_fk == null)
260            _crroptdt_crropt_carrieroptionid_fk = new CarrierOptionsPath(this, KeyRegistry.CARRIER_OPTION_DETAILS_CARRIER_OPTION_FK, null);
261
262        return _crroptdt_crropt_carrieroptionid_fk;
263    }
264
265    private transient SelectorsPath _crroptdt_recommendedgeocodeselectorid_fk;
266
267    /**
268     * Get the implicit join path to the <code>selectors</code> table, via the
269     * <code>crroptdt_recommendedgeocodeselectorid_fk</code> key.
270     */
271    public SelectorsPath crroptdt_recommendedgeocodeselectorid_fk() {
272        if (_crroptdt_recommendedgeocodeselectorid_fk == null)
273            _crroptdt_recommendedgeocodeselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_OPTION_DETAILS_RECOMMENDED_GEO_CODE_SELECTOR_FK, null);
274
275        return _crroptdt_recommendedgeocodeselectorid_fk;
276    }
277
278    private transient SelectorsPath _crroptdt_recommendeditemselectorid_fk;
279
280    /**
281     * Get the implicit join path to the <code>selectors</code> table, via the
282     * <code>crroptdt_recommendeditemselectorid_fk</code> key.
283     */
284    public SelectorsPath crroptdt_recommendeditemselectorid_fk() {
285        if (_crroptdt_recommendeditemselectorid_fk == null)
286            _crroptdt_recommendeditemselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_OPTION_DETAILS_RECOMMENDED_ITEM_SELECTOR_FK, null);
287
288        return _crroptdt_recommendeditemselectorid_fk;
289    }
290
291    private transient SelectorsPath _crroptdt_recommendedorderselectorid_fk;
292
293    /**
294     * Get the implicit join path to the <code>selectors</code> table, via the
295     * <code>crroptdt_recommendedorderselectorid_fk</code> key.
296     */
297    public SelectorsPath crroptdt_recommendedorderselectorid_fk() {
298        if (_crroptdt_recommendedorderselectorid_fk == null)
299            _crroptdt_recommendedorderselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_OPTION_DETAILS_RECOMMENDED_ORDER_SELECTOR_FK, null);
300
301        return _crroptdt_recommendedorderselectorid_fk;
302    }
303
304    private transient SelectorsPath _crroptdt_recommendedshipmentselectorid_fk;
305
306    /**
307     * Get the implicit join path to the <code>selectors</code> table, via the
308     * <code>crroptdt_recommendedshipmentselectorid_fk</code> key.
309     */
310    public SelectorsPath crroptdt_recommendedshipmentselectorid_fk() {
311        if (_crroptdt_recommendedshipmentselectorid_fk == null)
312            _crroptdt_recommendedshipmentselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_OPTION_DETAILS_RECOMMENDED_SHIPMENT_SELECTOR_FK, null);
313
314        return _crroptdt_recommendedshipmentselectorid_fk;
315    }
316
317    private transient SelectorsPath _crroptdt_requiredgeocodeselectorid_fk;
318
319    /**
320     * Get the implicit join path to the <code>selectors</code> table, via the
321     * <code>crroptdt_requiredgeocodeselectorid_fk</code> key.
322     */
323    public SelectorsPath crroptdt_requiredgeocodeselectorid_fk() {
324        if (_crroptdt_requiredgeocodeselectorid_fk == null)
325            _crroptdt_requiredgeocodeselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_OPTION_DETAILS_REQUIRED_GEO_CODE_SELECTOR_FK, null);
326
327        return _crroptdt_requiredgeocodeselectorid_fk;
328    }
329
330    private transient SelectorsPath _crroptdt_requireditemselectorid_fk;
331
332    /**
333     * Get the implicit join path to the <code>selectors</code> table, via the
334     * <code>crroptdt_requireditemselectorid_fk</code> key.
335     */
336    public SelectorsPath crroptdt_requireditemselectorid_fk() {
337        if (_crroptdt_requireditemselectorid_fk == null)
338            _crroptdt_requireditemselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_OPTION_DETAILS_REQUIRED_ITEM_SELECTOR_FK, null);
339
340        return _crroptdt_requireditemselectorid_fk;
341    }
342
343    private transient SelectorsPath _crroptdt_requiredorderselectorid_fk;
344
345    /**
346     * Get the implicit join path to the <code>selectors</code> table, via the
347     * <code>crroptdt_requiredorderselectorid_fk</code> key.
348     */
349    public SelectorsPath crroptdt_requiredorderselectorid_fk() {
350        if (_crroptdt_requiredorderselectorid_fk == null)
351            _crroptdt_requiredorderselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_OPTION_DETAILS_REQUIRED_ORDER_SELECTOR_FK, null);
352
353        return _crroptdt_requiredorderselectorid_fk;
354    }
355
356    private transient SelectorsPath _crroptdt_requiredshipmentselectorid_fk;
357
358    /**
359     * Get the implicit join path to the <code>selectors</code> table, via the
360     * <code>crroptdt_requiredshipmentselectorid_fk</code> key.
361     */
362    public SelectorsPath crroptdt_requiredshipmentselectorid_fk() {
363        if (_crroptdt_requiredshipmentselectorid_fk == null)
364            _crroptdt_requiredshipmentselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_OPTION_DETAILS_REQUIRED_SHIPMENT_SELECTOR_FK, null);
365
366        return _crroptdt_requiredshipmentselectorid_fk;
367    }
368
369    @Override
370    public CarrierOptionDetails as(String alias) {
371        return new CarrierOptionDetails(DSL.name(alias), this);
372    }
373
374    @Override
375    public CarrierOptionDetails as(Name alias) {
376        return new CarrierOptionDetails(alias, this);
377    }
378
379    @Override
380    public CarrierOptionDetails as(Table<?> alias) {
381        return new CarrierOptionDetails(alias.getQualifiedName(), this);
382    }
383
384    /**
385     * Rename this table
386     */
387    @Override
388    public CarrierOptionDetails rename(String name) {
389        return new CarrierOptionDetails(DSL.name(name), null);
390    }
391
392    /**
393     * Rename this table
394     */
395    @Override
396    public CarrierOptionDetails rename(Name name) {
397        return new CarrierOptionDetails(name, null);
398    }
399
400    /**
401     * Rename this table
402     */
403    @Override
404    public CarrierOptionDetails rename(Table<?> name) {
405        return new CarrierOptionDetails(name.getQualifiedName(), null);
406    }
407
408    /**
409     * Create an inline derived table from this table
410     */
411    @Override
412    public CarrierOptionDetails where(Condition condition) {
413        return new CarrierOptionDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
414    }
415
416    /**
417     * Create an inline derived table from this table
418     */
419    @Override
420    public CarrierOptionDetails where(Collection<? extends Condition> conditions) {
421        return where(DSL.and(conditions));
422    }
423
424    /**
425     * Create an inline derived table from this table
426     */
427    @Override
428    public CarrierOptionDetails where(Condition... conditions) {
429        return where(DSL.and(conditions));
430    }
431
432    /**
433     * Create an inline derived table from this table
434     */
435    @Override
436    public CarrierOptionDetails where(Field<Boolean> condition) {
437        return where(DSL.condition(condition));
438    }
439
440    /**
441     * Create an inline derived table from this table
442     */
443    @Override
444    @PlainSQL
445    public CarrierOptionDetails where(SQL condition) {
446        return where(DSL.condition(condition));
447    }
448
449    /**
450     * Create an inline derived table from this table
451     */
452    @Override
453    @PlainSQL
454    public CarrierOptionDetails where(@Stringly.SQL String condition) {
455        return where(DSL.condition(condition));
456    }
457
458    /**
459     * Create an inline derived table from this table
460     */
461    @Override
462    @PlainSQL
463    public CarrierOptionDetails where(@Stringly.SQL String condition, Object... binds) {
464        return where(DSL.condition(condition, binds));
465    }
466
467    /**
468     * Create an inline derived table from this table
469     */
470    @Override
471    @PlainSQL
472    public CarrierOptionDetails where(@Stringly.SQL String condition, QueryPart... parts) {
473        return where(DSL.condition(condition, parts));
474    }
475
476    /**
477     * Create an inline derived table from this table
478     */
479    @Override
480    public CarrierOptionDetails whereExists(TableLike<?> select) {
481        return where(DSL.exists(select));
482    }
483
484    /**
485     * Create an inline derived table from this table
486     */
487    @Override
488    public CarrierOptionDetails whereNotExists(TableLike<?> select) {
489        return where(DSL.notExists(select));
490    }
491}