(c) 2013 SF Softwareberatung. All rights reserved.
29.01.2013 20:21:08
(Optimal layout found after 00:00:01.5579107 with cost 62.)
| 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)
(None)
| Name | Unique | Fields | Usage |
| ID | True |
| |
| Bezeichnung | True |
|
|
(None)
(None)
(None)
(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 |
| Remarks [Bemerkungen] | True | StringField | Editable |
| Field | Type | Nullable | Settings | Persisted CHECK expression |
| ID | PrimaryKeyField | False |
| |
| TS | TimestampField | False |
| |
| Caption [Bezeichnung] | StringField | False |
| DATALENGTH([Caption]) >= 2 |
| Category [Kategorie] | ReferenceField | False |
| |
| 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 |
| ArticleVariant [Artikelvariante] | Article [Artikel] | False | OneToMany | True |
| Name | Unique | Fields | Usage |
| ID | True |
| |
| Caption | True |
| |
| CategoryCaption | True |
|
|
| CaptionCategory | True |
|
|
| Category | False |
|
(None)
(None)
(None)
(None)
(None)
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 | 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 |
(None)
| Name | Unique | Fields | Usage |
| ID | True |
| |
| ArticleVariantFromYear | True |
| |
| ArticleVariantFromYearNumber | True |
|
|
| Number | False |
|
(None)
| Type | Action | Persisted CHECK expression |
| FieldsNotNullRowValidator | Abort | (FromYear IS NOT NULL) OR (Number IS NOT NULL) |
| SimilarRowExistsRowValidator | Warn |
(None)
(None)
(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 |
| Color [Farbe] | True | ReferenceField | Editable |
| Language [Sprache] | True | ReferenceField | Editable |
| Field | IsNullable | FieldType | UserInterface | Supplement |
| SmallestImageId [Kleinstes Bild] | True | ReferenceField | (VisibleReadOnly) | SupplementArticleVariant |
| LargestImageId [Größtes Bild] | True | ReferenceField | (VisibleReadOnly) | SupplementArticleVariant |
| OldestArticleNumberYear [Ältestes Artikelnummer-Jahr] | True | YearField | (VisibleReadOnly) | SupplementArticleVariant |
| OldestArticleNumber [Älteste Artikelnummer] | True | StringField | (VisibleReadOnly) | SupplementArticleVariant |
| NewestArticleNumberYear [Jüngstes Artikelnummer-Jahr] | True | YearField | (VisibleReadOnly) | SupplementArticleVariant |
| NewestArticleNumber [Jüngste Artikelnummer] | True | StringField | (VisibleReadOnly) | SupplementArticleVariant |
| Field | Type | Nullable | Settings | Persisted CHECK expression |
| ID | PrimaryKeyField | False |
| |
| TS | TimestampField | False |
| |
| Article [Artikel] | ReferenceField | False |
| |
| Color [Farbe] | ReferenceField | True |
| |
| Language [Sprache] | ReferenceField | True |
|
| 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 |
| Image [Bild] | ArticleVariant [Artikelvariante] | False | OneToMany | True |
| Document [Dokument] | 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 |
| |
| ArticleColorLanguage | True |
|
|
(None)
(None)
(None)
| Name | Type | Settings | Persistable CHECK expression |
| SmallestImageId [Kleinstes Bild] | ReferenceField | ||
| LargestImageId [Größtes Bild] | 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 |
(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 |
(None)
| Table | Field | IsNullable | Type | CascadeDeletes |
| Image [Bild] | AttachmentSource [Dateianlagen-Quelle] | False | OneToMany | False |
| Document [Dokument] | AttachmentSource [Dateianlagen-Quelle] | False | OneToMany | False |
| Name | Unique | Fields | Usage |
| ID | True |
| |
| Caption | True |
|
|
(None)
(None)
(None)
(None)
(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 | 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 |
| Name | Unique | Fields | Usage |
| ID | True |
| |
| CompleteCaption | True |
|
|
| ParentCategoryCaption | True |
|
| Type | Watched Field |
| CategoryFiller | ParentCategory [Übergeordnete Kategorie] |
| CategoryFiller | Caption [Bezeichnung] |
(None)
(None)
(None)
(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 | 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 |
| Name | Unique | Fields | Usage |
| ID | True |
| |
| MainColorCaption | True |
|
|
(None)
(None)
(None)
(None)
(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)
| 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)
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 |
| 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 |
(None)
| Name | Unique | Fields | Usage |
| ID | True |
| |
| ArticleVariantDescription | True |
|
|
| AttachmentSource | False |
| |
| DocumentType | False |
|
| Type | Watched Field |
| AttachmentSetsDescription | Attachment [Anlage] |
| AttachmentSetsOriginalFileNameAndMimeTypeReference | Attachment [Anlage] |
(None)
(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 |
(None)
| Table | Field | IsNullable | Type | CascadeDeletes |
| Document [Dokument] | DocumentType [Dokumenttyp] | False | OneToMany | False |
| Name | Unique | Fields | Usage |
| ID | True |
| |
| ExtensionWithoutDot | True |
|
| Type | Watched Field |
| MimeTypeGenerator | (all fields watched) |
(None)
(None)
(None)
(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 |
| 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 |
| Thumbnail [Vorschaubild] | True | BitmapAttachmentField | Hidden |
| Year [Jahr] | True | YearField | Editable |
| Field | IsNullable | FieldType | UserInterface | Supplement |
| WebLink [Web-Link] | False | UriField | (VisibleReadOnly) | SupplementImage |
| WebThumbnailLink [Web-Link (Vorschaubild)] | False | UriField | (VisibleReadOnly) | SupplementImage |
| 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 |
| |
| 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 2048 |
| Height [Höhe/Pixel] | IntegerField | False |
| [Height] BETWEEN 1 AND 2048 |
| Thumbnail [Vorschaubild] | BitmapAttachmentField | True |
| |
| 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 |
| ImageType [Bildtyp] | ImageType [Bildtyp] | False | OneToMany | False |
(None)
| Name | Unique | Fields | Usage |
| ID | True |
| |
| ArticleVariantDescription | True |
|
|
| AttachmentSource | False |
| |
| ImageType | False |
|
| Type | Watched Field |
| AttachmentSetsDescription | Attachment [Bild] |
| AttachmentSetsOriginalFileNameAndMimeTypeReference | Attachment [Bild] |
| ImageSetsDimensionFields | Attachment [Bild] |
(None)
(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 |
(None)
| Table | Field | IsNullable | Type | CascadeDeletes |
| Image [Bild] | ImageType [Bildtyp] | False | OneToMany | False |
| Name | Unique | Fields | Usage |
| ID | True |
| |
| ExtensionWithoutDot | True |
|
| Type | Watched Field |
| MimeTypeGenerator | (all fields watched) |
(None)
(None)
(None)
(None)
(None)
| Field | IsNullable | FieldType | UserInterface |
| ID | False | PrimaryKeyField | Hidden |
| TS | False | TimestampField | Hidden |
| Caption [Bezeichnung] | False | StringField | Editable |
(None)
| Table | Field | IsNullable | Type | CascadeDeletes |
| ArticleVariant [Artikelvariante] | Language [Sprache] | True | OneToMany | False |
| Name | Unique | Fields | Usage |
| ID | True |
| |
| Caption | True |
|
|
(None)
(None)
(None)
(None)
(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 |
(None)
| Table | Field | IsNullable | Type | CascadeDeletes |
| Color [Farbe] | MainColor [Hauptfarbe] | False | OneToMany | False |
| Name | Unique | Fields | Usage |
| ID | True |
| |
| Caption | True |
|
|
(None)
(None)
(None)
(None)
(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 |
(None)
| Name | Unique | Fields | Usage |
| ID | True |
| |
| ArticleVariantContainedArticle | True |
|
|
| ContainedArticleArticleVariant | True |
|
(None)
| Type | Action | Persisted CHECK expression |
| GuidNotEqualRowValidator | Abort | ArticleVariant <> ContainedArticle |
(None)
(None)
(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 |
| 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 |
| BooleanFieldSetsAndClearsUserNameAndDateTime | IsResolved [Erledigt] |
| Type | Action | Persisted CHECK expression |
| FieldNotNullDependingOnBooleanFieldRowValidator | Abort | ((IsResolved = 0) OR (Resolver IS NOT NULL)) |
| FieldNotNullDependingOnBooleanFieldRowValidator | Abort | ((IsResolved = 1) OR (Resolver IS NULL)) |
| FieldNotNullDependingOnBooleanFieldRowValidator | Abort | ((IsResolved = 0) OR (ResolvedDate IS NOT NULL)) |
| FieldNotNullDependingOnBooleanFieldRowValidator | Abort | ((IsResolved = 1) OR (ResolvedDate IS NULL)) |
(None)
(None)
(None)
| Role | Select | Insert | Update | Delete | Import |
| Reader | ((dbo.AdHocAnalysisQueryDefinition.CreationUser = SYSTEM_USER) OR (dbo.AdHocAnalysisQueryDefinition.IsPublic = 1)) | - | - | - | - |
| Editors | X | X | X | X | 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 | - | - | - | - |
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 | - | - | - | - |
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 | - | - | - | - |
Quelle und Lizenz für Bilder und Dokumente.
| Role | Select | Insert | Update | Delete | Import |
| Editors | X | X | X | X | X |
| Reader | 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 | - | - | - | - |
Farben umfassen auch Farbvariationen und Schattierungen von Hauptfarben.
| Role | Select | Insert | Update | Delete | Import |
| Editors | X | X | X | X | X |
| Reader | 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 | - | - | - | - |
| Role | Select | Insert | Update | Delete | Import |
| Editors | X | X | X | X | X |
| Reader | 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 | - | - | - | - |
| Role | Select | Insert | Update | Delete | Import |
| Editors | X | X | X | X | X |
| Reader | X | - | - | - | - |
| Role | Select | Insert | Update | Delete | Import |
| Editors | X | X | X | X | X |
| Reader | X | - | - | - | - |
Hauptfarben enthalten nur einfache Farben ohne Farbvarianten oder Schattierungen.
| Role | Select | Insert | Update | Delete | Import |
| Editors | X | X | X | X | X |
| Reader | X | - | - | - | - |
Diese Tabelle beschreibt die Stückliste von Baukästen.
| Role | Select | Insert | Update | Delete | Import |
| Editors | X | X | X | X | X |
| Reader | 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 |
| Reader | (dbo.Reminder.CreationUser = SYSTEM_USER) | X | X | X | X |
| Editors | X | X | X | X | 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) |
| Table | Action | Persisted CHECK Expression |
| PartsList [Stückliste] | Abort | ArticleVariant <> ContainedArticle |
| Table | Action | Persisted CHECK Expression |
| ArticleNumber [Artikelnummer] | Warn |
| Table | Criteria Expression Sample |
| Article [Artikel] | ArticleID IN (SELECT dbo.ArticleVariantFind.ArticleVariantArticle FROM dbo.ArticleVariantFind INNER JOIN dbo.DocumentFind ON dbo.DocumentFind.DocumentArticleVariant = dbo.ArticleVariantFind.ArticleVariantID) |
| Table | Criteria Expression Sample |
| Article [Artikel] | 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] | ArticleID IN (SELECT dbo.ArticleVariantFind.ArticleVariantArticle FROM dbo.ArticleVariantFind INNER JOIN dbo.DocumentFind ON dbo.DocumentFind.DocumentArticleVariant = dbo.ArticleVariantFind.ArticleVariantID WHERE dbo.DocumentFind.DocumentDocumentType = @OnlyWithDocumentsOfType) |
| Article [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) |
| ArticleVariant [Artikelvariante] | ArticleVariantID IN (SELECT dbo.ArticleNumberFind.ArticleNumberArticleVariant FROM dbo.ArticleNumberFind WHERE dbo.ArticleNumberFind.ArticleNumberNumber LIKE (REPLACE(REPLACE(@Artikelnummer, N'*', N'%'), N'?', N'_') + N'%')) |
| ArticleVariant [Artikelvariante] | ArticleVariantID IN (SELECT dbo.PartsListFind.PartsListArticleVariant FROM dbo.PartsListFind WHERE dbo.PartsListFind.PartsListContainedArticle = @ContainedArticleVariant) |
| Field | Table | IsNullable | Supplement |
| QueryDefinition [Abfragedefinition] | AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | False |
| Field | Table | IsNullable | Supplement |
| RowReference [Betrifft Datensatz] | Reminder [Wiedervorlage] | True |
| Field | Table | IsNullable | Supplement |
| Attachment [Bild] | Image [Bild] | False | |
| Thumbnail [Vorschaubild] | Image [Bild] | True |
| Field | Table | IsNullable | Supplement |
| Attachment [Anlage] | Document [Dokument] | False |
| Field | Table | IsNullable | Supplement |
| Amount [Menge] | PartsList [Stückliste] | False | |
| DatabaseVersion | DatabaseVersion | False | |
| Height [Höhe/Pixel] | Image [Bild] | False | |
| Uniqueness | DatabaseVersion | False | |
| Width [Breite/Pixel] | Image [Bild] | False |
| Field | Table | IsNullable | Supplement |
| ID | AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | False | |
| ID | Article [Artikel] | False | |
| ID | ArticleNumber [Artikelnummer] | False | |
| ID | ArticleVariant [Artikelvariante] | False | |
| ID | AttachmentSource [Dateianlagen-Quelle] | False | |
| ID | Category [Kategorie] | False | |
| ID | Color [Farbe] | False | |
| ID | Configuration | False | |
| ID | DatabaseVersion | False | |
| ID | Document [Dokument] | False | |
| ID | DocumentType [Dokumenttyp] | False | |
| ID | Image [Bild] | False | |
| ID | ImageType [Bildtyp] | False | |
| ID | Language [Sprache] | False | |
| ID | MainColor [Hauptfarbe] | False | |
| ID | PartsList [Stückliste] | False | |
| ID | ProcedureInvocation [Befehlsaufruf] | False | |
| ID | ProcedureInvocationGroup [Befehlsgruppe] | False | |
| ID | Reminder [Wiedervorlage] | False |
| Field | Table | IsNullable | Supplement |
| Info [Befehl] | ProcedureInvocation [Befehlsaufruf] | False |
| Field | Table | IsNullable | Supplement |
| ExecutionOrder [Ausführungsreihenfolge] | ProcedureInvocation [Befehlsaufruf] | False |
| Field | Table | IsNullable | Supplement |
| TS | AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | False | |
| TS | Article [Artikel] | False | |
| TS | ArticleNumber [Artikelnummer] | False | |
| TS | ArticleVariant [Artikelvariante] | False | |
| TS | AttachmentSource [Dateianlagen-Quelle] | False | |
| TS | Category [Kategorie] | False | |
| TS | Color [Farbe] | False | |
| TS | Configuration | False | |
| TS | DatabaseVersion | False | |
| TS | Document [Dokument] | False | |
| TS | DocumentType [Dokumenttyp] | False | |
| TS | Image [Bild] | False | |
| TS | ImageType [Bildtyp] | False | |
| TS | Language [Sprache] | False | |
| TS | MainColor [Hauptfarbe] | False | |
| TS | PartsList [Stückliste] | False | |
| TS | ProcedureInvocation [Befehlsaufruf] | False | |
| TS | ProcedureInvocationGroup [Befehlsgruppe] | False | |
| TS | Reminder [Wiedervorlage] | False |
| Field | Table | IsNullable | Supplement |
| WebLink [Web-Link] | Document [Dokument] | False | SupplementDocument |
| WebLink [Web-Link] | Image [Bild] | False | SupplementImage |
| WebThumbnailLink [Web-Link (Vorschaubild)] | Image [Bild] | False | SupplementImage |
| Field | Table | IsNullable | Supplement |
| DatabaseVersion | DatabaseVersion | False | |
| ExecutionOrder [Ausführungsreihenfolge] | ProcedureInvocation [Befehlsaufruf] | False |
| Field | Table | IsNullable | Supplement |
| Data | Configuration | True |
| Field | Table | IsNullable | Supplement |
| TS | AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | False | |
| TS | Article [Artikel] | False | |
| TS | ArticleNumber [Artikelnummer] | False | |
| TS | ArticleVariant [Artikelvariante] | False | |
| TS | AttachmentSource [Dateianlagen-Quelle] | False | |
| TS | Category [Kategorie] | False | |
| TS | Color [Farbe] | False | |
| TS | Configuration | False | |
| TS | DatabaseVersion | False | |
| TS | Document [Dokument] | False | |
| TS | DocumentType [Dokumenttyp] | False | |
| TS | Image [Bild] | False | |
| TS | ImageType [Bildtyp] | False | |
| TS | Language [Sprache] | False | |
| TS | MainColor [Hauptfarbe] | False | |
| TS | PartsList [Stückliste] | False | |
| TS | ProcedureInvocation [Befehlsaufruf] | False | |
| TS | ProcedureInvocationGroup [Befehlsgruppe] | False | |
| TS | Reminder [Wiedervorlage] | False |
| Field | Table | IsNullable | Supplement |
| Uniqueness | DatabaseVersion | False |
| Field | Table | IsNullable | Supplement |
| Attachment [Anlage] | Document [Dokument] | False | |
| Attachment [Bild] | Image [Bild] | False | |
| Thumbnail [Vorschaubild] | Image [Bild] | True |
| Field | Table | IsNullable | Supplement |
| Info [Befehl] | ProcedureInvocation [Befehlsaufruf] | False | |
| QueryDefinition [Abfragedefinition] | AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | False | |
| RowReference [Betrifft Datensatz] | Reminder [Wiedervorlage] | True |
(None)
(None)
DELETE FROM dbo.Document;
DELETE FROM dbo.Image;
DELETE FROM dbo.PartsList;
DELETE FROM dbo.ArticleNumber;
DELETE FROM dbo.ArticleVariant;
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;
| Name | Index | Direction | Type | IsNullable |
| Pixels [Maximalanzahl Pixel in jeder Richtung] | 0 | Input | IntegerField | False |
| AnzahlBilder [Anzahl erzeugter Bilder] | 1 | Output | IntegerField | True |
(None)
| 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)
| Name | Index | Direction | Type | IsNullable |
| TargetFolder [Zielordner] | 0 | Input | FileNameField | False |
(None)
| 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)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
(None)
SELECT ArticleVariant, MIN(FromYear) AS FirstYear
FROM dbo.ArticleNumber
GROUP BY ArticleVariant;
(None)
SELECT ArticleVariant, MIN(CAST(Width AS INTEGER) * CAST(Height AS INTEGER)) AS MinSize
FROM dbo.Image
GROUP BY ArticleVariant;
| Name | Index | Direction | Type | IsNullable |
| 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 |
| ArticleNumberValidInYear [Artikelnummer gültig in Jahr] | 6 | Input | YearField | True |
| 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 |
| 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 |
|
DECLARE @CategoryCompleteCaption NVARCHAR(255)
SELECT @CategoryCompleteCaption = CompleteCaption
FROM dbo.Category
WHERE ID = @Category
SELECT C.CompleteCaption AS CategoryCompleteCaption,
A.ID AS ArticleID,
A.Caption AS ArticleCaption,
A.Remarks AS ArticleRemarks,
AV.ID AS ArticleVariantID,
MC.Caption AS MainColorCaption,
CO.Caption AS ColorCaption,
L.Caption AS LanguageCaption,
I.Thumbnail AS ImageThumbnail,
IT.MimeType AS ImageThumbnailMimeType
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 C.CompleteCaption, A.Caption, MC.Caption, CO.Caption, L.Caption
SELECT AV.ID,
(SELECT TOP 1 I.ID --MSSQL
--MYSQL: (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))
--MYSQL: LIMIT 1
) AS SmallestImageId,
(SELECT TOP 1 I.ID --MSSQL
--MYSQL: (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
--MYSQL: LIMIT 1
) AS LargestImageId,
(SELECT TOP 1 FromYear --MSSQL
--MYSQL: (SELECT FromYear
FROM dbo.ArticleNumber
WHERE ArticleVariant = AV.ID
AND Number IS NOT NULL
ORDER BY FromYear
--MYSQL: LIMIT 1
) AS OldestArticleNumberYear,
(SELECT TOP 1 Number --MSSQL
--MYSQL: (SELECT Number
FROM dbo.ArticleNumber
WHERE ArticleVariant = AV.ID
AND Number IS NOT NULL
ORDER BY FromYear
--MYSQL: LIMIT 1
) AS OldestArticleNumber,
(SELECT TOP 1 FromYear --MSSQL
--MYSQL: (SELECT FromYear
FROM dbo.ArticleNumber
WHERE ArticleVariant = AV.ID
AND Number IS NOT NULL
ORDER BY FromYear DESC
--MYSQL: LIMIT 1
) AS NewestArticleNumberYear,
(SELECT TOP 1 Number --MSSQL
--MYSQL: (SELECT Number
FROM dbo.ArticleNumber
WHERE ArticleVariant = AV.ID
AND Number IS NOT NULL
ORDER BY FromYear DESC
--MYSQL: LIMIT 1
) AS NewestArticleNumber
FROM dbo.ArticleVariant AS AV;
SELECT ID,
N'http://www.ft-datenbank.de/web_document.php?id='
+ CONVERT(NVARCHAR(38), ID) --MSSQL
--MYSQL: || ID
AS WebLink
FROM dbo.Document;
SELECT ID,
N'http://www.ft-datenbank.de/web_image.php?id='
+ CONVERT(NVARCHAR(38), ID) --MSSQL
--MYSQL: || ID
AS WebLink,
N'http://www.ft-datenbank.de/web_image.php?param=thumb&id='
+ CONVERT(NVARCHAR(38), ID) --MSSQL
--MYSQL: || ID
AS WebThumbnailLink
FROM dbo.Image;
(None)
(None)
SELECT *
FROM dbo.WebDownloadArticleNumbers
ORDER BY KategoriePfad, Artikel, Hauptfarbe, Farbe, AbJahr;
(None)
(None)
SELECT *
FROM dbo.WebDownloadImageInfo
ORDER BY KategoriePfad, Artikel, Hauptfarbe, Farbe, Breite, Hoehe;
(None)
(None)
SELECT *
FROM dbo.WebDownloadPartsList
ORDER BY KategoriePfad, Baukasten, Einzelteil, Hauptfarbe, Farbe;
| Name | Index | Direction | Type | IsNullable |
| Anzahl [Anzahl gelöschter Kategorien] | 0 | Output | IntegerField | True |
DECLARE @Count INTEGER
SET @Count = -1
SET @Anzahl = 0
WHILE @Count <> 0
BEGIN
DELETE FROM dbo.Category
WHERE NOT EXISTS(SELECT *
FROM dbo.Article
WHERE Category = dbo.Category.ID)
AND NOT EXISTS(SELECT *
FROM dbo.Category AS Category2
WHERE Category2.ParentCategory = dbo.Category.ID)
SET @Count = @@ROWCOUNT
SET @Anzahl = @Anzahl + @Count
END
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
--MYSQL: 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
LEFT JOIN dbo.SupplementArticleVariant AS SAV ON SAV.ID = AV.ID
LEFT JOIN dbo.LibFirstYearByArticleVariant AS FN ON FN.ArticleVariant = AV.ID;
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
--MYSQL: 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;
SELECT ArticleVariant AS ArticleVariantId,
FromYear, Number
FROM dbo.ArticleNumber;
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;
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;
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;
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;
SELECT ID AS CategoryId, ParentCategory AS ParentCategoryId, Caption, CompleteCaption
FROM dbo.Category;
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;
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;
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;
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;
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;
SELECT ID, Caption
FROM dbo.MainColor;
| Table | Select | Insert | Update | Delete | Import |
| AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | X | X | X | X | X |
| Article [Artikel] | X | X | X | X | X |
| ArticleNumber [Artikelnummer] | X | X | X | X | X |
| ArticleVariant [Artikelvariante] | X | X | X | X | X |
| AttachmentSource [Dateianlagen-Quelle] | X | X | X | X | X |
| Category [Kategorie] | X | X | X | X | X |
| Color [Farbe] | X | X | X | X | X |
| Configuration | X | X | X | - | - |
| DatabaseVersion | X | - | - | - | - |
| Document [Dokument] | X | X | X | X | X |
| DocumentType [Dokumenttyp] | X | X | X | X | X |
| Image [Bild] | X | X | X | X | X |
| ImageType [Bildtyp] | X | X | X | X | X |
| Language [Sprache] | X | X | X | X | X |
| MainColor [Hauptfarbe] | X | X | X | X | X |
| PartsList [Stückliste] | X | X | X | X | X |
| ProcedureInvocation [Befehlsaufruf] | X | X | X | X | X |
| ProcedureInvocationGroup [Befehlsgruppe] | X | X | X | X | X |
| Reminder [Wiedervorlage] | X | X | X | X | X |
| Permission | Procedure |
| X | DeleteAllData [Alle Daten löschen] |
| X | EnsureSmallImages [Kleine Bilder ergänzen] |
| X | ExecuteProcedureInvocationGroup [Befehlsgruppe ausführen] |
| X | ExportToCsvSet [Export zu vollständigem CSV-Satz] |
| X | ExportToMySql [Export der Datenbank nach MySQL] |
| X | HandleReminders [Wiedervorlage bearbeiten] |
| X | ImportDocumentPartsList [Import der Stücklisten aus Word-Dokumenten] |
| X | ImportSwitzerlandFiles [Bilder und Dokumente aus der Schweiz importieren] |
| - | LibFirstYearByArticleVariant |
| - | LibMinImageSizeByArticleVariant |
| X | ReportArtikel [Artikel] |
| X | SupplementArticleVariant |
| X | SupplementDocument |
| X | SupplementImage |
| X | ToolsExportArticleNumbers [Artikelnummern exportieren] |
| X | ToolsExportImageInfo [Bildinformationen exportieren] |
| X | ToolsExportPartsList [Stücklisten exportieren] |
| X | ToolsRemoveEmptyCategories [Leere Kategorien löschen] |
| - | WebArticleVariant |
| - | WebArticleVariantDetail |
| - | WebArticleVariantDetailArticleNumber |
| - | WebArticleVariantDetailDocument |
| - | WebArticleVariantDetailImage |
| - | WebArticleVariantDetailPartsList |
| - | WebArticleVariantReversePartsList |
| - | WebCategory |
| - | WebDocument |
| - | WebDownloadArticleNumbers |
| - | WebDownloadImageInfo |
| - | WebDownloadPartsList |
| - | WebImage |
| - | WebMainColor |
| Table | Select | Insert | Update | Delete | Import |
| AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | ((dbo.AdHocAnalysisQueryDefinition.CreationUser = SYSTEM_USER) OR (dbo.AdHocAnalysisQueryDefinition.IsPublic = 1)) | - | - | - | - |
| Article [Artikel] | X | - | - | - | - |
| ArticleNumber [Artikelnummer] | X | - | - | - | - |
| ArticleVariant [Artikelvariante] | X | - | - | - | - |
| AttachmentSource [Dateianlagen-Quelle] | X | - | - | - | - |
| Category [Kategorie] | X | - | - | - | - |
| Color [Farbe] | X | - | - | - | - |
| Configuration | X | X | X | - | - |
| DatabaseVersion | X | - | - | - | - |
| Document [Dokument] | X | - | - | - | - |
| DocumentType [Dokumenttyp] | X | - | - | - | - |
| Image [Bild] | X | - | - | - | - |
| ImageType [Bildtyp] | X | - | - | - | - |
| Language [Sprache] | X | - | - | - | - |
| MainColor [Hauptfarbe] | X | - | - | - | - |
| PartsList [Stückliste] | X | - | - | - | - |
| ProcedureInvocation [Befehlsaufruf] | 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 |
| ProcedureInvocationGroup [Befehlsgruppe] | ((dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER) OR (dbo.ProcedureInvocationGroup.VisibleForOthers = 1)) | (dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER) | Same as Insert | Same as Insert | X |
| Reminder [Wiedervorlage] | (dbo.Reminder.CreationUser = SYSTEM_USER) | X | X | X | X |
| Permission | Procedure |
| - | DeleteAllData [Alle Daten löschen] |
| - | EnsureSmallImages [Kleine Bilder ergänzen] |
| X | ExecuteProcedureInvocationGroup [Befehlsgruppe ausführen] |
| - | ExportToCsvSet [Export zu vollständigem CSV-Satz] |
| - | ExportToMySql [Export der Datenbank nach MySQL] |
| X | HandleReminders [Wiedervorlage bearbeiten] |
| - | ImportDocumentPartsList [Import der Stücklisten aus Word-Dokumenten] |
| - | ImportSwitzerlandFiles [Bilder und Dokumente aus der Schweiz importieren] |
| - | LibFirstYearByArticleVariant |
| - | LibMinImageSizeByArticleVariant |
| X | ReportArtikel [Artikel] |
| X | SupplementArticleVariant |
| X | SupplementDocument |
| X | SupplementImage |
| X | ToolsExportArticleNumbers [Artikelnummern exportieren] |
| X | ToolsExportImageInfo [Bildinformationen exportieren] |
| X | ToolsExportPartsList [Stücklisten exportieren] |
| - | ToolsRemoveEmptyCategories [Leere Kategorien löschen] |
| - | WebArticleVariant |
| - | WebArticleVariantDetail |
| - | WebArticleVariantDetailArticleNumber |
| - | WebArticleVariantDetailDocument |
| - | WebArticleVariantDetailImage |
| - | WebArticleVariantDetailPartsList |
| - | WebArticleVariantReversePartsList |
| - | WebCategory |
| - | WebDocument |
| - | WebDownloadArticleNumbers |
| - | WebDownloadImageInfo |
| - | WebDownloadPartsList |
| - | WebImage |
| - | WebMainColor |
| Table | Select | Insert | Update | Delete | Import |
| AdHocAnalysisQueryDefinition [Ad-hoc-Abfrage] | - | - | - | - | - |
| Article [Artikel] | - | - | - | - | - |
| ArticleNumber [Artikelnummer] | - | - | - | - | - |
| ArticleVariant [Artikelvariante] | - | - | - | - | - |
| AttachmentSource [Dateianlagen-Quelle] | - | - | - | - | - |
| Category [Kategorie] | - | - | - | - | - |
| Color [Farbe] | - | - | - | - | - |
| Configuration | X | X | X | - | - |
| DatabaseVersion | X | - | - | - | - |
| Document [Dokument] | - | - | - | - | - |
| DocumentType [Dokumenttyp] | - | - | - | - | - |
| Image [Bild] | - | - | - | - | - |
| ImageType [Bildtyp] | - | - | - | - | - |
| Language [Sprache] | - | - | - | - | - |
| MainColor [Hauptfarbe] | - | - | - | - | - |
| PartsList [Stückliste] | - | - | - | - | - |
| ProcedureInvocation [Befehlsaufruf] | 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 |
| ProcedureInvocationGroup [Befehlsgruppe] | ((dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER) OR (dbo.ProcedureInvocationGroup.VisibleForOthers = 1)) | (dbo.ProcedureInvocationGroup.CreationUser = SYSTEM_USER) | Same as Insert | Same as Insert | X |
| Reminder [Wiedervorlage] | - | - | - | - | - |
| Permission | Procedure |
| - | DeleteAllData [Alle Daten löschen] |
| - | EnsureSmallImages [Kleine Bilder ergänzen] |
| X | ExecuteProcedureInvocationGroup [Befehlsgruppe ausführen] |
| - | ExportToCsvSet [Export zu vollständigem CSV-Satz] |
| - | ExportToMySql [Export der Datenbank nach MySQL] |
| - | HandleReminders [Wiedervorlage bearbeiten] |
| - | ImportDocumentPartsList [Import der Stücklisten aus Word-Dokumenten] |
| - | ImportSwitzerlandFiles [Bilder und Dokumente aus der Schweiz importieren] |
| - | LibFirstYearByArticleVariant |
| - | LibMinImageSizeByArticleVariant |
| - | ReportArtikel [Artikel] |
| X | SupplementArticleVariant |
| X | SupplementDocument |
| X | SupplementImage |
| - | ToolsExportArticleNumbers [Artikelnummern exportieren] |
| - | ToolsExportImageInfo [Bildinformationen exportieren] |
| - | ToolsExportPartsList [Stücklisten exportieren] |
| - | ToolsRemoveEmptyCategories [Leere Kategorien löschen] |
| X | WebArticleVariant |
| X | WebArticleVariantDetail |
| X | WebArticleVariantDetailArticleNumber |
| X | WebArticleVariantDetailDocument |
| X | WebArticleVariantDetailImage |
| X | WebArticleVariantDetailPartsList |
| X | WebArticleVariantReversePartsList |
| X | WebCategory |
| X | WebDocument |
| X | WebDownloadArticleNumbers |
| X | WebDownloadImageInfo |
| X | WebDownloadPartsList |
| X | WebImage |
| X | WebMainColor |
No writing roles defined. All roles may write.
| Name | Type | IsNullable | Settings | Persistable CHECK expression |
| DefaultValidFileExtensions [Standardmäßig zugelassene Dateinamenserweiterungen für Dateianlagen] | ValidFileExtensionsField | False |
| DATALENGTH([DefaultValidFileExtensions]) >= 2 |
| ReportServerName [Name/URL des Berichtsservers] | StringField | False |
| DATALENGTH([ReportServerName]) >= 2 |
| ReportManagerDirectory [Berichtsserver-Manager-Verzeichnis] | StringField | False |
| DATALENGTH([ReportManagerDirectory]) >= 2 |
| ReportWebServiceDirectory [Berichtsserver-Webservice-Verzeichnis] | StringField | False |
| DATALENGTH([ReportWebServiceDirectory]) >= 2 |
| ReportFolderName [Berichts-Ordnername (mit '/' beginnend und endend)] | StringField | False |
| DATALENGTH([ReportFolderName]) >= 2 |
| ReportExecution [Berichtsausführung] | EnumerationField | False |
| [ReportExecution] BETWEEN 0 AND 1 |
No writing roles defined. All roles may write.
| Name | Type | IsNullable | Settings | Persistable CHECK expression |
| ReminderCheckOnStartDays [Beim Start auf Wiedervorlagen prüfen] | EnumerationField | False |
| [ReminderCheckOnStartDays] BETWEEN 0 AND 6 |
| FormScalingPercent [Skalierung der Ansicht in Prozent (nach Neustart)] | IntegerField | False |
| [FormScalingPercent] BETWEEN 50 AND 500 |
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)
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) |
ID = 6241dad7-e0a5-4ba8-989f-1ed7fa7a56a9
(None)