Standard Studio¶
Standard Studio is ThinkERD's dedicated workspace for defining and managing data standards. It enables your entire team to use consistent naming conventions by systematically managing words, terms, and domains.
Accessing Standard Studio¶
Select the Standard Studio icon in the left sidebar to enter. Standard Studio provides an independent interface separate from the ERD canvas.
Workspace-Level Management
Standard Studio's standard data is managed at the workspace level. All projects and diagrams within the same workspace share the same standard dictionary.
Layout¶
Standard Studio is organized into 3 tabs, each corresponding to the Words → Terms → Domains three-tier standard system.
Words Management¶
View and manage all standard words registered in the workspace in a grid format.
| Feature | Description | Use Case |
|---|---|---|
| Inline editing | Click a cell to edit directly | Quick typo fixes, abbreviation changes |
| Batch add | Register multiple words at once | Bulk registration during initial setup |
| Search & Filter | Rapid search by logical/physical name | Instantly find words among thousands |
| Prohibited toggle | Mark/unmark banned words | Prevent non-standard term usage |
| Sort | Sort by clicking column headers | Sort by recent, alphabetical, etc. |
Word Registration Workflow¶
- Click the + Add button to create a new row
- Enter the logical name — e.g.,
Customer - Enter the physical abbreviation — e.g.,
CUST - Enter the full English name — e.g.,
Customer - (Optional) Add synonyms to register alternative expressions — e.g.,
Client,Buyer - (Optional) Mark non-standard words as prohibited and link replacement words
Bulk Registration
Copy-paste word lists from Excel or CSV to register multiple words at once. Match the column order for automatic mapping.
Terms Management¶
Manage standard terms composed from word combinations. Terms are the units directly applied to ERD columns.
| Feature | Description |
|---|---|
| Auto-compose | Physical term is auto-generated when words are selected (e.g., Customer(CUST) + Number(NO) → CUST_NO) |
| Domain binding | Linking a domain to a term auto-applies the data type to columns |
| Usage tracking | View the list of columns where this term is applied |
| Validation | Warns when unregistered words are included in terms |
Term Creation Examples¶
Customer No → Customer(CUST) + Number(NO) → CUST_NO
Order Date → Order(ORD) + Date(DT) → ORD_DT
Product Amt → Product(PROD) + Amount(AMT) → PROD_AMT
Domains Management¶
Define standardized type specifications for data types. Ensures consistent types for columns of the same nature.
| Feature | Description |
|---|---|
| DBMS-specific types | Configure physical types individually for Oracle, PostgreSQL, MySQL, etc. |
| Length/Precision | Specify Length, Scale values |
| Default values | Set Default Value |
Domain Usage Examples¶
Defining an Amount domain applies the same type to all amount-related columns:
| Domain | Oracle | PostgreSQL | MySQL |
|---|---|---|---|
| Amount | NUMBER(18,2) | NUMERIC(18,2) | DECIMAL(18,2) |
| Code | VARCHAR2(20) | VARCHAR(20) | VARCHAR(20) |
| Date | DATE | DATE | DATE |
| Large Text | CLOB | TEXT | LONGTEXT |
Global Template¶
Building a standard dictionary from scratch requires significant effort. ThinkERD provides predefined templates for a quick start.
| Template | Contents | Best For |
|---|---|---|
| Public Data Standards | Words/terms based on government data standards | Government agencies, public sector projects |
| Industry Standards | Industry-specific data standards (finance, telecom) | Projects following industry conventions |
Template Application Workflow¶
- Enter Standard Studio and click the Apply Template button
- Select the desired template
- Words, terms, and domains are bulk registered
- Customize for your project:
- Remove unnecessary words
- Add project-specific words
- Adjust domain lengths/precisions
Templates are a starting point
After applying a template, you can freely add or modify words to match your workspace. Templates are just a starting point — fully extensible and customizable.
Practical Scenarios¶
Scenario 1: Building Standards for a New Project¶
- Apply a Global Template to establish a base word dictionary
- Add project-specific business terms (e.g., for insurance:
Policy,Claim,Premium) - Define domains (type standards for amounts, codes, dates, etc.)
- Register common terms (standardize frequently used column names)
- Verify that entering logical names during ERD creation auto-generates physical names
Scenario 2: Migrating Existing Standards¶
- Copy word lists from existing standard dictionary files (Excel)
- Paste into Standard Studio's Words tab for bulk registration
- Review and fix physical abbreviation consistency
- Define domains and bind them to terms