Website

362055 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
new_newwebsiteId uuid 2147483647 √ null
CreatedOn timestamp 26,3 √ null
CreatedBy uuid 2147483647 √ null
statecode int4 10 0
statuscode int4 10 √ null
WebsiteStatus.id Website_statuscode_fkeyR
new_AccessCheck timestamp 26,3 √ null
new_AccessCheckFailCounter numeric 25,10 √ null
new_AccessNotes text 2147483647 √ null
new_AdminPassword varchar 100 √ null
new_adminuser varchar 100 √ null
new_baseurl varchar 1000 √ null
new_BlogProbability int4 10 √ null
WebsiteBlogProbability.id Website_new_BlogProbability_fkeyR
new_ContentIndicator int4 10 √ null
WebsiteContentIndicator.id Website_new_ContentIndicator_fkeyR
new_DoFollowLinks bool 1 √ null
new_DomainRatingMOZ float8 17,17 √ null
new_DropRate float8 17,17 √ null
new_dtoxrisk int4 10 √ null
WebsiteDToxRisk.id Website_new_dtoxrisk_fkeyR
new_GoogleIndexedPages int4 10 √ null
new_language uuid 2147483647 √ null
new_LastSeoCheck timestamp 26,3 √ null
new_LastUptimeCheck timestamp 26,3 √ null
new_MaxPosts int4 10 √ null
new_MozDomainAuthority numeric 25,10 √ null
new_name varchar 2147483647 √ null
new_OfflineSince timestamp 26,3 √ null
new_Powerdomain float8 17,17 √ null
new_SubDomain bool 1 √ null
new_TitleHome varchar 1000 √ null
new_trustdom int4 10 √ null
new_UptimeStatus int4 10 √ null
WebsiteUptimeStatus.id Website_new_UptimeStatus_fkeyR
new_WebsiteContactOwner uuid 2147483647 √ null
new_WebsiteIP varchar 15 √ null
createdby_id int4 10 √ null
SystemUserBase.id Website_createdby_id_fkeyR
language_id int4 10 √ null
new_languagesBase.id Website_language_id_fkeyR
website_owner_id int4 10 √ null
ContactBase.id Website_website_owner_id_fkeyR
id serial 10 √ nextval('v1."Website_id_seq"'::regclass)
ContentTypes.website_id ContentTypes_website_id_fkeyR
Offer.website_id Offer_website_id_fkeyR
Page.website_id Page_website_id_fkeyR
Posts.website_id Posts_website_id_fkeyR
Project.website_id Project_website_id_fkeyR
WebsitesToTopics.website_id WebsitesToTopics_website_id_fkeyN
new_Platform text 2147483647 √ null
new_TotalTrafficAHREFS int4 10 √ null
new_power int4 10 √ null
platform_id int4 10 √ null
Website_Platform.id Website_platform_id_fkeyR
website_topic_id int4 10 √ null
WebsiteTopics.id Website_website_topic_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
Website_pkey Primary key Asc id
Website_id_key Must be unique Asc id
website_name_index Performance Asc new_name
website_statecode_index Performance Asc statecode

Relationships

Close relationships within degrees of separation