Version 2023.10
| CREATE TABLE alex_import_extension ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| import_change_timestamp | datetime | |
| name | nvarchar(255) | NOT NULL |
| value_int | int | |
| value_float | float | |
| value_date | datetime | |
| value_string | nvarchar(510) | |
| value_hours | numeric(14,4) | |
| value_currency_ekey | nvarchar(255) | |
| value_currency | numeric(28,10) | |
| value_bobref_type | nvarchar(255) | |
| value_bobref_ekey | nvarchar(255) | |
| parent_ekey | nvarchar(255) | NOT NULL |
| CONSTRAINT alex_import_extension_PK PRIMARY KEY CLUSTERED ( external_key ) | ||
| ) | ||
| go |