C.3 Content of STATUS_COLUMNS

STATUS_COLUMNS stores cost information relating to the base table columns. One row stores information for one column.

The content of STATUS_COLUMNS is shown in the following table.

Table C‒4: Content of STATUS_COLUMNS
No.	Column name	Data type	Stored information
1	`TABLE_SCHEMA`	`VARCHAR(100)`	Schema name
2	`TABLE_NAME`	`VARCHAR(100)`	Table identifier
3	`COLUMN_NAME`	`VARCHAR(100)`	Column name
4	`DATA_TYPE_CODE`	`SMALLINT`	Column data type
5	`DATA_LENGTH`	`SMALLINT`	Defined length of column data For details, see DATA_LENGTH under Table B‒4: Content of SQL_COLUMNS.
6	`COLUMN_VALUE_MAX`	`VARCHAR(100)`	Maximum column value If the value of the `IS_MAXMIN_COMPLETE` column is `'N'`, the maximum value in the processing-target column at the time when collection of cost information was canceled is stored. If no column data exists or the data existing in the column is only `NULL`, a null value is stored in this column.
7	`COLUMN_VALUE_MIN`	`VARCHAR(100)`	Minimum column value If the value of the `IS_MAXMIN_COMPLETE` column is `'N'`, the minimum value in the processing-target column at the time when collection of cost information was canceled is stored. If no column data exists or the data existing in the column is only `NULL`, a null value is stored in this column.
8	`N_NULL`	`INTEGER`	Number of null values The number of null values in the processing-target columns for which analysis was completed at the time when collection of cost information was canceled is stored in the following case: in `STATUS_TABLES` that corresponds to the table that includes this column, the value of the `IS_COMPLETE` column is `'N'`.
9	`IS_MAXMIN_COMPLETE`	`CHAR(1)`	Whether collection of the maximum column value and minimum column value was completed^# `'Y'`: Completed `'N'`: Not completed Collection of cost information was canceled because the time required to collect cost information exceeded the maximum (time specified for the `adb_getcst_collect_time` cost information collection option).

#

For a table that satisfies all of the following conditions, a null value is stored in this column of STATUS_COLUMNS:

Table from which cost information was collected by an HADB server whose version is earlier than 04-03
Table from which cost information was not collected by an HADB server whose version is 04-03 or later

To Page Top