Skip to main content

Indicate table/column status

Databases hold many tables and columns that are not used anymore, were never used, or are not used yet. There are likely many other cases you can think of. Understanding the status of a field is crucial and helpful when working with databases and data. We advise documenting the status in a custom status field.

Status field example

Here are guidelines for creating such a custom field):

Custom field attributes:

  • Type - Dropdown list (closed),
  • Class - Status,
  • Visibility - Tables, Columns, Procedures, Parameters, Terms,
  • Definition - List of possible statuses (see below),

Here are suggested options available in the field, but you may define this field so that it works for your specific needs:

  • Active
  • Never used
  • Deprecated
  • Planned