Primary key Field
Last updated
Last updated
A primary key field is an input that serves to uniquely distinguish each entry within a database table.
Label Field • The first input field allows you to specify the Label of the column. • Enter a meaningful name, such as “Order ID” or “User Identifier”, to indicate the purpose of this column. This label will appear as the header for the column in the table view.
Type Field • The second dropdown menu is used to select the Type of data for the column. • Choose Primary Key to designate this column as the unique identifier for each row in the table.
Format Field • The third dropdown menu is used to define the Format of the primary key type. • Select Generate String to automatically generate a unique alphanumeric string for this field. This ensures every row has a distinct identifier without manual input.
Label Field • The first input field allows you to specify the Label of the column. • Enter a meaningful name, such as “Transaction ID” or “Session Identifier”, to indicate the purpose of this column. This label will appear as the header for the column in the table view.
Type Field • The second dropdown menu is used to select the Type of data for the column. • Choose Primary Key to designate this column as the unique identifier for each row in the table.
Format Field • The third dropdown menu is used to define the Format of the primary key type. • Select UUID to automatically generate a universally unique identifier (UUID) for this field. This ensures a globally unique ID is assigned to each row, making it suitable for distributed systems.
Label Field • The first input field allows you to specify the Label of the column. • Enter a meaningful name, such as “Order Number” or “Custom Identifier”, to indicate the purpose of this column. This label will appear as the header for the column in the table view.
Type Field • The second dropdown menu is used to select the Type of data for the column. • Choose Primary Key to designate this column as the unique identifier for each row in the table.
Format Field • The third dropdown menu is used to define the Format of the primary key type. • Select Manual String to allow users to manually input unique string values for this field. This ensures that each entry has a custom and meaningful identifier, as determined by the user.
Label Field • The first input field allows you to specify the Label of the column. • Enter a meaningful name, such as “Invoice Number” or “Customer ID”, to indicate the purpose of this column. This label will appear as the header for the column in the table view.
Type Field • The second dropdown menu is used to select the Type of data for the column. • Choose Primary Key to make this column uniquely identify each record in the table.
Format Field • The third dropdown menu is used to define the Format of the primary key type. • Select Increment Number to ensure that the system automatically assigns a unique, sequential number to each record added to the table. This is useful for maintaining numerical order, such as for invoices or ticket numbers.
