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.CarrierServiceDetailPK;
008import com.echothree.model.data.carrier.common.pk.CarrierServicePK;
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.CarrierServices.CarrierServicesPath;
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 CarrierServiceDetails extends TableImpl<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> {
048
049    private static final long serialVersionUID = 1L;
050
051    /**
052     * The reference instance of <code>carrierservicedetails</code>
053     */
054    public static final CarrierServiceDetails CarrierServiceDetails = new CarrierServiceDetails();
055
056    /**
057     * The class holding records for this type
058     */
059    @Override
060    public Class<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> getRecordType() {
061        return com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails.class;
062    }
063
064    /**
065     * The column
066     * <code>carrierservicedetails.crrsrvdt_carrierservicedetailid</code>.
067     */
068    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, CarrierServiceDetailPK> CARRIER_SERVICE_DETAIL = createField(DSL.name("crrsrvdt_carrierservicedetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, CarrierServiceDetailPK.class, id -> new com.echothree.model.data.carrier.common.pk.CarrierServiceDetailPK(id), primaryKey -> primaryKey.getEntityId()));
069
070    /**
071     * The column
072     * <code>carrierservicedetails.crrsrvdt_crrsrv_carrierserviceid</code>.
073     */
074    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, CarrierServicePK> CARRIER_SERVICE = createField(DSL.name("crrsrvdt_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()));
075
076    /**
077     * The column <code>carrierservicedetails.crrsrvdt_carrierpartyid</code>.
078     */
079    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, PartyPK> CARRIER_PARTY = createField(DSL.name("crrsrvdt_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
083     * <code>carrierservicedetails.crrsrvdt_carrierservicename</code>.
084     */
085    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, String> CARRIER_SERVICE_NAME = createField(DSL.name("crrsrvdt_carrierservicename"), SQLDataType.VARCHAR(40).nullable(false), this, "");
086
087    /**
088     * The column <code>carrierservicedetails.crrsrvdt_geocodeselectorid</code>.
089     */
090    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, SelectorPK> GEO_CODE_SELECTOR = createField(DSL.name("crrsrvdt_geocodeselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
091
092    /**
093     * The column <code>carrierservicedetails.crrsrvdt_itemselectorid</code>.
094     */
095    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, SelectorPK> ITEM_SELECTOR = createField(DSL.name("crrsrvdt_itemselectorid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, SelectorPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorPK(id), primaryKey -> primaryKey.getEntityId()));
096
097    /**
098     * The column <code>carrierservicedetails.crrsrvdt_isdefault</code>.
099     */
100    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, Boolean> IS_DEFAULT = createField(DSL.name("crrsrvdt_isdefault"), SQLDataType.BIT.nullable(false), this, "");
101
102    /**
103     * The column <code>carrierservicedetails.crrsrvdt_sortorder</code>.
104     */
105    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, Integer> SORT_ORDER = createField(DSL.name("crrsrvdt_sortorder"), SQLDataType.INTEGER.nullable(false), this, "");
106
107    /**
108     * The column <code>carrierservicedetails.crrsrvdt_fromtime</code>.
109     */
110    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, Long> FROM_TIME = createField(DSL.name("crrsrvdt_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
111
112    /**
113     * The column <code>carrierservicedetails.crrsrvdt_thrutime</code>.
114     */
115    public final TableField<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, Long> THRU_TIME = createField(DSL.name("crrsrvdt_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
116
117    private CarrierServiceDetails(Name alias, Table<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> aliased) {
118        this(alias, aliased, (Field<?>[]) null, null);
119    }
120
121    private CarrierServiceDetails(Name alias, Table<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> aliased, Field<?>[] parameters, Condition where) {
122        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
123    }
124
125    /**
126     * Create an aliased <code>carrierservicedetails</code> table reference
127     */
128    public CarrierServiceDetails(String alias) {
129        this(DSL.name(alias), CarrierServiceDetails);
130    }
131
132    /**
133     * Create an aliased <code>carrierservicedetails</code> table reference
134     */
135    public CarrierServiceDetails(Name alias) {
136        this(alias, CarrierServiceDetails);
137    }
138
139    /**
140     * Create a <code>carrierservicedetails</code> table reference
141     */
142    public CarrierServiceDetails() {
143        this(DSL.name("carrierservicedetails"), null);
144    }
145
146    public <O extends Record> CarrierServiceDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> parentPath) {
147        super(path, childPath, parentPath, CarrierServiceDetails);
148    }
149
150    /**
151     * A subtype implementing {@link Path} for simplified path-based joins.
152     */
153    public static class CarrierServiceDetailsPath extends CarrierServiceDetails implements Path<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> {
154
155        private static final long serialVersionUID = 1L;
156        public <O extends Record> CarrierServiceDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> parentPath) {
157            super(path, childPath, parentPath);
158        }
159        private CarrierServiceDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> aliased) {
160            super(alias, aliased);
161        }
162
163        @Override
164        public CarrierServiceDetailsPath as(String alias) {
165            return new CarrierServiceDetailsPath(DSL.name(alias), this);
166        }
167
168        @Override
169        public CarrierServiceDetailsPath as(Name alias) {
170            return new CarrierServiceDetailsPath(alias, this);
171        }
172
173        @Override
174        public CarrierServiceDetailsPath as(Table<?> alias) {
175            return new CarrierServiceDetailsPath(alias.getQualifiedName(), this);
176        }
177    }
178
179    @Override
180    public UniqueKey<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails> getPrimaryKey() {
181        return KeyRegistry.CARRIER_SERVICE_DETAILS_PK;
182    }
183
184    @Override
185    public List<UniqueKey<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails>> getUniqueKeys() {
186        return Arrays.asList(KeyRegistry.CARRIER_SERVICE_DETAILS_CARRIER_SERVICE_AND_THRU_TIME_UK, KeyRegistry.CARRIER_SERVICE_DETAILS_CARRIER_PARTY_AND_CARRIER_SERVICE_NAME_AND_THRU_TIME_UK);
187    }
188
189    @Override
190    public List<ForeignKey<com.echothree.model.jooq.server.records.carrier.CarrierServiceDetails, ?>> getReferences() {
191        return Arrays.asList(KeyRegistry.CARRIER_SERVICE_DETAILS_CARRIER_PARTY_FK, KeyRegistry.CARRIER_SERVICE_DETAILS_CARRIER_SERVICE_FK, KeyRegistry.CARRIER_SERVICE_DETAILS_GEO_CODE_SELECTOR_FK, KeyRegistry.CARRIER_SERVICE_DETAILS_ITEM_SELECTOR_FK);
192    }
193
194    private transient PartiesPath _crrsrvdt_carrierpartyid_fk;
195
196    /**
197     * Get the implicit join path to the <code>parties</code> table.
198     */
199    public PartiesPath crrsrvdt_carrierpartyid_fk() {
200        if (_crrsrvdt_carrierpartyid_fk == null)
201            _crrsrvdt_carrierpartyid_fk = new PartiesPath(this, KeyRegistry.CARRIER_SERVICE_DETAILS_CARRIER_PARTY_FK, null);
202
203        return _crrsrvdt_carrierpartyid_fk;
204    }
205
206    private transient CarrierServicesPath _crrsrvdt_crrsrv_carrierserviceid_fk;
207
208    /**
209     * Get the implicit join path to the <code>carrierservices</code> table.
210     */
211    public CarrierServicesPath crrsrvdt_crrsrv_carrierserviceid_fk() {
212        if (_crrsrvdt_crrsrv_carrierserviceid_fk == null)
213            _crrsrvdt_crrsrv_carrierserviceid_fk = new CarrierServicesPath(this, KeyRegistry.CARRIER_SERVICE_DETAILS_CARRIER_SERVICE_FK, null);
214
215        return _crrsrvdt_crrsrv_carrierserviceid_fk;
216    }
217
218    private transient SelectorsPath _crrsrvdt_geocodeselectorid_fk;
219
220    /**
221     * Get the implicit join path to the <code>selectors</code> table, via the
222     * <code>crrsrvdt_geocodeselectorid_fk</code> key.
223     */
224    public SelectorsPath crrsrvdt_geocodeselectorid_fk() {
225        if (_crrsrvdt_geocodeselectorid_fk == null)
226            _crrsrvdt_geocodeselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_SERVICE_DETAILS_GEO_CODE_SELECTOR_FK, null);
227
228        return _crrsrvdt_geocodeselectorid_fk;
229    }
230
231    private transient SelectorsPath _crrsrvdt_itemselectorid_fk;
232
233    /**
234     * Get the implicit join path to the <code>selectors</code> table, via the
235     * <code>crrsrvdt_itemselectorid_fk</code> key.
236     */
237    public SelectorsPath crrsrvdt_itemselectorid_fk() {
238        if (_crrsrvdt_itemselectorid_fk == null)
239            _crrsrvdt_itemselectorid_fk = new SelectorsPath(this, KeyRegistry.CARRIER_SERVICE_DETAILS_ITEM_SELECTOR_FK, null);
240
241        return _crrsrvdt_itemselectorid_fk;
242    }
243
244    @Override
245    public CarrierServiceDetails as(String alias) {
246        return new CarrierServiceDetails(DSL.name(alias), this);
247    }
248
249    @Override
250    public CarrierServiceDetails as(Name alias) {
251        return new CarrierServiceDetails(alias, this);
252    }
253
254    @Override
255    public CarrierServiceDetails as(Table<?> alias) {
256        return new CarrierServiceDetails(alias.getQualifiedName(), this);
257    }
258
259    /**
260     * Rename this table
261     */
262    @Override
263    public CarrierServiceDetails rename(String name) {
264        return new CarrierServiceDetails(DSL.name(name), null);
265    }
266
267    /**
268     * Rename this table
269     */
270    @Override
271    public CarrierServiceDetails rename(Name name) {
272        return new CarrierServiceDetails(name, null);
273    }
274
275    /**
276     * Rename this table
277     */
278    @Override
279    public CarrierServiceDetails rename(Table<?> name) {
280        return new CarrierServiceDetails(name.getQualifiedName(), null);
281    }
282
283    /**
284     * Create an inline derived table from this table
285     */
286    @Override
287    public CarrierServiceDetails where(Condition condition) {
288        return new CarrierServiceDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
289    }
290
291    /**
292     * Create an inline derived table from this table
293     */
294    @Override
295    public CarrierServiceDetails where(Collection<? extends Condition> conditions) {
296        return where(DSL.and(conditions));
297    }
298
299    /**
300     * Create an inline derived table from this table
301     */
302    @Override
303    public CarrierServiceDetails where(Condition... conditions) {
304        return where(DSL.and(conditions));
305    }
306
307    /**
308     * Create an inline derived table from this table
309     */
310    @Override
311    public CarrierServiceDetails where(Field<Boolean> 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 CarrierServiceDetails where(SQL condition) {
321        return where(DSL.condition(condition));
322    }
323
324    /**
325     * Create an inline derived table from this table
326     */
327    @Override
328    @PlainSQL
329    public CarrierServiceDetails where(@Stringly.SQL String condition) {
330        return where(DSL.condition(condition));
331    }
332
333    /**
334     * Create an inline derived table from this table
335     */
336    @Override
337    @PlainSQL
338    public CarrierServiceDetails where(@Stringly.SQL String condition, Object... binds) {
339        return where(DSL.condition(condition, binds));
340    }
341
342    /**
343     * Create an inline derived table from this table
344     */
345    @Override
346    @PlainSQL
347    public CarrierServiceDetails where(@Stringly.SQL String condition, QueryPart... parts) {
348        return where(DSL.condition(condition, parts));
349    }
350
351    /**
352     * Create an inline derived table from this table
353     */
354    @Override
355    public CarrierServiceDetails whereExists(TableLike<?> select) {
356        return where(DSL.exists(select));
357    }
358
359    /**
360     * Create an inline derived table from this table
361     */
362    @Override
363    public CarrierServiceDetails whereNotExists(TableLike<?> select) {
364        return where(DSL.notExists(select));
365    }
366}