Indicate table/column status

22nd April, 2021
Applies to: 9.x (current) versions, Article available also for: 10.x

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

Here are guidelines for creating such custom field:

Custom field attributes:

  1. Type - Dropdown list (closed),
  2. Class - Status,
  3. Visibility - Tables, Columns, Procedures, Parameters, Terms,
  4. 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:

  1. Active
  2. Never used
  3. Deprecated
  4. Planned
Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.