New columns
The AS database model, as generated by the DCK creation scripts, contains columns that are not required by the Web Viewer. All numeric columns are created with a default value of 0. See the interface sheet for more information on new columns.
This table shows all of the columns that are added since AS 5.4 and which are not used by the Web Viewer:
Table name | Column name | Type | Length |
---|---|---|---|
AS_ProcessBatch | as_changeover_cost | INT | |
as_setup_cost | INT | ||
as_split_link | TEXT | 80 | |
AS_ProcessStep | as_release_duration | INT | |
AS_ResourceCIPRule | as_changeover_limit | INT | |
as_cip_type | INT | ||
as_gauge_cost | INT | ||
as_gauge_count | INT | ||
as_gauge_duration | INT | ||
as_gauge_quantity | FLOAT | ||
as_gauge_time | DATETIME | ||
as_matrix_code | TEXT | 80 | |
as_max_cost | INT | ||
as_max_count | INT | ||
as_max_duration | INT | ||
as_max_quantity | FLOAT | ||
as_min_count | INT | ||
as_min_duration | INT | ||
as_min_quantity | FLOAT | ||
as_model_name | TEXT | 80 | |
as_resource_code | TEXT | 80 | |
as_step_code | TEXT | 80 | |
as_step_version | TEXT | 80 | |
as_unique_key | TEXT | 80 | |
AS_ResourceClaim | as_flow_inflow | INT | |
as_flow_outflow | INT | ||
as_keep_batch_claim | INT | ||
as_process | INT | ||
AS_ResourceTable | as_changeover_after_idle_time | INT | |
as_changeover_cost_formula | INT | ||
as_changeover_idle_time | INT | ||
as_non_std_changeover_after_id | INT | ||
as_setup_cost_formula | INT | ||
as_setup_duration_formula | INT | ||
AS_TankBatch | as_changeover_cost | INT | |
as_order_code | TEXT | 80 | |
as_setup_cost | INT | ||
as_split_link | TEXT | 80 | |
AS_UtilityClaim | as_flow_inflow | FLOAT | |
as_flow_outflow | FLOAT | ||
as_keep_batch_claim | INT | ||
as_process | FLOAT |