Datenbankänderungen von Version STS-2023.3 → STS-2023.4 (Stand 11/2023)
ARTICLE: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | HASUDI | TINYINT(1) | NULL | YES | None |
ARTICLEBUNDLE: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None |
ARTICLEITEM: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None | |||
| new | UDI | VARCHAR(250) | NULL | YES | None |
ARTICLEVARIANT: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None |
ASSORTMENTHEAD: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | AUTOMATICALLY | TINYINT(1) | 0 | YES | None | ||
| new | CREATEORDERWISHESINSTEADORDER | TINYINT(1) | 0 | YES | None |
CARE: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(20) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None |
COMPARATIVEFITTING: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None |
COMPLAINT: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None |
CUSTOMERDETAIL: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | DISCOUNTVALUEPERCENT | DECIMAL(12,2) | NULL | YES | None | ||
| LTS-2022.4 | DOMINANTEYE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | DOMINANTEYE | VARCHAR(50) | NO | None | |||
| LTS-2022.4 | DOMINANTHAND | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | DOMINANTHAND | VARCHAR(50) | NO | None | |||
| new | INDIVIDUALDISCOUNTID | CHAR(32) | NULL | YES | None |
CUSTOMERFLATRATE: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None |
DELIVERY: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | PROVIDER | VARCHAR(5) | NULL | YES | None | ||
| new | RETOURENUMBER | VARCHAR(50) | NULL | YES | None | ||
| new | SHIPPINGSTATUS | VARCHAR(30) | NULL | YES | None |
DELIVERYPOSITION: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None | |||
| new | UDI | VARCHAR(250) | NULL | YES | None |
GLASSESCONFIGURATION: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None |
HICOSTCOVERAGE: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | AMOUNTCOSTCOVERAGE | DECIMAL(12,2) | NULL | YES | None | ||
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None |
INVOICEPOSITION: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | AMOUNTCOSTCOVERAGE1 | DECIMAL(12,2) | NULL | YES | None | ||
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None | |||
| new | UDI | VARCHAR(250) | NULL | YES | None |
OAUTHTOKEN: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | REFERENCEID | CHAR(32) | None | NO | None | ||
| new | REFERENCETYPE | VARCHAR(50) | 'service_configuration' | YES | None | ||
| removed | SERVICECONFIGURATIONID | CHAR(32) | None | COL_INDEXED | NO | None |
OAUTHTOKEN: Indexes/Constraints
| Type | Index Name | Columns |
|---|---|---|
| removed in LTS-2023.4 | FK_OAUTHTOKEN_SERVICECONFIGURATION | SERVICECONFIGURATIONID |
OAUTHTOKEN: Foreign Keys
| Type | Constraint Name | Parent Table (Columns) |
|---|---|---|
| removed in LTS-2023.4 | FK_OAUTHTOKEN_SERVICECONFIGURATION | SERVICECONFIGURATION (SERVICECONFIGURATIONID) |
ORDERPOSITION: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None |
PICKUPORDER: (new)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | BRANCHID | CHAR(32) | NULL | YES | None | ||
| new | CHAINID | CHAR(32) | None | NO | None | ||
| new | FREEOFCHARGE | TINYINT(1) | NULL | YES | None | ||
| new | ID | CHAR(32) | None | COL_IN_PK | NO | None | |
| new | MODIFIED | DATETIME | None | NO | None | ||
| new | ORDERID | VARCHAR(50) | NULL | YES | None | ||
| new | ORDERSTATE | VARCHAR(10) | NULL | YES | None | ||
| new | PICKUPDATE | DATE | None | NO | None | ||
| new | PICKUPTYPE | VARCHAR(20) | NULL | YES | None | ||
| new | PROVIDER | VARCHAR(5) | NULL | YES | None | ||
| new | STAFFID | CHAR(32) | NULL | COL_INDEXED | YES | None | |
| new | TOADDRESSID | CHAR(32) | NULL | COL_INDEXED | YES | None |
PICKUPORDER: Indexes/Constraints
| Type | Index Name | Columns |
|---|---|---|
| new in LTS-2023.4 | PRIMARY | ID |
| new in LTS-2023.4 | FK_PICKUPORDER_ADDRESS | TOADDRESSID |
| new in LTS-2023.4 | FK_PICKUPORDER_STAFF | STAFFID |
PICKUPORDER: Foreign Keys
| Type | Constraint Name | Parent Table (Columns) |
|---|---|---|
| new in LTS-2023.4 | FK_PICKUPORDER_ADDRESS | ADDRESS (TOADDRESSID) |
| new in LTS-2023.4 | FK_PICKUPORDER_STAFF | STAFF (STAFFID) |
PRINCIPALBRANCHROLE: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | EXTENDEDLOGIN | TINYINT(1) | 0 | NO | None |
TPONLINECONFIGURATION: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | CSSLOCATIONTERMINO | TEXT | NULL | YES | None |
TPRESOURCE: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| new | GOAUTH | TINYINT(1) | 0 | NO | None |
TREATMENTHEAD: (changed)
| Type | Column | ColumnType | COLUMN_DEFAULT | COLUMN_KEY | IS_NULLABLE | check_clause | comment |
|---|---|---|---|---|---|---|---|
| LTS-2022.4 | SIDE | VARCHAR(50) | YES | None | |||
| LTS-2023.4 | SIDE | VARCHAR(50) | NO | None |