invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SolutionFolderArticleAttachments: Freshdesk

read only

  • Catalogus: Freshdesk
  • Schema: Views

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel SolutionFolderArticleAttachments worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
scr_created_at datetime Aangemaakt op Date/time at which the record was created.
scr_description varchar2 Description
scr_id int64 ID
scr_name varchar2 Name
scr_updated_at datetime Bijgewerkt op Date/time at which the record was last updated.
scr_visibility int64 Visibility
scy_created_at datetime Aangemaakt op Date/time at which the record was created.
scy_description varchar2 Description Description.
scy_id int64 ID Unique ID of the solution category.
scy_is_default char Is Standaard Whether the category is a default category.
scy_name varchar2 Name Name of the solution category.
scy_position int64 Position Rank of the solution category in the category listing.
scy_updated_at datetime Bijgewerkt op Date/time at which the record was last updated.
sfe_agent_id int64 Agent ID
sfe_art_type int64 Typesoort Type of the article.Zie SolutionArticleTypes.
sfe_category_id int64 Categorie ID
sfe_created_at datetime Aangemaakt op Date/time at which the record was created.
sfe_description varchar2 Description Description.
sfe_description_text varchar2 Description
sfe_folder_id int64 Map ID ID of the folder under which the article is listed.
sfe_hits int64 Hits
sfe_id int64 ID Unique ID of the solution article.
sfe_position int64 Position The rank of the solution article in the article listing.
sfe_seo_data_meta_description varchar2 SEO Omschrijving
sfe_seo_data_meta_keywords varchar2 SEO Trefwoorden
sfe_seo_data_meta_title varchar2 SEO Titel
sfe_status int64 Status Status of the article.Zie SolutionArticleStatuses.
sfe_thumbs_down int64 Duimen Omlaag Number of down votes for the solution article.
sfe_thumbs_up int64 Duimen Omhoog Number of upvotes for the solution article.
sfe_title varchar2 Title Title of the solution article.
sfe_type int64 Type
sfe_updated_at datetime Bijgewerkt op Date/time at which the record was last updated.
sfe_user_id int64 Gebruikers-ID ID of the user who created the solution article.
sft_agent_id int64 Agent ID
sft_attachments_attachment_url varchar2 Bijlagen URL
sft_attachments_content_type varchar2 Bijlage Inhoudstype
sft_attachments_created_at datetime Bijlagen Aangemaakt op
sft_attachments_id int64 Bijlagen ID
sft_attachments_name varchar2 Bijlagen Naam
sft_attachments_size int64 Bijlagen Omvang
sft_attachments_updated_at datetime Bijlagen bijgewerkt om
sft_category_id int64 Categorie ID
sft_created_at datetime Aangemaakt op Date/time at which the record was created.
sft_description varchar2 Description
sft_description_text varchar2 Description
sft_folder_id int64 Map ID
sft_hits int64 Hits
sft_id int64 ID
sft_seo_data_meta_description varchar2 SEO Omschrijving
sft_seo_data_meta_keywords varchar2 SEO Trefwoorden
sft_seo_data_meta_title varchar2 SEO Titel
sft_status int64 Status
sft_title varchar2 Title
sft_tumbs_down int64 Duimen Omlaag
sft_tumbs_up int64 Duimen Omhoog
sft_type int64 Type
sft_updated_at datetime Bijgewerkt op Date/time at which the record was last updated.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: