CRUD

With Astah Professional, you can create CRUD table (Create, Read, Update and Delete) based on all the diagrams you have created.

CRUD Sample
section divider

Create CRUD

You can create a CRUD from [Diagram] – [CRUD] in the Main menu.
Create CRUD

section divider

Edit CRUD

You can open a window to edit CRUD by selecting [Edit CRUD] from CRUD’s pop-up menu in the Structure Tree or clicking [Edit CRUD] button on the CRUD’s property view.
Edit CRUD

section divider

CRUD Edit Window

On [Edit CRUD] dialog, edit the functions on the left, models in the right and common options at the bottom.
Edit CRUD

Set Functions

Show CRUD by group

Show diagram names and group items by diagrams that they belong to.

[ON]

CRUD Sample

[OFF]
CRUD Sample

Select Diagram Type to show

  1. Click [Add] button beside the function column
  2. Click on the Diagram to show in CRUD then click [OK]. To select all, click on [Select All]. To deselect all, click on [Deselect All].
  3. Selected Diagrams and all items in selected diagrams are shown in the Functions Column in Tree. Check items to show in CRUD.
    Selecting function objects

    ※You can select the UseCase diagram, Activity diagram, Data Flow diagram and Flowchart only.
    There is only one diagram type you can add in one CRUD.
section divider

Set Models

Show items by grouping by diagrams.

ER Diagram models on CRUD

Add diagrams and models

  1. Click [Add] button beside the Models column.
  2. Click on the diagram to show in CRUD then click [OK]. To select all, click on [Select All]. To deselect all, click on [Deselect All].
    Add models to CRUD
  3. Selected diagrams and all items in selected diagrams are shown in the Models Column in Tree. Check on the items to show in CRUD.
    Delete models from CRUD
section divider

Setting CRUD Value

You can directly enter C, R, U, D on the cell.
Configuring CRUD Format

Also, you can select a cell and enter [C], [R], [U], and [D] keys to set CRUD value directly. Or double-click on the cell to insert a value or right-click on the cell and select [Set CRUD Value].
Configuring CRUD format

section divider

Export CRUD to Excel

To export CRUD to Excel, go to [Tool] – [CRUD] – [Export CRUD to Excel] in the Main Menu.
Export CRUD to excel

section divider

Export CRUD Statistics to Excel

Select [Tool] – [CRUD] – [Export CRUD Statistics to Excel] from Main Menu to export all CRUD statistics in the project file to Excel.
Export CRUD

section divider

System Properties

You can set detailed settings from [Tools] – [System Properties] – [CRUD].
System Properties for CRUD