001/* 002 * This file is generated by jOOQ. 003 */ 004package com.echothree.model.jooq.server.tables.offer; 005 006 007import com.echothree.model.data.offer.common.pk.OfferNameElementDetailPK; 008import com.echothree.model.data.offer.common.pk.OfferNameElementPK; 009import com.echothree.model.jooq.server.KeyRegistry; 010import com.echothree.model.jooq.server.tables.offer.OfferNameElements.OfferNameElementsPath; 011 012import java.util.Arrays; 013import java.util.Collection; 014import java.util.List; 015 016import org.jooq.Condition; 017import org.jooq.Converter; 018import org.jooq.Field; 019import org.jooq.ForeignKey; 020import org.jooq.InverseForeignKey; 021import org.jooq.Name; 022import org.jooq.Path; 023import org.jooq.PlainSQL; 024import org.jooq.QueryPart; 025import org.jooq.Record; 026import org.jooq.SQL; 027import org.jooq.Stringly; 028import org.jooq.Table; 029import org.jooq.TableField; 030import org.jooq.TableLike; 031import org.jooq.TableOptions; 032import org.jooq.UniqueKey; 033import org.jooq.impl.DSL; 034import org.jooq.impl.Internal; 035import org.jooq.impl.SQLDataType; 036import org.jooq.impl.TableImpl; 037 038 039/** 040 * This class is generated by jOOQ. 041 */ 042@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" }) 043public class OfferNameElementDetails extends TableImpl<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> { 044 045 private static final long serialVersionUID = 1L; 046 047 /** 048 * The reference instance of <code>offernameelementdetails</code> 049 */ 050 public static final OfferNameElementDetails OfferNameElementDetails = new OfferNameElementDetails(); 051 052 /** 053 * The class holding records for this type 054 */ 055 @Override 056 public Class<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> getRecordType() { 057 return com.echothree.model.jooq.server.records.offer.OfferNameElementDetails.class; 058 } 059 060 /** 061 * The column 062 * <code>offernameelementdetails.ofrnedt_offernameelementdetailid</code>. 063 */ 064 public final TableField<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails, OfferNameElementDetailPK> OFFER_NAME_ELEMENT_DETAIL = createField(DSL.name("ofrnedt_offernameelementdetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, OfferNameElementDetailPK.class, id -> new com.echothree.model.data.offer.common.pk.OfferNameElementDetailPK(id), primaryKey -> primaryKey.getEntityId())); 065 066 /** 067 * The column 068 * <code>offernameelementdetails.ofrnedt_ofrne_offernameelementid</code>. 069 */ 070 public final TableField<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails, OfferNameElementPK> OFFER_NAME_ELEMENT = createField(DSL.name("ofrnedt_ofrne_offernameelementid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, OfferNameElementPK.class, id -> new com.echothree.model.data.offer.common.pk.OfferNameElementPK(id), primaryKey -> primaryKey.getEntityId())); 071 072 /** 073 * The column 074 * <code>offernameelementdetails.ofrnedt_offernameelementname</code>. 075 */ 076 public final TableField<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails, String> OFFER_NAME_ELEMENT_NAME = createField(DSL.name("ofrnedt_offernameelementname"), SQLDataType.VARCHAR(40).nullable(false), this, ""); 077 078 /** 079 * The column <code>offernameelementdetails.ofrnedt_offset</code>. 080 */ 081 public final TableField<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails, Integer> OFFSET = createField(DSL.name("ofrnedt_offset"), SQLDataType.INTEGER.nullable(false), this, ""); 082 083 /** 084 * The column <code>offernameelementdetails.ofrnedt_length</code>. 085 */ 086 public final TableField<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails, Integer> LENGTH = createField(DSL.name("ofrnedt_length"), SQLDataType.INTEGER.nullable(false), this, ""); 087 088 /** 089 * The column 090 * <code>offernameelementdetails.ofrnedt_validationpattern</code>. 091 */ 092 public final TableField<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails, String> VALIDATION_PATTERN = createField(DSL.name("ofrnedt_validationpattern"), SQLDataType.VARCHAR(128), this, ""); 093 094 /** 095 * The column <code>offernameelementdetails.ofrnedt_fromtime</code>. 096 */ 097 public final TableField<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails, Long> FROM_TIME = createField(DSL.name("ofrnedt_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 098 099 /** 100 * The column <code>offernameelementdetails.ofrnedt_thrutime</code>. 101 */ 102 public final TableField<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails, Long> THRU_TIME = createField(DSL.name("ofrnedt_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 103 104 private OfferNameElementDetails(Name alias, Table<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> aliased) { 105 this(alias, aliased, (Field<?>[]) null, null); 106 } 107 108 private OfferNameElementDetails(Name alias, Table<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> aliased, Field<?>[] parameters, Condition where) { 109 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 110 } 111 112 /** 113 * Create an aliased <code>offernameelementdetails</code> table reference 114 */ 115 public OfferNameElementDetails(String alias) { 116 this(DSL.name(alias), OfferNameElementDetails); 117 } 118 119 /** 120 * Create an aliased <code>offernameelementdetails</code> table reference 121 */ 122 public OfferNameElementDetails(Name alias) { 123 this(alias, OfferNameElementDetails); 124 } 125 126 /** 127 * Create a <code>offernameelementdetails</code> table reference 128 */ 129 public OfferNameElementDetails() { 130 this(DSL.name("offernameelementdetails"), null); 131 } 132 133 public <O extends Record> OfferNameElementDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> parentPath) { 134 super(path, childPath, parentPath, OfferNameElementDetails); 135 } 136 137 /** 138 * A subtype implementing {@link Path} for simplified path-based joins. 139 */ 140 public static class OfferNameElementDetailsPath extends OfferNameElementDetails implements Path<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> { 141 142 private static final long serialVersionUID = 1L; 143 public <O extends Record> OfferNameElementDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> parentPath) { 144 super(path, childPath, parentPath); 145 } 146 private OfferNameElementDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> aliased) { 147 super(alias, aliased); 148 } 149 150 @Override 151 public OfferNameElementDetailsPath as(String alias) { 152 return new OfferNameElementDetailsPath(DSL.name(alias), this); 153 } 154 155 @Override 156 public OfferNameElementDetailsPath as(Name alias) { 157 return new OfferNameElementDetailsPath(alias, this); 158 } 159 160 @Override 161 public OfferNameElementDetailsPath as(Table<?> alias) { 162 return new OfferNameElementDetailsPath(alias.getQualifiedName(), this); 163 } 164 } 165 166 @Override 167 public UniqueKey<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails> getPrimaryKey() { 168 return KeyRegistry.OFFER_NAME_ELEMENT_DETAILS_PK; 169 } 170 171 @Override 172 public List<UniqueKey<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails>> getUniqueKeys() { 173 return Arrays.asList(KeyRegistry.OFFER_NAME_ELEMENT_DETAILS_OFFER_NAME_ELEMENT_AND_THRU_TIME_UK, KeyRegistry.OFFER_NAME_ELEMENT_DETAILS_OFFER_NAME_ELEMENT_NAME_AND_THRU_TIME_UK); 174 } 175 176 @Override 177 public List<ForeignKey<com.echothree.model.jooq.server.records.offer.OfferNameElementDetails, ?>> getReferences() { 178 return Arrays.asList(KeyRegistry.OFFER_NAME_ELEMENT_DETAILS_OFFER_NAME_ELEMENT_FK); 179 } 180 181 private transient OfferNameElementsPath _ofrnedt_ofrne_offernameelementid_fk; 182 183 /** 184 * Get the implicit join path to the <code>offernameelements</code> table. 185 */ 186 public OfferNameElementsPath ofrnedt_ofrne_offernameelementid_fk() { 187 if (_ofrnedt_ofrne_offernameelementid_fk == null) 188 _ofrnedt_ofrne_offernameelementid_fk = new OfferNameElementsPath(this, KeyRegistry.OFFER_NAME_ELEMENT_DETAILS_OFFER_NAME_ELEMENT_FK, null); 189 190 return _ofrnedt_ofrne_offernameelementid_fk; 191 } 192 193 @Override 194 public OfferNameElementDetails as(String alias) { 195 return new OfferNameElementDetails(DSL.name(alias), this); 196 } 197 198 @Override 199 public OfferNameElementDetails as(Name alias) { 200 return new OfferNameElementDetails(alias, this); 201 } 202 203 @Override 204 public OfferNameElementDetails as(Table<?> alias) { 205 return new OfferNameElementDetails(alias.getQualifiedName(), this); 206 } 207 208 /** 209 * Rename this table 210 */ 211 @Override 212 public OfferNameElementDetails rename(String name) { 213 return new OfferNameElementDetails(DSL.name(name), null); 214 } 215 216 /** 217 * Rename this table 218 */ 219 @Override 220 public OfferNameElementDetails rename(Name name) { 221 return new OfferNameElementDetails(name, null); 222 } 223 224 /** 225 * Rename this table 226 */ 227 @Override 228 public OfferNameElementDetails rename(Table<?> name) { 229 return new OfferNameElementDetails(name.getQualifiedName(), null); 230 } 231 232 /** 233 * Create an inline derived table from this table 234 */ 235 @Override 236 public OfferNameElementDetails where(Condition condition) { 237 return new OfferNameElementDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 238 } 239 240 /** 241 * Create an inline derived table from this table 242 */ 243 @Override 244 public OfferNameElementDetails where(Collection<? extends Condition> conditions) { 245 return where(DSL.and(conditions)); 246 } 247 248 /** 249 * Create an inline derived table from this table 250 */ 251 @Override 252 public OfferNameElementDetails where(Condition... conditions) { 253 return where(DSL.and(conditions)); 254 } 255 256 /** 257 * Create an inline derived table from this table 258 */ 259 @Override 260 public OfferNameElementDetails where(Field<Boolean> condition) { 261 return where(DSL.condition(condition)); 262 } 263 264 /** 265 * Create an inline derived table from this table 266 */ 267 @Override 268 @PlainSQL 269 public OfferNameElementDetails where(SQL condition) { 270 return where(DSL.condition(condition)); 271 } 272 273 /** 274 * Create an inline derived table from this table 275 */ 276 @Override 277 @PlainSQL 278 public OfferNameElementDetails where(@Stringly.SQL String condition) { 279 return where(DSL.condition(condition)); 280 } 281 282 /** 283 * Create an inline derived table from this table 284 */ 285 @Override 286 @PlainSQL 287 public OfferNameElementDetails where(@Stringly.SQL String condition, Object... binds) { 288 return where(DSL.condition(condition, binds)); 289 } 290 291 /** 292 * Create an inline derived table from this table 293 */ 294 @Override 295 @PlainSQL 296 public OfferNameElementDetails where(@Stringly.SQL String condition, QueryPart... parts) { 297 return where(DSL.condition(condition, parts)); 298 } 299 300 /** 301 * Create an inline derived table from this table 302 */ 303 @Override 304 public OfferNameElementDetails whereExists(TableLike<?> select) { 305 return where(DSL.exists(select)); 306 } 307 308 /** 309 * Create an inline derived table from this table 310 */ 311 @Override 312 public OfferNameElementDetails whereNotExists(TableLike<?> select) { 313 return where(DSL.notExists(select)); 314 } 315}