001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.party;
005
006
007import com.echothree.model.data.core.common.pk.MimeTypePK;
008import com.echothree.model.data.icon.common.pk.IconPK;
009import com.echothree.model.data.party.common.pk.BirthdayFormatPK;
010import com.echothree.model.data.party.common.pk.GenderPK;
011import com.echothree.model.data.party.common.pk.PartyPK;
012import com.echothree.model.data.party.common.pk.ProfilePK;
013import com.echothree.model.jooq.server.KeyRegistry;
014import com.echothree.model.jooq.server.tables.core.MimeTypes.MimeTypesPath;
015import com.echothree.model.jooq.server.tables.icon.Icons.IconsPath;
016import com.echothree.model.jooq.server.tables.party.BirthdayFormats.BirthdayFormatsPath;
017import com.echothree.model.jooq.server.tables.party.Genders.GendersPath;
018import com.echothree.model.jooq.server.tables.party.Parties.PartiesPath;
019
020import java.util.Arrays;
021import java.util.Collection;
022import java.util.List;
023
024import org.jooq.Condition;
025import org.jooq.Converter;
026import org.jooq.Field;
027import org.jooq.ForeignKey;
028import org.jooq.Name;
029import org.jooq.PlainSQL;
030import org.jooq.QueryPart;
031import org.jooq.SQL;
032import org.jooq.Stringly;
033import org.jooq.Table;
034import org.jooq.TableField;
035import org.jooq.TableLike;
036import org.jooq.TableOptions;
037import org.jooq.UniqueKey;
038import org.jooq.impl.DSL;
039import org.jooq.impl.Internal;
040import org.jooq.impl.SQLDataType;
041import org.jooq.impl.TableImpl;
042
043
044/**
045 * This class is generated by jOOQ.
046 */
047@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
048public class Profiles extends TableImpl<com.echothree.model.jooq.server.records.party.Profiles> {
049
050    private static final long serialVersionUID = 1L;
051
052    /**
053     * The reference instance of <code>profiles</code>
054     */
055    public static final Profiles Profiles = new Profiles();
056
057    /**
058     * The class holding records for this type
059     */
060    @Override
061    public Class<com.echothree.model.jooq.server.records.party.Profiles> getRecordType() {
062        return com.echothree.model.jooq.server.records.party.Profiles.class;
063    }
064
065    /**
066     * The column <code>profiles.prfl_profileid</code>.
067     */
068    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, ProfilePK> PROFILE = createField(DSL.name("prfl_profileid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ProfilePK.class, id -> new com.echothree.model.data.party.common.pk.ProfilePK(id), primaryKey -> primaryKey.getEntityId()));
069
070    /**
071     * The column <code>profiles.prfl_par_partyid</code>.
072     */
073    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, PartyPK> PARTY = createField(DSL.name("prfl_par_partyid"), 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()));
074
075    /**
076     * The column <code>profiles.prfl_nickname</code>.
077     */
078    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, String> NICKNAME = createField(DSL.name("prfl_nickname"), SQLDataType.VARCHAR(40), this, "");
079
080    /**
081     * The column <code>profiles.prfl_icn_iconid</code>.
082     */
083    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, IconPK> ICON = createField(DSL.name("prfl_icn_iconid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, IconPK.class, id -> new com.echothree.model.data.icon.common.pk.IconPK(id), primaryKey -> primaryKey.getEntityId()));
084
085    /**
086     * The column <code>profiles.prfl_pronunciation</code>.
087     */
088    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, String> PRONUNCIATION = createField(DSL.name("prfl_pronunciation"), SQLDataType.VARCHAR(200), this, "");
089
090    /**
091     * The column <code>profiles.prfl_gndr_genderid</code>.
092     */
093    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, GenderPK> GENDER = createField(DSL.name("prfl_gndr_genderid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, GenderPK.class, id -> new com.echothree.model.data.party.common.pk.GenderPK(id), primaryKey -> primaryKey.getEntityId()));
094
095    /**
096     * The column <code>profiles.prfl_pronouns</code>.
097     */
098    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, String> PRONOUNS = createField(DSL.name("prfl_pronouns"), SQLDataType.VARCHAR(50), this, "");
099
100    /**
101     * The column <code>profiles.prfl_birthday</code>.
102     */
103    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, Integer> BIRTHDAY = createField(DSL.name("prfl_birthday"), SQLDataType.INTEGER, this, "");
104
105    /**
106     * The column <code>profiles.prfl_bdyf_birthdayformatid</code>.
107     */
108    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, BirthdayFormatPK> BIRTHDAY_FORMAT = createField(DSL.name("prfl_bdyf_birthdayformatid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, BirthdayFormatPK.class, id -> new com.echothree.model.data.party.common.pk.BirthdayFormatPK(id), primaryKey -> primaryKey.getEntityId()));
109
110    /**
111     * The column <code>profiles.prfl_occupation</code>.
112     */
113    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, String> OCCUPATION = createField(DSL.name("prfl_occupation"), SQLDataType.VARCHAR(200), this, "");
114
115    /**
116     * The column <code>profiles.prfl_hobbies</code>.
117     */
118    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, String> HOBBIES = createField(DSL.name("prfl_hobbies"), SQLDataType.VARCHAR(200), this, "");
119
120    /**
121     * The column <code>profiles.prfl_location</code>.
122     */
123    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, String> LOCATION = createField(DSL.name("prfl_location"), SQLDataType.VARCHAR(60), this, "");
124
125    /**
126     * The column <code>profiles.prfl_biomimetypeid</code>.
127     */
128    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, MimeTypePK> BIO_MIME_TYPE = createField(DSL.name("prfl_biomimetypeid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, MimeTypePK.class, id -> new com.echothree.model.data.core.common.pk.MimeTypePK(id), primaryKey -> primaryKey.getEntityId()));
129
130    /**
131     * The column <code>profiles.prfl_bio</code>.
132     */
133    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, String> BIO = createField(DSL.name("prfl_bio"), SQLDataType.CLOB, this, "");
134
135    /**
136     * The column <code>profiles.prfl_signaturemimetypeid</code>.
137     */
138    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, MimeTypePK> SIGNATURE_MIME_TYPE = createField(DSL.name("prfl_signaturemimetypeid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, MimeTypePK.class, id -> new com.echothree.model.data.core.common.pk.MimeTypePK(id), primaryKey -> primaryKey.getEntityId()));
139
140    /**
141     * The column <code>profiles.prfl_signature</code>.
142     */
143    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, String> SIGNATURE = createField(DSL.name("prfl_signature"), SQLDataType.CLOB, this, "");
144
145    /**
146     * The column <code>profiles.prfl_fromtime</code>.
147     */
148    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, Long> FROM_TIME = createField(DSL.name("prfl_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
149
150    /**
151     * The column <code>profiles.prfl_thrutime</code>.
152     */
153    public final TableField<com.echothree.model.jooq.server.records.party.Profiles, Long> THRU_TIME = createField(DSL.name("prfl_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
154
155    private Profiles(Name alias, Table<com.echothree.model.jooq.server.records.party.Profiles> aliased) {
156        this(alias, aliased, (Field<?>[]) null, null);
157    }
158
159    private Profiles(Name alias, Table<com.echothree.model.jooq.server.records.party.Profiles> aliased, Field<?>[] parameters, Condition where) {
160        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
161    }
162
163    /**
164     * Create an aliased <code>profiles</code> table reference
165     */
166    public Profiles(String alias) {
167        this(DSL.name(alias), Profiles);
168    }
169
170    /**
171     * Create an aliased <code>profiles</code> table reference
172     */
173    public Profiles(Name alias) {
174        this(alias, Profiles);
175    }
176
177    /**
178     * Create a <code>profiles</code> table reference
179     */
180    public Profiles() {
181        this(DSL.name("profiles"), null);
182    }
183
184    @Override
185    public UniqueKey<com.echothree.model.jooq.server.records.party.Profiles> getPrimaryKey() {
186        return KeyRegistry.PROFILES_PK;
187    }
188
189    @Override
190    public List<UniqueKey<com.echothree.model.jooq.server.records.party.Profiles>> getUniqueKeys() {
191        return Arrays.asList(KeyRegistry.PROFILES_PARTY_AND_THRU_TIME_UK, KeyRegistry.PROFILES_NICKNAME_AND_THRU_TIME_UK);
192    }
193
194    @Override
195    public List<ForeignKey<com.echothree.model.jooq.server.records.party.Profiles, ?>> getReferences() {
196        return Arrays.asList(KeyRegistry.PROFILES_BIRTHDAY_FORMAT_FK, KeyRegistry.PROFILES_BIO_MIME_TYPE_FK, KeyRegistry.PROFILES_GENDER_FK, KeyRegistry.PROFILES_ICON_FK, KeyRegistry.PROFILES_PARTY_FK, KeyRegistry.PROFILES_SIGNATURE_MIME_TYPE_FK);
197    }
198
199    private transient BirthdayFormatsPath _prfl_bdyf_birthdayformatid_fk;
200
201    /**
202     * Get the implicit join path to the <code>birthdayformats</code> table.
203     */
204    public BirthdayFormatsPath prfl_bdyf_birthdayformatid_fk() {
205        if (_prfl_bdyf_birthdayformatid_fk == null)
206            _prfl_bdyf_birthdayformatid_fk = new BirthdayFormatsPath(this, KeyRegistry.PROFILES_BIRTHDAY_FORMAT_FK, null);
207
208        return _prfl_bdyf_birthdayformatid_fk;
209    }
210
211    private transient MimeTypesPath _prfl_biomimetypeid_fk;
212
213    /**
214     * Get the implicit join path to the <code>mimetypes</code> table, via the
215     * <code>prfl_biomimetypeid_fk</code> key.
216     */
217    public MimeTypesPath prfl_biomimetypeid_fk() {
218        if (_prfl_biomimetypeid_fk == null)
219            _prfl_biomimetypeid_fk = new MimeTypesPath(this, KeyRegistry.PROFILES_BIO_MIME_TYPE_FK, null);
220
221        return _prfl_biomimetypeid_fk;
222    }
223
224    private transient GendersPath _prfl_gndr_genderid_fk;
225
226    /**
227     * Get the implicit join path to the <code>genders</code> table.
228     */
229    public GendersPath prfl_gndr_genderid_fk() {
230        if (_prfl_gndr_genderid_fk == null)
231            _prfl_gndr_genderid_fk = new GendersPath(this, KeyRegistry.PROFILES_GENDER_FK, null);
232
233        return _prfl_gndr_genderid_fk;
234    }
235
236    private transient IconsPath _prfl_icn_iconid_fk;
237
238    /**
239     * Get the implicit join path to the <code>icons</code> table.
240     */
241    public IconsPath prfl_icn_iconid_fk() {
242        if (_prfl_icn_iconid_fk == null)
243            _prfl_icn_iconid_fk = new IconsPath(this, KeyRegistry.PROFILES_ICON_FK, null);
244
245        return _prfl_icn_iconid_fk;
246    }
247
248    private transient PartiesPath _prfl_par_partyid_fk;
249
250    /**
251     * Get the implicit join path to the <code>parties</code> table.
252     */
253    public PartiesPath prfl_par_partyid_fk() {
254        if (_prfl_par_partyid_fk == null)
255            _prfl_par_partyid_fk = new PartiesPath(this, KeyRegistry.PROFILES_PARTY_FK, null);
256
257        return _prfl_par_partyid_fk;
258    }
259
260    private transient MimeTypesPath _prfl_signaturemimetypeid_fk;
261
262    /**
263     * Get the implicit join path to the <code>mimetypes</code> table, via the
264     * <code>prfl_signaturemimetypeid_fk</code> key.
265     */
266    public MimeTypesPath prfl_signaturemimetypeid_fk() {
267        if (_prfl_signaturemimetypeid_fk == null)
268            _prfl_signaturemimetypeid_fk = new MimeTypesPath(this, KeyRegistry.PROFILES_SIGNATURE_MIME_TYPE_FK, null);
269
270        return _prfl_signaturemimetypeid_fk;
271    }
272
273    @Override
274    public Profiles as(String alias) {
275        return new Profiles(DSL.name(alias), this);
276    }
277
278    @Override
279    public Profiles as(Name alias) {
280        return new Profiles(alias, this);
281    }
282
283    @Override
284    public Profiles as(Table<?> alias) {
285        return new Profiles(alias.getQualifiedName(), this);
286    }
287
288    /**
289     * Rename this table
290     */
291    @Override
292    public Profiles rename(String name) {
293        return new Profiles(DSL.name(name), null);
294    }
295
296    /**
297     * Rename this table
298     */
299    @Override
300    public Profiles rename(Name name) {
301        return new Profiles(name, null);
302    }
303
304    /**
305     * Rename this table
306     */
307    @Override
308    public Profiles rename(Table<?> name) {
309        return new Profiles(name.getQualifiedName(), null);
310    }
311
312    /**
313     * Create an inline derived table from this table
314     */
315    @Override
316    public Profiles where(Condition condition) {
317        return new Profiles(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
318    }
319
320    /**
321     * Create an inline derived table from this table
322     */
323    @Override
324    public Profiles where(Collection<? extends Condition> conditions) {
325        return where(DSL.and(conditions));
326    }
327
328    /**
329     * Create an inline derived table from this table
330     */
331    @Override
332    public Profiles where(Condition... conditions) {
333        return where(DSL.and(conditions));
334    }
335
336    /**
337     * Create an inline derived table from this table
338     */
339    @Override
340    public Profiles where(Field<Boolean> condition) {
341        return where(DSL.condition(condition));
342    }
343
344    /**
345     * Create an inline derived table from this table
346     */
347    @Override
348    @PlainSQL
349    public Profiles where(SQL condition) {
350        return where(DSL.condition(condition));
351    }
352
353    /**
354     * Create an inline derived table from this table
355     */
356    @Override
357    @PlainSQL
358    public Profiles where(@Stringly.SQL String condition) {
359        return where(DSL.condition(condition));
360    }
361
362    /**
363     * Create an inline derived table from this table
364     */
365    @Override
366    @PlainSQL
367    public Profiles where(@Stringly.SQL String condition, Object... binds) {
368        return where(DSL.condition(condition, binds));
369    }
370
371    /**
372     * Create an inline derived table from this table
373     */
374    @Override
375    @PlainSQL
376    public Profiles where(@Stringly.SQL String condition, QueryPart... parts) {
377        return where(DSL.condition(condition, parts));
378    }
379
380    /**
381     * Create an inline derived table from this table
382     */
383    @Override
384    public Profiles whereExists(TableLike<?> select) {
385        return where(DSL.exists(select));
386    }
387
388    /**
389     * Create an inline derived table from this table
390     */
391    @Override
392    public Profiles whereNotExists(TableLike<?> select) {
393        return where(DSL.notExists(select));
394    }
395}