In Kuika, you can create data tables without the need for any external program or software. In this learning content, we will create the needed data tables together using ManageDB.
In Kuika, you can create data tables without the need for any external program or software.
Within the scope of this learning content, let's create the needed data tables together using ManageDB.
To create the data table, first open the Datasources view mode.
To create a data table, hover over Tables on the left panel and open the new table creation screen by clicking the + icon that appears.
On the screen that opens, name the table you want to create.
In this learning content, we will create three data tables named Employee, Department, and Title.
Let's start with the Department table. In the Create a new table screen, type the table name as Department and press the NEXT button.
By default, Kuika creates an ID column of Guid data type for each data table you create.
Kuika automatically selects the appropriate data type for the column name when you enter the column name with the artificial intelligence assistant it offers during the table creation process. For this process, you need to activate the switch next to the data type before typing the column name.
Apart from Id, create the column titled DepartmentName in the String data type that will be needed in the Department table and complete the addition process via the Add button.
Complete the table creation process by clicking the CREATE button in the upper right corner.
Let's continue by creating the next table, Title.
On the screen for creating a new table, type the table name as Title and press the NEXT button.
The ID column in the Guid data type is created by Kuika by default.
Create the column titled Title in String data type and complete the insertion process via the Add button. Complete the table creation process by clicking the CREATE button in the upper right corner.
Now, let's create the Employee table.
On the Create a new table screen, type the table name as Employee and press the NEXT button.
The ID column in the Guid data type is created by Kuika by default.
Let's start by creating other columns.
First, create a column titled EmployeeImage with Image data type for staff images and click the Add button.
Then, create another column titled FullName, of data type String, to hold the names of the staff members and complete the insertion process via the Add button.
For the phone number data for the staff, create a new column with String data type in the PhoneNumber column header and click the Add button.
Then, create a String column with an Email column header for email information, which is another contact information for the staff, and add the column via the Add button.
Create a column with a Department column header and Department data type to hold the department information of the staff.
Department data type allows the establishment of a relationship between two tables. To establish a relationship between tables in Kuika, you must select the data table you want to establish a relationship with as the data type of the relevant column.
Create a column titled Title and with Title data type to hold the title information of the personnel. Title data type allows to establish a relationship between two tables.
Then, create a BirthdayDate column with a Date data type that will hold the birth date of the staff and add the column via the Add button.
Finally, create a CreatedDate column with DateTime data type that will hold the date information for the addition of the personnel to the application.
Finally, complete the table creation process by clicking the CREATE button in the upper right corner.
Now, you can view the data table you created in the diagram in Datasources view mode and edit your table if needed.
Thus, you have prepared the data tables you will use within the scope of this learning content.
In Kuika, you can create data tables without the need for any external program or software. In this learning content, we will create the needed data tables together using ManageDB.
In Kuika, you can create data tables without the need for any external program or software.
Within the scope of this learning content, let's create the needed data tables together using ManageDB.
To create the data table, first open the Datasources view mode.
To create a data table, hover over Tables on the left panel and open the new table creation screen by clicking the + icon that appears.
On the screen that opens, name the table you want to create.
In this learning content, we will create three data tables named Employee, Department, and Title.
Let's start with the Department table. In the Create a new table screen, type the table name as Department and press the NEXT button.
By default, Kuika creates an ID column of Guid data type for each data table you create.
Kuika automatically selects the appropriate data type for the column name when you enter the column name with the artificial intelligence assistant it offers during the table creation process. For this process, you need to activate the switch next to the data type before typing the column name.
Apart from Id, create the column titled DepartmentName in the String data type that will be needed in the Department table and complete the addition process via the Add button.
Complete the table creation process by clicking the CREATE button in the upper right corner.
Let's continue by creating the next table, Title.
On the screen for creating a new table, type the table name as Title and press the NEXT button.
The ID column in the Guid data type is created by Kuika by default.
Create the column titled Title in String data type and complete the insertion process via the Add button. Complete the table creation process by clicking the CREATE button in the upper right corner.
Now, let's create the Employee table.
On the Create a new table screen, type the table name as Employee and press the NEXT button.
The ID column in the Guid data type is created by Kuika by default.
Let's start by creating other columns.
First, create a column titled EmployeeImage with Image data type for staff images and click the Add button.
Then, create another column titled FullName, of data type String, to hold the names of the staff members and complete the insertion process via the Add button.
For the phone number data for the staff, create a new column with String data type in the PhoneNumber column header and click the Add button.
Then, create a String column with an Email column header for email information, which is another contact information for the staff, and add the column via the Add button.
Create a column with a Department column header and Department data type to hold the department information of the staff.
Department data type allows the establishment of a relationship between two tables. To establish a relationship between tables in Kuika, you must select the data table you want to establish a relationship with as the data type of the relevant column.
Create a column titled Title and with Title data type to hold the title information of the personnel. Title data type allows to establish a relationship between two tables.
Then, create a BirthdayDate column with a Date data type that will hold the birth date of the staff and add the column via the Add button.
Finally, create a CreatedDate column with DateTime data type that will hold the date information for the addition of the personnel to the application.
Finally, complete the table creation process by clicking the CREATE button in the upper right corner.
Now, you can view the data table you created in the diagram in Datasources view mode and edit your table if needed.
Thus, you have prepared the data tables you will use within the scope of this learning content.
