# Viewing the column list The column list on **Database View** contains information about the sensitivity and generator configuration for each column. ![Column list on Database View](https://3378426797-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSQCLFQ4bslJ-HYc8c3%2Fuploads%2FpIV86zKePygZMtoPgoPx%2FDatabaseViewColumnList.png?alt=media\&token=828721cd-2d25-413e-9fa6-ff5dd2f19e6a) ## Column - Column name and type The **Column** column provides general information about the columns and their content, including: * Table and column name. When you click the column name, [**Table View**](https://docs.tonic.ai/app/generation/table-view) for the column table displays. * The name of the schema that contains the table. * The data type for the column. * An indicator when the column is a primary key The **Column** column also contains the option to [display sample data for the column](https://docs.tonic.ai/app/generation/database-view/database-view-sample-data). ## Status - Protection and sensitivity status The **Status** column provides information about whether the column contains sensitive data and whether it has an assigned generator. The protection status can be one of the following values:

* **Protected -** The column has an assigned generator. * **Not Sensitive -** The column is marked as not sensitive. * **At Risk -** The column is sensitive and does not have an assigned generator. At the right of the **Status** column is a confidence indicator. For **At Risk** columns, the confidence indicator shows how confident Structural is that the column is sensitive and contains values of the displayed sensitivity type. Protected columns also reflect the original confidence level.

Confidence level indicators for database columns

For more information about how Structural identifies values and assigns the confidence level, go to [#sensitive-data-how-identified](https://docs.tonic.ai/app/identify-sensitive-data/running-the-structural-sensitivity-scan#sensitive-data-how-identified "mention"). From the **Status** column, you can [change whether a column is sensitive](https://docs.tonic.ai/app/generation/database-view-configure-column#database-view-column-config-single-sensitivity). ## Applied Generator - Column configuration The **Applied Generator** column is where you [select and configure the generator to assign](https://docs.tonic.ai/app/generation/database-view/database-view-configure-column). The generator dropdown indicates the currently assigned generator. It also indicates when an unprotected column has a recommended generator.

Unprotected column that has a recommended generator

For foreign key columns, the generator dropdown is disabled and the column is marked as a foreign key. Foreign key columns always inherit the generator that is assigned to the primary key.

Disable generator dropdown for a foreign key column

In a child workspace, when the generator configuration overrides the parent workspace, the generator dropdown displays the override icon.

Column with a generator configuration that overrides the parent workspace

The **Applied Generator** column also contains the option to [display and create column comments](https://docs.tonic.ai/app/generation/database-view/database-view-column-comment). ## Filtering the column list You can use the [Structural Agent](https://docs.tonic.ai/app/structural-agent/agent-about) to display a filtered list of columns. For example: * `Display Database View filtered to show all of the unprotected columns.` * `Display Database View filtered to show non-sensitive columns in the stores and vendors tables.` To filter the column list manually from **Database View**, you can: * Use the table list to filter the displayed columns based on the table that the columns belong to. * Use the filter field to filter the columns by table or column name. * Use the **Filters** panel to filter the columns based on column attributes and generator configuration. You can use column filters to quickly find columns that you want to verify or to update the configuration for. ### Filter by table To filter the column list to only include columns for specific tables, either: * [Apply a filter to the table list](https://docs.tonic.ai/app/generation/database-view-tables#database-view-tables-filter). * Check the checkbox for each table to display columns for. ### Filter by table or column name To filter the column list by table or column name, in the filter field, begin to type text that is in the table or column name. As you type, Structural filters the column list. ![Filtering columns by name](https://3378426797-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LSQCLFQ4bslJ-HYc8c3%2Fuploads%2FQIOjargLy0s65TvGbJ5L%2FDatabaseViewColumnFilterName.png?alt=media\&token=71a0e024-b472-4e1b-9f81-fe1187203602) ### Using the Filters panel The **Filters** panel provides access to column filters other than the table and column name. To display the **Filters** panel, click **Filters**. The list only includes the filters that apply to the displayed data.

#### **Searching for a filter** To search for a filter or a filter value, in the search field, start to type the value. The search looks for text in the individual settings. For each filter, the **Filters** panel indicates the number of matching columns, based on the selected tables and the current filters.

#### **Adding a filter** To add a filter, depending on the filter type, either check the checkbox or select a filter option. As you add filters, Structural applies them to the column list. Above the list, Structural displays tags for the selected filters.

#### **Clearing the selected filters** To clear all of the currently selected filters, click **Clear All**. ## Filters panel filters ### Columns with generator recommendations To only display detected sensitive columns for which there is a recommended generator, on the **Filters** panel, check **Has Generator Recommendation**. ### At-risk columns An at-risk column: * Is marked as sensitive. * Is included in the destination data. * Is assigned the Passthrough generator. To only display at-risk columns, on the **Filters** panel, check **At-Risk Column**. When you check **At-Risk Column**, Structural adds the following filters under **Privacy Settings**: * Sets the sensitivity filter to **Sensitive** * Sets the protection status filter to **Not protected** * Sets the column inclusion filter to **Included** ### Sensitivity You can filter the columns based on the column sensitivity. On the **Filters** panel, under **Privacy Settings**, the sensitivity filter is by default set to **All**, which indicates to display both sensitive and non-sensitive columns. * To only display sensitive columns, click **Sensitive**. * To only display non-sensitive columns, click **Not sensitive**. Note that when you check **At-risk Column**, Structural automatically selects **Sensitive**. ### Protection status You can filter the columns based on whether they have any generator other than Passthrough assigned. To filter the columns based on specific assigned generators, use the **Applied Generator** filter. On the **Filters** panel, under **Privacy Settings**, the column protection filter is by default set to **All**, which indicates to display both protected and not protected columns. * To only display columns that have an assigned generator, click **Protected**. * To only display columns that do not have an assigned generator, click **Not protected**. Note that when you check **At-Risk Column**, Structural automatically selects **Not protected**. ### Inclusion in the destination database You can filter the columns based on whether they are populated in the destination database. For example, if a table is truncated, then the columns in that table are not populated. On the **Filters** panel, under **Privacy Settings**, the column inclusion filter is by default set to **All**, which indicates to display both included and not included columns. * To only display columns that are populated in the destination database, click **Included**. * To only display columns that are not populated in the destination database, click **Not included**. Note that when you check **At-Risk Column**, Structural automatically selects **Included**. ### Assigned generator To only display columns that are assigned specific generators, on the **Filters** panel, under **Applied Generator,** check the checkbox for each generator to include. The list of generators only includes generators that are assigned to the currently displayed columns and that are compatible with other applied filters. To search for a specific generator, in the **Filters** search field, begin to type the generator name. ### Column data type You can filter the columns by the column data type. For example, you can only display `varchar` columns, or only columns that contain either numeric or integer values. To only display columns that have specific data types, on the **Filters** panel, under **Database Data Types**, check the checkbox for each data type to include. The list of data types only includes data types that are present in the currently displayed columns and that are compatible with other applied filters. To search for a specific data type, in the **Filters** search field, begin to type the data type. ### Unresolved schema changes When the source database schema changes, you might need to update the configuration to reflect those changes. If you do not resolve the schema changes, then the data generation might fail. The data generation fails if there are unresolved conflicting changes, or if you configure Structural to always fail data generation when there are any unresolved changes. For more information about schema changes, go to [schema-changes](https://docs.tonic.ai/app/generation/schema-changes "mention"). To only display columns that have unresolved schema changes, on the **Filters** panel, check **Unresolved Schema Changes**. ### Sensitivity type For detected sensitive columns, the sensitivity type indicates the type of data that was detected. Examples of sensitivity types include First Name, Address, and Email. To only display columns that contain specific sensitivity types, on the **Filters** panel, under **Sensitivity Type**, check the checkbox for each sensitivity type to include. The list of sensitivity types only includes sensitivity types that are present in the currently displayed columns. To search for a specific sensitivity type, in the **Filters** search field, type the sensitivity type. ### **Sensitivity confidence** When the Structural sensitivity scan [identifies a value as belonging to a sensitivity type](https://docs.tonic.ai/app/identify-sensitive-data/running-the-structural-sensitivity-scan#sensitive-data-how-identified), it also determines how confident it is in that determination. The **Status** column displays the confidence level. You can filter the columns based on the confidence level. To only display columns that have a specific confidence level, on the **Filters** panel, under **Sensitivity confidence**, check the checkbox next to each confidence level to include. ### Column nullability You can filter the column list based on whether the column is nullable. On the **Filters** panel, under **Data Attributes**, the nullability filter is by default set to **All**, which indicates to display both nullable and non-nullable columns. * To only display columns that are nullable, click **Nullable**. * To only display columns that are not nullable, click **Non-nullable**. ### Column uniqueness You can filter the column list based on whether the column must be unique. On the **Filters** panel, under **Data Attributes**, the uniqueness filter is by default set to **All**, which indicates to display both unique and not unique columns. * To only display columns that must be unique, click **Unique**. * To only display columns that do not require uniqueness, click **Not unique**. ### Primary or foreign keys You can filter the column list to indicate whether to include: * Columns that are not primary or foreign keys. * Columns that are foreign keys. * Columns that are primary keys. On the **Filters** panel, under **Column Type**: * To display columns that are neither a primary key nor a foreign key, check **Non-keyed**. * To display columns that are primary keys, check **Primary key**. * To display columns that are foreign keys, check **Foreign key**. ### Generator overrides in a child workspace In a child workspace, to only display columns that override the generator configuration that is in the parent workspace, on the **Filters** panel, check **Overrides Inheritance**. ### Uses Structural data encryption You can enable Structural data encryption, a configuration that allows Structural to: * Decrypt source data before applying the generator. * Encrypt generated data before writing it to the destination database. For more information, go to [generators-data-encryption-config](https://docs.tonic.ai/app/generation/generators-assign-config/generators-data-encryption-config "mention"). When Structural data encryption is enabled, the generator configuration panel includes an option to use Structural data encryption. To only display columns that are configured to use Structural data encryption, on the **Filters** panel, check **Uses Data Encryption**. ### Columns with automatically assigned generators You can filter the columns to only display those for which Structural automatically assigned the generator. Based on the [workspace configuration](https://docs.tonic.ai/app/workspace/managing-workspaces/workspace-configuration-settings/schema-management-settings#workspace-config-schema-change-handling), this can happen during data generation in response to changes to the source data schema. To only display columns that have automatically applied generators, on the **Filters** panel, toggle **Automatically Applied Generators** to the on position. ## Sorting the column list By default, the column list is sorted first by table name, then by column name. The columns for each table display together. Within each table, the columns are in alphabetical order. You can also sort the column list by column name first, then by table. Columns that have the same name display together. Those columns are sorted by the name of the table. The button at the right of the **Column** column heading indicates the current sort order.

* **T.C** indicates that the table is sorted by table, then by column * **C.T** indicates that the table is sorted by column, then by table To switch the sort order, click the button.