Built-in Tables

A workflow application can automatically prepare a management table for case records, histories, and potential persons in charge.

How to create

The procedure is as follows:

1. Select the database menu from side menu.
2. Select table from the "Database" node and right-click to open the context menu.
3. Select the menu item Table Creation > Built-ins > Workflow.
4. Confirm that two tables $case and $case_history have been created in the "Table" node.

Specialty

Built-in tables, like regular tables, can be freely customized. You can add foreign key columns to be associated with business data or business data tables.

Tips

Tips

Customization refers to arbitrarily changing column contents or adding columns. If you want to reset the built-in table, you can recreate it by creating the built-in table again. In that case, the existing table is dropped once and then created.

$case

This table manages case records.

Column name	Data type	M	D	fsp	PK	NN	UQ	UN	AI
case_id	INT				TRUE	TRUE			TRUE
status_id	VARCHAR	45				TRUE
owner_id	VARCHAR	128				TRUE

Tips

Tips

owner_id is registered by the UserId of the person in charge. UserId is a 128-digit GUID that uniquely identifies the sign-in user.

$case_history

This table records the history of case records.

Column name	Data type	M	D	fsp	PK	NN	UQ	UN	AI
id	INT				TRUE	TRUE			TRUE
case_id	INT
before_status_id	VARCHAR	45
after_status_id	VARCHAR	45
before_owner_id	VARCHAR	45
after_owner_id	VARCHAR	45
update_time	TIMESTAMP					TRUE

Tips

Tips

case_id is a foreign key to the case_id column of the $case table.