(c) 2017 SF Software-Beratung GmbH. All rights reserved.
28.06.2017 13:23:49
Role | SysAdmin Server Role allowed | Description |
Editors | False | Personen, die Daten ändern dürfen |
Reader | False | Personen, die Daten nur lesen dürfen |
FtdbWebsite | False | Das Rolle, unter der die ftdb-Website auf die Datenbank zugreift |
(Optimal layout found after 00:00:00.4225362 with cost 79.)
(Optimal layout found after 00:00:00.0344484 with cost 4,871.)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
Bezeichnung | False | StringField | Editable |
Bemerkungen | True | StringField | Editable |
QueryDefinition [Abfragedefinition] | False | AdHocAnalysisQueryDefinitionField | Editable |
IsPublic [für Andere sichtbar] | False | BooleanField | Editable |
CreationTime [angelegt am] | True | DateTimeField | VisibleReadOnly |
CreationUser [angelegt von] | True | SystemUserNameField | VisibleReadOnly |
LastUpdateTime [zuletzt geändert am] | True | DateTimeField | VisibleReadOnly |
LastUpdateUser [zuletzt geändert von] | True | SystemUserNameField | VisibleReadOnly |
(None)
Table | Field | IsNullable | Type | CascadeDeletes |
AdHocAnalysisQueryDefinitionRowChangeLog [Ad-hoc-Abfrage - Datensatzänderung] | AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
Bezeichnung | True |
|
|
(None)
(None)
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
AdHocAnalysisQueryDefinitionRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Artikel in dieser Tabelle sind unabhängig von den Farben in denen sie verfügbar sind.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
Caption [Bezeichnung] | False | StringField | Editable |
Category [Kategorie] | False | ReferenceField | Editable |
WeightInG [Gewicht in g] | True | FloatField | Editable |
Remarks [Bemerkungen] | True | StringField | Editable |
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementArticleAutoGeneratedSupplements |
RemarksAutoLength [Bemerkungen - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementArticleAutoGeneratedSupplements |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
Caption [Bezeichnung] | StringField | False |
| DATALENGTH([Caption]) >= 2 |
Category [Kategorie] | ReferenceField | False |
| |
WeightInG [Gewicht in g] | FloatField | True |
| ([WeightInG] IS NULL OR [WeightInG] BETWEEN 0 AND 99999) AND ([WeightInG] IS NULL OR [WeightInG] <> 0) |
Remarks [Bemerkungen] | StringField | True |
| [Remarks] IS NULL OR DATALENGTH([Remarks]) >= 2 |
Field | Table | IsNullable | Type | CascadeDeletes |
Category [Kategorie] | Category [Kategorie] | False | OneToMany | False |
Table | Field | IsNullable | Type | CascadeDeletes |
ArticleRowChangeLog [Artikel - Datensatzänderung] | Article [Artikel] | False | OneToMany | True |
ArticleVariant [Artikelvariante] | Article [Artikel] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
CategoryCaption | True |
|
|
CaptionCategory | True |
|
|
(None)
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementArticleAutoGeneratedSupplements |
RemarksAutoLength [Bemerkungen - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementArticleAutoGeneratedSupplements |
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Diese Tabelle beschreibt, ab wann einem Artikel welche Artikelnummer zugewiesen war.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
ArticleVariant [Artikelvariante] | False | ReferenceField | Editable |
FromYear [Ab Jahr] | True | YearField | Editable |
Number [Nummer (leer = nicht mehr produziert)] | True | StringField | Editable |
Field | IsNullable | FieldType | UserInterface | Supplement |
ValidUntil [Gültig bis] | True | YearField | (VisibleReadOnly) | SupplementArticleNumber |
NumberPreusedIn [Nummer vormals verwendet in] | True | ReferenceField | (VisibleReadOnly) | SupplementArticleNumber |
NumberReusedIn [Nummer wiederverwendet in] | True | ReferenceField | (VisibleReadOnly) | SupplementArticleNumber |
NumberAutoLength [Nummer (leer = nicht mehr produziert) - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementArticleNumberAutoGeneratedSupplements |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
ArticleVariant [Artikelvariante] | ReferenceField | False |
| |
FromYear [Ab Jahr] | YearField | True |
| [FromYear] IS NULL OR [FromYear] BETWEEN 1950 AND 2099 |
Number [Nummer (leer = nicht mehr produziert)] | StringField | True |
| [Number] IS NULL OR DATALENGTH([Number]) >= 2 |
Field | Table | IsNullable | Type | CascadeDeletes |
ArticleVariant [Artikelvariante] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
Table | Field | IsNullable | Type | CascadeDeletes |
ArticleNumberRowChangeLog [Artikelnummer - Datensatzänderung] | ArticleNumber [Artikelnummer] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
ArticleVariantFromYear | True |
| |
ArticleVariantFromYearNumber | True |
|
|
Number | False |
|
(None)
Type | Action | Persisted CHECK expression |
SFSoftwareberatung.ApplicationCreator.RowValidatorTypes.FieldsNotNullRowValidator | Abort | (FromYear IS NOT NULL) OR (Number IS NOT NULL) |
SFSoftwareberatung.ApplicationCreator.RowValidatorTypes.SimilarRowExistsRowValidator | Warn |
Field | IsNullable | FieldType | UserInterface | Supplement |
ValidUntil [Gültig bis] | True | YearField | (VisibleReadOnly) | SupplementArticleNumber |
NumberPreusedIn [Nummer vormals verwendet in] | True | ReferenceField | (VisibleReadOnly) | SupplementArticleNumber |
NumberReusedIn [Nummer wiederverwendet in] | True | ReferenceField | (VisibleReadOnly) | SupplementArticleNumber |
Name | Type | Settings | Persistable CHECK expression |
ValidUntil [Gültig bis] | YearField | [ValidUntil] IS NULL OR [ValidUntil] BETWEEN 1950 AND 2099 | |
NumberPreusedIn [Nummer vormals verwendet in] | ReferenceField | ||
NumberReusedIn [Nummer wiederverwendet in] | ReferenceField |
Field | IsNullable | FieldType | UserInterface | Supplement |
NumberAutoLength [Nummer (leer = nicht mehr produziert) - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementArticleNumberAutoGeneratedSupplements |
(None)
Field | IsNullable | Type | CHECK expression |
NumberPreusedIn [Nummer vormals verwendet in] | True | ReferenceField | |
NumberReusedIn [Nummer wiederverwendet in] | True | ReferenceField |
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
ArticleNumber [Artikelnummer] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
ArticleNumber [Artikelnummer] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
ArticleNumber [Artikelnummer] | ArticleNumber [Artikelnummer] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
ArticleNumberRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
Article [Artikel] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
Article [Artikel] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
Article [Artikel] | Article [Artikel] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
ArticleRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Diese Tabelle enthält für jeden Artikel und jede Farbe, in der er existiert(e), einen Datensatz.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
Article [Artikel] | False | ReferenceField | Editable |
Year [Jahr] | True | YearField | Editable |
Color [Farbe] | True | ReferenceField | Editable |
Language [Sprache] | True | ReferenceField | Editable |
Remarks [Bemerkungen] | True | StringField | Editable |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
Article [Artikel] | ReferenceField | False |
| |
Year [Jahr] | YearField | True |
| [Year] IS NULL OR [Year] BETWEEN 1960 AND 2099 |
Color [Farbe] | ReferenceField | True |
| |
Language [Sprache] | ReferenceField | True |
| |
Remarks [Bemerkungen] | StringField | True |
| [Remarks] IS NULL OR DATALENGTH([Remarks]) >= 2 |
Field | Table | IsNullable | Type | CascadeDeletes |
Article [Artikel] | Article [Artikel] | False | OneToMany | True |
Color [Farbe] | Color [Farbe] | True | OneToMany | False |
Language [Sprache] | Language [Sprache] | True | OneToMany | False |
Table | Field | IsNullable | Type | CascadeDeletes |
ArticleNumber [Artikelnummer] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
ArticleVariantRowChangeLog [Artikelvariante - Datensatzänderung] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
Document [Dokument] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
Image [Bild] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
PartsList [Stückliste] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
PartsList [Stückliste] | ContainedArticle [Enthaltener Artikel] | False | OneToMany | False |
Name | Unique | Fields | Usage |
ID | True |
| |
Color | False |
| |
Language | False |
| |
Year | False |
| |
ArticleYearColorLanguage | True |
|
|
(None)
(None)
Name | Type | Settings | Persistable CHECK expression |
ArticleVariantText [Variantenbeschreibung] | StringField | [ArticleVariantText] IS NULL OR DATALENGTH([ArticleVariantText]) >= 2 | |
SmallestImageId [Kleinstes Bild] | ReferenceField | ||
LargestImageId [Größtes Bild] | ReferenceField | ||
LargestImageIdUpTo360 [Größtes Bild bis 360 ∙ 360 Pixel] | ReferenceField | ||
OldestArticleNumberYear [Ältestes Artikelnummer-Jahr] | YearField | [OldestArticleNumberYear] IS NULL OR [OldestArticleNumberYear] BETWEEN 1950 AND 2099 | |
OldestArticleNumber [Älteste Artikelnummer] | StringField | [OldestArticleNumber] IS NULL OR DATALENGTH([OldestArticleNumber]) >= 2 | |
NewestArticleNumberYear [Jüngstes Artikelnummer-Jahr] | YearField | [NewestArticleNumberYear] IS NULL OR [NewestArticleNumberYear] BETWEEN 1950 AND 2099 | |
NewestArticleNumber [Jüngste Artikelnummer] | StringField | [NewestArticleNumber] IS NULL OR DATALENGTH([NewestArticleNumber]) >= 2 | |
LastProductionYear [Produziert bis] | YearField | [LastProductionYear] IS NULL OR [LastProductionYear] BETWEEN 1590 AND 2099 | |
DocumentCount [Dokumente] | IntegerField | [DocumentCount] IS NULL OR [DocumentCount] BETWEEN 0 AND 2147483647 | |
PartsListCount [Stücklisteneinträge] | IntegerField | [PartsListCount] IS NULL OR [PartsListCount] BETWEEN 0 AND 2147483647 | |
PartsCount [Enthaltene Teile] | IntegerField | [PartsCount] IS NULL OR [PartsCount] BETWEEN 0 AND 2147483647 | |
WebLink [Web-Link] | UriField | (DATALENGTH([WebLink]) >= 2) AND ([WebLink] LIKE N'_%://_%') |
Field | IsNullable | FieldType | UserInterface | Supplement |
ArticleNumberText [Alle Artikelnummern als Text] | True | StringField | (VisibleReadOnly) | SupplementArticleVariantArticleNumberText |
Field | IsNullable | FieldType | UserInterface | Supplement |
RemarksAutoLength [Bemerkungen - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementArticleVariantAutoGeneratedSupplements |
(None)
Field | IsNullable | Type | CHECK expression |
PartsCount [Enthaltene Teile] | True | IntegerField | PartsCount IS NULL OR PartsCount BETWEEN 0 AND 2147483647 |
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
ArticleVariant [Artikelvariante] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
ArticleVariant [Artikelvariante] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
ArticleVariant [Artikelvariante] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
ArticleVariantRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Quelle und Lizenz für Bilder und Dokumente.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
Caption [Bezeichnung] | False | StringField | Editable |
Remarks [Bemerkungen] | True | StringField | Editable |
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementAttachmentSourceAutoGeneratedSupplements |
RemarksAutoLength [Bemerkungen - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementAttachmentSourceAutoGeneratedSupplements |
(None)
Table | Field | IsNullable | Type | CascadeDeletes |
AttachmentSourceRowChangeLog [Dateianlagen-Quelle - Datensatzänderung] | AttachmentSource [Dateianlagen-Quelle] | False | OneToMany | True |
Document [Dokument] | AttachmentSource [Dateianlagen-Quelle] | False | OneToMany | False |
Image [Bild] | AttachmentSource [Dateianlagen-Quelle] | False | OneToMany | False |
Name | Unique | Fields | Usage |
ID | True |
| |
Caption | True |
|
|
(None)
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementAttachmentSourceAutoGeneratedSupplements |
RemarksAutoLength [Bemerkungen - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementAttachmentSourceAutoGeneratedSupplements |
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
AttachmentSource [Dateianlagen-Quelle] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
AttachmentSource [Dateianlagen-Quelle] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
AttachmentSource [Dateianlagen-Quelle] | AttachmentSource [Dateianlagen-Quelle] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
AttachmentSourceRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Die hierarchischen Kategorien lassen auch viele Artikel übersichtlich strukturiert darstellen.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
ParentCategory [Übergeordnete Kategorie] | True | ReferenceField | Editable |
Caption [Bezeichnung] | False | StringField | Editable |
CompleteCaption [Vollständige Bezeichnung] | False | StringField | VisibleReadOnly |
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementCategoryAutoGeneratedSupplements |
CompleteCaptionAutoLength [Vollständige Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementCategoryAutoGeneratedSupplements |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
ParentCategory [Übergeordnete Kategorie] | ReferenceField | True |
| |
Caption [Bezeichnung] | StringField | False |
| DATALENGTH([Caption]) >= 2 |
CompleteCaption [Vollständige Bezeichnung] | StringField | False |
| DATALENGTH([CompleteCaption]) >= 2 |
Field | Table | IsNullable | Type | CascadeDeletes |
ParentCategory [Übergeordnete Kategorie] | Category [Kategorie] | True | OneToMany | False |
Table | Field | IsNullable | Type | CascadeDeletes |
Article [Artikel] | Category [Kategorie] | False | OneToMany | False |
Category [Kategorie] | ParentCategory [Übergeordnete Kategorie] | True | OneToMany | False |
CategoryRowChangeLog [Kategorie - Datensatzänderung] | Category [Kategorie] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
CompleteCaption | True |
|
|
ParentCategoryCaption | True |
|
Type | Watched Field |
SFSoftwareberatung.SFParts.Definition.CategoryFiller | ParentCategory [Übergeordnete Kategorie] |
SFSoftwareberatung.SFParts.Definition.CategoryFiller | Caption [Bezeichnung] |
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementCategoryAutoGeneratedSupplements |
CompleteCaptionAutoLength [Vollständige Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementCategoryAutoGeneratedSupplements |
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
Category [Kategorie] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
Category [Kategorie] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
Category [Kategorie] | Category [Kategorie] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
CategoryRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Farben umfassen auch Farbvariationen und Schattierungen von Hauptfarben.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
MainColor [Hauptfarbe] | False | ReferenceField | Editable |
Caption [Bezeichnung] | False | StringField | Editable |
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementColorAutoGeneratedSupplements |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
MainColor [Hauptfarbe] | ReferenceField | False |
| |
Caption [Bezeichnung] | StringField | False |
| DATALENGTH([Caption]) >= 2 |
Field | Table | IsNullable | Type | CascadeDeletes |
MainColor [Hauptfarbe] | MainColor [Hauptfarbe] | False | OneToMany | False |
Table | Field | IsNullable | Type | CascadeDeletes |
ArticleVariant [Artikelvariante] | Color [Farbe] | True | OneToMany | False |
ColorRowChangeLog [Farbe - Datensatzänderung] | Color [Farbe] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
MainColorCaption | True |
|
|
(None)
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementColorAutoGeneratedSupplements |
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
Color [Farbe] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
Color [Farbe] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
Color [Farbe] | Color [Farbe] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
ColorRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
OptionKey | False | StringField | Editable |
UserName | False | StringField | Editable |
Data | True | StringField | Editable |
(None)
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
OptionKeyUserName | True |
|
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
Uniqueness | False | IntegerField | Editable |
DatabaseVersion | False | IntegerField | Editable |
(None)
(None)
Name | Unique | Fields | Usage |
ID | True |
|
|
Uniqueness | True |
|
|
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
Diese Tabelle kann je Artikelvariante mehrere Dokumente aufnehmen.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
ArticleVariant [Artikelvariante] | False | ReferenceField | Editable |
Description [Beschreibung] | False | StringField | Editable |
Attachment [Anlage] | False | FileAttachmentField | Editable |
OriginalFileName [Ursprünglicher Dateiname] | False | StringField | VisibleReadOnly |
AttachmentSource [Dateianlagen-Quelle] | False | ReferenceField | Editable |
DocumentType [Dokumenttyp] | False | ReferenceField | VisibleReadOnly |
Year [Jahr] | True | YearField | Editable |
Field | IsNullable | FieldType | UserInterface | Supplement |
WebLink [Web-Link] | False | UriField | (VisibleReadOnly) | SupplementDocument |
DescriptionAutoLength [Beschreibung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementDocumentAutoGeneratedSupplements |
AttachmentAutoDataLength [Anlage - Speicherplatz in Bytes] | False | LongIntegerField | (VisibleReadOnly) | SupplementDocumentAutoGeneratedSupplements |
OriginalFileNameAutoLength [Ursprünglicher Dateiname - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementDocumentAutoGeneratedSupplements |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
ArticleVariant [Artikelvariante] | ReferenceField | False |
| |
Description [Beschreibung] | StringField | False |
| DATALENGTH([Description]) >= 2 |
Attachment [Anlage] | FileAttachmentField | False |
| |
OriginalFileName [Ursprünglicher Dateiname] | StringField | False |
| DATALENGTH([OriginalFileName]) >= 2 |
AttachmentSource [Dateianlagen-Quelle] | ReferenceField | False |
| |
DocumentType [Dokumenttyp] | ReferenceField | False |
| |
Year [Jahr] | YearField | True |
| [Year] IS NULL OR [Year] BETWEEN 1950 AND 2099 |
Field | Table | IsNullable | Type | CascadeDeletes |
ArticleVariant [Artikelvariante] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
AttachmentSource [Dateianlagen-Quelle] | AttachmentSource [Dateianlagen-Quelle] | False | OneToMany | False |
DocumentType [Dokumenttyp] | DocumentType [Dokumenttyp] | False | OneToMany | False |
Table | Field | IsNullable | Type | CascadeDeletes |
DocumentRowChangeLog [Dokument - Datensatzänderung] | Document [Dokument] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
ArticleVariantDescription | True |
|
|
AttachmentSource | False |
| |
DocumentType | False |
|
Type | Watched Field |
SFSoftwareberatung.ApplicationCreator.FieldBasedBusinessRuleTypes.AttachmentSetsDescription | Attachment [Anlage] |
SFSoftwareberatung.SFParts.Definition.AttachmentSetsOriginalFileNameAndMimeTypeReference | Attachment [Anlage] |
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
WebLink [Web-Link] | False | UriField | (VisibleReadOnly) | SupplementDocument |
Field | IsNullable | FieldType | UserInterface | Supplement |
DescriptionAutoLength [Beschreibung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementDocumentAutoGeneratedSupplements |
AttachmentAutoDataLength [Anlage - Speicherplatz in Bytes] | False | LongIntegerField | (VisibleReadOnly) | SupplementDocumentAutoGeneratedSupplements |
OriginalFileNameAutoLength [Ursprünglicher Dateiname - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementDocumentAutoGeneratedSupplements |
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
Document [Dokument] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
Document [Dokument] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
Document [Dokument] | Document [Dokument] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
DocumentRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
ExtensionWithoutDot [Dateinamens-Erweiterung (ohne Punkt)] | False | StringField | Editable |
MimeType [Mime-Typ] | False | StringField | Editable |
Field | IsNullable | FieldType | UserInterface | Supplement |
ExtensionWithoutDotAutoLength [Dateinamens-Erweiterung (ohne Punkt) - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementDocumentTypeAutoGeneratedSupplements |
MimeTypeAutoLength [Mime-Typ - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementDocumentTypeAutoGeneratedSupplements |
(None)
Table | Field | IsNullable | Type | CascadeDeletes |
Document [Dokument] | DocumentType [Dokumenttyp] | False | OneToMany | False |
DocumentTypeRowChangeLog [Dokumenttyp - Datensatzänderung] | DocumentType [Dokumenttyp] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
ExtensionWithoutDot | True |
|
Type | Watched Field |
SFSoftwareberatung.SFParts.Definition.MimeTypeTable+MimeTypeGenerator | (all fields watched) |
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
ExtensionWithoutDotAutoLength [Dateinamens-Erweiterung (ohne Punkt) - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementDocumentTypeAutoGeneratedSupplements |
MimeTypeAutoLength [Mime-Typ - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementDocumentTypeAutoGeneratedSupplements |
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
DocumentType [Dokumenttyp] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
DocumentType [Dokumenttyp] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
DocumentType [Dokumenttyp] | DocumentType [Dokumenttyp] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
DocumentTypeRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Diese Tabelle enthält die Bilder für Artikel. Für jeden Artikel können mehrere Bilder in gleichen und verschiedenen Größen gespeichert werden.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
ArticleVariant [Artikelvariante] | False | ReferenceField | Editable |
Description [Beschreibung] | False | StringField | Editable |
Attachment [Bild] | False | BitmapAttachmentField | Editable |
ImageSubject [Bildmotiv] | True | ReferenceField | Editable |
OriginalFileName [Ursprünglicher Dateiname] | False | StringField | VisibleReadOnly |
AttachmentSource [Dateianlagen-Quelle] | False | ReferenceField | Editable |
ImageType [Bildtyp] | False | ReferenceField | VisibleReadOnly |
Width [Breite/Pixel] | False | IntegerField | VisibleReadOnly |
Height [Höhe/Pixel] | False | IntegerField | VisibleReadOnly |
Year [Jahr] | True | YearField | Editable |
Thumbnail [Vorschaubild] | True | BitmapAttachmentField | Hidden |
JpegThumbnail [Vorschaubild (JPEG)] | True | JpegBitmapAttachmentField | Hidden |
Field | IsNullable | FieldType | UserInterface | Supplement |
WebLink [Web-Link] | False | UriField | (VisibleReadOnly) | SupplementImage |
WebThumbnailLink [Web-Link (Vorschaubild)] | False | UriField | (VisibleReadOnly) | SupplementImage |
DescriptionAutoLength [Beschreibung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementImageAutoGeneratedSupplements |
AttachmentAutoDataLength [Bild - Speicherplatz in Bytes] | False | LongIntegerField | (VisibleReadOnly) | SupplementImageAutoGeneratedSupplements |
OriginalFileNameAutoLength [Ursprünglicher Dateiname - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementImageAutoGeneratedSupplements |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
ArticleVariant [Artikelvariante] | ReferenceField | False |
| |
Description [Beschreibung] | StringField | False |
| DATALENGTH([Description]) >= 2 |
Attachment [Bild] | BitmapAttachmentField | False |
| |
ImageSubject [Bildmotiv] | ReferenceField | True |
| |
OriginalFileName [Ursprünglicher Dateiname] | StringField | False |
| DATALENGTH([OriginalFileName]) >= 2 |
AttachmentSource [Dateianlagen-Quelle] | ReferenceField | False |
| |
ImageType [Bildtyp] | ReferenceField | False |
| |
Width [Breite/Pixel] | IntegerField | False |
| [Width] BETWEEN 1 AND 32767 |
Height [Höhe/Pixel] | IntegerField | False |
| [Height] BETWEEN 1 AND 32767 |
Year [Jahr] | YearField | True |
| [Year] IS NULL OR [Year] BETWEEN 1950 AND 2099 |
Thumbnail [Vorschaubild] | BitmapAttachmentField | True |
| |
JpegThumbnail [Vorschaubild (JPEG)] | JpegBitmapAttachmentField | True |
|
A - D - H - I - J - O - T - W - Y
A - B - D - H - I - J - T - U - V
Field | Table | IsNullable | Type | CascadeDeletes |
ArticleVariant [Artikelvariante] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
ImageSubject [Bildmotiv] | ImageSubject [Bildmotiv] | True | OneToMany | False |
AttachmentSource [Dateianlagen-Quelle] | AttachmentSource [Dateianlagen-Quelle] | False | OneToMany | False |
ImageType [Bildtyp] | ImageType [Bildtyp] | False | OneToMany | False |
Table | Field | IsNullable | Type | CascadeDeletes |
ImageRowChangeLog [Bild - Datensatzänderung] | Image [Bild] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
ArticleVariantDescription | True |
|
|
AttachmentSource | False |
| |
ImageType | False |
| |
ImageSubject | False |
|
Type | Watched Field |
SFSoftwareberatung.ApplicationCreator.FieldBasedBusinessRuleTypes.AttachmentSetsDescription | Attachment [Bild] |
SFSoftwareberatung.SFParts.Definition.AttachmentSetsOriginalFileNameAndMimeTypeReference | Attachment [Bild] |
SFSoftwareberatung.SFParts.Definition.ImageSetsDimensions | Attachment [Bild] |
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
WebLink [Web-Link] | False | UriField | (VisibleReadOnly) | SupplementImage |
WebThumbnailLink [Web-Link (Vorschaubild)] | False | UriField | (VisibleReadOnly) | SupplementImage |
Field | IsNullable | FieldType | UserInterface | Supplement |
DescriptionAutoLength [Beschreibung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementImageAutoGeneratedSupplements |
AttachmentAutoDataLength [Bild - Speicherplatz in Bytes] | False | LongIntegerField | (VisibleReadOnly) | SupplementImageAutoGeneratedSupplements |
OriginalFileNameAutoLength [Ursprünglicher Dateiname - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementImageAutoGeneratedSupplements |
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
Image [Bild] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
Image [Bild] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
Image [Bild] | Image [Bild] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
ImageRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
Caption [Bezeichnung] | False | StringField | Editable |
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementImageSubjectAutoGeneratedSupplements |
(None)
Table | Field | IsNullable | Type | CascadeDeletes |
Image [Bild] | ImageSubject [Bildmotiv] | True | OneToMany | False |
ImageSubjectRowChangeLog [Bildmotiv - Datensatzänderung] | ImageSubject [Bildmotiv] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
Caption | True |
|
|
(None)
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementImageSubjectAutoGeneratedSupplements |
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
ImageSubject [Bildmotiv] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
ImageSubject [Bildmotiv] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
ImageSubject [Bildmotiv] | ImageSubject [Bildmotiv] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
ImageSubjectRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
ExtensionWithoutDot [Dateinamens-Erweiterung (ohne Punkt)] | False | StringField | Editable |
MimeType [Mime-Typ] | False | StringField | Editable |
Field | IsNullable | FieldType | UserInterface | Supplement |
ExtensionWithoutDotAutoLength [Dateinamens-Erweiterung (ohne Punkt) - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementImageTypeAutoGeneratedSupplements |
MimeTypeAutoLength [Mime-Typ - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementImageTypeAutoGeneratedSupplements |
(None)
Table | Field | IsNullable | Type | CascadeDeletes |
Image [Bild] | ImageType [Bildtyp] | False | OneToMany | False |
ImageTypeRowChangeLog [Bildtyp - Datensatzänderung] | ImageType [Bildtyp] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
ExtensionWithoutDot | True |
|
Type | Watched Field |
SFSoftwareberatung.SFParts.Definition.MimeTypeTable+MimeTypeGenerator | (all fields watched) |
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
ExtensionWithoutDotAutoLength [Dateinamens-Erweiterung (ohne Punkt) - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementImageTypeAutoGeneratedSupplements |
MimeTypeAutoLength [Mime-Typ - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementImageTypeAutoGeneratedSupplements |
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
ImageType [Bildtyp] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
ImageType [Bildtyp] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
ImageType [Bildtyp] | ImageType [Bildtyp] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
ImageTypeRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
Caption [Bezeichnung] | False | StringField | Editable |
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementLanguageAutoGeneratedSupplements |
(None)
Table | Field | IsNullable | Type | CascadeDeletes |
ArticleVariant [Artikelvariante] | Language [Sprache] | True | OneToMany | False |
LanguageRowChangeLog [Sprache - Datensatzänderung] | Language [Sprache] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
Caption | True |
|
|
(None)
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementLanguageAutoGeneratedSupplements |
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
Language [Sprache] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
Language [Sprache] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
Language [Sprache] | Language [Sprache] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
LanguageRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Hauptfarben enthalten nur einfache Farben ohne Farbvarianten oder Schattierungen.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
Caption [Bezeichnung] | False | StringField | Editable |
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementMainColorAutoGeneratedSupplements |
(None)
Table | Field | IsNullable | Type | CascadeDeletes |
Color [Farbe] | MainColor [Hauptfarbe] | False | OneToMany | False |
MainColorRowChangeLog [Hauptfarbe - Datensatzänderung] | MainColor [Hauptfarbe] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
Caption | True |
|
|
(None)
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
CaptionAutoLength [Bezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementMainColorAutoGeneratedSupplements |
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
MainColor [Hauptfarbe] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
MainColor [Hauptfarbe] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
MainColor [Hauptfarbe] | MainColor [Hauptfarbe] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
MainColorRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Diese Tabelle beschreibt die Stückliste von Baukästen.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
ArticleVariant [Artikelvariante] | False | ReferenceField | Editable |
ContainedArticle [Enthaltener Artikel] | False | ReferenceField | Editable |
Amount [Menge] | False | IntegerField | Editable |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
ArticleVariant [Artikelvariante] | ReferenceField | False |
| |
ContainedArticle [Enthaltener Artikel] | ReferenceField | False |
| |
Amount [Menge] | IntegerField | False |
| [Amount] BETWEEN 1 AND 9999 |
Field | Table | IsNullable | Type | CascadeDeletes |
ArticleVariant [Artikelvariante] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
ContainedArticle [Enthaltener Artikel] | ArticleVariant [Artikelvariante] | False | OneToMany | False |
Table | Field | IsNullable | Type | CascadeDeletes |
PartsListRowChangeLog [Stückliste - Datensatzänderung] | PartsList [Stückliste] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
ArticleVariantContainedArticle | True |
|
|
ContainedArticleArticleVariant | True |
|
(None)
Type | Action | Persisted CHECK expression |
SFSoftwareberatung.ApplicationCreator.RowValidatorTypes.GuidNotEqualRowValidator | Abort | ArticleVariant <> ContainedArticle |
(None)
(None)
(None)
(None)
Zeigt protokollierte Änderungen an diesem Datensatz an.
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | VisibleReadOnly |
PartsList [Stückliste] | False | ReferenceField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
PartsList [Stückliste] | ReferenceField | False |
|
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToOne | True |
PartsList [Stückliste] | PartsList [Stückliste] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLog | True |
|
|
PartsListRowChangeLog | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | Type | CHECK expression |
FieldValueChanges [Änderungen] | True | StringField | FieldValueChanges IS NULL OR DATALENGTH(FieldValueChanges) >= 2 |
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
ProcedureInvocationGroup [Befehlsgruppe] | False | ReferenceField | Editable |
ExecutionOrder [Ausführungsreihenfolge] | False | RowSequenceField | Hidden |
Info [Befehl] | False | ProcedureInvocationInfoField | Editable |
Description [Beschreibung] | False | StringField | Hidden |
CreationTime [angelegt am] | True | DateTimeField | VisibleReadOnly |
CreationUser [angelegt von] | True | SystemUserNameField | VisibleReadOnly |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
ProcedureInvocationGroup [Befehlsgruppe] | ReferenceField | False |
| |
ExecutionOrder [Ausführungsreihenfolge] | RowSequenceField | False |
| [ExecutionOrder] BETWEEN 0 AND 2147483647 |
Info [Befehl] | ProcedureInvocationInfoField | False |
| |
Description [Beschreibung] | StringField | False |
| DATALENGTH([Description]) >= 2 |
CreationTime [angelegt am] | DateTimeField | True |
| [CreationTime] IS NULL OR [CreationTime] BETWEEN CONVERT(DATETIME, '1900-01-01 00:00:00', 121) AND CONVERT(DATETIME, '2099-12-31 00:00:00', 121) |
CreationUser [angelegt von] | SystemUserNameField | True |
| [CreationUser] IS NULL OR DATALENGTH([CreationUser]) >= 2 |
Field | Table | IsNullable | Type | CascadeDeletes |
ProcedureInvocationGroup [Befehlsgruppe] | ProcedureInvocationGroup [Befehlsgruppe] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
ProcedureInvocationGroupExecutionOrderDescriptionID | True |
|
|
Type | Watched Field |
SFSoftwareberatung.ApplicationCreator.FieldBasedBusinessRuleTypes.ProcedureInvocationInfoDescriptionGenerator | Info [Befehl] |
(None)
(None)
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
Bezeichnung | False | StringField | Editable |
Comments [Bemerkungen] | True | StringField | Editable |
VisibleForOthers [für Andere sichtbar] | False | BooleanField | Editable |
CreationTime [angelegt am] | True | DateTimeField | VisibleReadOnly |
CreationUser [angelegt von] | True | SystemUserNameField | VisibleReadOnly |
(None)
Table | Field | IsNullable | Type | CascadeDeletes |
ProcedureInvocation [Befehlsaufruf] | ProcedureInvocationGroup [Befehlsgruppe] | False | OneToMany | True |
Name | Unique | Fields | Usage |
ID | True |
| |
BezeichnungCreationUser | True |
|
|
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
ReminderDate [Datum] | False | DateTimeField | Editable |
Caption [Betreff] | False | StringField | Editable |
RowReference [Betrifft Datensatz] | True | ArbitraryReferenceField | Editable |
Remarks [Bemerkungen] | True | StringField | Editable |
IsResolved [Erledigt] | False | BooleanField | Editable |
Resolver [Erledigt von] | True | SystemUserNameField | VisibleReadOnly |
ResolvedDate [Erledigt am] | True | DateTimeField | VisibleReadOnly |
CreationTime [angelegt am] | True | DateTimeField | VisibleReadOnly |
CreationUser [angelegt von] | True | SystemUserNameField | VisibleReadOnly |
LastUpdateTime [zuletzt geändert am] | True | DateTimeField | VisibleReadOnly |
LastUpdateUser [zuletzt geändert von] | True | SystemUserNameField | VisibleReadOnly |
(None)
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
ReminderDateCreationUserCaptionCreationTime | True |
|
|
CreationTime | False |
| |
ResolvedDate | False |
| |
Resolver | False |
|
Type | Watched Field |
SFSoftwareberatung.ApplicationCreator.FieldBasedBusinessRuleTypes.BooleanFieldSetsAndClearsUserNameAndDateTime | IsResolved [Erledigt] |
Type | Action | Persisted CHECK expression |
SFSoftwareberatung.ApplicationCreator.RowValidatorTypes.FieldNotNullDependingOnBooleanFieldRowValidator | Abort | ((IsResolved = 0) OR (Resolver IS NOT NULL)) |
SFSoftwareberatung.ApplicationCreator.RowValidatorTypes.FieldNotNullDependingOnBooleanFieldRowValidator | Abort | ((IsResolved = 1) OR (Resolver IS NULL)) |
SFSoftwareberatung.ApplicationCreator.RowValidatorTypes.FieldNotNullDependingOnBooleanFieldRowValidator | Abort | ((IsResolved = 0) OR (ResolvedDate IS NOT NULL)) |
SFSoftwareberatung.ApplicationCreator.RowValidatorTypes.FieldNotNullDependingOnBooleanFieldRowValidator | Abort | ((IsResolved = 1) OR (ResolvedDate IS NULL)) |
(None)
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
ChangeNumber [Änderungsnummer] | False | IdentityField | VisibleReadOnly |
ChangeTime [Änderungszeitpunkt] | False | DateTimeField | Editable |
SystemUserName [System-Benutzername] | False | SystemUserNameField | VisibleReadOnly |
ChangeType [Änderungstyp] | False | RowChangeTypeField | Editable |
LoggedTableName [Datei] | False | TableNameField | Hidden |
LoggedTableFriendlyName [Datei] | False | StringField | Editable |
LoggedRowId | False | GuidField | Hidden |
LoggedRowDescription [Datensatzbeschreibung] | True | StringField | Editable |
LoggedRowReference [Geänderter Datensatz] | False | ArbitraryReferenceField | Editable |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
ChangeNumber | True |
|
|
ChangeNumberChangeTimeChangeType | True |
|
|
LoggedRowIdChangeNumber | True |
|
(None)
(None)
(None)
(None)
(None)
(None)
Field | IsNullable | FieldType | UserInterface |
ID | False | PrimaryKeyField | Hidden |
TS | False | TimestampField | Hidden |
RowChangeLog [Datensatzänderung] | False | ReferenceField | Editable |
FieldIndex | False | IntegerField | Hidden |
FieldName [Feld] | False | FieldNameField | Hidden |
FieldFriendlyName [Feldbezeichnung] | False | StringField | Editable |
OldValueText [Vorheriger Feldinhalt] | True | StringField | Editable |
NewValueText [Neuer Feldinhalt] | True | StringField | Editable |
OldValue | True | ObjectField | Hidden |
NewValue | True | ObjectField | Hidden |
OldBlobValue | True | BlobField | Hidden |
NewBlobValue | True | BlobField | Hidden |
OldGuidValue | True | GuidField | Hidden |
NewGuidValue | True | GuidField | Hidden |
Field | IsNullable | FieldType | UserInterface | Supplement |
FieldFriendlyNameAutoLength [Feldbezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementRowChangeLogFieldValueAutoGeneratedSupplements |
OldValueTextAutoLength [Vorheriger Feldinhalt - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementRowChangeLogFieldValueAutoGeneratedSupplements |
NewValueTextAutoLength [Neuer Feldinhalt - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementRowChangeLogFieldValueAutoGeneratedSupplements |
Field | Type | Nullable | Settings | Persisted CHECK expression |
ID | PrimaryKeyField | False |
| |
TS | TimestampField | False |
| |
RowChangeLog [Datensatzänderung] | ReferenceField | False |
| |
FieldIndex | IntegerField | False |
| [FieldIndex] BETWEEN 0 AND 2147483647 |
FieldName [Feld] | FieldNameField | False |
| DATALENGTH([FieldName]) >= 2 |
FieldFriendlyName [Feldbezeichnung] | StringField | False |
| DATALENGTH([FieldFriendlyName]) >= 2 |
OldValueText [Vorheriger Feldinhalt] | StringField | True |
| [OldValueText] IS NULL OR DATALENGTH([OldValueText]) >= 2 |
NewValueText [Neuer Feldinhalt] | StringField | True |
| [NewValueText] IS NULL OR DATALENGTH([NewValueText]) >= 2 |
OldValue | ObjectField | True |
| |
NewValue | ObjectField | True |
| |
OldBlobValue | BlobField | True |
| |
NewBlobValue | BlobField | True |
| |
OldGuidValue | GuidField | True |
| |
NewGuidValue | GuidField | True |
|
B - F - G - I - O - P - R - S - T
Field | Table | IsNullable | Type | CascadeDeletes |
RowChangeLog [Datensatzänderung] | RowChangeLog [Datensatzänderung] | False | OneToMany | True |
(None)
Name | Unique | Fields | Usage |
ID | True |
| |
RowChangeLogFieldIndex | True |
|
|
RowChangeLogFieldName | True |
|
|
OldGuidValue | False |
| |
NewGuidValue | False |
|
(None)
Type | Action | Persisted CHECK expression |
SFSoftwareberatung.ApplicationCreator.RowValidatorTypes.FieldsNotNullRowValidator | Abort | ((OldValue IS NULL) AND (OldBlobValue IS NULL)) OR (((OldValue IS NOT NULL) AND (OldBlobValue IS NULL)) OR ((OldValue IS NULL) AND (OldBlobValue IS NOT NULL))) |
SFSoftwareberatung.ApplicationCreator.RowValidatorTypes.FieldsNotNullRowValidator | Abort | ((NewValue IS NULL) AND (NewBlobValue IS NULL)) OR (((NewValue IS NOT NULL) AND (NewBlobValue IS NULL)) OR ((NewValue IS NULL) AND (NewBlobValue IS NOT NULL))) |
(None)
Field | IsNullable | FieldType | UserInterface | Supplement |
FieldFriendlyNameAutoLength [Feldbezeichnung - Textlänge] | False | IntegerField | (VisibleReadOnly) | SupplementRowChangeLogFieldValueAutoGeneratedSupplements |
OldValueTextAutoLength [Vorheriger Feldinhalt - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementRowChangeLogFieldValueAutoGeneratedSupplements |
NewValueTextAutoLength [Neuer Feldinhalt - Textlänge] | True | IntegerField | (VisibleReadOnly) | SupplementRowChangeLogFieldValueAutoGeneratedSupplements |
(None)
(None)
(None)
A - B - C - D - F - H - K - S - W
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | ((dbo.AdHocAnalysisQueryDefinition.CreationUser = SYSTEM_USER) OR (dbo.AdHocAnalysisQueryDefinition.IsPublic = 1)) | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Artikel in dieser Tabelle sind unabhängig von den Farben in denen sie verfügbar sind.
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Diese Tabelle beschreibt, ab wann einem Artikel welche Artikelnummer zugewiesen war.
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Diese Tabelle enthält für jeden Artikel und jede Farbe, in der er existiert(e), einen Datensatz.
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Quelle und Lizenz für Bilder und Dokumente.
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Die hierarchischen Kategorien lassen auch viele Artikel übersichtlich strukturiert darstellen.
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Farben umfassen auch Farbvariationen und Schattierungen von Hauptfarben.
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | - | - |
Reader | X | X | X | - | - |
FtdbWebsite | X | X | X | - | - |
Role | Select | Insert | Update | Delete | Import |
Editors | X | - | - | - | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Diese Tabelle kann je Artikelvariante mehrere Dokumente aufnehmen.
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Diese Tabelle enthält die Bilder für Artikel. Für jeden Artikel können mehrere Bilder in gleichen und verschiedenen Größen gespeichert werden.
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Hauptfarben enthalten nur einfache Farben ohne Farbvarianten oder Schattierungen.
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Diese Tabelle beschreibt die Stückliste von Baukästen.
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | X | - | - | - | - |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | dbo.ProcedureInvocation.ProcedureInvocationGroup IN (SELECT dbo.ProcedureInvocationGroup.ID FROM dbo.ProcedureInvocationGroup WHERE ((dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER) OR (dbo.ProcedureInvocationGroup.VisibleForOthers = 1))) | dbo.ProcedureInvocation.ProcedureInvocationGroup IN (SELECT dbo.ProcedureInvocationGroup.ID FROM dbo.ProcedureInvocationGroup WHERE (dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER)) | Same as Insert | Same as Insert | X |
FtdbWebsite | dbo.ProcedureInvocation.ProcedureInvocationGroup IN (SELECT dbo.ProcedureInvocationGroup.ID FROM dbo.ProcedureInvocationGroup WHERE ((dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER) OR (dbo.ProcedureInvocationGroup.VisibleForOthers = 1))) | dbo.ProcedureInvocation.ProcedureInvocationGroup IN (SELECT dbo.ProcedureInvocationGroup.ID FROM dbo.ProcedureInvocationGroup WHERE (dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER)) | Same as Insert | Same as Insert | X |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | ((dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER) OR (dbo.ProcedureInvocationGroup.VisibleForOthers = 1)) | (dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER) | Same as Insert | Same as Insert | X |
FtdbWebsite | ((dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER) OR (dbo.ProcedureInvocationGroup.VisibleForOthers = 1)) | (dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER) | Same as Insert | Same as Insert | X |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | X | X | X |
Reader | (dbo.Reminder.CreationUser = SYSTEM_USER) | X | X | X | X |
FtdbWebsite |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | X | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Role | Select | Insert | Update | Delete | Import |
Editors | X | X | - | - | - |
Reader | X | - | - | - | - |
FtdbWebsite | X | - | - | - | - |
Table | WatchedField |
Document [Dokument] | Attachment [Anlage] |
Image [Bild] | Attachment [Bild] |
Table | WatchedField |
Reminder [Wiedervorlage] | IsResolved [Erledigt] |
Table | WatchedField |
ProcedureInvocation [Befehlsaufruf] | Info [Befehl] |
Table | WatchedField |
Document [Dokument] | Attachment [Anlage] |
Image [Bild] | Attachment [Bild] |
Table | WatchedField |
Category [Kategorie] | Caption [Bezeichnung] |
Category [Kategorie] | ParentCategory [Übergeordnete Kategorie] |
Table | WatchedField |
Image [Bild] | Attachment [Bild] |
Table | WatchedField |
DocumentType [Dokumenttyp] | |
ImageType [Bildtyp] |
Table | Action | Persisted CHECK Expression |
Reminder [Wiedervorlage] | Abort | ((IsResolved = 0) OR (ResolvedDate IS NOT NULL)) |
Reminder [Wiedervorlage] | Abort | ((IsResolved = 0) OR (Resolver IS NOT NULL)) |
Reminder [Wiedervorlage] | Abort | ((IsResolved = 1) OR (ResolvedDate IS NULL)) |
Reminder [Wiedervorlage] | Abort | ((IsResolved = 1) OR (Resolver IS NULL)) |
Table | Action | Persisted CHECK Expression |
ArticleNumber [Artikelnummer] | Abort | (FromYear IS NOT NULL) OR (Number IS NOT NULL) |
RowChangeLogFieldValue [Datensatzänderungs-Feldinhalt] | Abort | ((NewValue IS NULL) AND (NewBlobValue IS NULL)) OR (((NewValue IS NOT NULL) AND (NewBlobValue IS NULL)) OR ((NewValue IS NULL) AND (NewBlobValue IS NOT NULL))) |
RowChangeLogFieldValue [Datensatzänderungs-Feldinhalt] | Abort | ((OldValue IS NULL) AND (OldBlobValue IS NULL)) OR (((OldValue IS NOT NULL) AND (OldBlobValue IS NULL)) OR ((OldValue IS NULL) AND (OldBlobValue IS NOT NULL))) |
Table | Action | Persisted CHECK Expression |
PartsList [Stückliste] | Abort | ArticleVariant <> ContainedArticle |
Table | Action | Persisted CHECK Expression |
ArticleNumber [Artikelnummer] | Warn |
Table | Invocations | OutputFields |
AdHocAnalysisQueryDefinitionRowChangeLog [Ad-hoc-Abfrage - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
ArticleNumberRowChangeLog [Artikelnummer - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
ArticleRowChangeLog [Artikel - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
ArticleVariantRowChangeLog [Artikelvariante - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
AttachmentSourceRowChangeLog [Dateianlagen-Quelle - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
CategoryRowChangeLog [Kategorie - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
ColorRowChangeLog [Farbe - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
DocumentRowChangeLog [Dokument - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
DocumentTypeRowChangeLog [Dokumenttyp - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
ImageRowChangeLog [Bild - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
ImageSubjectRowChangeLog [Bildmotiv - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
ImageTypeRowChangeLog [Bildtyp - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
LanguageRowChangeLog [Sprache - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
MainColorRowChangeLog [Hauptfarbe - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
PartsListRowChangeLog [Stückliste - Datensatzänderung] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
Table | Invocations | OutputFields |
ArticleNumber [Artikelnummer] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
ArticleVariant [Artikelvariante] | OnNavigatingToRow, AfterSaveAfterTransaction |
|
Table | Supplement | Criteria Expression Sample |
Article [Artikel] | ArticleNumber [Nummer (leer = nicht mehr produziert)] | ArticleID IN (SELECT dbo.ArticleVariantFind.ArticleVariantArticle FROM dbo.ArticleVariantFind INNER JOIN dbo.ArticleNumberFind ON dbo.ArticleNumberFind.ArticleNumberArticleVariant = dbo.ArticleVariantFind.ArticleVariantID WHERE dbo.ArticleNumberFind.ArticleNumberNumber LIKE (REPLACE(REPLACE(@ArticleNumber, N'*', N'%'), N'?', N'_') + N'%')) |
Article [Artikel] | ContainedArticleVariant [Enthaltener Artikel] | ArticleID IN (SELECT dbo.ArticleVariantFind.ArticleVariantArticle FROM dbo.ArticleVariantFind INNER JOIN dbo.PartsListFind ON dbo.PartsListFind.PartsListArticleVariant = dbo.ArticleVariantFind.ArticleVariantID WHERE dbo.PartsListFind.PartsListContainedArticle = @ContainedArticleVariant) |
Article [Artikel] | Color [Nur mit dieser Farbe] | ArticleID IN (SELECT dbo.ArticleVariantFind.ArticleVariantArticle FROM dbo.ArticleVariantFind WHERE dbo.ArticleVariantFind.ArticleVariantColor = @Color) |
ArticleVariant [Artikelvariante] | Artikelnummer [Nummer (leer = nicht mehr produziert)] | ArticleVariantID IN (SELECT dbo.ArticleNumberFind.ArticleNumberArticleVariant FROM dbo.ArticleNumberFind WHERE dbo.ArticleNumberFind.ArticleNumberNumber LIKE (REPLACE(REPLACE(@Artikelnummer, N'*', N'%'), N'?', N'_') + N'%')) |
ArticleVariant [Artikelvariante] | ContainedArticleVariant [Enthaltener Artikel] | ArticleVariantID IN (SELECT dbo.PartsListFind.PartsListArticleVariant FROM dbo.PartsListFind WHERE dbo.PartsListFind.PartsListContainedArticle = @ContainedArticleVariant) |
Table | Supplement | Criteria Expression Sample |
ArticleNumber [Artikelnummer] | Textsuche | ArticleNumberID IN (SELECT ID FROM dbo.SearchTextInSeveralTablesArticleNumberTextsuche(@Textsuche)) |
Table | Supplement | Criteria Expression Sample |
Article [Artikel] | SearchText [Suchbegriff] | ArticleID IN (SELECT ID FROM dbo.GetArticleIdsByText(@SearchText)) |
Table | Supplement | Criteria Expression Sample |
ArticleVariant [Artikelvariante] | SearchText [Suchbegriff] | ArticleVariantID IN (SELECT ID FROM dbo.GetArticleVariantIdsByText(@SearchText)) |
Table | Action |
AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | ExecuteQueryQueryDefinition [Abfragedefinition ausführen] |
Table | Action |
ProcedureInvocationGroup [Befehlsgruppe] | ExecuteProcedureInvocationGroupTable [Befehlsgruppe ausführen] |
Table | Action |
ArticleVariant [Artikelvariante] | EditPartsList [Stückliste pflegen] |
Table | Action |
AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | LiveLinkQueryDefinition [Live-Verknüpfung für Abfragedefinition] |
Table | Action |
RowChangeLog [Datensatzänderung] | UndoLoggedRowChange [Protokollierte Änderung rückgängig machen] |
Table | Action |
ArticleVariant [Artikelvariante] | FtdbArticleVariantWebsite [Auf der ftdb-Website aufrufen] |
Category [Kategorie] | FtdbArticleVariantWebsite [Auf der ftdb-Website aufrufen] |
A - B - C - D - E - F - H - I - J - L - M - N - O - P - Q - R - S - T - U - V - W - Y
A - Ä - A - B - D - E - F - G - H - I - J - K - L - M - N - O - P - S - T - Ü - U - V - W - Z
Field | Table | IsNullable | Supplement |
QueryDefinition [Abfragedefinition] | AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | False |
Field | Table | IsNullable | Supplement |
LoggedRowReference [Geänderter Datensatz] | RowChangeLog [Datensatzänderung] | False | |
RowReference [Betrifft Datensatz] | Reminder [Wiedervorlage] | True |
Field | Table | IsNullable | Supplement |
Attachment [Bild] | Image [Bild] | False | |
Thumbnail [Vorschaubild] | Image [Bild] | True |
Field | Table | IsNullable | Supplement |
NewBlobValue | RowChangeLogFieldValue [Datensatzänderungs-Feldinhalt] | True | |
OldBlobValue | RowChangeLogFieldValue [Datensatzänderungs-Feldinhalt] | True |
Field | Table | IsNullable | Supplement |
FieldName [Feld] | RowChangeLogFieldValue [Datensatzänderungs-Feldinhalt] | False |
Field | Table | IsNullable | Supplement |
Attachment [Anlage] | Document [Dokument] | False |
Field | Table | IsNullable | Supplement |
WeightInG [Gewicht in g] | Article [Artikel] | True |
Field | Table | IsNullable | Supplement |
LoggedRowId | RowChangeLog [Datensatzänderung] | False | |
NewGuidValue | RowChangeLogFieldValue [Datensatzänderungs-Feldinhalt] | True | |
OldGuidValue | RowChangeLogFieldValue [Datensatzänderungs-Feldinhalt] | True |
Field | Table | IsNullable | Supplement |
ChangeNumber [Änderungsnummer] | RowChangeLog [Datensatzänderung] | False |
A - B - C - D - E - F - H - L - M - N - O - P - R - S - U - W
Field | Table | IsNullable | Supplement |
JpegThumbnail [Vorschaubild (JPEG)] | Image [Bild] | True |
Field | Table | IsNullable | Supplement |
NewValue | RowChangeLogFieldValue [Datensatzänderungs-Feldinhalt] | True | |
OldValue | RowChangeLogFieldValue [Datensatzänderungs-Feldinhalt] | True |
Field | Table | IsNullable | Supplement |
Info [Befehl] | ProcedureInvocation [Befehlsaufruf] | False |
A - C - D - I - L - M - N - P - R - S
Field | Table | IsNullable | Supplement |
ChangeType [Änderungstyp] | RowChangeLog [Datensatzänderung] | False |
Field | Table | IsNullable | Supplement |
ExecutionOrder [Ausführungsreihenfolge] | ProcedureInvocation [Befehlsaufruf] | False |
A - B - C - D - E - F - L - M - N - O - R - U
Field | Table | IsNullable | Supplement |
LoggedTableName [Datei] | RowChangeLog [Datensatzänderung] | False |
B - D - F - I - N - S - T - U - V - X
Field | Table | IsNullable | Supplement |
WeightInG [Gewicht in g] | Article [Artikel] | True |
Field | Table | IsNullable | Supplement |
Data | Configuration | True |
A - B - C - D - E - F - L - M - N - O - R - S - U - W
A - B - C - F - H - L - N - O - R - V - W - Y
B - C - D - E - L - M - N - O - R - S - U
A - C - D - I - L - M - N - O - P - R - S
A - B - C - D - E - F - L - M - N - O - P - R - S - V - W
A - Ä - A - B - D - E - F - G - J - K - M - N - P - S - U - V - W - Z
B - C - D - E - F - L - M - N - O - P - R - S
B - C - D - E - L - M - N - O - R - S
A - C - D - E - G - H - I - L - R - S - T - W
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
(None)
(None)
(None)
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
(None)
(None)
(None)
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
(None)
(None)
DELETE FROM dbo.DocumentRowChangeLog;
DELETE FROM dbo.ImageRowChangeLog;
DELETE FROM dbo.PartsListRowChangeLog;
DELETE FROM dbo.ArticleNumberRowChangeLog;
DELETE FROM dbo.ArticleVariantRowChangeLog;
DELETE FROM dbo.Document;
DELETE FROM dbo.Image;
DELETE FROM dbo.PartsList;
DELETE FROM dbo.ArticleNumber;
DELETE FROM dbo.ArticleVariant;
DELETE FROM dbo.ImageSubjectRowChangeLog;
DELETE FROM dbo.LanguageRowChangeLog;
DELETE FROM dbo.AdHocAnalysisQueryDefinitionRowChangeLog;
DELETE FROM dbo.ImageTypeRowChangeLog;
DELETE FROM dbo.DocumentTypeRowChangeLog;
DELETE FROM dbo.AttachmentSourceRowChangeLog;
DELETE FROM dbo.ArticleRowChangeLog;
DELETE FROM dbo.ColorRowChangeLog;
DELETE FROM dbo.MainColorRowChangeLog;
DELETE FROM dbo.CategoryRowChangeLog;
DELETE FROM dbo.RowChangeLogFieldValue;
DELETE FROM dbo.RowChangeLog;
DELETE FROM dbo.ImageSubject;
DELETE FROM dbo.Language;
DELETE FROM dbo.ProcedureInvocation;
DELETE FROM dbo.ProcedureInvocationGroup;
DELETE FROM dbo.Reminder;
DELETE FROM dbo.ImageType;
DELETE FROM dbo.DocumentType;
DELETE FROM dbo.AttachmentSource;
DELETE FROM dbo.Article;
DELETE FROM dbo.Color;
DELETE FROM dbo.MainColor;
DELETE FROM dbo.Category;
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
Name | Index | Direction | Type | IsNullable |
Pixels [Maximalanzahl Pixel in jeder Richtung] | 0 | Input | IntegerField | False |
AnzahlBilder [Anzahl erzeugter Bilder] | 1 | Output | IntegerField | True |
(None)
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
(None)
(None)
(None)
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
Name | Index | Direction | Type | IsNullable |
ProcedureInvocationGroup [Befehlsgruppe] | 0 | Input | ReferenceField | False |
ReportOption [Berichte] | 1 | Input | EnumerationField | False |
NumberOfCopies [Anzahl der Exemplare beim Drucken] | 2 | Input | IntegerField | False |
FolderName [Ordner für Dateiausgabe] | 3 | Input | FileNameField | False |
Name | Index | Direction | Type | IsNullable | Settings | Persistable CHECK expression |
ProcedureInvocationGroup [Befehlsgruppe] | 0 | Input | ReferenceField | False |
| |
ReportOption [Berichte] | 1 | Input | EnumerationField | False |
| [ReportOption] BETWEEN 0 AND 4 |
NumberOfCopies [Anzahl der Exemplare beim Drucken] | 2 | Input | IntegerField | False |
| [NumberOfCopies] BETWEEN 1 AND 32767 |
FolderName [Ordner für Dateiausgabe] | 3 | Input | FileNameField | False |
| DATALENGTH([FolderName]) >= 2 |
(None)
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
Name | Index | Direction | Type | IsNullable |
TargetFolder [Zielordner] | 0 | Input | FileNameField | False |
(None)
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
Name | Index | Direction | Type | IsNullable |
Zieldateiname | 0 | Input | FileNameField | False |
Structure [Struktur] | 1 | Input | BooleanField | False |
SupportObjects [Unterstützungsobjekte] | 2 | Input | BooleanField | False |
Data [Daten] | 3 | Input | BooleanField | False |
Images [Bilder (nur zusammen mit Daten)] | 4 | Input | BooleanField | False |
Documents [Dokumente (nur zusammen mit Daten)] | 5 | Input | BooleanField | False |
OnlyOneRecordPerTable [Nur ein Datensatz pro Tabelle zum Test] | 6 | Input | BooleanField | False |
(None)
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
Name | Index | Direction | Type | IsNullable |
SearchText | 0 | Input | StringField | False |
SELECT A.ID
FROM dbo.V_Article AS A
INNER JOIN dbo.Category AS C ON C.ID = A.Category
WHERE A.Caption LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%'
OR C.CompleteCaption LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%'
OR A.ID IN (SELECT AV.Article
FROM dbo.V_ArticleVariant AS AV
LEFT JOIN dbo.Color AS C ON C.ID = AV.Color
LEFT JOIN dbo.MainColor AS MC ON MC.ID = C.MainColor
LEFT JOIN dbo.Language AS L ON L.ID = AV.Language
WHERE C.Caption LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%'
OR MC.Caption LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%'
OR L.Caption LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%')
OR A.ID IN (SELECT AV.Article
FROM dbo.ArticleVariant AS AV
INNER JOIN dbo.V_ArticleNumber AS AN ON AN.ArticleVariant = AV.ID
WHERE AN.Number LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%')
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
Name | Index | Direction | Type | IsNullable |
SearchText | 0 | Input | StringField | False |
SELECT AV.ID
FROM dbo.V_ArticleVariant AS AV
INNER JOIN dbo.Article AS A ON A.ID = AV.Article
INNER JOIN dbo.Category AS C ON C.ID = A.Category
LEFT JOIN dbo.Color AS COL ON COL.ID = AV.Color
LEFT JOIN dbo.MainColor AS MC ON MC.ID = COL.MainColor
LEFT JOIN dbo.Language AS L ON L.ID = AV.Language
WHERE A.Caption LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%'
OR C.CompleteCaption LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%'
OR COL.Caption LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%'
OR MC.Caption LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%'
OR L.Caption LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%'
OR AV.ID IN (SELECT AN.ArticleVariant
FROM dbo.V_ArticleNumber AS AN
WHERE AN.Number LIKE REPLACE(REPLACE(@SearchText, N'?', N'_'), N'*', N'%') + N'%')
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
(None)
(None)
(None)
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
(None)
(None)
(None)
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
(None)
(None)
(None)
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
(None)
(None)
(None)
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
(None)
(None)
(None)
Permission | Role |
- | Editors |
- | Reader |
- | FtdbWebsite |
Name | Index | Direction | Type | IsNullable |
ArticleVariant [Artikelvariante] | 0 | Input | ReferenceField | False |
Result | 1 | ReturnValue | StringField | True |
Name | Index | Direction | Type | IsNullable | Settings | Persistable CHECK expression |
ArticleVariant [Artikelvariante] | 0 | Input | ReferenceField | False |
| |
Result | 1 | ReturnValue | StringField | True |
|
DECLARE @Result NVARCHAR(4000),
@LastFromYear INTEGER,
@LastNumber NVARCHAR(20);
SELECT @Result = COALESCE(@Result, N'')
+ CASE WHEN (@LastNumber IS NULL AND Number IS NULL)
OR (@LastNumber IS NOT NULL
AND Number IS NOT NULL AND Number = @LastNumber)
THEN N''
ELSE CASE WHEN @LastFromYear IS NOT NULL
AND @LastFromYear <> FromYear - 1
AND @LastNumber IS NOT NULL
THEN N'-' + CAST(FromYear - 1 AS NVARCHAR(4))
ELSE N''
END
+ CASE WHEN @LastFromYear IS NOT NULL AND @LastNumber IS NOT NULL
THEN N')'
ELSE N''
END
+ CASE WHEN Number IS NOT NULL
THEN CASE WHEN @Result IS NULL OR @Result = N''
THEN N''
ELSE N', '
END
+ Number + ' (' + CAST(FromYear AS NVARCHAR(4))
ELSE N''
END
END,
@LastFromYear = FromYear,
@LastNumber = Number
FROM dbo.ArticleNumber
WHERE ArticleVariant = @ArticleVariant
ORDER BY FromYear;
IF @LastNumber IS NOT NULL
SET @Result = @Result + N' bis heute)';
RETURN @Result;
Permission | Role |
- | Editors |
- | Reader |
- | FtdbWebsite |
SELECT ArticleVariant, MIN(FromYear) AS FirstYear
FROM dbo.ArticleNumber
GROUP BY ArticleVariant;
Permission | Role |
- | Editors |
- | Reader |
- | FtdbWebsite |
SELECT ArticleVariant, MIN(CAST(Width AS INTEGER) * CAST(Height AS INTEGER)) AS MinSize
FROM dbo.Image
GROUP BY ArticleVariant;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
Name | Index | Direction | Type | IsNullable | Settings | Persistable CHECK expression |
Category [Nur diese Kategorie (leer = alle)] | 0 | Input | ReferenceField | True |
| |
IncludingSubcategories [Mit Unterkategorien] | 1 | Input | BooleanField | False |
| |
MainColor [Nur diese Hauptfarbe (leer = alle)] | 2 | Input | ReferenceField | True |
| |
Color [Nur diese Farbe (leer = alle)] | 3 | Input | ReferenceField | True |
| |
Language [Nur diese Sprache (leer = alle)] | 4 | Input | ReferenceField | True |
| |
Number [Nur dieses Artikelnummer-Muster (leer = alle)] | 5 | Input | StringField | True |
| [Number] IS NULL OR DATALENGTH([Number]) >= 2 |
ArticleNumberValidInYear [Artikelnummer gültig in Jahr] | 6 | Input | YearField | True |
| [ArticleNumberValidInYear] IS NULL OR [ArticleNumberValidInYear] BETWEEN 1960 AND 2099 |
OnlyWithDocuments [Nur mit Dokumenten] | 7 | Input | BooleanField | False |
| |
Article [Nur dieser Artikel (leer = alle] | 8 | Input | ReferenceField | True |
| |
ArticleVariant [Nur diese Artikelvariante (leer = alle)] | 9 | Input | ReferenceField | True |
| |
ContainedArticleVariant [Nur mit enthaltenem Teil (leer = alle)] | 10 | Input | ReferenceField | True |
| |
Sort1 [Sortierung (1)] | 11 | Input | SortingField | False |
| [Sort1] BETWEEN 0 AND 5 |
ShowGroupHeader [Gruppenköpfe ausgeben] | 12 | Input | BooleanField | False |
| |
Sort2 [Sortierung (2)] | 13 | Input | SortingField | False |
| [Sort2] BETWEEN 0 AND 5 |
Sort3 [Sortierung (3)] | 14 | Input | SortingField | False |
| [Sort3] BETWEEN 0 AND 5 |
Sort4 [Sortierung (4)] | 15 | Input | SortingField | False |
| [Sort4] BETWEEN 0 AND 5 |
Sort5 [Sortierung (5)] | 16 | Input | SortingField | False |
| [Sort5] BETWEEN 0 AND 5 |
Sort6 [Sortierung (6)] | 17 | Input | SortingField | False |
| [Sort6] BETWEEN 0 AND 5 |
DECLARE @CategoryCompleteCaption NVARCHAR(255);
SELECT @CategoryCompleteCaption = CompleteCaption
FROM dbo.Category
WHERE ID = @Category;
SELECT C.CompleteCaption AS CategoryCompleteCaption,
A.ID AS ArticleID,
SAV.OldestArticleNumberYear,
SAV.OldestArticleNumber,
SAV.NewestArticleNumberYear,
SAV.NewestArticleNumber,
SAV.LastProductionYear,
A.Caption AS ArticleCaption,
A.Remarks AS ArticleRemarks,
AV.ID AS ArticleVariantID,
MC.Caption AS MainColorCaption,
CO.Caption AS ColorCaption,
L.Caption AS LanguageCaption,
SAV.DocumentCount,
SAV.PartsListCount,
SAV.PartsCount,
I.JpegThumbnail AS JpegImageThumbnail,
SAV.WebLink AS ArticleVariantWebLink
FROM dbo.Category AS C
INNER JOIN dbo.Article AS A ON A.Category = C.ID
INNER JOIN dbo.ArticleVariant AS AV ON AV.Article = A.ID
LEFT JOIN dbo.Color AS CO ON CO.ID = AV.Color
LEFT JOIN dbo.MainColor AS MC ON MC.ID = CO.MainColor
LEFT JOIN dbo.Language AS L ON L.ID = AV.Language
LEFT JOIN dbo.SupplementArticleVariant AS SAV ON SAV.ID = AV.ID
LEFT JOIN dbo.Image AS I ON I.ID = SAV.LargestImageId
LEFT JOIN dbo.ImageType AS IT ON IT.ID = I.ImageType
WHERE (@Category IS NULL
OR C.CompleteCaption = @CategoryCompleteCaption
OR (@IncludingSubcategories = 1 AND C.CompleteCaption LIKE @CategoryCompleteCaption + N' - _%'))
AND (@MainColor IS NULL OR MC.ID = @MainColor)
AND (@Color IS NULL OR AV.Color = @Color)
AND (@Language IS NULL OR AV.Language = @Language)
AND (@Number IS NULL
OR EXISTS(SELECT *
FROM dbo.ArticleNumber AS AN
WHERE AN.ArticleVariant = AV.ID
AND AN.Number LIKE REPLACE(REPLACE(@Number, N'?', N'_'), N'*', N'%')))
AND (@ArticleNumberValidInYear IS NULL
OR (EXISTS(SELECT *
FROM dbo.ArticleNumber AS AN
WHERE AN.ArticleVariant = AV.ID
AND AN.FromYear IS NOT NULL
AND AN.FromYear <= @ArticleNumberValidInYear
AND (@Number IS NULL
OR AN.Number LIKE REPLACE(REPLACE(@Number, N'?', N'_'), N'*', N'%'))
AND NOT EXISTS(SELECT *
FROM dbo.ArticleNumber AS AN2
WHERE (AN2.ArticleVariant <> AN.ArticleVariant
OR (AN2.ArticleVariant = AN.ArticleVariant
AND AN2.Number IS NULL))
AND AN2.FromYear <= @ArticleNumberValidInYear
AND AN2.FromYear > AN.FromYear))))
AND (@OnlyWithDocuments = 0
OR EXISTS(SELECT *
FROM dbo.Document AS D
WHERE D.ArticleVariant = AV.ID))
AND (@Article IS NULL OR A.ID = @Article)
AND (@ArticleVariant IS NULL OR AV.ID = @ArticleVariant)
AND (@ContainedArticleVariant IS NULL
OR EXISTS(SELECT *
FROM dbo.PartsList AS PL
WHERE PL.ArticleVariant = AV.ID
AND PL.ContainedArticle = @ContainedArticleVariant))
ORDER BY CASE @Sort1
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort2
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort3
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort4
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort5
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort6
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
Name | Index | Direction | Type | IsNullable | Settings | Persistable CHECK expression |
Category [Nur diese Kategorie (leer = alle)] | 0 | Input | ReferenceField | True |
| |
IncludingSubcategories [Mit Unterkategorien] | 1 | Input | BooleanField | False |
| |
MainColor [Nur diese Hauptfarbe (leer = alle)] | 2 | Input | ReferenceField | True |
| |
Color [Nur diese Farbe (leer = alle)] | 3 | Input | ReferenceField | True |
| |
Language [Nur diese Sprache (leer = alle)] | 4 | Input | ReferenceField | True |
| |
Number [Nur dieses Artikelnummer-Muster (leer = alle)] | 5 | Input | StringField | True |
| [Number] IS NULL OR DATALENGTH([Number]) >= 2 |
ArticleNumberValidInYear [Artikelnummer gültig in Jahr] | 6 | Input | YearField | True |
| [ArticleNumberValidInYear] IS NULL OR [ArticleNumberValidInYear] BETWEEN 1960 AND 2099 |
OnlyWithDocuments [Nur mit Dokumenten] | 7 | Input | BooleanField | False |
| |
Article [Nur dieser Artikel (leer = alle] | 8 | Input | ReferenceField | True |
| |
ArticleVariant [Nur diese Artikelvariante (leer = alle)] | 9 | Input | ReferenceField | True |
| |
ContainedArticleVariant [Nur mit enthaltenem Teil (leer = alle)] | 10 | Input | ReferenceField | True |
| |
Sort1 [Sortierung (1)] | 11 | Input | SortingField | False |
| [Sort1] BETWEEN 0 AND 5 |
ShowGroupHeader [Gruppenköpfe ausgeben] | 12 | Input | BooleanField | False |
| |
Sort2 [Sortierung (2)] | 13 | Input | SortingField | False |
| [Sort2] BETWEEN 0 AND 5 |
Sort3 [Sortierung (3)] | 14 | Input | SortingField | False |
| [Sort3] BETWEEN 0 AND 5 |
Sort4 [Sortierung (4)] | 15 | Input | SortingField | False |
| [Sort4] BETWEEN 0 AND 5 |
Sort5 [Sortierung (5)] | 16 | Input | SortingField | False |
| [Sort5] BETWEEN 0 AND 5 |
Sort6 [Sortierung (6)] | 17 | Input | SortingField | False |
| [Sort6] BETWEEN 0 AND 5 |
DECLARE @CategoryCompleteCaption NVARCHAR(255);
SELECT @CategoryCompleteCaption = CompleteCaption
FROM dbo.Category
WHERE ID = @Category;
SELECT C.CompleteCaption AS CategoryCompleteCaption,
A.ID AS ArticleID,
SAV.OldestArticleNumberYear,
SAV.OldestArticleNumber,
SAV.NewestArticleNumberYear,
SAV.NewestArticleNumber,
SAV.LastProductionYear,
A.Caption AS ArticleCaption,
A.Remarks AS ArticleRemarks,
AV.ID AS ArticleVariantID,
MC.Caption AS MainColorCaption,
CO.Caption AS ColorCaption,
L.Caption AS LanguageCaption,
SAV.DocumentCount,
SAV.PartsListCount,
SAV.PartsCount,
I.JpegThumbnail AS JpegImageThumbnail,
SAV.WebLink AS ArticleVariantWebLink
FROM dbo.Category AS C
INNER JOIN dbo.Article AS A ON A.Category = C.ID
INNER JOIN dbo.ArticleVariant AS AV ON AV.Article = A.ID
LEFT JOIN dbo.Color AS CO ON CO.ID = AV.Color
LEFT JOIN dbo.MainColor AS MC ON MC.ID = CO.MainColor
LEFT JOIN dbo.Language AS L ON L.ID = AV.Language
LEFT JOIN dbo.SupplementArticleVariant AS SAV ON SAV.ID = AV.ID
LEFT JOIN dbo.Image AS I ON I.ID = SAV.LargestImageId
LEFT JOIN dbo.ImageType AS IT ON IT.ID = I.ImageType
WHERE (@Category IS NULL
OR C.CompleteCaption = @CategoryCompleteCaption
OR (@IncludingSubcategories = 1 AND C.CompleteCaption LIKE @CategoryCompleteCaption + N' - _%'))
AND (@MainColor IS NULL OR MC.ID = @MainColor)
AND (@Color IS NULL OR AV.Color = @Color)
AND (@Language IS NULL OR AV.Language = @Language)
AND (@Number IS NULL
OR EXISTS(SELECT *
FROM dbo.ArticleNumber AS AN
WHERE AN.ArticleVariant = AV.ID
AND AN.Number LIKE REPLACE(REPLACE(@Number, N'?', N'_'), N'*', N'%')))
AND (@ArticleNumberValidInYear IS NULL
OR (EXISTS(SELECT *
FROM dbo.ArticleNumber AS AN
WHERE AN.ArticleVariant = AV.ID
AND AN.FromYear IS NOT NULL
AND AN.FromYear <= @ArticleNumberValidInYear
AND (@Number IS NULL
OR AN.Number LIKE REPLACE(REPLACE(@Number, N'?', N'_'), N'*', N'%'))
AND NOT EXISTS(SELECT *
FROM dbo.ArticleNumber AS AN2
WHERE (AN2.ArticleVariant <> AN.ArticleVariant
OR (AN2.ArticleVariant = AN.ArticleVariant
AND AN2.Number IS NULL))
AND AN2.FromYear <= @ArticleNumberValidInYear
AND AN2.FromYear > AN.FromYear))))
AND (@OnlyWithDocuments = 0
OR EXISTS(SELECT *
FROM dbo.Document AS D
WHERE D.ArticleVariant = AV.ID))
AND (@Article IS NULL OR A.ID = @Article)
AND (@ArticleVariant IS NULL OR AV.ID = @ArticleVariant)
AND (@ContainedArticleVariant IS NULL
OR EXISTS(SELECT *
FROM dbo.PartsList AS PL
WHERE PL.ArticleVariant = AV.ID
AND PL.ContainedArticle = @ContainedArticleVariant))
ORDER BY CASE @Sort1
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort2
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort3
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort4
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort5
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort6
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
Name | Index | Direction | Type | IsNullable | Settings | Persistable CHECK expression |
Category [Nur diese Kategorie (leer = alle)] | 0 | Input | ReferenceField | True |
| |
IncludingSubcategories [Mit Unterkategorien] | 1 | Input | BooleanField | False |
| |
MainColor [Nur diese Hauptfarbe (leer = alle)] | 2 | Input | ReferenceField | True |
| |
Color [Nur diese Farbe (leer = alle)] | 3 | Input | ReferenceField | True |
| |
Language [Nur diese Sprache (leer = alle)] | 4 | Input | ReferenceField | True |
| |
Number [Nur dieses Artikelnummer-Muster (leer = alle)] | 5 | Input | StringField | True |
| [Number] IS NULL OR DATALENGTH([Number]) >= 2 |
ArticleNumberValidInYear [Artikelnummer gültig in Jahr] | 6 | Input | YearField | True |
| [ArticleNumberValidInYear] IS NULL OR [ArticleNumberValidInYear] BETWEEN 1960 AND 2099 |
OnlyWithDocuments [Nur mit Dokumenten] | 7 | Input | BooleanField | False |
| |
Article [Nur dieser Artikel (leer = alle] | 8 | Input | ReferenceField | True |
| |
ArticleVariant [Nur diese Artikelvariante (leer = alle)] | 9 | Input | ReferenceField | True |
| |
ContainedArticleVariant [Nur mit enthaltenem Teil (leer = alle)] | 10 | Input | ReferenceField | True |
| |
Sort1 [Sortierung (1)] | 11 | Input | SortingField | False |
| [Sort1] BETWEEN 0 AND 5 |
ShowGroupHeader [Gruppenköpfe ausgeben] | 12 | Input | BooleanField | False |
| |
Sort2 [Sortierung (2)] | 13 | Input | SortingField | False |
| [Sort2] BETWEEN 0 AND 5 |
Sort3 [Sortierung (3)] | 14 | Input | SortingField | False |
| [Sort3] BETWEEN 0 AND 5 |
Sort4 [Sortierung (4)] | 15 | Input | SortingField | False |
| [Sort4] BETWEEN 0 AND 5 |
Sort5 [Sortierung (5)] | 16 | Input | SortingField | False |
| [Sort5] BETWEEN 0 AND 5 |
Sort6 [Sortierung (6)] | 17 | Input | SortingField | False |
| [Sort6] BETWEEN 0 AND 5 |
DECLARE @CategoryCompleteCaption NVARCHAR(255);
SELECT @CategoryCompleteCaption = CompleteCaption
FROM dbo.Category
WHERE ID = @Category;
SELECT C.CompleteCaption AS CategoryCompleteCaption,
A.ID AS ArticleID,
SAV.OldestArticleNumberYear,
SAV.OldestArticleNumber,
SAV.NewestArticleNumberYear,
SAV.NewestArticleNumber,
SAV.LastProductionYear,
A.Caption AS ArticleCaption,
A.Remarks AS ArticleRemarks,
AV.ID AS ArticleVariantID,
MC.Caption AS MainColorCaption,
CO.Caption AS ColorCaption,
L.Caption AS LanguageCaption,
SAV.DocumentCount,
SAV.PartsListCount,
SAV.PartsCount,
I.JpegThumbnail AS JpegImageThumbnail,
SAV.WebLink AS ArticleVariantWebLink
FROM dbo.Category AS C
INNER JOIN dbo.Article AS A ON A.Category = C.ID
INNER JOIN dbo.ArticleVariant AS AV ON AV.Article = A.ID
LEFT JOIN dbo.Color AS CO ON CO.ID = AV.Color
LEFT JOIN dbo.MainColor AS MC ON MC.ID = CO.MainColor
LEFT JOIN dbo.Language AS L ON L.ID = AV.Language
LEFT JOIN dbo.SupplementArticleVariant AS SAV ON SAV.ID = AV.ID
LEFT JOIN dbo.Image AS I ON I.ID = SAV.LargestImageId
LEFT JOIN dbo.ImageType AS IT ON IT.ID = I.ImageType
WHERE (@Category IS NULL
OR C.CompleteCaption = @CategoryCompleteCaption
OR (@IncludingSubcategories = 1 AND C.CompleteCaption LIKE @CategoryCompleteCaption + N' - _%'))
AND (@MainColor IS NULL OR MC.ID = @MainColor)
AND (@Color IS NULL OR AV.Color = @Color)
AND (@Language IS NULL OR AV.Language = @Language)
AND (@Number IS NULL
OR EXISTS(SELECT *
FROM dbo.ArticleNumber AS AN
WHERE AN.ArticleVariant = AV.ID
AND AN.Number LIKE REPLACE(REPLACE(@Number, N'?', N'_'), N'*', N'%')))
AND (@ArticleNumberValidInYear IS NULL
OR (EXISTS(SELECT *
FROM dbo.ArticleNumber AS AN
WHERE AN.ArticleVariant = AV.ID
AND AN.FromYear IS NOT NULL
AND AN.FromYear <= @ArticleNumberValidInYear
AND (@Number IS NULL
OR AN.Number LIKE REPLACE(REPLACE(@Number, N'?', N'_'), N'*', N'%'))
AND NOT EXISTS(SELECT *
FROM dbo.ArticleNumber AS AN2
WHERE (AN2.ArticleVariant <> AN.ArticleVariant
OR (AN2.ArticleVariant = AN.ArticleVariant
AND AN2.Number IS NULL))
AND AN2.FromYear <= @ArticleNumberValidInYear
AND AN2.FromYear > AN.FromYear))))
AND (@OnlyWithDocuments = 0
OR EXISTS(SELECT *
FROM dbo.Document AS D
WHERE D.ArticleVariant = AV.ID))
AND (@Article IS NULL OR A.ID = @Article)
AND (@ArticleVariant IS NULL OR AV.ID = @ArticleVariant)
AND (@ContainedArticleVariant IS NULL
OR EXISTS(SELECT *
FROM dbo.PartsList AS PL
WHERE PL.ArticleVariant = AV.ID
AND PL.ContainedArticle = @ContainedArticleVariant))
ORDER BY CASE @Sort1
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort2
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort3
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort4
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort5
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END,
CASE @Sort6
WHEN 0 THEN C.CompleteCaption
WHEN 1 THEN A.Caption
WHEN 2 THEN SAV.NewestArticleNumber
WHEN 3 THEN L.Caption
WHEN 4 THEN MC.Caption + N'/' + CO.Caption
END;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
Name | Index | Direction | Type | IsNullable |
Textsuche | 0 | Input | StringField | True |
SELECT T0.ID
FROM dbo.V_ArticleNumber AS T0
INNER JOIN dbo.ArticleVariant AS T1 ON T1.ID = T0.ArticleVariant
INNER JOIN dbo.Article AS T2 ON T2.ID = T1.Article
INNER JOIN dbo.Category AS T3 ON T3.ID = T2.Category
LEFT JOIN dbo.Color AS T4 ON T4.ID = T1.Color
LEFT JOIN dbo.MainColor AS T5 ON T5.ID = T4.MainColor
LEFT JOIN dbo.Language AS T6 ON T6.ID = T1.Language
WHERE T0.Number LIKE (REPLACE(REPLACE(@Textsuche, N'?', N'_'), N'*', N'%') + N'%')
OR T2.Caption LIKE (REPLACE(REPLACE(@Textsuche, N'?', N'_'), N'*', N'%') + N'%')
OR T3.CompleteCaption LIKE (REPLACE(REPLACE(@Textsuche, N'?', N'_'), N'*', N'%') + N'%')
OR T4.Caption LIKE (REPLACE(REPLACE(@Textsuche, N'?', N'_'), N'*', N'%') + N'%')
OR T5.Caption LIKE (REPLACE(REPLACE(@Textsuche, N'?', N'_'), N'*', N'%') + N'%')
OR T6.Caption LIKE (REPLACE(REPLACE(@Textsuche, N'?', N'_'), N'*', N'%') + N'%')
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Bezeichnung) / 2 AS BezeichnungAutoLength,
DATALENGTH(Bemerkungen) / 2 AS BemerkungenAutoLength,
DATEPART(YEAR, CreationTime) AS CreationTimeAutoYear,
DATEPART(MONTH, CreationTime) AS CreationTimeAutoMonth,
DATEPART(DAY, CreationTime) AS CreationTimeAutoDay,
DATEPART(WEEKDAY, CreationTime) % 7 AS CreationTimeAutoWeekday,
DATEPART(HOUR, CreationTime) AS CreationTimeAutoHour,
DATEPART(MINUTE, CreationTime) AS CreationTimeAutoMinute,
DATEPART(SECOND, CreationTime) AS CreationTimeAutoSecond,
DATALENGTH(CreationUser) / 2 AS CreationUserAutoLength,
DATEPART(YEAR, LastUpdateTime) AS LastUpdateTimeAutoYear,
DATEPART(MONTH, LastUpdateTime) AS LastUpdateTimeAutoMonth,
DATEPART(DAY, LastUpdateTime) AS LastUpdateTimeAutoDay,
DATEPART(WEEKDAY, LastUpdateTime) % 7 AS LastUpdateTimeAutoWeekday,
DATEPART(HOUR, LastUpdateTime) AS LastUpdateTimeAutoHour,
DATEPART(MINUTE, LastUpdateTime) AS LastUpdateTimeAutoMinute,
DATEPART(SECOND, LastUpdateTime) AS LastUpdateTimeAutoSecond,
DATALENGTH(LastUpdateUser) / 2 AS LastUpdateUserAutoLength
FROM dbo.V_AdHocAnalysisQueryDefinition;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Caption) / 2 AS CaptionAutoLength,
DATALENGTH(Remarks) / 2 AS RemarksAutoLength
FROM dbo.V_Article;
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
SELECT ID,
(SELECT MIN(NewerAN.FromYear) - 1
FROM dbo.V_ArticleNumber AS NewerAN
WHERE NewerAN.ArticleVariant = AN.ArticleVariant
AND NewerAN.FromYear > AN.FromYear) AS ValidUntil,
(SELECT TOP 1 OldAN.ID --MSSQL
--PGSQL: (SELECT OldAN.ID
FROM dbo.V_ArticleNumber AS OldAN
WHERE OldAN.ArticleVariant <> AN.ArticleVariant
AND OldAN.FromYear < AN.FromYear
AND OldAN.Number = AN.Number
ORDER BY OldAN.FromYear DESC
--PGSQL: LIMIT 1
) AS NumberPreusedIn,
(SELECT TOP 1 NewAN.ID --MSSQL
--PGSQL: (SELECT NewAN.ID
FROM dbo.V_ArticleNumber AS NewAN
WHERE NewAN.ArticleVariant <> AN.ArticleVariant
AND NewAN.FromYear > AN.FromYear
AND NewAN.Number = AN.Number
ORDER BY NewAN.FromYear
--PGSQL: LIMIT 1
) AS NumberReusedIn
FROM dbo.ArticleNumber AS AN
WHERE AN.FromYear IS NOT NULL
AND AN.Number IS NOT NULL;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Number) / 2 AS NumberAutoLength
FROM dbo.V_ArticleNumber;
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
SELECT AV.ID,
CASE WHEN AV.Year IS NULL AND AV.Language IS NULL AND AV.Color IS NULL
THEN NULL
ELSE LTRIM(RTRIM(REPLACE(COALESCE(CAST(Year AS NVARCHAR(4)), N'') + N' ' --MSSQL
+ COALESCE(L.Caption, N'') + N' ' --MSSQL
+ CASE WHEN MC.Caption = C.Caption --MSSQL
THEN N'' --MSSQL
ELSE COALESCE(MC.Caption + N'/', N'') --MSSQL
END --MSSQL
+ COALESCE(C.Caption, N''), --MSSQL
N' ', N' '))) --MSSQL
--PGSQL: ELSE LTRIM(RTRIM(REPLACE(COALESCE(CAST(Year AS NVARCHAR(4)), N'') || N' '
--PGSQL: || COALESCE(L.Caption, N'') || N' '
--PGSQL: || CASE WHEN MC.Caption = C.Caption
--PGSQL: THEN N''
--PGSQL: ELSE COALESCE(MC.Caption || N'/', N'')
--PGSQL: END
--PGSQL: || COALESCE(C.Caption, N''),
--PGSQL: N' ', N' ')))
END AS ArticleVariantText,
(SELECT TOP 1 I.ID --MSSQL
--PGSQL: (SELECT I.ID
FROM dbo.Image AS I
WHERE I.ArticleVariant = AV.ID
ORDER BY (CAST(I.Width AS INTEGER) * CAST(I.Height AS INTEGER))
--PGSQL: LIMIT 1
) AS SmallestImageId,
(SELECT TOP 1 I.ID --MSSQL
--PGSQL: (SELECT I.ID
FROM dbo.Image AS I
WHERE I.ArticleVariant = AV.ID
ORDER BY (CAST(I.Width AS INTEGER) * CAST(I.Height AS INTEGER)) DESC
--PGSQL: LIMIT 1
) AS LargestImageId,
(SELECT TOP 1 I.ID --MSSQL
--PGSQL: (SELECT I.ID
FROM dbo.Image AS I
WHERE I.ArticleVariant = AV.ID
AND Width <= 360
AND Height <= 360
ORDER BY (CAST(I.Width AS INTEGER) * CAST(I.Height AS INTEGER)) DESC
--PGSQL: LIMIT 1
) AS LargestImageIdUpTo360,
(SELECT TOP 1 FromYear --MSSQL
--PGSQL: (SELECT FromYear
FROM dbo.ArticleNumber
WHERE ArticleVariant = AV.ID
AND Number IS NOT NULL
ORDER BY FromYear
--PGSQL: LIMIT 1
) AS OldestArticleNumberYear,
(SELECT TOP 1 Number --MSSQL
--PGSQL: (SELECT Number
FROM dbo.ArticleNumber
WHERE ArticleVariant = AV.ID
AND Number IS NOT NULL
ORDER BY FromYear
--PGSQL: LIMIT 1
) AS OldestArticleNumber,
(SELECT TOP 1 FromYear --MSSQL
--PGSQL: (SELECT FromYear
FROM dbo.ArticleNumber
WHERE ArticleVariant = AV.ID
AND Number IS NOT NULL
ORDER BY FromYear DESC
--PGSQL: LIMIT 1
) AS NewestArticleNumberYear,
(SELECT TOP 1 Number --MSSQL
--PGSQL: (SELECT Number
FROM dbo.ArticleNumber
WHERE ArticleVariant = AV.ID
AND Number IS NOT NULL
ORDER BY FromYear DESC
--PGSQL: LIMIT 1
) AS NewestArticleNumber,
(SELECT MAX(AN.FromYear) - 1
FROM dbo.ArticleNumber AS AN
WHERE AN.ArticleVariant = AV.ID
AND AN.Number IS NULL
AND EXISTS(SELECT *
FROM dbo.ArticleNumber AS PrevAN
WHERE PrevAN.ArticleVariant = AN.ArticleVariant
AND PrevAN.Number IS NOT NULL
AND PrevAN.FromYear < AN.FromYear)
) AS LastProductionYear,
(SELECT COUNT(*)
FROM dbo.Document
WHERE ArticleVariant = AV.ID) AS DocumentCount,
(SELECT COUNT(*)
FROM dbo.PartsList
WHERE ArticleVariant = AV.ID) AS PartsListCount,
(SELECT SUM(Amount)
FROM dbo.PartsList
WHERE ArticleVariant = AV.ID) AS PartsCount,
N'http://www.ft-datenbank.de/details.php?ArticleVariantId='
+ CAST(AV.ID AS NVARCHAR(38)) AS WebLink --MSSQL
--PGSQL: || CAST(AV.ID AS NVARCHAR(38)) AS WebLink
FROM dbo.ArticleVariant AS AV
LEFT JOIN dbo.Language AS L ON L.ID = AV.Language
LEFT JOIN dbo.Color AS C ON C.ID = AV.Color
LEFT JOIN dbo.MainColor AS MC ON MC.ID = C.MainColor;
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
SELECT ID,
dbo.LibArticleNumberTextByArticleVariant(ID) AS ArticleNumberText
FROM dbo.V_ArticleVariant;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Remarks) / 2 AS RemarksAutoLength
FROM dbo.V_ArticleVariant;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Caption) / 2 AS CaptionAutoLength,
DATALENGTH(Remarks) / 2 AS RemarksAutoLength
FROM dbo.V_AttachmentSource;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Caption) / 2 AS CaptionAutoLength,
DATALENGTH(CompleteCaption) / 2 AS CompleteCaptionAutoLength
FROM dbo.V_Category;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Caption) / 2 AS CaptionAutoLength
FROM dbo.V_Color;
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
SELECT ID,
N'http://www.ft-datenbank.de/web_document.php?id='
+ CONVERT(NVARCHAR(38), ID) --MSSQL
--PGSQL: || ID
AS WebLink
FROM dbo.Document;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Description) / 2 AS DescriptionAutoLength,
DATALENGTH(Attachment) AS AttachmentAutoDataLength,
DATALENGTH(OriginalFileName) / 2 AS OriginalFileNameAutoLength
FROM dbo.V_Document;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(ExtensionWithoutDot) / 2 AS ExtensionWithoutDotAutoLength,
DATALENGTH(MimeType) / 2 AS MimeTypeAutoLength
FROM dbo.V_DocumentType;
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
SELECT ID,
N'http://www.ft-datenbank.de/web_image.php?id='
+ CONVERT(NVARCHAR(38), ID) --MSSQL
--PGSQL: || ID
AS WebLink,
N'http://www.ft-datenbank.de/web_image.php?param=thumb&id='
+ CONVERT(NVARCHAR(38), ID) --MSSQL
--PGSQL: || ID
AS WebThumbnailLink
FROM dbo.Image;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Description) / 2 AS DescriptionAutoLength,
DATALENGTH(Attachment) AS AttachmentAutoDataLength,
DATALENGTH(OriginalFileName) / 2 AS OriginalFileNameAutoLength
FROM dbo.V_Image;
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
SELECT ID,
DATALENGTH(Caption) / 2 AS CaptionAutoLength
FROM dbo.V_ImageSubject;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(ExtensionWithoutDot) / 2 AS ExtensionWithoutDotAutoLength,
DATALENGTH(MimeType) / 2 AS MimeTypeAutoLength
FROM dbo.V_ImageType;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Caption) / 2 AS CaptionAutoLength
FROM dbo.V_Language;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(Caption) / 2 AS CaptionAutoLength
FROM dbo.V_MainColor;
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
SELECT ID,
DATEPART(YEAR, CreationTime) AS CreationTimeAutoYear,
DATEPART(MONTH, CreationTime) AS CreationTimeAutoMonth,
DATEPART(DAY, CreationTime) AS CreationTimeAutoDay,
DATEPART(WEEKDAY, CreationTime) % 7 AS CreationTimeAutoWeekday,
DATEPART(HOUR, CreationTime) AS CreationTimeAutoHour,
DATEPART(MINUTE, CreationTime) AS CreationTimeAutoMinute,
DATEPART(SECOND, CreationTime) AS CreationTimeAutoSecond,
DATALENGTH(CreationUser) / 2 AS CreationUserAutoLength
FROM dbo.V_ProcedureInvocation;
Permission | Role |
X | Editors |
X | Reader |
X | FtdbWebsite |
SELECT ID,
DATALENGTH(Bezeichnung) / 2 AS BezeichnungAutoLength,
DATALENGTH(Comments) / 2 AS CommentsAutoLength,
DATEPART(YEAR, CreationTime) AS CreationTimeAutoYear,
DATEPART(MONTH, CreationTime) AS CreationTimeAutoMonth,
DATEPART(DAY, CreationTime) AS CreationTimeAutoDay,
DATEPART(WEEKDAY, CreationTime) % 7 AS CreationTimeAutoWeekday,
DATEPART(HOUR, CreationTime) AS CreationTimeAutoHour,
DATEPART(MINUTE, CreationTime) AS CreationTimeAutoMinute,
DATEPART(SECOND, CreationTime) AS CreationTimeAutoSecond,
DATALENGTH(CreationUser) / 2 AS CreationUserAutoLength
FROM dbo.V_ProcedureInvocationGroup;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATEPART(YEAR, ReminderDate) AS ReminderDateAutoYear,
DATEPART(MONTH, ReminderDate) AS ReminderDateAutoMonth,
DATEPART(DAY, ReminderDate) AS ReminderDateAutoDay,
DATEPART(WEEKDAY, ReminderDate) % 7 AS ReminderDateAutoWeekday,
DATALENGTH(Caption) / 2 AS CaptionAutoLength,
DATALENGTH(Remarks) / 2 AS RemarksAutoLength,
DATALENGTH(Resolver) / 2 AS ResolverAutoLength,
DATEPART(YEAR, ResolvedDate) AS ResolvedDateAutoYear,
DATEPART(MONTH, ResolvedDate) AS ResolvedDateAutoMonth,
DATEPART(DAY, ResolvedDate) AS ResolvedDateAutoDay,
DATEPART(WEEKDAY, ResolvedDate) % 7 AS ResolvedDateAutoWeekday,
DATEPART(HOUR, ResolvedDate) AS ResolvedDateAutoHour,
DATEPART(MINUTE, ResolvedDate) AS ResolvedDateAutoMinute,
DATEPART(YEAR, CreationTime) AS CreationTimeAutoYear,
DATEPART(MONTH, CreationTime) AS CreationTimeAutoMonth,
DATEPART(DAY, CreationTime) AS CreationTimeAutoDay,
DATEPART(WEEKDAY, CreationTime) % 7 AS CreationTimeAutoWeekday,
DATEPART(HOUR, CreationTime) AS CreationTimeAutoHour,
DATEPART(MINUTE, CreationTime) AS CreationTimeAutoMinute,
DATEPART(SECOND, CreationTime) AS CreationTimeAutoSecond,
DATALENGTH(CreationUser) / 2 AS CreationUserAutoLength,
DATEPART(YEAR, LastUpdateTime) AS LastUpdateTimeAutoYear,
DATEPART(MONTH, LastUpdateTime) AS LastUpdateTimeAutoMonth,
DATEPART(DAY, LastUpdateTime) AS LastUpdateTimeAutoDay,
DATEPART(WEEKDAY, LastUpdateTime) % 7 AS LastUpdateTimeAutoWeekday,
DATEPART(HOUR, LastUpdateTime) AS LastUpdateTimeAutoHour,
DATEPART(MINUTE, LastUpdateTime) AS LastUpdateTimeAutoMinute,
DATEPART(SECOND, LastUpdateTime) AS LastUpdateTimeAutoSecond,
DATALENGTH(LastUpdateUser) / 2 AS LastUpdateUserAutoLength
FROM dbo.V_Reminder;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATEPART(YEAR, ChangeTime) AS ChangeTimeAutoYear,
DATEPART(MONTH, ChangeTime) AS ChangeTimeAutoMonth,
DATEPART(DAY, ChangeTime) AS ChangeTimeAutoDay,
DATEPART(WEEKDAY, ChangeTime) % 7 AS ChangeTimeAutoWeekday,
DATEPART(HOUR, ChangeTime) AS ChangeTimeAutoHour,
DATEPART(MINUTE, ChangeTime) AS ChangeTimeAutoMinute,
DATEPART(SECOND, ChangeTime) AS ChangeTimeAutoSecond,
DATALENGTH(SystemUserName) / 2 AS SystemUserNameAutoLength,
DATALENGTH(LoggedTableFriendlyName) / 2 AS LoggedTableFriendlyNameAutoLength,
DATALENGTH(LoggedRowDescription) / 2 AS LoggedRowDescriptionAutoLength
FROM dbo.V_RowChangeLog;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
SELECT ID,
DATALENGTH(FieldFriendlyName) / 2 AS FieldFriendlyNameAutoLength,
DATALENGTH(OldValueText) / 2 AS OldValueTextAutoLength,
DATALENGTH(NewValueText) / 2 AS NewValueTextAutoLength
FROM dbo.V_RowChangeLogFieldValue;
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
Name | Index | Direction | Type | IsNullable |
DeleteBefore [Änderungsprotokoll löschen vor] | 0 | Input | DateTimeField | False |
DeletedEntries [Gelöschte Einträge] | 1 | Output | IntegerField | True |
DELETE FROM dbo.RowChangeLog WHERE ChangeTime < @DeleteBefore AND ChangeTime < DATEADD(DAY, -366, GETDATE());
SET @DeletedEntries = @@ROWCOUNT;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
(None)
(None)
SELECT *
FROM dbo.WebDownloadArticleNumbers
ORDER BY KategoriePfad, Artikel, Hauptfarbe, Farbe, AbJahr;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
(None)
(None)
SELECT *
FROM dbo.WebDownloadImageInfo
ORDER BY KategoriePfad, Artikel, Hauptfarbe, Farbe, Breite, Hoehe;
Permission | Role |
X | Editors |
X | Reader |
- | FtdbWebsite |
(None)
(None)
SELECT *
FROM dbo.WebDownloadPartsList
ORDER BY KategoriePfad, Baukasten, Einzelteil, Hauptfarbe, Farbe;
Permission | Role |
X | Editors |
- | Reader |
- | FtdbWebsite |
(None)
(None)
(None)
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT AV.ID AS ArticleVariantId,
A.Category AS CategoryId,
CA.Caption AS CategoryCaption,
CA.CompleteCaption AS CategoryCompleteCaption,
A.Caption,
MC.ID AS MainColorId,
CASE WHEN MC.Caption = C.Caption THEN C.Caption
ELSE MC.Caption + ' (' + C.Caption + ')' --MSSQL
--PGSQL: ELSE MC.Caption || ' (' || C.Caption || ')'
END AS Color,
FN.FirstYear,
AN.FromYear, AN.Number,
SAV.SmallestImageId AS ImageId
FROM dbo.Article AS A
INNER JOIN dbo.Category AS CA ON CA.ID = A.Category
INNER JOIN dbo.ArticleVariant AS AV ON AV.Article = A.ID
LEFT JOIN dbo.Color AS C ON C.ID = AV.Color
LEFT JOIN dbo.MainColor AS MC ON MC.ID = C.MainColor
LEFT JOIN dbo.ArticleNumber AS AN ON AN.ArticleVariant = AV.ID AND Number IS NOT NULL
LEFT JOIN dbo.SupplementArticleVariant AS SAV ON SAV.ID = AV.ID
LEFT JOIN dbo.LibFirstYearByArticleVariant AS FN ON FN.ArticleVariant = AV.ID;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT AV.ID AS ArticleVariantId,
CA.ID AS CategoryId,
CA.CompleteCaption AS CategoryCompleteCaption,
A.Caption,
CASE WHEN MC.Caption = C.Caption THEN C.Caption
ELSE MC.Caption + ' (' + C.Caption + ')' --MSSQL
--PGSQL: ELSE MC.Caption || ' (' || C.Caption || ')'
END AS Color,
A.Remarks
FROM dbo.Article AS A
INNER JOIN dbo.ArticleVariant AS AV ON AV.Article = A.ID
INNER JOIN dbo.Category AS CA ON CA.ID = A.Category
LEFT JOIN dbo.Color AS C ON C.ID = AV.Color
LEFT JOIN dbo.MainColor AS MC ON MC.ID = C.MainColor;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT ArticleVariant AS ArticleVariantId,
FromYear, Number
FROM dbo.ArticleNumber;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT D.ID AS DocumentId,
D.ArticleVariant AS ArticleVariantId,
D.Description, D.Attachment, D.OriginalFileName,
DT.MimeType,
S.Caption AS AttachmentSource
FROM dbo.Document AS D
INNER JOIN dbo.DocumentType AS DT ON DT.ID = D.DocumentType
INNER JOIN dbo.AttachmentSource AS S ON S.ID = D.AttachmentSource;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT I.ArticleVariant AS ArticleVariantId,
I.ID AS ImageId,
I.Description, I.Attachment, I.OriginalFileName, I.Width, I.Height,
CAST(I.Width AS INTEGER) * CAST(I.Height AS INTEGER) AS Size,
IT.MimeType,
S.Caption AS AttachmentSource
FROM dbo.Image AS I
INNER JOIN dbo.ImageType AS IT ON IT.ID = I.ImageType
INNER JOIN dbo.AttachmentSource AS S ON S.ID = I.AttachmentSource;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT PL.ArticleVariant, PL.ContainedArticle AS ContainedArticleVariantId, PL.Amount,
AV.Caption, AV.Color, AV.ImageId
FROM dbo.PartsList AS PL
INNER JOIN dbo.WebArticleVariant AS AV ON AV.ArticleVariantId = PL.ContainedArticle;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT PL.ArticleVariant, PL.ContainedArticle AS ContainedArticleVariantId, PL.Amount,
AV.Caption, AV.ImageId
FROM dbo.PartsList AS PL
INNER JOIN dbo.WebArticleVariant AS AV ON AV.ArticleVariantId = PL.ArticleVariant;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT ID AS CategoryId, ParentCategory AS ParentCategoryId, Caption, CompleteCaption
FROM dbo.Category;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT D.ID AS DocumentId, D.Attachment, DT.MimeType, D.OriginalFileName
FROM dbo.Document AS D
INNER JOIN dbo.DocumentType AS DT ON DT.ID = D.DocumentType;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT C.Caption AS Kategorie, C.CompleteCaption AS KategoriePfad,
A.Caption AS Artikel,
AV.ID AS ArtikelVarianteID,
MC.Caption AS Hauptfarbe,
CO.Caption AS Farbe,
AN.FromYear AS AbJahr,
AN.Number AS Artikelnummer
FROM dbo.Category AS C
INNER JOIN dbo.Article AS A ON A.Category = C.ID
INNER JOIN dbo.ArticleVariant AS AV ON AV.Article = A.ID
LEFT JOIN dbo.Color AS CO ON CO.ID = AV.Color
LEFT JOIN dbo.MainColor AS MC ON MC.ID = CO.MainColor
LEFT JOIN dbo.ArticleNumber AS AN ON AN.ArticleVariant = AV.ID;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT C.Caption AS Kategorie, C.CompleteCaption AS KategoriePfad,
A.Caption AS Artikel,
AV.ID AS ArtikelVarianteID,
MC.Caption AS Hauptfarbe,
CO.Caption AS Farbe,
I.OriginalFileName AS OriginalDateiname,
S.Caption AS Bildquelle,
IT.ExtensionWithoutDot AS Bildtyp,
IT.MimeType AS MimeType,
I.Width AS Breite,
I.Height AS Hoehe,
SI.WebLink
FROM dbo.Category AS C
INNER JOIN dbo.Article AS A ON A.Category = C.ID
INNER JOIN dbo.ArticleVariant AS AV ON AV.Article = A.ID
LEFT JOIN dbo.Color AS CO ON CO.ID = AV.Color
LEFT JOIN dbo.MainColor AS MC ON MC.ID = CO.MainColor
INNER JOIN dbo.Image AS I ON I.ArticleVariant = AV.ID
INNER JOIN dbo.SupplementImage AS SI ON SI.ID = I.ID
INNER JOIN dbo.AttachmentSource AS S ON S.ID = I.AttachmentSource
INNER JOIN dbo.ImageType AS IT ON IT.ID = I.ImageType;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT C.Caption AS Kategorie, C.CompleteCaption AS KategoriePfad,
A.Caption AS Baukasten,
AV.ID AS BaukastenArtikelVarianteID,
PLAV.ID AS EinzelteilArtikelVarianteID,
PLA.Caption AS Einzelteil,
PLMC.Caption AS Hauptfarbe,
PLCO.Caption AS Farbe,
PL.Amount AS Anzahl
FROM dbo.Category AS C
INNER JOIN dbo.Article AS A ON A.Category = C.ID
INNER JOIN dbo.ArticleVariant AS AV ON AV.Article = A.ID
INNER JOIN dbo.PartsList AS PL ON PL.ArticleVariant = AV.ID
INNER JOIN dbo.ArticleVariant AS PLAV ON PLAV.ID = PL.ContainedArticle
INNER JOIN dbo.Article AS PLA ON PLA.ID = PLAV.Article
LEFT JOIN dbo.Color AS PLCO ON PLCO.ID = PLAV.Color
LEFT JOIN dbo.MainColor AS PLMC ON PLMC.ID = PLCO.MainColor;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT I.ID AS ImageId, I.Attachment, IT.MimeType, I.OriginalFileName, I.Thumbnail
FROM dbo.Image AS I
INNER JOIN dbo.ImageType AS IT ON IT.ID = I.ImageType;
Permission | Role |
- | Editors |
- | Reader |
X | FtdbWebsite |
SELECT ID, Caption
FROM dbo.MainColor;
A - B - D - E - G - I - K - L - M - S - V - W
A - C - D - E - G - H - I - L - R - S - T - W
Object | Object Type | Parent Type | Parent |
FolderName [Ordner für Dateiausgabe] | ProcedureParameterTemplateField | Procedure | ExecuteProcedureInvocationGroup [Befehlsgruppe ausführen] |
TargetFolder [Zielordner] | ProcedureParameterTemplateField | Procedure | ExportToCsvSet [Export zu vollständigem CSV-Satz] |
Zieldateiname | ProcedureParameterTemplateField | Procedure | ExportToPostgres [Export der Datenbank nach Postgres] |
Object | Object Type | Parent Type | Parent |
AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | Table | ||
Reminder [Wiedervorlage] | Table |
(Optimal layout found after 00:00:00.0048336 with cost 79.)
(Optimal layout found after 00:00:00.0223709 with cost 5,968.)
A - C - D - E - G - H - I - L - R - S - T - W
(Optimal layout found after 00:00:00.0073084 with cost 79.)
(Optimal layout found after 00:00:00.0304348 with cost 5,968.)
A - C - D - E - G - H - I - L - R - S - T - W
(Optimal layout found after 00:00:00.0053692 with cost 79.)
(Optimal layout found after 00:00:00.0241383 with cost 5,968.)
A - C - D - E - G - H - I - L - R - S - T - W
No writing roles defined. All roles may write.
Field | IsNullable | FieldType | UserInterface |
DefaultValidFileExtensions [Standardmäßig zugelassene Dateinamenserweiterungen für Dateianlagen] | False | ValidFileExtensionsField | Editable |
ReportServerName [Name/URL des Berichtsservers] | False | StringField | Editable |
ReportManagerDirectory [Berichtsserver-Manager-Verzeichnis] | False | StringField | Editable |
ReportWebServiceDirectory [Berichtsserver-Webservice-Verzeichnis] | False | StringField | Editable |
ReportFolderName [Berichts-Ordnername (mit '/' beginnend und endend)] | False | StringField | Editable |
ReportExecution [Berichtsausführung] | False | EnumerationField | Editable |
No writing roles defined. All roles may write.
Field | IsNullable | FieldType | UserInterface |
ReminderCheckOnStartDays [Beim Start auf Wiedervorlagen prüfen für] | False | EnumerationField | Editable |
ReminderCheckOnStartCreator [Beim Start Wiedervorlagen prüfen von] | False | EnumerationField | Editable |
FormScalingPercent [Skalierung der Ansicht in Prozent (nach Neustart)] | False | IntegerField | Editable |
AskBeforeApplicationQuit [Beim Beenden von SF Parts nachfragen] | False | BooleanField | Editable |
ID = c1ffde0e-b9d0-4615-9a43-9a98d91b36b6
Type | CommandTimeoutSeconds | Statements |
ChangeIntegerFieldRange | 0 | ALTER TABLE dbo.DatabaseVersion DROP CONSTRAINT CK_DatabaseVersion_Uniqueness; ALTER TABLE dbo.DatabaseVersion WITH CHECK ADD CONSTRAINT CK_DatabaseVersion_Uniqueness CHECK (Uniqueness BETWEEN 0 AND 255); |
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
ID = b7aea8ab-db0f-4b44-a755-bc9faa52f716
Type | CommandTimeoutSeconds | Statements |
AddIndex | 3600 | IF NOT EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'Article' AND i.Name = N'Category') CREATE NONCLUSTERED INDEX Category ON dbo.Article(Category); |
Type | CommandTimeoutSeconds | Statements |
AddTable | 0 | CREATE TABLE dbo.Reminder ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_Reminder PRIMARY KEY NONCLUSTERED CONSTRAINT DF_Reminder_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, ReminderDate DATETIME NOT NULL CONSTRAINT CK_Reminder_ReminderDate CHECK((ReminderDate BETWEEN CONVERT(DATETIME, '1900-01-01 00:00:00', 121) AND CONVERT(DATETIME, '2099-12-31 00:00:00', 121)) AND (DATEPART(HOUR, ReminderDate) = 0 AND DATEPART(MINUTE, ReminderDate) = 0 AND DATEPART(SECOND, ReminderDate) = 0 AND DATEPART(MILLISECOND, ReminderDate) = 0)), Caption NVARCHAR(255) NOT NULL CONSTRAINT CK_Reminder_Caption CHECK(DATALENGTH(Caption) >= 2), RowReference XML NULL, Remarks NVARCHAR(1000) NULL CONSTRAINT CK_Reminder_Remarks CHECK(Remarks IS NULL OR DATALENGTH(Remarks) >= 2), IsResolved BIT NOT NULL CONSTRAINT DF_Reminder_IsResolved DEFAULT(0), Resolver NVARCHAR(128) NULL CONSTRAINT CK_Reminder_Resolver CHECK(Resolver IS NULL OR DATALENGTH(Resolver) >= 2), ResolvedDate DATETIME NULL CONSTRAINT CK_Reminder_ResolvedDate CHECK((ResolvedDate IS NULL OR ResolvedDate BETWEEN CONVERT(DATETIME, '1900-01-01 00:00:00', 121) AND CONVERT(DATETIME, '2099-12-31 00:00:00', 121)) AND (ResolvedDate IS NULL OR (DATEPART(SECOND, ResolvedDate) = 0 AND DATEPART(MILLISECOND, ResolvedDate) = 0))), CreationTime DATETIME NULL CONSTRAINT CK_Reminder_CreationTime CHECK(CreationTime IS NULL OR CreationTime BETWEEN CONVERT(DATETIME, '1900-01-01 00:00:00', 121) AND CONVERT(DATETIME, '2099-12-31 00:00:00', 121)), CreationUser NVARCHAR(128) NULL CONSTRAINT CK_Reminder_CreationUser CHECK(CreationUser IS NULL OR DATALENGTH(CreationUser) >= 2) CONSTRAINT DF_Reminder_CreationUser DEFAULT(SYSTEM_USER), LastUpdateTime DATETIME NULL CONSTRAINT CK_Reminder_LastUpdateTime CHECK(LastUpdateTime IS NULL OR LastUpdateTime BETWEEN CONVERT(DATETIME, '1900-01-01 00:00:00', 121) AND CONVERT(DATETIME, '2099-12-31 00:00:00', 121)), LastUpdateUser NVARCHAR(128) NULL CONSTRAINT CK_Reminder_LastUpdateUser CHECK(LastUpdateUser IS NULL OR DATALENGTH(LastUpdateUser) >= 2), CONSTRAINT CK_Reminder_ROW_1 CHECK(((IsResolved = 0) OR (Resolver IS NOT NULL))), CONSTRAINT CK_Reminder_ROW_2 CHECK(((IsResolved = 1) OR (Resolver IS NULL))), CONSTRAINT CK_Reminder_ROW_3 CHECK(((IsResolved = 0) OR (ResolvedDate IS NOT NULL))), CONSTRAINT CK_Reminder_ROW_4 CHECK(((IsResolved = 1) OR (ResolvedDate IS NULL))) ); CREATE UNIQUE CLUSTERED INDEX ReminderDateCreationUserCaptionCreationTime ON dbo.Reminder(ReminderDate DESC, CreationUser, Caption, CreationTime DESC); CREATE NONCLUSTERED INDEX CreationTime ON dbo.Reminder(CreationTime); CREATE NONCLUSTERED INDEX ResolvedDate ON dbo.Reminder(ResolvedDate); CREATE NONCLUSTERED INDEX Resolver ON dbo.Reminder(Resolver); GO |
Type | CommandTimeoutSeconds | Statements |
AddTable | 0 | CREATE TABLE dbo.ProcedureInvocationGroup ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_ProcedureInvocationGroup PRIMARY KEY NONCLUSTERED CONSTRAINT DF_ProcedureInvocationGroup_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, Bezeichnung NVARCHAR(255) NOT NULL CONSTRAINT CK_ProcedureInvocationGroup_Bezeichnung CHECK(DATALENGTH(Bezeichnung) >= 2), Comments NVARCHAR(1000) NULL CONSTRAINT CK_ProcedureInvocationGroup_Comments CHECK(Comments IS NULL OR DATALENGTH(Comments) >= 2), VisibleForOthers BIT NOT NULL CONSTRAINT DF_ProcedureInvocationGroup_VisibleForOthers DEFAULT(0), CreationTime DATETIME NULL CONSTRAINT CK_ProcedureInvocationGroup_CreationTime CHECK(CreationTime IS NULL OR CreationTime BETWEEN CONVERT(DATETIME, '1900-01-01 00:00:00', 121) AND CONVERT(DATETIME, '2099-12-31 00:00:00', 121)), CreationUser NVARCHAR(128) NULL CONSTRAINT CK_ProcedureInvocationGroup_CreationUser CHECK(CreationUser IS NULL OR DATALENGTH(CreationUser) >= 2) CONSTRAINT DF_ProcedureInvocationGroup_CreationUser DEFAULT(SYSTEM_USER) ); CREATE UNIQUE CLUSTERED INDEX BezeichnungCreationUser ON dbo.ProcedureInvocationGroup(Bezeichnung, CreationUser); GO |
AddTable | 0 | CREATE TABLE dbo.ProcedureInvocation ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_ProcedureInvocation PRIMARY KEY NONCLUSTERED CONSTRAINT DF_ProcedureInvocation_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, ProcedureInvocationGroup UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ProcedureInvocation_ProcedureInvocationGroup_ProcedureInvocationGroup_ID FOREIGN KEY REFERENCES dbo.ProcedureInvocationGroup(ID) ON DELETE CASCADE, ExecutionOrder INTEGER NOT NULL CONSTRAINT CK_ProcedureInvocation_ExecutionOrder CHECK(ExecutionOrder BETWEEN 0 AND 2147483647), Info XML NOT NULL, Description NVARCHAR(1000) NOT NULL CONSTRAINT CK_ProcedureInvocation_Description CHECK(DATALENGTH(Description) >= 2), CreationTime DATETIME NULL CONSTRAINT CK_ProcedureInvocation_CreationTime CHECK(CreationTime IS NULL OR CreationTime BETWEEN CONVERT(DATETIME, '1900-01-01 00:00:00', 121) AND CONVERT(DATETIME, '2099-12-31 00:00:00', 121)), CreationUser NVARCHAR(128) NULL CONSTRAINT CK_ProcedureInvocation_CreationUser CHECK(CreationUser IS NULL OR DATALENGTH(CreationUser) >= 2) CONSTRAINT DF_ProcedureInvocation_CreationUser DEFAULT(SYSTEM_USER) ); CREATE UNIQUE CLUSTERED INDEX ProcedureInvocationGroupExecutionOrderDescriptionID ON dbo.ProcedureInvocation(ProcedureInvocationGroup, ExecutionOrder, Description, ID); GO |
Type | CommandTimeoutSeconds | Statements |
AddField | 0 | ALTER TABLE dbo.Image ADD Thumbnail VARBINARY(MAX) NULL; GO |
Type | CommandTimeoutSeconds | Statements |
AddField | 0 | ALTER TABLE dbo.Image ADD Year SMALLINT NULL CONSTRAINT CK_Image_Year CHECK(Year IS NULL OR Year BETWEEN 1950 AND 2099); GO |
AddField | 0 | ALTER TABLE dbo.Document ADD Year SMALLINT NULL CONSTRAINT CK_Document_Year CHECK(Year IS NULL OR Year BETWEEN 1950 AND 2099); GO |
Type | CommandTimeoutSeconds | Statements |
AddTable | 0 | CREATE TABLE dbo.Language ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_Language PRIMARY KEY NONCLUSTERED CONSTRAINT DF_Language_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, Caption NVARCHAR(50) NOT NULL CONSTRAINT CK_Language_Caption CHECK(DATALENGTH(Caption) >= 2) ); CREATE UNIQUE CLUSTERED INDEX Caption ON dbo.Language(Caption); GO |
AddField | 0 | ALTER TABLE dbo.ArticleVariant ADD Language UNIQUEIDENTIFIER NULL CONSTRAINT FK_ArticleVariant_Language_Language_ID FOREIGN KEY REFERENCES dbo.Language(ID) ON DELETE NO ACTION; GO |
AddIndex | 3600 | IF NOT EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'ArticleVariant' AND i.Name = N'Language') CREATE NONCLUSTERED INDEX Language ON dbo.ArticleVariant(Language); |
ReplaceIndex | 60 | IF EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'ArticleVariant' AND i.Name = N'ArticleColor') DROP INDEX dbo.ArticleVariant.ArticleColor; CREATE UNIQUE CLUSTERED INDEX ArticleColorLanguage ON dbo.ArticleVariant(Article, Color, Language); |
Type | CommandTimeoutSeconds | Statements |
ChangeIntegerFieldRange | 0 | ALTER TABLE dbo.Image DROP CONSTRAINT CK_Image_Width; ALTER TABLE dbo.Image WITH CHECK ADD CONSTRAINT CK_Image_Width CHECK (Width BETWEEN 1 AND 32767); |
ChangeIntegerFieldRange | 0 | ALTER TABLE dbo.Image DROP CONSTRAINT CK_Image_Height; ALTER TABLE dbo.Image WITH CHECK ADD CONSTRAINT CK_Image_Height CHECK (Height BETWEEN 1 AND 32767); |
AddTable | 0 | CREATE TABLE dbo.ImageSubject ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_ImageSubject PRIMARY KEY NONCLUSTERED CONSTRAINT DF_ImageSubject_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, Caption NVARCHAR(50) NOT NULL CONSTRAINT CK_ImageSubject_Caption CHECK(DATALENGTH(Caption) >= 2) ); CREATE UNIQUE CLUSTERED INDEX Caption ON dbo.ImageSubject(Caption); GO |
AddField | 0 | ALTER TABLE dbo.Image ADD ImageSubject UNIQUEIDENTIFIER NULL CONSTRAINT FK_Image_ImageSubject_ImageSubject_ID FOREIGN KEY REFERENCES dbo.ImageSubject(ID) ON DELETE NO ACTION; GO |
AddIndex | 3600 | IF NOT EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'Image' AND i.Name = N'ImageSubject') CREATE NONCLUSTERED INDEX ImageSubject ON dbo.Image(ImageSubject); |
Type | CommandTimeoutSeconds | Statements |
AddTable | 0 | CREATE TABLE dbo.RowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_RowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_RowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, ChangeNumber INTEGER NOT NULL IDENTITY(1, 1), ChangeTime DATETIME NOT NULL CONSTRAINT CK_RowChangeLog_ChangeTime CHECK(ChangeTime BETWEEN CONVERT(DATETIME, '1900-01-01 00:00:00', 121) AND CONVERT(DATETIME, '2099-12-31 00:00:00', 121)), SystemUserName NVARCHAR(128) NOT NULL CONSTRAINT CK_RowChangeLog_SystemUserName CHECK(DATALENGTH(SystemUserName) >= 2) CONSTRAINT DF_RowChangeLog_SystemUserName DEFAULT(SYSTEM_USER), ChangeType TINYINT NOT NULL CONSTRAINT CK_RowChangeLog_ChangeType CHECK(ChangeType BETWEEN 0 AND 2), LoggedTableName NVARCHAR(128) NOT NULL CONSTRAINT CK_RowChangeLog_LoggedTableName CHECK(DATALENGTH(LoggedTableName) >= 2), LoggedTableFriendlyName NVARCHAR(255) NOT NULL CONSTRAINT CK_RowChangeLog_LoggedTableFriendlyName CHECK(DATALENGTH(LoggedTableFriendlyName) >= 2), LoggedRowId UNIQUEIDENTIFIER NOT NULL, LoggedRowDescription NVARCHAR(4000) NULL CONSTRAINT CK_RowChangeLog_LoggedRowDescription CHECK(LoggedRowDescription IS NULL OR DATALENGTH(LoggedRowDescription) >= 2), LoggedRowReference XML NOT NULL ); CREATE UNIQUE CLUSTERED INDEX ChangeNumber ON dbo.RowChangeLog(ChangeNumber DESC); CREATE UNIQUE NONCLUSTERED INDEX ChangeNumberChangeTimeChangeType ON dbo.RowChangeLog(ChangeNumber DESC, ChangeTime DESC, ChangeType); CREATE UNIQUE NONCLUSTERED INDEX LoggedRowIdChangeNumber ON dbo.RowChangeLog(LoggedRowId, ChangeNumber DESC); GO |
AddTable | 0 | CREATE TABLE dbo.RowChangeLogFieldValue ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_RowChangeLogFieldValue PRIMARY KEY NONCLUSTERED CONSTRAINT DF_RowChangeLogFieldValue_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_RowChangeLogFieldValue_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, FieldIndex INTEGER NOT NULL CONSTRAINT CK_RowChangeLogFieldValue_FieldIndex CHECK(FieldIndex BETWEEN 0 AND 2147483647), FieldName NVARCHAR(128) NOT NULL CONSTRAINT CK_RowChangeLogFieldValue_FieldName CHECK(DATALENGTH(FieldName) >= 2), FieldFriendlyName NVARCHAR(256) NOT NULL CONSTRAINT CK_RowChangeLogFieldValue_FieldFriendlyName CHECK(DATALENGTH(FieldFriendlyName) >= 2), OldValueText NVARCHAR(1000) NULL CONSTRAINT CK_RowChangeLogFieldValue_OldValueText CHECK(OldValueText IS NULL OR DATALENGTH(OldValueText) >= 2), NewValueText NVARCHAR(1000) NULL CONSTRAINT CK_RowChangeLogFieldValue_NewValueText CHECK(NewValueText IS NULL OR DATALENGTH(NewValueText) >= 2), OldValue XML NULL, NewValue XML NULL, OldBlobValue VARBINARY(MAX) NULL, NewBlobValue VARBINARY(MAX) NULL, CONSTRAINT CK_RowChangeLogFieldValue_ROW_1 CHECK(((OldValue IS NULL) AND (OldBlobValue IS NULL)) OR (((OldValue IS NOT NULL) AND (OldBlobValue IS NULL)) OR ((OldValue IS NULL) AND (OldBlobValue IS NOT NULL)))), CONSTRAINT CK_RowChangeLogFieldValue_ROW_2 CHECK(((NewValue IS NULL) AND (NewBlobValue IS NULL)) OR (((NewValue IS NOT NULL) AND (NewBlobValue IS NULL)) OR ((NewValue IS NULL) AND (NewBlobValue IS NOT NULL)))) ); CREATE UNIQUE CLUSTERED INDEX RowChangeLogFieldIndex ON dbo.RowChangeLogFieldValue(RowChangeLog, FieldIndex); CREATE UNIQUE NONCLUSTERED INDEX RowChangeLogFieldName ON dbo.RowChangeLogFieldValue(RowChangeLog, FieldName); GO |
AddTable | 0 | CREATE TABLE dbo.CategoryRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_CategoryRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_CategoryRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_CategoryRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, Category UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_CategoryRowChangeLog_Category_Category_ID FOREIGN KEY REFERENCES dbo.Category(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.CategoryRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX CategoryRowChangeLog ON dbo.CategoryRowChangeLog(Category, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.MainColorRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_MainColorRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_MainColorRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_MainColorRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, MainColor UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_MainColorRowChangeLog_MainColor_MainColor_ID FOREIGN KEY REFERENCES dbo.MainColor(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.MainColorRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX MainColorRowChangeLog ON dbo.MainColorRowChangeLog(MainColor, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.ColorRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_ColorRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_ColorRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ColorRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, Color UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ColorRowChangeLog_Color_Color_ID FOREIGN KEY REFERENCES dbo.Color(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.ColorRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX ColorRowChangeLog ON dbo.ColorRowChangeLog(Color, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.ArticleRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_ArticleRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_ArticleRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ArticleRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, Article UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ArticleRowChangeLog_Article_Article_ID FOREIGN KEY REFERENCES dbo.Article(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.ArticleRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX ArticleRowChangeLog ON dbo.ArticleRowChangeLog(Article, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.ArticleVariantRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_ArticleVariantRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_ArticleVariantRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ArticleVariantRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, ArticleVariant UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ArticleVariantRowChangeLog_ArticleVariant_ArticleVariant_ID FOREIGN KEY REFERENCES dbo.ArticleVariant(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.ArticleVariantRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX ArticleVariantRowChangeLog ON dbo.ArticleVariantRowChangeLog(ArticleVariant, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.ArticleNumberRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_ArticleNumberRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_ArticleNumberRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ArticleNumberRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, ArticleNumber UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ArticleNumberRowChangeLog_ArticleNumber_ArticleNumber_ID FOREIGN KEY REFERENCES dbo.ArticleNumber(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.ArticleNumberRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX ArticleNumberRowChangeLog ON dbo.ArticleNumberRowChangeLog(ArticleNumber, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.PartsListRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_PartsListRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_PartsListRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_PartsListRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, PartsList UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_PartsListRowChangeLog_PartsList_PartsList_ID FOREIGN KEY REFERENCES dbo.PartsList(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.PartsListRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX PartsListRowChangeLog ON dbo.PartsListRowChangeLog(PartsList, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.AttachmentSourceRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_AttachmentSourceRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_AttachmentSourceRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_AttachmentSourceRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, AttachmentSource UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_AttachmentSourceRowChangeLog_AttachmentSource_AttachmentSource_ID FOREIGN KEY REFERENCES dbo.AttachmentSource(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.AttachmentSourceRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX AttachmentSourceRowChangeLog ON dbo.AttachmentSourceRowChangeLog(AttachmentSource, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.DocumentTypeRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_DocumentTypeRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_DocumentTypeRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_DocumentTypeRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, DocumentType UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_DocumentTypeRowChangeLog_DocumentType_DocumentType_ID FOREIGN KEY REFERENCES dbo.DocumentType(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.DocumentTypeRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX DocumentTypeRowChangeLog ON dbo.DocumentTypeRowChangeLog(DocumentType, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.ImageTypeRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_ImageTypeRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_ImageTypeRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ImageTypeRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, ImageType UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ImageTypeRowChangeLog_ImageType_ImageType_ID FOREIGN KEY REFERENCES dbo.ImageType(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.ImageTypeRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX ImageTypeRowChangeLog ON dbo.ImageTypeRowChangeLog(ImageType, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.ImageRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_ImageRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_ImageRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ImageRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, Image UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ImageRowChangeLog_Image_Image_ID FOREIGN KEY REFERENCES dbo.Image(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.ImageRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX ImageRowChangeLog ON dbo.ImageRowChangeLog(Image, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.DocumentRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_DocumentRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_DocumentRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_DocumentRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, Document UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_DocumentRowChangeLog_Document_Document_ID FOREIGN KEY REFERENCES dbo.Document(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.DocumentRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX DocumentRowChangeLog ON dbo.DocumentRowChangeLog(Document, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.AdHocAnalysisQueryDefinitionRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_AdHocAnalysisQueryDefinitionRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_AdHocAnalysisQueryDefinitionRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_AdHocAnalysisQueryDefinitionRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, AdHocAnalysisQueryDefinition UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_AdHocAnalysisQueryDefinitionRowChangeLog_AdHocAnalysisQueryDefinition_AdHocAnalysisQueryDefinition_ID FOREIGN KEY REFERENCES dbo.AdHocAnalysisQueryDefinition(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.AdHocAnalysisQueryDefinitionRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX AdHocAnalysisQueryDefinitionRowChangeLog ON dbo.AdHocAnalysisQueryDefinitionRowChangeLog(AdHocAnalysisQueryDefinition, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.LanguageRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_LanguageRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_LanguageRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_LanguageRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, Language UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_LanguageRowChangeLog_Language_Language_ID FOREIGN KEY REFERENCES dbo.Language(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.LanguageRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX LanguageRowChangeLog ON dbo.LanguageRowChangeLog(Language, RowChangeLog); GO |
AddTable | 0 | CREATE TABLE dbo.ImageSubjectRowChangeLog ( ID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL CONSTRAINT PK_ImageSubjectRowChangeLog PRIMARY KEY NONCLUSTERED CONSTRAINT DF_ImageSubjectRowChangeLog_ID DEFAULT(NEWID()), TS TIMESTAMP NOT NULL, RowChangeLog UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ImageSubjectRowChangeLog_RowChangeLog_RowChangeLog_ID FOREIGN KEY REFERENCES dbo.RowChangeLog(ID) ON DELETE CASCADE, ImageSubject UNIQUEIDENTIFIER NOT NULL CONSTRAINT FK_ImageSubjectRowChangeLog_ImageSubject_ImageSubject_ID FOREIGN KEY REFERENCES dbo.ImageSubject(ID) ON DELETE CASCADE ); CREATE UNIQUE CLUSTERED INDEX RowChangeLog ON dbo.ImageSubjectRowChangeLog(RowChangeLog); CREATE UNIQUE NONCLUSTERED INDEX ImageSubjectRowChangeLog ON dbo.ImageSubjectRowChangeLog(ImageSubject, RowChangeLog); GO |
AddField | 0 | ALTER TABLE dbo.Article ADD WeightInG FLOAT NULL CONSTRAINT CK_Article_WeightInG CHECK((WeightInG IS NULL OR WeightInG BETWEEN 0 AND 99999) AND (WeightInG IS NULL OR WeightInG <> 0)); GO |
Type | CommandTimeoutSeconds | Statements |
AddField | 0 | ALTER TABLE dbo.ArticleVariant ADD Year SMALLINT NULL CONSTRAINT CK_ArticleVariant_Year CHECK(Year IS NULL OR Year BETWEEN 1960 AND 2099); GO |
AddIndex | 3600 | IF NOT EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'ArticleVariant' AND i.Name = N'Year') CREATE NONCLUSTERED INDEX Year ON dbo.ArticleVariant(Year); |
ReplaceIndex | 60 | IF EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'ArticleVariant' AND i.Name = N'ArticleColorLanguage') DROP INDEX dbo.ArticleVariant.ArticleColorLanguage; CREATE UNIQUE CLUSTERED INDEX ArticleYearColorLanguage ON dbo.ArticleVariant(Article, Year, Color, Language); |
AddField | 0 | ALTER TABLE dbo.ArticleVariant ADD Remarks NVARCHAR(999) NULL CONSTRAINT CK_ArticleVariant_Remarks CHECK(Remarks IS NULL OR DATALENGTH(Remarks) >= 2); GO |
Type | CommandTimeoutSeconds | Statements |
MoveField | 0 | |
AddField | 0 | ALTER TABLE dbo.Image ADD JpegThumbnail VARBINARY(MAX) NULL; GO |
Type | CommandTimeoutSeconds | Statements |
RemoveIndex | 0 | IF EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'Article' AND i.Name = N'Caption') DROP INDEX dbo.Article.Caption; |
RemoveIndex | 0 | IF EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'Article' AND i.Name = N'Category') DROP INDEX dbo.Article.Category; |
ID = 6241dad7-e0a5-4ba8-989f-1ed7fa7a56a9
(None)
ID = edde7d1c-de0b-4da2-948f-3cca79370218
Type | CommandTimeoutSeconds | Statements |
ReplaceFieldInIndexes | 0 | IF EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'ProcedureInvocation' AND i.Name = N'ProcedureInvocationGroupExecutionOrderDescriptionID') DROP INDEX dbo.ProcedureInvocation.ProcedureInvocationGroupExecutionOrderDescriptionID; CREATE UNIQUE CLUSTERED INDEX ProcedureInvocationGroupExecutionOrderCreationTimeID ON dbo.ProcedureInvocation(ProcedureInvocationGroup, ExecutionOrder, CreationTime, ID); |
ChangeStringFieldMaxLength | 0 | ALTER TABLE dbo.ProcedureInvocation DROP CONSTRAINT CK_ProcedureInvocation_Description; UPDATE dbo.ProcedureInvocation SET Description = SUBSTRING(Description, 1, 400) WHERE DATALENGTH(Description) > 800; ALTER TABLE dbo.ProcedureInvocation ALTER COLUMN Description NVARCHAR(400) NOT NULL; ALTER TABLE dbo.ProcedureInvocation WITH CHECK ADD CONSTRAINT CK_ProcedureInvocation_Description CHECK (DATALENGTH(Description) >= 2); |
ReplaceFieldInIndexes | 0 | IF EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'ProcedureInvocation' AND i.Name = N'ProcedureInvocationGroupExecutionOrderCreationTimeID') DROP INDEX dbo.ProcedureInvocation.ProcedureInvocationGroupExecutionOrderCreationTimeID; CREATE UNIQUE CLUSTERED INDEX ProcedureInvocationGroupExecutionOrderDescriptionID ON dbo.ProcedureInvocation(ProcedureInvocationGroup, ExecutionOrder, Description, ID); |
ID = 5fe648a2-1658-44d7-9c9b-baa4ef11b346
Type | CommandTimeoutSeconds | Statements |
AddField | 0 | ALTER TABLE dbo.RowChangeLogFieldValue ADD OldGuidValue UNIQUEIDENTIFIER NULL; GO |
AddField | 0 | ALTER TABLE dbo.RowChangeLogFieldValue ADD NewGuidValue UNIQUEIDENTIFIER NULL; GO |
DirectSql | 120 | UPDATE dbo.RowChangeLogFieldValue SET OldGuidValue = OldValue.value('/*[1]', 'UNIQUEIDENTIFIER') WHERE CONVERT(NVARCHAR(MAX), OldValue) LIKE N'<anytype %d1p1:type="q1:guid">________-____-____-____-____________</anytype>' |
DirectSql | 120 | UPDATE dbo.RowChangeLogFieldValue SET NewGuidValue = NewValue.value('/*[1]', 'UNIQUEIDENTIFIER') WHERE CONVERT(NVARCHAR(MAX), NewValue) LIKE N'<anytype %d1p1:type="q1:guid">________-____-____-____-____________</anytype>' |
AddIndex | 3600 | IF NOT EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'RowChangeLogFieldValue' AND i.Name = N'OldGuidValue') CREATE NONCLUSTERED INDEX OldGuidValue ON dbo.RowChangeLogFieldValue(OldGuidValue); |
AddIndex | 3600 | IF NOT EXISTS(SELECT * FROM sys.objects AS O INNER JOIN sys.indexes AS I ON I.object_id = O.object_id WHERE o.name = N'RowChangeLogFieldValue' AND i.Name = N'NewGuidValue') CREATE NONCLUSTERED INDEX NewGuidValue ON dbo.RowChangeLogFieldValue(NewGuidValue); |
(End of Documentation)