Structure

The name property refers to the identifier or label assigned to a particular field or column in the database structure. It helps users and developers understand the purpose or content of the data stored in that specific field.

The data type property specifies the type of data that can be stored in a particular field or column. Common data types include integers (for whole numbers), characters (for text), timestamps (for date and time), and doubles (for floating-point numbers).

The is nullable property indicates whether a field or column in the database allows null values. A null value represents the absence of data or an unknown value. If a field is nullable, it means that it can contain null values, while if it’s not nullable, it means that it must always contain a valid value.

The char max length property applies specifically to character data types (e.g., varchar) and specifies the maximum number of characters that can be stored in a field or column. It helps enforce data integrity by limiting the length of text that can be entered into a particular field.

The column default property defines a default value that is automatically assigned to a field or column if no other value is specified during data insertion. This property is optional and can help ensure consistency in the database by providing a fallback value when necessary.

You also have the option to rearrange rows by clicking on the header you wish to prioritize. It will sort the rows in ascending or descending order, depending on the current order of the rows.