001/* 002 * This file is generated by jOOQ. 003 */ 004package com.echothree.model.jooq.server.tables.chain; 005 006 007import com.echothree.model.data.chain.common.pk.ChainKindDetailPK; 008import com.echothree.model.data.chain.common.pk.ChainKindPK; 009import com.echothree.model.jooq.server.KeyRegistry; 010import com.echothree.model.jooq.server.tables.chain.ChainKinds.ChainKindsPath; 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 ChainKindDetails extends TableImpl<com.echothree.model.jooq.server.records.chain.ChainKindDetails> { 044 045 private static final long serialVersionUID = 1L; 046 047 /** 048 * The reference instance of <code>chainkinddetails</code> 049 */ 050 public static final ChainKindDetails ChainKindDetails = new ChainKindDetails(); 051 052 /** 053 * The class holding records for this type 054 */ 055 @Override 056 public Class<com.echothree.model.jooq.server.records.chain.ChainKindDetails> getRecordType() { 057 return com.echothree.model.jooq.server.records.chain.ChainKindDetails.class; 058 } 059 060 /** 061 * The column <code>chainkinddetails.chnkdt_chainkinddetailid</code>. 062 */ 063 public final TableField<com.echothree.model.jooq.server.records.chain.ChainKindDetails, ChainKindDetailPK> CHAIN_KIND_DETAIL = createField(DSL.name("chnkdt_chainkinddetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ChainKindDetailPK.class, id -> new com.echothree.model.data.chain.common.pk.ChainKindDetailPK(id), primaryKey -> primaryKey.getEntityId())); 064 065 /** 066 * The column <code>chainkinddetails.chnkdt_chnk_chainkindid</code>. 067 */ 068 public final TableField<com.echothree.model.jooq.server.records.chain.ChainKindDetails, ChainKindPK> CHAIN_KIND = createField(DSL.name("chnkdt_chnk_chainkindid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ChainKindPK.class, id -> new com.echothree.model.data.chain.common.pk.ChainKindPK(id), primaryKey -> primaryKey.getEntityId())); 069 070 /** 071 * The column <code>chainkinddetails.chnkdt_chainkindname</code>. 072 */ 073 public final TableField<com.echothree.model.jooq.server.records.chain.ChainKindDetails, String> CHAIN_KIND_NAME = createField(DSL.name("chnkdt_chainkindname"), SQLDataType.VARCHAR(40).nullable(false), this, ""); 074 075 /** 076 * The column <code>chainkinddetails.chnkdt_isdefault</code>. 077 */ 078 public final TableField<com.echothree.model.jooq.server.records.chain.ChainKindDetails, Boolean> IS_DEFAULT = createField(DSL.name("chnkdt_isdefault"), SQLDataType.BIT.nullable(false), this, ""); 079 080 /** 081 * The column <code>chainkinddetails.chnkdt_sortorder</code>. 082 */ 083 public final TableField<com.echothree.model.jooq.server.records.chain.ChainKindDetails, Integer> SORT_ORDER = createField(DSL.name("chnkdt_sortorder"), SQLDataType.INTEGER.nullable(false), this, ""); 084 085 /** 086 * The column <code>chainkinddetails.chnkdt_fromtime</code>. 087 */ 088 public final TableField<com.echothree.model.jooq.server.records.chain.ChainKindDetails, Long> FROM_TIME = createField(DSL.name("chnkdt_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 089 090 /** 091 * The column <code>chainkinddetails.chnkdt_thrutime</code>. 092 */ 093 public final TableField<com.echothree.model.jooq.server.records.chain.ChainKindDetails, Long> THRU_TIME = createField(DSL.name("chnkdt_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 094 095 private ChainKindDetails(Name alias, Table<com.echothree.model.jooq.server.records.chain.ChainKindDetails> aliased) { 096 this(alias, aliased, (Field<?>[]) null, null); 097 } 098 099 private ChainKindDetails(Name alias, Table<com.echothree.model.jooq.server.records.chain.ChainKindDetails> aliased, Field<?>[] parameters, Condition where) { 100 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 101 } 102 103 /** 104 * Create an aliased <code>chainkinddetails</code> table reference 105 */ 106 public ChainKindDetails(String alias) { 107 this(DSL.name(alias), ChainKindDetails); 108 } 109 110 /** 111 * Create an aliased <code>chainkinddetails</code> table reference 112 */ 113 public ChainKindDetails(Name alias) { 114 this(alias, ChainKindDetails); 115 } 116 117 /** 118 * Create a <code>chainkinddetails</code> table reference 119 */ 120 public ChainKindDetails() { 121 this(DSL.name("chainkinddetails"), null); 122 } 123 124 public <O extends Record> ChainKindDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.chain.ChainKindDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.chain.ChainKindDetails> parentPath) { 125 super(path, childPath, parentPath, ChainKindDetails); 126 } 127 128 /** 129 * A subtype implementing {@link Path} for simplified path-based joins. 130 */ 131 public static class ChainKindDetailsPath extends ChainKindDetails implements Path<com.echothree.model.jooq.server.records.chain.ChainKindDetails> { 132 133 private static final long serialVersionUID = 1L; 134 public <O extends Record> ChainKindDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.chain.ChainKindDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.chain.ChainKindDetails> parentPath) { 135 super(path, childPath, parentPath); 136 } 137 private ChainKindDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.chain.ChainKindDetails> aliased) { 138 super(alias, aliased); 139 } 140 141 @Override 142 public ChainKindDetailsPath as(String alias) { 143 return new ChainKindDetailsPath(DSL.name(alias), this); 144 } 145 146 @Override 147 public ChainKindDetailsPath as(Name alias) { 148 return new ChainKindDetailsPath(alias, this); 149 } 150 151 @Override 152 public ChainKindDetailsPath as(Table<?> alias) { 153 return new ChainKindDetailsPath(alias.getQualifiedName(), this); 154 } 155 } 156 157 @Override 158 public UniqueKey<com.echothree.model.jooq.server.records.chain.ChainKindDetails> getPrimaryKey() { 159 return KeyRegistry.CHAIN_KIND_DETAILS_PK; 160 } 161 162 @Override 163 public List<UniqueKey<com.echothree.model.jooq.server.records.chain.ChainKindDetails>> getUniqueKeys() { 164 return Arrays.asList(KeyRegistry.CHAIN_KIND_DETAILS_CHAIN_KIND_AND_THRU_TIME_UK, KeyRegistry.CHAIN_KIND_DETAILS_CHAIN_KIND_NAME_AND_THRU_TIME_UK); 165 } 166 167 @Override 168 public List<ForeignKey<com.echothree.model.jooq.server.records.chain.ChainKindDetails, ?>> getReferences() { 169 return Arrays.asList(KeyRegistry.CHAIN_KIND_DETAILS_CHAIN_KIND_FK); 170 } 171 172 private transient ChainKindsPath _chnkdt_chnk_chainkindid_fk; 173 174 /** 175 * Get the implicit join path to the <code>chainkinds</code> table. 176 */ 177 public ChainKindsPath chnkdt_chnk_chainkindid_fk() { 178 if (_chnkdt_chnk_chainkindid_fk == null) 179 _chnkdt_chnk_chainkindid_fk = new ChainKindsPath(this, KeyRegistry.CHAIN_KIND_DETAILS_CHAIN_KIND_FK, null); 180 181 return _chnkdt_chnk_chainkindid_fk; 182 } 183 184 @Override 185 public ChainKindDetails as(String alias) { 186 return new ChainKindDetails(DSL.name(alias), this); 187 } 188 189 @Override 190 public ChainKindDetails as(Name alias) { 191 return new ChainKindDetails(alias, this); 192 } 193 194 @Override 195 public ChainKindDetails as(Table<?> alias) { 196 return new ChainKindDetails(alias.getQualifiedName(), this); 197 } 198 199 /** 200 * Rename this table 201 */ 202 @Override 203 public ChainKindDetails rename(String name) { 204 return new ChainKindDetails(DSL.name(name), null); 205 } 206 207 /** 208 * Rename this table 209 */ 210 @Override 211 public ChainKindDetails rename(Name name) { 212 return new ChainKindDetails(name, null); 213 } 214 215 /** 216 * Rename this table 217 */ 218 @Override 219 public ChainKindDetails rename(Table<?> name) { 220 return new ChainKindDetails(name.getQualifiedName(), null); 221 } 222 223 /** 224 * Create an inline derived table from this table 225 */ 226 @Override 227 public ChainKindDetails where(Condition condition) { 228 return new ChainKindDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 229 } 230 231 /** 232 * Create an inline derived table from this table 233 */ 234 @Override 235 public ChainKindDetails where(Collection<? extends Condition> conditions) { 236 return where(DSL.and(conditions)); 237 } 238 239 /** 240 * Create an inline derived table from this table 241 */ 242 @Override 243 public ChainKindDetails where(Condition... conditions) { 244 return where(DSL.and(conditions)); 245 } 246 247 /** 248 * Create an inline derived table from this table 249 */ 250 @Override 251 public ChainKindDetails where(Field<Boolean> condition) { 252 return where(DSL.condition(condition)); 253 } 254 255 /** 256 * Create an inline derived table from this table 257 */ 258 @Override 259 @PlainSQL 260 public ChainKindDetails where(SQL 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 ChainKindDetails where(@Stringly.SQL String 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 ChainKindDetails where(@Stringly.SQL String condition, Object... binds) { 279 return where(DSL.condition(condition, binds)); 280 } 281 282 /** 283 * Create an inline derived table from this table 284 */ 285 @Override 286 @PlainSQL 287 public ChainKindDetails where(@Stringly.SQL String condition, QueryPart... parts) { 288 return where(DSL.condition(condition, parts)); 289 } 290 291 /** 292 * Create an inline derived table from this table 293 */ 294 @Override 295 public ChainKindDetails whereExists(TableLike<?> select) { 296 return where(DSL.exists(select)); 297 } 298 299 /** 300 * Create an inline derived table from this table 301 */ 302 @Override 303 public ChainKindDetails whereNotExists(TableLike<?> select) { 304 return where(DSL.notExists(select)); 305 } 306}