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.CarrierOptionPK;
008import com.echothree.model.data.carrier.common.pk.CarrierServiceOptionPK;
009import com.echothree.model.data.carrier.common.pk.CarrierServicePK;
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.carrier.CarrierServices.CarrierServicesPath;
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.Name;
025import org.jooq.PlainSQL;
026import org.jooq.QueryPart;
027import org.jooq.SQL;
028import org.jooq.Stringly;
029import org.jooq.Table;
030import org.jooq.TableField;
031import org.jooq.TableLike;
032import org.jooq.TableOptions;
033import org.jooq.UniqueKey;
034import org.jooq.impl.DSL;
035import org.jooq.impl.Internal;
036import org.jooq.impl.SQLDataType;
037import org.jooq.impl.TableImpl;
038
039
040/**
041 * This class is generated by jOOQ.
042 */
043@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
044public class CarrierServiceOptions extends TableImpl<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions> {
045
046    private static final long serialVersionUID = 1L;
047
048    /**
049     * The reference instance of <code>carrierserviceoptions</code>
050     */
051    public static final CarrierServiceOptions CarrierServiceOptions = new CarrierServiceOptions();
052
053    /**
054     * The class holding records for this type
055     */
056    @Override
057    public Class<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions> getRecordType() {
058        return com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions.class;
059    }
060
061    /**
062     * The column
063     * <code>carrierserviceoptions.crrsrvopt_carrierserviceoptionid</code>.
064     */
065    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, CarrierServiceOptionPK> CARRIER_SERVICE_OPTION = createField(DSL.name("crrsrvopt_carrierserviceoptionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, CarrierServiceOptionPK.class, id -> new com.echothree.model.data.carrier.common.pk.CarrierServiceOptionPK(id), primaryKey -> primaryKey.getEntityId()));
066
067    /**
068     * The column
069     * <code>carrierserviceoptions.crrsrvopt_crrsrv_carrierserviceid</code>.
070     */
071    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, CarrierServicePK> CARRIER_SERVICE = createField(DSL.name("crrsrvopt_crrsrv_carrierserviceid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, CarrierServicePK.class, id -> new com.echothree.model.data.carrier.common.pk.CarrierServicePK(id), primaryKey -> primaryKey.getEntityId()));
072
073    /**
074     * The column
075     * <code>carrierserviceoptions.crrsrvopt_crropt_carrieroptionid</code>.
076     */
077    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, CarrierOptionPK> CARRIER_OPTION = createField(DSL.name("crrsrvopt_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()));
078
079    /**
080     * The column <code>carrierserviceoptions.crrsrvopt_isrecommended</code>.
081     */
082    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, Boolean> IS_RECOMMENDED = createField(DSL.name("crrsrvopt_isrecommended"), SQLDataType.BIT.nullable(false), this, "");
083
084    /**
085     * The column <code>carrierserviceoptions.crrsrvopt_isrequired</code>.
086     */
087    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, Boolean> IS_REQUIRED = createField(DSL.name("crrsrvopt_isrequired"), SQLDataType.BIT.nullable(false), this, "");
088
089    /**
090     * The column
091     * <code>carrierserviceoptions.crrsrvopt_recommendedgeocodeselectorid</code>.
092     */
093    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, SelectorPK> RECOMMENDED_GEO_CODE_SELECTOR = createField(DSL.name("crrsrvopt_recommendedgeocodeselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
094
095    /**
096     * The column
097     * <code>carrierserviceoptions.crrsrvopt_requiredgeocodeselectorid</code>.
098     */
099    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, SelectorPK> REQUIRED_GEO_CODE_SELECTOR = createField(DSL.name("crrsrvopt_requiredgeocodeselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
100
101    /**
102     * The column
103     * <code>carrierserviceoptions.crrsrvopt_recommendeditemselectorid</code>.
104     */
105    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, SelectorPK> RECOMMENDED_ITEM_SELECTOR = createField(DSL.name("crrsrvopt_recommendeditemselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
106
107    /**
108     * The column
109     * <code>carrierserviceoptions.crrsrvopt_requireditemselectorid</code>.
110     */
111    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, SelectorPK> REQUIRED_ITEM_SELECTOR = createField(DSL.name("crrsrvopt_requireditemselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
112
113    /**
114     * The column
115     * <code>carrierserviceoptions.crrsrvopt_recommendedorderselectorid</code>.
116     */
117    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, SelectorPK> RECOMMENDED_ORDER_SELECTOR = createField(DSL.name("crrsrvopt_recommendedorderselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
118
119    /**
120     * The column
121     * <code>carrierserviceoptions.crrsrvopt_requiredorderselectorid</code>.
122     */
123    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, SelectorPK> REQUIRED_ORDER_SELECTOR = createField(DSL.name("crrsrvopt_requiredorderselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
124
125    /**
126     * The column
127     * <code>carrierserviceoptions.crrsrvopt_recommendedshipmentselectorid</code>.
128     */
129    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, SelectorPK> RECOMMENDED_SHIPMENT_SELECTOR = createField(DSL.name("crrsrvopt_recommendedshipmentselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
130
131    /**
132     * The column
133     * <code>carrierserviceoptions.crrsrvopt_requiredshipmentselectorid</code>.
134     */
135    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, SelectorPK> REQUIRED_SHIPMENT_SELECTOR = createField(DSL.name("crrsrvopt_requiredshipmentselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
136
137    /**
138     * The column <code>carrierserviceoptions.crrsrvopt_fromtime</code>.
139     */
140    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, Long> FROM_TIME = createField(DSL.name("crrsrvopt_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
141
142    /**
143     * The column <code>carrierserviceoptions.crrsrvopt_thrutime</code>.
144     */
145    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, Long> THRU_TIME = createField(DSL.name("crrsrvopt_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
146
147    private CarrierServiceOptions(Name alias, Table<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions> aliased) {
148        this(alias, aliased, (Field<?>[]) null, null);
149    }
150
151    private CarrierServiceOptions(Name alias, Table<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions> aliased, Field<?>[] parameters, Condition where) {
152        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
153    }
154
155    /**
156     * Create an aliased <code>carrierserviceoptions</code> table reference
157     */
158    public CarrierServiceOptions(String alias) {
159        this(DSL.name(alias), CarrierServiceOptions);
160    }
161
162    /**
163     * Create an aliased <code>carrierserviceoptions</code> table reference
164     */
165    public CarrierServiceOptions(Name alias) {
166        this(alias, CarrierServiceOptions);
167    }
168
169    /**
170     * Create a <code>carrierserviceoptions</code> table reference
171     */
172    public CarrierServiceOptions() {
173        this(DSL.name("carrierserviceoptions"), null);
174    }
175
176    @Override
177    public UniqueKey<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions> getPrimaryKey() {
178        return KeyRegistry.CARRIER_SERVICE_OPTIONS_PK;
179    }
180
181    @Override
182    public List<UniqueKey<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions>> getUniqueKeys() {
183        return Arrays.asList(KeyRegistry.CARRIER_SERVICE_OPTIONS_CARRIER_SERVICE_AND_CARRIER_OPTION_AND_THRU_TIME_UK);
184    }
185
186    @Override
187    public List<ForeignKey<com.echothree.model.jooq.server.records.carrier.CarrierServiceOptions, ?>> getReferences() {
188        return Arrays.asList(KeyRegistry.CARRIER_SERVICE_OPTIONS_CARRIER_OPTION_FK, KeyRegistry.CARRIER_SERVICE_OPTIONS_CARRIER_SERVICE_FK, KeyRegistry.CARRIER_SERVICE_OPTIONS_RECOMMENDED_GEO_CODE_SELECTOR_FK, KeyRegistry.CARRIER_SERVICE_OPTIONS_RECOMMENDED_ITEM_SELECTOR_FK, KeyRegistry.CARRIER_SERVICE_OPTIONS_RECOMMENDED_ORDER_SELECTOR_FK, KeyRegistry.CARRIER_SERVICE_OPTIONS_RECOMMENDED_SHIPMENT_SELECTOR_FK, KeyRegistry.CARRIER_SERVICE_OPTIONS_REQUIRED_GEO_CODE_SELECTOR_FK, KeyRegistry.CARRIER_SERVICE_OPTIONS_REQUIRED_ITEM_SELECTOR_FK, KeyRegistry.CARRIER_SERVICE_OPTIONS_REQUIRED_ORDER_SELECTOR_FK, KeyRegistry.CARRIER_SERVICE_OPTIONS_REQUIRED_SHIPMENT_SELECTOR_FK);
189    }
190
191    private transient CarrierOptionsPath _crrsrvopt_crropt_carrieroptionid_fk;
192
193    /**
194     * Get the implicit join path to the <code>carrieroptions</code> table.
195     */
196    public CarrierOptionsPath crrsrvopt_crropt_carrieroptionid_fk() {
197        if (_crrsrvopt_crropt_carrieroptionid_fk == null)
198            _crrsrvopt_crropt_carrieroptionid_fk = new CarrierOptionsPath(this, KeyRegistry.CARRIER_SERVICE_OPTIONS_CARRIER_OPTION_FK, null);
199
200        return _crrsrvopt_crropt_carrieroptionid_fk;
201    }
202
203    private transient CarrierServicesPath _crrsrvopt_crrsrv_carrierserviceid_fk;
204
205    /**
206     * Get the implicit join path to the <code>carrierservices</code> table.
207     */
208    public CarrierServicesPath crrsrvopt_crrsrv_carrierserviceid_fk() {
209        if (_crrsrvopt_crrsrv_carrierserviceid_fk == null)
210            _crrsrvopt_crrsrv_carrierserviceid_fk = new CarrierServicesPath(this, KeyRegistry.CARRIER_SERVICE_OPTIONS_CARRIER_SERVICE_FK, null);
211
212        return _crrsrvopt_crrsrv_carrierserviceid_fk;
213    }
214
215    private transient SelectorsPath _crrsrvopt_recommendedgeocodeselectorid_fk;
216
217    /**
218     * Get the implicit join path to the <code>selectors</code> table, via the
219     * <code>crrsrvopt_recommendedgeocodeselectorid_fk</code> key.
220     */
221    public SelectorsPath crrsrvopt_recommendedgeocodeselectorid_fk() {
222        if (_crrsrvopt_recommendedgeocodeselectorid_fk == null)
223            _crrsrvopt_recommendedgeocodeselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_SERVICE_OPTIONS_RECOMMENDED_GEO_CODE_SELECTOR_FK, null);
224
225        return _crrsrvopt_recommendedgeocodeselectorid_fk;
226    }
227
228    private transient SelectorsPath _crrsrvopt_recommendeditemselectorid_fk;
229
230    /**
231     * Get the implicit join path to the <code>selectors</code> table, via the
232     * <code>crrsrvopt_recommendeditemselectorid_fk</code> key.
233     */
234    public SelectorsPath crrsrvopt_recommendeditemselectorid_fk() {
235        if (_crrsrvopt_recommendeditemselectorid_fk == null)
236            _crrsrvopt_recommendeditemselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_SERVICE_OPTIONS_RECOMMENDED_ITEM_SELECTOR_FK, null);
237
238        return _crrsrvopt_recommendeditemselectorid_fk;
239    }
240
241    private transient SelectorsPath _crrsrvopt_recommendedorderselectorid_fk;
242
243    /**
244     * Get the implicit join path to the <code>selectors</code> table, via the
245     * <code>crrsrvopt_recommendedorderselectorid_fk</code> key.
246     */
247    public SelectorsPath crrsrvopt_recommendedorderselectorid_fk() {
248        if (_crrsrvopt_recommendedorderselectorid_fk == null)
249            _crrsrvopt_recommendedorderselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_SERVICE_OPTIONS_RECOMMENDED_ORDER_SELECTOR_FK, null);
250
251        return _crrsrvopt_recommendedorderselectorid_fk;
252    }
253
254    private transient SelectorsPath _crrsrvopt_recommendedshipmentselectorid_fk;
255
256    /**
257     * Get the implicit join path to the <code>selectors</code> table, via the
258     * <code>crrsrvopt_recommendedshipmentselectorid_fk</code> key.
259     */
260    public SelectorsPath crrsrvopt_recommendedshipmentselectorid_fk() {
261        if (_crrsrvopt_recommendedshipmentselectorid_fk == null)
262            _crrsrvopt_recommendedshipmentselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_SERVICE_OPTIONS_RECOMMENDED_SHIPMENT_SELECTOR_FK, null);
263
264        return _crrsrvopt_recommendedshipmentselectorid_fk;
265    }
266
267    private transient SelectorsPath _crrsrvopt_requiredgeocodeselectorid_fk;
268
269    /**
270     * Get the implicit join path to the <code>selectors</code> table, via the
271     * <code>crrsrvopt_requiredgeocodeselectorid_fk</code> key.
272     */
273    public SelectorsPath crrsrvopt_requiredgeocodeselectorid_fk() {
274        if (_crrsrvopt_requiredgeocodeselectorid_fk == null)
275            _crrsrvopt_requiredgeocodeselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_SERVICE_OPTIONS_REQUIRED_GEO_CODE_SELECTOR_FK, null);
276
277        return _crrsrvopt_requiredgeocodeselectorid_fk;
278    }
279
280    private transient SelectorsPath _crrsrvopt_requireditemselectorid_fk;
281
282    /**
283     * Get the implicit join path to the <code>selectors</code> table, via the
284     * <code>crrsrvopt_requireditemselectorid_fk</code> key.
285     */
286    public SelectorsPath crrsrvopt_requireditemselectorid_fk() {
287        if (_crrsrvopt_requireditemselectorid_fk == null)
288            _crrsrvopt_requireditemselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_SERVICE_OPTIONS_REQUIRED_ITEM_SELECTOR_FK, null);
289
290        return _crrsrvopt_requireditemselectorid_fk;
291    }
292
293    private transient SelectorsPath _crrsrvopt_requiredorderselectorid_fk;
294
295    /**
296     * Get the implicit join path to the <code>selectors</code> table, via the
297     * <code>crrsrvopt_requiredorderselectorid_fk</code> key.
298     */
299    public SelectorsPath crrsrvopt_requiredorderselectorid_fk() {
300        if (_crrsrvopt_requiredorderselectorid_fk == null)
301            _crrsrvopt_requiredorderselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_SERVICE_OPTIONS_REQUIRED_ORDER_SELECTOR_FK, null);
302
303        return _crrsrvopt_requiredorderselectorid_fk;
304    }
305
306    private transient SelectorsPath _crrsrvopt_requiredshipmentselectorid_fk;
307
308    /**
309     * Get the implicit join path to the <code>selectors</code> table, via the
310     * <code>crrsrvopt_requiredshipmentselectorid_fk</code> key.
311     */
312    public SelectorsPath crrsrvopt_requiredshipmentselectorid_fk() {
313        if (_crrsrvopt_requiredshipmentselectorid_fk == null)
314            _crrsrvopt_requiredshipmentselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_SERVICE_OPTIONS_REQUIRED_SHIPMENT_SELECTOR_FK, null);
315
316        return _crrsrvopt_requiredshipmentselectorid_fk;
317    }
318
319    @Override
320    public CarrierServiceOptions as(String alias) {
321        return new CarrierServiceOptions(DSL.name(alias), this);
322    }
323
324    @Override
325    public CarrierServiceOptions as(Name alias) {
326        return new CarrierServiceOptions(alias, this);
327    }
328
329    @Override
330    public CarrierServiceOptions as(Table<?> alias) {
331        return new CarrierServiceOptions(alias.getQualifiedName(), this);
332    }
333
334    /**
335     * Rename this table
336     */
337    @Override
338    public CarrierServiceOptions rename(String name) {
339        return new CarrierServiceOptions(DSL.name(name), null);
340    }
341
342    /**
343     * Rename this table
344     */
345    @Override
346    public CarrierServiceOptions rename(Name name) {
347        return new CarrierServiceOptions(name, null);
348    }
349
350    /**
351     * Rename this table
352     */
353    @Override
354    public CarrierServiceOptions rename(Table<?> name) {
355        return new CarrierServiceOptions(name.getQualifiedName(), null);
356    }
357
358    /**
359     * Create an inline derived table from this table
360     */
361    @Override
362    public CarrierServiceOptions where(Condition condition) {
363        return new CarrierServiceOptions(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
364    }
365
366    /**
367     * Create an inline derived table from this table
368     */
369    @Override
370    public CarrierServiceOptions where(Collection<? extends Condition> conditions) {
371        return where(DSL.and(conditions));
372    }
373
374    /**
375     * Create an inline derived table from this table
376     */
377    @Override
378    public CarrierServiceOptions where(Condition... conditions) {
379        return where(DSL.and(conditions));
380    }
381
382    /**
383     * Create an inline derived table from this table
384     */
385    @Override
386    public CarrierServiceOptions where(Field<Boolean> condition) {
387        return where(DSL.condition(condition));
388    }
389
390    /**
391     * Create an inline derived table from this table
392     */
393    @Override
394    @PlainSQL
395    public CarrierServiceOptions where(SQL condition) {
396        return where(DSL.condition(condition));
397    }
398
399    /**
400     * Create an inline derived table from this table
401     */
402    @Override
403    @PlainSQL
404    public CarrierServiceOptions where(@Stringly.SQL String condition) {
405        return where(DSL.condition(condition));
406    }
407
408    /**
409     * Create an inline derived table from this table
410     */
411    @Override
412    @PlainSQL
413    public CarrierServiceOptions where(@Stringly.SQL String condition, Object... binds) {
414        return where(DSL.condition(condition, binds));
415    }
416
417    /**
418     * Create an inline derived table from this table
419     */
420    @Override
421    @PlainSQL
422    public CarrierServiceOptions where(@Stringly.SQL String condition, QueryPart... parts) {
423        return where(DSL.condition(condition, parts));
424    }
425
426    /**
427     * Create an inline derived table from this table
428     */
429    @Override
430    public CarrierServiceOptions whereExists(TableLike<?> select) {
431        return where(DSL.exists(select));
432    }
433
434    /**
435     * Create an inline derived table from this table
436     */
437    @Override
438    public CarrierServiceOptions whereNotExists(TableLike<?> select) {
439        return where(DSL.notExists(select));
440    }
441}