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