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