Key Concepts

Understanding these core concepts will help you get the most out of SchemaStack.

Organization

The top-level container. An organization has members, settings, and one or more workspaces. Think of it as your company or team account.

Workspace

A workspace holds your data and its schema. Each workspace can have multiple views, and members can be assigned workspace-specific roles.

Workspace statuses:

• Active — Normal operation, all features available
• Read-Only — Data can be viewed but not modified
• Design — Schema changes allowed, data writes restricted
• Maintenance — Temporarily unavailable for modifications

View

A view is a configured perspective on your workspace data. Each view defines which columns are visible, their order, and default filters or sorting.

Views can be:

• Addable — Users can add new rows
• Editable — Users can modify existing data
• Read-only — View data without modification

Column

A column defines a single field in your data. Each column has:

• Name — The display label
• Type — The data type (text, number, date, boolean, etc.)
• Widget — How the data is displayed and edited (text input, dropdown, date picker, etc.)
• Widget Options — Per-widget settings (e.g., DATETIME columns can auto-set timestamps on insert or update)
• Constraints — Validation rules specific to this column

Constraint

Constraints enforce data quality rules. There are two levels:

Column Constraints

Rules applied to a single column's values:

• Not Blank — Value cannot be empty
• Min / Max — Numeric bounds
• Min Length / Max Length — Text length bounds
• Pattern — Must match a regular expression
• Email / URL — Format validation
• Positive / Negative — Sign constraints
• Past / Future — Date constraints

Entity Constraints

Rules that span multiple columns:

• Unique Composite — Combination of fields must be unique
• Field Comparisons — One field must be less than, greater than, or not equal to another
• Conditional Required — A field is required when another field has a value
• At Least One Required — At least one of several fields must have a value
• All or None — Either all selected fields have values, or none do

Preset

A saved configuration of filters, sorting, and column visibility. Presets let you quickly switch between different views of the same data, and share those configurations with your team.

Role

Permissions are managed through roles at two levels:

Organization Roles

• Owner — Full control over the organization
• Admin — Manage members, workspaces, and settings
• Member — Access workspaces they're assigned to

Workspace Roles

• Admin — Full control over the workspace
• Editor — Read and write data
• Viewer — Read-only access
• Member — Basic access