Your First Table

Available to: Developers, Admins Minimum plan: Free

This tutorial walks you through the complete workflow of creating a reference data table in TitanRDM — from defining a domain, through to entering data. By the end, you will have a working table that your team can view and edit.

Prerequisites

  • A TitanRDM account that has been activated
  • You are signed in as a user with a Developer licence
  • You are on the correct branch (Development for Business/Enterprise plans, Production for Free/Team plans)

Tip: Your current branch is shown in the top-right corner of the dashboard and in the header bar. To switch branches, click the branch name and select a different one.

Step 1: Create a Domain

Domains organise your tables into subject areas and control who can access them. You need at least one domain before you can create a table.

  1. In the sidebar, expand Admin and click Domains
  2. Click New Domain
  3. Fill in the form:
    • Name — a descriptive name, e.g., Finance
    • Description — optional, e.g., Finance reference data tables
    • Abbreviation — a short code (max 4 characters), e.g., fin. This is used as a prefix to the physical database table name.
  4. Click Create Domain

Create domain form

TitanRDM automatically creates default user groups and permissions for the new domain, so developers on your account can immediately start creating tables within it.

Step 2: Create a Table Definition

A table definition describes the structure of your reference data table — think of it as the schema.

  1. In the sidebar, expand Development and click Table Definitions
  2. Click New Table Definition
  3. Fill in the form:
    • Branch — pre-filled with your current branch (read-only)
    • Domain — select the domain you just created (e.g., Finance)
    • Table definition name — e.g., Currency Codes
    • Database table name — auto-generated from the name, e.g., currency_codes. You can customise this if needed.
    • Description — optional, e.g., ISO 4217 currency codes and names
    • Allow new rows to be added manually — check this box if users should be able to add rows through the UI. Leave unchecked if data will come from only file uploads or source system API/SDK syncs.
  4. Click Create Table Definition

Create table definition form

Note: The Key field is a system-generated identifier that is maintained across branches. You do not need to set this.

Step 3: Add Column Definitions

After creating the table definition, you are taken to the Edit Columns page where you define the columns for your table.

Using the Column Grid

The column editor uses an interactive grid where you can add, edit, and reorder columns.

Tip: You can alternatively import the schema from a CSV file using the Import Schema button to make this process faster.

  1. The top row of the grid is reserved for adding a new column.
  2. Fill in the column properties:
PropertyDescriptionExample
NameColumn name. Must start with a letter or underscore.currency_code
Data TypeThe data type for the column.varchar
LengthMaximum length (for varchar) or precision (for decimal).3
ScaleDecimal places (for decimal types only).—
Primary KeyCheck if this column uniquely identifies a row.Yes
RequiredCheck if this column must always have a value.This is automatically ticked and disabled for primary key columns
DescriptionOptional description shown to users.scroll across and enter ISO 4217 three-letter code
Valid ValuesComma-separated list of allowed values (optional).—

  1. Click the + button to add the new row

  2. Add more columns as needed. For this tutorial, create:

NameData TypeLengthPKRequired
currency_codevarchar3YesYes
currency_namevarchar100NoYes
numeric_codevarchar3NoNo
minor_unitsinteger—NoNo

Column definitions grid

Tip: You can reorder columns by dragging them, using the "6 dot" drag handle on the left.

Supported Data Types

TitanRDM supports a wide range of data types:

  • Text: varchar, character, text
  • Numeric: integer, smallint, bigint, decimal, real, double
  • Boolean: boolean
  • Date/Time: date, time, timetz, timestamp, timestamptz
  • Binary: binary

Step 4: Deploy the Table

Creating a table definition only defines the metadata — it does not create the physical database table. To make the table available for data entry, you need to deploy it.

  1. In the top menu bar, click Deploy
  2. You will see a list of table definitions that have changes requiring deployment. The "Currency Code" table will be ticked by default. You can choose to deploy all or select specific tables.
  3. Click the Create Deployment button
  4. The Deployment table appears, showing you what tables will be deployed, including the changes that will be made to each table in the deployment. In this case only a single table is being deployed, and since this is a new table, the changes will be the creation of the table.
  5. Review the changes — TitanRDM shows exactly what will be created (new table, columns, constraints)
  6. Click Deploy

Deployment review page

TitanRDM will: - Create the physical database table with the columns you defined - Add system columns (trdm_sk as the surrogate key, plus audit columns for created/updated timestamps and user tracking) - Mark the table definition as deployed

Note: On Free and Team plans, you work directly on the Production branch, so your deployed table is immediately live. On Business/Enterprise plans, you deploy to your private branch (e.g., Development) and later promote to Test and Production.

Step 5: View and Enter Data

Now that your table is deployed, you can view it and start entering data.

  1. In the sidebar, expand Tables — you should see the Finance domain listed, and within it, your new table
  2. Click the table name (e.g., Currency Codes)

You are now in the data grid — an interactive spreadsheet-like interface.

Data grid with sample data

Adding Records

If you enabled Allow new rows to be added manually on the table definition:

  1. The top row of the grid is a special row for adding new records
  2. Fill in the values for each column directly in the top row cells. The UID is a reserved system-generated surrogate primary key.
  3. Click the + button to save your changes

Editing Records

  • Click any cell to edit it inline
  • Changes are saved automatically when you move to another cell
  • For columns with valid values defined, a dropdown appears with the allowed options
  • For foreign key columns, a lookup dropdown shows values from the referenced table

Sorting and Filtering

  • Click a column header to sort
  • Use the column menu (right-click the header) to filter by value
  • The grid supports multi-column sorting

Data grid with data entered

What You Have Built

Congratulations! You have completed the core TitanRDM workflow:

  1. Domain — organised your table into a subject area
  2. Table Definition — described the structure of your reference data
  3. Column Definitions — specified the columns, data types, and constraints
  4. Deployment — created the physical database table
  5. Data Entry — added and edited reference data through the grid

This is the foundation for everything else in TitanRDM. From here you can:

What's Next