Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| new_lpmprojectId | uuid | 2147483647 | √ | null |
|
|
||||
| CreatedOn | timestamp | 26,3 | √ | null |
|
|
||||
| OwnerId | uuid | 2147483647 | √ | null |
|
|
||||
| statecode | int4 | 10 | 0 |
|
|
|||||
| statuscode | int4 | 10 | √ | null |
|
|
||||
| new_Description | text | 2147483647 | √ | null |
|
|
||||
| new_DoShellyWebsitePlacements | bool | 1 | √ | null |
|
|
||||
| new_LastContentOrder | timestamp | 26,3 | √ | null |
|
|
||||
| new_PostLength | int4 | 10 | √ | null |
|
|
||||
| new_ContentTemplate | int4 | 10 | √ | null |
|
|
||||
| new_High | int4 | 10 | √ | null |
|
|
||||
| new_Medium | int4 | 10 | √ | null |
|
|
||||
| new_Low | int4 | 10 | √ | null |
|
|
||||
| new_MainPhrase | int4 | 10 | √ | null |
|
|
||||
| new_Normal | int4 | 10 | √ | null |
|
|
||||
| new_Brand | int4 | 10 | √ | null |
|
|
||||
| new_UrlAnchors | int4 | 10 | √ | null |
|
|
||||
| new_GeneralVariationNoise | int4 | 10 | √ | null |
|
|
||||
| new_Compound | int4 | 10 | √ | null |
|
|
||||
| new_ShellyRandom | bool | 1 | √ | null |
|
|
||||
| new_Latest10Articles | int4 | 10 | √ | null |
|
|
||||
| new_IncludeAnchorTexts | bool | 1 | √ | null |
|
|
||||
| new_Tear | int4 | 10 | √ | null |
|
|
||||
| new_PostsindexedinGoogle | int4 | 10 | √ | null |
|
|
||||
| new_Month | int4 | 10 | √ | null |
|
|
||||
| new_Year | int4 | 10 | √ | null |
|
|
||||
| new_StatusChanged | timestamp | 26,3 | √ | null |
|
|
||||
| new_FollowUp | timestamp | 26,3 | √ | null |
|
|
||||
| new_includetargeturl | bool | 1 | √ | null |
|
|
||||
| new_MonthlyTarget | int4 | 10 | √ | 0 |
|
|
||||
| new_Priority | int4 | 10 | √ | null |
|
|
||||
| new_name | varchar | 100 | √ | null |
|
|
||||
| new_ProjectTopic | uuid | 2147483647 | √ | null |
|
|
||||
| new_ContactOwner | uuid | 2147483647 | √ | null |
|
|
||||
| new_ParticipatingContact1 | uuid | 2147483647 | √ | null |
|
|
||||
| new_ParticipatingContact2 | uuid | 2147483647 | √ | null |
|
|
||||
| new_defaultcontenttype | uuid | 2147483647 | √ | null |
|
|
||||
| new_MinWordsperpost | int4 | 10 | √ | null |
|
|
||||
| new_InstructionsForContentWriters | text | 2147483647 | √ | null |
|
|
||||
| new_PictureLink | int4 | 10 | √ | null |
|
|
||||
| new_AllowWriterToAddPosts | bool | 1 | √ | null |
|
|
||||
| new_PotentialWebsites | int4 | 10 | √ | null |
|
|
||||
| new_WriterUploadToSite | bool | 1 | √ | null |
|
|
||||
| new_UploadCost | int4 | 10 | √ | null |
|
|
||||
| id | serial | 10 | √ | nextval('v1."Campaign_id_seq"'::regclass) |
|
|
||||
| project_id | int4 | 10 | √ | 799 |
|
|
||||
| owner_id | int4 | 10 | √ | null |
|
|
||||
| createdby_id | int4 | 10 | √ | null |
|
|
||||
| strategy_id | int4 | 10 | √ | null |
|
|
||||
| language_id | int4 | 10 | √ | null |
|
|
||||
| contenttype_id | int4 | 10 | √ | null |
|
|
||||
| uploader_id | int4 | 10 | √ | null |
|
|
||||
| approver_id | int4 | 10 | √ | null |
|
|
||||
| writer_id | int4 | 10 | √ | null |
|
|
||||
| currency_id | int4 | 10 | √ | null |
|
|
||||
| content_cost | float8 | 17,17 | √ | '0'::double precision |
|
|
||||
| allow_upload_content_portal | bool | 1 | false |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| Campaign_pkey | Primary key | Asc | id |
| camp_name_index | Performance | Asc | new_name |
| camp_project_index | Performance | Asc | project_id |
| camp_statecode_index | Performance | Asc | statecode |
| Campaign_id_key | Must be unique | Asc | id |
Relationships
Close relationships within degrees of separation
