Table design is performed on the Design tab of the work area. This section describes the table design operations.
Enter item names, etc.
It corresponds to a "column" in a general database. The information to be entered on the [Design] tab is as follows
|
Column Name |
Description. |
|---|---|
|
item name |
This is the name of the column you are creating and will also be used when linking to controls and processes (logic). The following six symbols may not be used in item names. ( ) . / [ ] |
|
physical item name |
The name of the column to be stored in SQLite. Within the same table, the same name cannot be used for another column. When using the logic component "Execute SQL", the physical item name is used when writing SQL statements directly or when specifying them in a filter. The name "rowid" cannot be used in the physical item name. |
|
type (e.g. of machine, goods, etc.) |
The data type of the column. ."character type"numeric type"date type"binary typeYou can choose from among the following |
|
number of digits or characters |
The maximum number of digits/maximum number of characters in the column. This item exists for future expansion of external linkages and is not currently used in Unifinity. If you set a value that exceeds the maximum number of digits, SQLite will not generate an error and store the value in the database as is. |
|
carte blanche |
This setting determines whether to allow columns to be empty (NULL) or not. When checked, null status is an allowed column. When unchecked, null status is a column that is not allowed. By not allowing the column to be null, the logic component "Database/AdditionIf you forget to set a value for a logic parameter when adding a value to the database using the "Add Value to Database" function, you can prevent the value from being added as a violation of a database constraint. |
|
default value |
You can set default values for columns. |
|
master key |
You can set the primary key of the table. |
|
remarks |
You can fill in the column description. The entry will be replaced by the keyword "####Notes###" in the design document template when the design document is automatically output. |
Column Manipulation
[On the Design tab, you can
Insert Column
Deletion of columns
Change the order of columns
Edit Columns
Insert Columns
Right-click on the row at the location to be inserted and select "Insert" from the menu.
A confirmation message screen will appear. Click "Yes" to add a blank line above the selected line.
Deleting columns
Right-click on the row to be deleted and select "Delete" from the menu.
A confirmation message screen will appear. Click "Yes" to delete the selected rows.
*The same can be done by selecting the line to be deleted and choosing [Edit] ⇒ [Delete] from the TOP menu.
Change the order of columns
Drag and drop rows to change the order of columns.
Edit Columns
The following operations can be performed on rows in [Edit] of the TOP menu. For more information on [Edit], see "Basic Operations: Unifinity Studio Edition" in5. description of TOP menuSee "The following is a brief description of the newest version of the product.
Undo and redo
Cut, copy and paste
The same operation can also be performed in the menu that appears by right-clicking on a row.