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