Table Structure
Last updated
Last updated
To create a new Table Structure,
Highlight the table which you want to add a structure to, then select the Structure tab.
Press the Add button located inside the table structure section.
A new table structure will be added with several empty / default value fields inside
Available fields:
Primary Key
Name
Type
Length
Optional
Auto Increment
To modify a Table Structure,
Highlight the table which structure you want to modify, then select the Structure tab.
Select the field that you want to modify
Available fields:
Primary Key
Name
Type
Length
Optional
Auto Increment
Modifying the Primary Key field
Check or uncheck the field to modify the Primary Key value
Notes for Primary Key field:
One primary key available for every table
Once a structure identified as a Primary Key (checked), it cannot be deleted unless it has been unchecked again
Once a structure identified as a Primary Key (checked), it's type cannot be changed unless it has been unchecked again
Auto Increment field will only be available to modify once a structure identified as a Primary Key (checked)
Modifying the Name field
Type on the field to modify the Name value
Notes for Name field:
Must be unique, cannot have multiple structure with the same name
Cannot be empty
Empty by default
Modifying the Type field
Select on the dropdown field to modify the Type value
Notes for Type field:
There are 8 types selection:
VARCHAR
BOOLEAN
INT
DATE
TIME
DATETIME
DECIMAL
BLOB
The detailed information for each supported data type can be found here: MariaDB-data-types
VARCHAR will be selected by default
Modifying the Length field
Type on the field to modify the Length value
Notes for Length field:
Some data Type cannot have Length value
Each data Type might have a different maximum or minimum Length value, refer to: MariaDB-data-types for the detailed information
Modifying the Optional field
Select on the dropdown field to modify the Optional value
Notes for Optional field:
True by default
Modifying the Auto Increment field
Select on the dropdown field to modify the Auto Increment value
Notes for Auto Increment field:
Only applicable if the type of the structure is an INT
Only applicable if the structure is a Primary Key (checked)
Save the project to make the structure usable in the Content tab
To delete a Table Structure,
Highlight the table which structure you want to delete, then select the Structure tab.
Take note that if a structure is a Primary Key (checked) it cannot be deleted, and need to be unchecked first if you want to remove it.
Save the project to see the structure change in the Content tab.
Press the Delete button on the right side of a structure that need to be removed.
