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