Source code

001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.item;
005
006
007import com.echothree.model.data.item.common.pk.HarmonizedTariffScheduleCodePK;
008import com.echothree.model.data.item.common.pk.HarmonizedTariffScheduleCodeUsePK;
009import com.echothree.model.data.item.common.pk.HarmonizedTariffScheduleCodeUseTypePK;
010import com.echothree.model.jooq.server.KeyRegistry;
011import com.echothree.model.jooq.server.tables.item.HarmonizedTariffScheduleCodeUseTypes.HarmonizedTariffScheduleCodeUseTypesPath;
012import com.echothree.model.jooq.server.tables.item.HarmonizedTariffScheduleCodes.HarmonizedTariffScheduleCodesPath;
013
014import java.util.Arrays;
015import java.util.Collection;
016import java.util.List;
017
018import org.jooq.Condition;
019import org.jooq.Converter;
020import org.jooq.Field;
021import org.jooq.ForeignKey;
022import org.jooq.Name;
023import org.jooq.PlainSQL;
024import org.jooq.QueryPart;
025import org.jooq.SQL;
026import org.jooq.Stringly;
027import org.jooq.Table;
028import org.jooq.TableField;
029import org.jooq.TableLike;
030import org.jooq.TableOptions;
031import org.jooq.UniqueKey;
032import org.jooq.impl.DSL;
033import org.jooq.impl.Internal;
034import org.jooq.impl.SQLDataType;
035import org.jooq.impl.TableImpl;
036
037
038/**
039 * This class is generated by jOOQ.
040 */
041@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
042public class HarmonizedTariffScheduleCodeUses extends TableImpl<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses> {
043
044    private static final long serialVersionUID = 1L;
045
046    /**
047     * The reference instance of <code>harmonizedtariffschedulecodeuses</code>
048     */
049    public static final HarmonizedTariffScheduleCodeUses HarmonizedTariffScheduleCodeUses = new HarmonizedTariffScheduleCodeUses();
050
051    /**
052     * The class holding records for this type
053     */
054    @Override
055    public Class<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses> getRecordType() {
056        return com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses.class;
057    }
058
059    /**
060     * The column
061     * <code>harmonizedtariffschedulecodeuses.hztscu_harmonizedtariffschedulecodeuseid</code>.
062     */
063    public final TableField<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses, HarmonizedTariffScheduleCodeUsePK> HARMONIZED_TARIFF_SCHEDULE_CODE_USE = createField(DSL.name("hztscu_harmonizedtariffschedulecodeuseid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, HarmonizedTariffScheduleCodeUsePK.class, id -> new com.echothree.model.data.item.common.pk.HarmonizedTariffScheduleCodeUsePK(id), primaryKey -> primaryKey.getEntityId()));
064
065    /**
066     * The column
067     * <code>harmonizedtariffschedulecodeuses.hztscu_hztsc_harmonizedtariffschedulecodeid</code>.
068     */
069    public final TableField<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses, HarmonizedTariffScheduleCodePK> HARMONIZED_TARIFF_SCHEDULE_CODE = createField(DSL.name("hztscu_hztsc_harmonizedtariffschedulecodeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, HarmonizedTariffScheduleCodePK.class, id -> new com.echothree.model.data.item.common.pk.HarmonizedTariffScheduleCodePK(id), primaryKey -> primaryKey.getEntityId()));
070
071    /**
072     * The column
073     * <code>harmonizedtariffschedulecodeuses.hztscu_hztscutyp_harmonizedtariffschedulecodeusetypeid</code>.
074     */
075    public final TableField<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses, HarmonizedTariffScheduleCodeUseTypePK> HARMONIZED_TARIFF_SCHEDULE_CODE_USE_TYPE = createField(DSL.name("hztscu_hztscutyp_harmonizedtariffschedulecodeusetypeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, HarmonizedTariffScheduleCodeUseTypePK.class, id -> new com.echothree.model.data.item.common.pk.HarmonizedTariffScheduleCodeUseTypePK(id), primaryKey -> primaryKey.getEntityId()));
076
077    /**
078     * The column <code>harmonizedtariffschedulecodeuses.hztscu_fromtime</code>.
079     */
080    public final TableField<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses, Long> FROM_TIME = createField(DSL.name("hztscu_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
081
082    /**
083     * The column <code>harmonizedtariffschedulecodeuses.hztscu_thrutime</code>.
084     */
085    public final TableField<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses, Long> THRU_TIME = createField(DSL.name("hztscu_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
086
087    private HarmonizedTariffScheduleCodeUses(Name alias, Table<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses> aliased) {
088        this(alias, aliased, (Field<?>[]) null, null);
089    }
090
091    private HarmonizedTariffScheduleCodeUses(Name alias, Table<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses> aliased, Field<?>[] parameters, Condition where) {
092        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
093    }
094
095    /**
096     * Create an aliased <code>harmonizedtariffschedulecodeuses</code> table
097     * reference
098     */
099    public HarmonizedTariffScheduleCodeUses(String alias) {
100        this(DSL.name(alias), HarmonizedTariffScheduleCodeUses);
101    }
102
103    /**
104     * Create an aliased <code>harmonizedtariffschedulecodeuses</code> table
105     * reference
106     */
107    public HarmonizedTariffScheduleCodeUses(Name alias) {
108        this(alias, HarmonizedTariffScheduleCodeUses);
109    }
110
111    /**
112     * Create a <code>harmonizedtariffschedulecodeuses</code> table reference
113     */
114    public HarmonizedTariffScheduleCodeUses() {
115        this(DSL.name("harmonizedtariffschedulecodeuses"), null);
116    }
117
118    @Override
119    public UniqueKey<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses> getPrimaryKey() {
120        return KeyRegistry.HARMONIZED_TARIFF_SCHEDULE_CODE_USES_PK;
121    }
122
123    @Override
124    public List<UniqueKey<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses>> getUniqueKeys() {
125        return Arrays.asList(KeyRegistry.HARMONIZED_TARIFF_SCHEDULE_CODE_USES_HARMONIZED_TARIFF_SCHEDULE_CODE_AND_HARMONIZED_TARIFF_SCHEDULE_CODE_USE_TYPE_AND_THRU_TIME_UK);
126    }
127
128    @Override
129    public List<ForeignKey<com.echothree.model.jooq.server.records.item.HarmonizedTariffScheduleCodeUses, ?>> getReferences() {
130        return Arrays.asList(KeyRegistry.HARMONIZED_TARIFF_SCHEDULE_CODE_USES_HARMONIZED_TARIFF_SCHEDULE_CODE_FK, KeyRegistry.HARMONIZED_TARIFF_SCHEDULE_CODE_USES_HARMONIZED_TARIFF_SCHEDULE_CODE_USE_TYPE_FK);
131    }
132
133    private transient HarmonizedTariffScheduleCodesPath _hztscu_hztsc_harmonizedtariffschedulecodeid_fk;
134
135    /**
136     * Get the implicit join path to the
137     * <code>harmonizedtariffschedulecodes</code> table.
138     */
139    public HarmonizedTariffScheduleCodesPath hztscu_hztsc_harmonizedtariffschedulecodeid_fk() {
140        if (_hztscu_hztsc_harmonizedtariffschedulecodeid_fk == null)
141            _hztscu_hztsc_harmonizedtariffschedulecodeid_fk = new HarmonizedTariffScheduleCodesPath(this, KeyRegistry.HARMONIZED_TARIFF_SCHEDULE_CODE_USES_HARMONIZED_TARIFF_SCHEDULE_CODE_FK, null);
142
143        return _hztscu_hztsc_harmonizedtariffschedulecodeid_fk;
144    }
145
146    private transient HarmonizedTariffScheduleCodeUseTypesPath _hztscu_hztscutyp_harmonizedtariffschedulecodeusetypeid_fk;
147
148    /**
149     * Get the implicit join path to the
150     * <code>harmonizedtariffschedulecodeusetypes</code> table.
151     */
152    public HarmonizedTariffScheduleCodeUseTypesPath hztscu_hztscutyp_harmonizedtariffschedulecodeusetypeid_fk() {
153        if (_hztscu_hztscutyp_harmonizedtariffschedulecodeusetypeid_fk == null)
154            _hztscu_hztscutyp_harmonizedtariffschedulecodeusetypeid_fk = new HarmonizedTariffScheduleCodeUseTypesPath(this, KeyRegistry.HARMONIZED_TARIFF_SCHEDULE_CODE_USES_HARMONIZED_TARIFF_SCHEDULE_CODE_USE_TYPE_FK, null);
155
156        return _hztscu_hztscutyp_harmonizedtariffschedulecodeusetypeid_fk;
157    }
158
159    @Override
160    public HarmonizedTariffScheduleCodeUses as(String alias) {
161        return new HarmonizedTariffScheduleCodeUses(DSL.name(alias), this);
162    }
163
164    @Override
165    public HarmonizedTariffScheduleCodeUses as(Name alias) {
166        return new HarmonizedTariffScheduleCodeUses(alias, this);
167    }
168
169    @Override
170    public HarmonizedTariffScheduleCodeUses as(Table<?> alias) {
171        return new HarmonizedTariffScheduleCodeUses(alias.getQualifiedName(), this);
172    }
173
174    /**
175     * Rename this table
176     */
177    @Override
178    public HarmonizedTariffScheduleCodeUses rename(String name) {
179        return new HarmonizedTariffScheduleCodeUses(DSL.name(name), null);
180    }
181
182    /**
183     * Rename this table
184     */
185    @Override
186    public HarmonizedTariffScheduleCodeUses rename(Name name) {
187        return new HarmonizedTariffScheduleCodeUses(name, null);
188    }
189
190    /**
191     * Rename this table
192     */
193    @Override
194    public HarmonizedTariffScheduleCodeUses rename(Table<?> name) {
195        return new HarmonizedTariffScheduleCodeUses(name.getQualifiedName(), null);
196    }
197
198    /**
199     * Create an inline derived table from this table
200     */
201    @Override
202    public HarmonizedTariffScheduleCodeUses where(Condition condition) {
203        return new HarmonizedTariffScheduleCodeUses(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
204    }
205
206    /**
207     * Create an inline derived table from this table
208     */
209    @Override
210    public HarmonizedTariffScheduleCodeUses where(Collection<? extends Condition> conditions) {
211        return where(DSL.and(conditions));
212    }
213
214    /**
215     * Create an inline derived table from this table
216     */
217    @Override
218    public HarmonizedTariffScheduleCodeUses where(Condition... conditions) {
219        return where(DSL.and(conditions));
220    }
221
222    /**
223     * Create an inline derived table from this table
224     */
225    @Override
226    public HarmonizedTariffScheduleCodeUses where(Field<Boolean> condition) {
227        return where(DSL.condition(condition));
228    }
229
230    /**
231     * Create an inline derived table from this table
232     */
233    @Override
234    @PlainSQL
235    public HarmonizedTariffScheduleCodeUses where(SQL condition) {
236        return where(DSL.condition(condition));
237    }
238
239    /**
240     * Create an inline derived table from this table
241     */
242    @Override
243    @PlainSQL
244    public HarmonizedTariffScheduleCodeUses where(@Stringly.SQL String condition) {
245        return where(DSL.condition(condition));
246    }
247
248    /**
249     * Create an inline derived table from this table
250     */
251    @Override
252    @PlainSQL
253    public HarmonizedTariffScheduleCodeUses where(@Stringly.SQL String condition, Object... binds) {
254        return where(DSL.condition(condition, binds));
255    }
256
257    /**
258     * Create an inline derived table from this table
259     */
260    @Override
261    @PlainSQL
262    public HarmonizedTariffScheduleCodeUses where(@Stringly.SQL String condition, QueryPart... parts) {
263        return where(DSL.condition(condition, parts));
264    }
265
266    /**
267     * Create an inline derived table from this table
268     */
269    @Override
270    public HarmonizedTariffScheduleCodeUses whereExists(TableLike<?> select) {
271        return where(DSL.exists(select));
272    }
273
274    /**
275     * Create an inline derived table from this table
276     */
277    @Override
278    public HarmonizedTariffScheduleCodeUses whereNotExists(TableLike<?> select) {
279        return where(DSL.notExists(select));
280    }
281}