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