What Is a CRUD Table?

With Astah Professional, you can create a CRUD table that shows which functions Create, Read, Update, or Delete which model elements. It helps you confirm responsibility, coverage, and gaps in your design.

CRUD Table Sample

Create a CRUD Table

To create a CRUD table, go to Diagram → CRUD in the main menu. A new CRUD diagram is added to the project and appears in the Structure Tree.
Menu to create CRUD

Edit a CRUD table

You can open the CRUD edit window in either of these ways:

  • Right-click the CRUD diagram in the Structure Tree and select Edit CRUD.
  • Select the CRUD diagram and click Edit CRUD in the Property View.
    Edit CRUD
section divider

CRUD Edit Window

In the edit window, you configure which items appear in the table:

  • Functions (left): operations extracted from selected diagrams
  • Models (right): model elements extracted from selected diagrams
  • Options (bottom): grouping and display settings

After you finish selecting items, click OK to update the table.
CRUD Edit Window

Set Functions

Functions are listed on the left side of the edit window.

Show CRUD by group

Turn on [Show CRUD by group] to display functions grouped under their diagram names. Turn it off to show all functions in one flat list.

  • On:
    Show CRUD by group: on
  • Off:
    Show CRUD by group: off

Select diagram types to include

  1. Click [Add] next to Functions.
  2. Select the diagrams you want to include, then click [OK].
  3. In the Functions tree, check the functions you want to display.
    Add Functions to CRUD

NOTE:

  • You can add functions from Use Case, Activity, Data Flow, or Flowchart diagrams.
  • Only one diagram type can be added per CRUD table.

Set Models

Model elements are listed on the right side of the edit window.

ER Diagram models on CRUD

Select diagrams to include

  1. Click [Add] next to Models.
  2. Select the diagrams you want to include, then click [OK].
    Select diagrams to include in the CRUD table
  3. In the Models tree, check the model elements you want to display.
    Select models to include in the CRUD table

Set CRUD Values

You can set CRUD values in three convenient ways:

  • Type directly into a cell (C, R, U, D).
  • Select a cell and press C / R / U / D on your keyboard.
  • Right-click or double-click a cell and select Set CRUD Value.
    Setting a CRUD value

You can update values at any time; the table refreshes immediately.

Export CRUD to Excel

To export the current CRUD table, go to Tools → CRUD → Export CRUD to Excel.

Choose a location and file name, then click Save.
Export CRUD to Excel

Export CRUD statistics to Excel

To export a project-wide summary of CRUD coverage, go to Tools → CRUD → Export CRUD Statistics to Excel. This export includes statistics for all CRUD tables in the project.

System Properties

You can configure CRUD behavior, including the default display options, in Tools → System Properties → CRUD.
System Properties for CRUD