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