001/* 002 * This file is generated by jOOQ. 003 */ 004package com.echothree.model.jooq.server.tables.tax; 005 006 007import com.echothree.model.data.core.common.pk.MimeTypePK; 008import com.echothree.model.data.party.common.pk.LanguagePK; 009import com.echothree.model.data.tax.common.pk.TaxClassificationPK; 010import com.echothree.model.data.tax.common.pk.TaxClassificationTranslationPK; 011import com.echothree.model.jooq.server.KeyRegistry; 012import com.echothree.model.jooq.server.tables.core.MimeTypes.MimeTypesPath; 013import com.echothree.model.jooq.server.tables.party.Languages.LanguagesPath; 014import com.echothree.model.jooq.server.tables.tax.TaxClassifications.TaxClassificationsPath; 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 TaxClassificationTranslations extends TableImpl<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations> { 045 046 private static final long serialVersionUID = 1L; 047 048 /** 049 * The reference instance of <code>taxclassificationtranslations</code> 050 */ 051 public static final TaxClassificationTranslations TaxClassificationTranslations = new TaxClassificationTranslations(); 052 053 /** 054 * The class holding records for this type 055 */ 056 @Override 057 public Class<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations> getRecordType() { 058 return com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations.class; 059 } 060 061 /** 062 * The column 063 * <code>taxclassificationtranslations.txclsfntr_taxclassificationtranslationid</code>. 064 */ 065 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations, TaxClassificationTranslationPK> TAX_CLASSIFICATION_TRANSLATION = createField(DSL.name("txclsfntr_taxclassificationtranslationid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, TaxClassificationTranslationPK.class, id -> new com.echothree.model.data.tax.common.pk.TaxClassificationTranslationPK(id), primaryKey -> primaryKey.getEntityId())); 066 067 /** 068 * The column 069 * <code>taxclassificationtranslations.txclsfntr_txclsfn_taxclassificationid</code>. 070 */ 071 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations, TaxClassificationPK> TAX_CLASSIFICATION = createField(DSL.name("txclsfntr_txclsfn_taxclassificationid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, TaxClassificationPK.class, id -> new com.echothree.model.data.tax.common.pk.TaxClassificationPK(id), primaryKey -> primaryKey.getEntityId())); 072 073 /** 074 * The column 075 * <code>taxclassificationtranslations.txclsfntr_lang_languageid</code>. 076 */ 077 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations, LanguagePK> LANGUAGE = createField(DSL.name("txclsfntr_lang_languageid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, LanguagePK.class, id -> new com.echothree.model.data.party.common.pk.LanguagePK(id), primaryKey -> primaryKey.getEntityId())); 078 079 /** 080 * The column 081 * <code>taxclassificationtranslations.txclsfntr_description</code>. 082 */ 083 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations, String> DESCRIPTION = createField(DSL.name("txclsfntr_description"), SQLDataType.VARCHAR(132).nullable(false), this, ""); 084 085 /** 086 * The column 087 * <code>taxclassificationtranslations.txclsfntr_overviewmimetypeid</code>. 088 */ 089 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations, MimeTypePK> OVERVIEW_MIME_TYPE = createField(DSL.name("txclsfntr_overviewmimetypeid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, MimeTypePK.class, id -> new com.echothree.model.data.core.common.pk.MimeTypePK(id), primaryKey -> primaryKey.getEntityId())); 090 091 /** 092 * The column <code>taxclassificationtranslations.txclsfntr_overview</code>. 093 */ 094 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations, String> OVERVIEW = createField(DSL.name("txclsfntr_overview"), SQLDataType.CLOB, this, ""); 095 096 /** 097 * The column <code>taxclassificationtranslations.txclsfntr_fromtime</code>. 098 */ 099 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations, Long> FROM_TIME = createField(DSL.name("txclsfntr_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 100 101 /** 102 * The column <code>taxclassificationtranslations.txclsfntr_thrutime</code>. 103 */ 104 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations, Long> THRU_TIME = createField(DSL.name("txclsfntr_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 105 106 private TaxClassificationTranslations(Name alias, Table<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations> aliased) { 107 this(alias, aliased, (Field<?>[]) null, null); 108 } 109 110 private TaxClassificationTranslations(Name alias, Table<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations> aliased, Field<?>[] parameters, Condition where) { 111 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 112 } 113 114 /** 115 * Create an aliased <code>taxclassificationtranslations</code> table 116 * reference 117 */ 118 public TaxClassificationTranslations(String alias) { 119 this(DSL.name(alias), TaxClassificationTranslations); 120 } 121 122 /** 123 * Create an aliased <code>taxclassificationtranslations</code> table 124 * reference 125 */ 126 public TaxClassificationTranslations(Name alias) { 127 this(alias, TaxClassificationTranslations); 128 } 129 130 /** 131 * Create a <code>taxclassificationtranslations</code> table reference 132 */ 133 public TaxClassificationTranslations() { 134 this(DSL.name("taxclassificationtranslations"), null); 135 } 136 137 @Override 138 public UniqueKey<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations> getPrimaryKey() { 139 return KeyRegistry.TAX_CLASSIFICATION_TRANSLATIONS_PK; 140 } 141 142 @Override 143 public List<UniqueKey<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations>> getUniqueKeys() { 144 return Arrays.asList(KeyRegistry.TAX_CLASSIFICATION_TRANSLATIONS_TAX_CLASSIFICATION_AND_LANGUAGE_AND_THRU_TIME_UK); 145 } 146 147 @Override 148 public List<ForeignKey<com.echothree.model.jooq.server.records.tax.TaxClassificationTranslations, ?>> getReferences() { 149 return Arrays.asList(KeyRegistry.TAX_CLASSIFICATION_TRANSLATIONS_LANGUAGE_FK, KeyRegistry.TAX_CLASSIFICATION_TRANSLATIONS_OVERVIEW_MIME_TYPE_FK, KeyRegistry.TAX_CLASSIFICATION_TRANSLATIONS_TAX_CLASSIFICATION_FK); 150 } 151 152 private transient LanguagesPath _txclsfntr_lang_languageid_fk; 153 154 /** 155 * Get the implicit join path to the <code>languages</code> table. 156 */ 157 public LanguagesPath txclsfntr_lang_languageid_fk() { 158 if (_txclsfntr_lang_languageid_fk == null) 159 _txclsfntr_lang_languageid_fk = new LanguagesPath(this, KeyRegistry.TAX_CLASSIFICATION_TRANSLATIONS_LANGUAGE_FK, null); 160 161 return _txclsfntr_lang_languageid_fk; 162 } 163 164 private transient MimeTypesPath _txclsfntr_overviewmimetypeid_fk; 165 166 /** 167 * Get the implicit join path to the <code>mimetypes</code> table. 168 */ 169 public MimeTypesPath txclsfntr_overviewmimetypeid_fk() { 170 if (_txclsfntr_overviewmimetypeid_fk == null) 171 _txclsfntr_overviewmimetypeid_fk = new MimeTypesPath(this, KeyRegistry.TAX_CLASSIFICATION_TRANSLATIONS_OVERVIEW_MIME_TYPE_FK, null); 172 173 return _txclsfntr_overviewmimetypeid_fk; 174 } 175 176 private transient TaxClassificationsPath _txclsfntr_txclsfn_taxclassificationid_fk; 177 178 /** 179 * Get the implicit join path to the <code>taxclassifications</code> table. 180 */ 181 public TaxClassificationsPath txclsfntr_txclsfn_taxclassificationid_fk() { 182 if (_txclsfntr_txclsfn_taxclassificationid_fk == null) 183 _txclsfntr_txclsfn_taxclassificationid_fk = new TaxClassificationsPath(this, KeyRegistry.TAX_CLASSIFICATION_TRANSLATIONS_TAX_CLASSIFICATION_FK, null); 184 185 return _txclsfntr_txclsfn_taxclassificationid_fk; 186 } 187 188 @Override 189 public TaxClassificationTranslations as(String alias) { 190 return new TaxClassificationTranslations(DSL.name(alias), this); 191 } 192 193 @Override 194 public TaxClassificationTranslations as(Name alias) { 195 return new TaxClassificationTranslations(alias, this); 196 } 197 198 @Override 199 public TaxClassificationTranslations as(Table<?> alias) { 200 return new TaxClassificationTranslations(alias.getQualifiedName(), this); 201 } 202 203 /** 204 * Rename this table 205 */ 206 @Override 207 public TaxClassificationTranslations rename(String name) { 208 return new TaxClassificationTranslations(DSL.name(name), null); 209 } 210 211 /** 212 * Rename this table 213 */ 214 @Override 215 public TaxClassificationTranslations rename(Name name) { 216 return new TaxClassificationTranslations(name, null); 217 } 218 219 /** 220 * Rename this table 221 */ 222 @Override 223 public TaxClassificationTranslations rename(Table<?> name) { 224 return new TaxClassificationTranslations(name.getQualifiedName(), null); 225 } 226 227 /** 228 * Create an inline derived table from this table 229 */ 230 @Override 231 public TaxClassificationTranslations where(Condition condition) { 232 return new TaxClassificationTranslations(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 233 } 234 235 /** 236 * Create an inline derived table from this table 237 */ 238 @Override 239 public TaxClassificationTranslations where(Collection<? extends Condition> conditions) { 240 return where(DSL.and(conditions)); 241 } 242 243 /** 244 * Create an inline derived table from this table 245 */ 246 @Override 247 public TaxClassificationTranslations where(Condition... conditions) { 248 return where(DSL.and(conditions)); 249 } 250 251 /** 252 * Create an inline derived table from this table 253 */ 254 @Override 255 public TaxClassificationTranslations where(Field<Boolean> condition) { 256 return where(DSL.condition(condition)); 257 } 258 259 /** 260 * Create an inline derived table from this table 261 */ 262 @Override 263 @PlainSQL 264 public TaxClassificationTranslations where(SQL condition) { 265 return where(DSL.condition(condition)); 266 } 267 268 /** 269 * Create an inline derived table from this table 270 */ 271 @Override 272 @PlainSQL 273 public TaxClassificationTranslations where(@Stringly.SQL String condition) { 274 return where(DSL.condition(condition)); 275 } 276 277 /** 278 * Create an inline derived table from this table 279 */ 280 @Override 281 @PlainSQL 282 public TaxClassificationTranslations where(@Stringly.SQL String condition, Object... binds) { 283 return where(DSL.condition(condition, binds)); 284 } 285 286 /** 287 * Create an inline derived table from this table 288 */ 289 @Override 290 @PlainSQL 291 public TaxClassificationTranslations where(@Stringly.SQL String condition, QueryPart... parts) { 292 return where(DSL.condition(condition, parts)); 293 } 294 295 /** 296 * Create an inline derived table from this table 297 */ 298 @Override 299 public TaxClassificationTranslations whereExists(TableLike<?> select) { 300 return where(DSL.exists(select)); 301 } 302 303 /** 304 * Create an inline derived table from this table 305 */ 306 @Override 307 public TaxClassificationTranslations whereNotExists(TableLike<?> select) { 308 return where(DSL.notExists(select)); 309 } 310}