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