SchemaStack

Appearance

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

SchemaStack Documentation