Collection Overview

NocoBase provides a unique DSL to describe the structure of data, known as Collection, which unifies the data structure from various sources, providing a reliable foundation for data management, analysis, and application.

20240512161522

To conveniently use various data models, it supports various types of collections:

  • General collection: Built-in common system fields;
  • Inheritance collection: You can create a parent collection and then derive a child collection from the parent collection. The child collection will inherit the structure of the parent collection and can also define its own columns.
  • Tree collection: Tree structure collection, currently only supports adjacency list design;
  • Calendar collection: Used to create calendar-related event collections;
  • File collection: Used for file storage management;
  • : Used for dynamic expression scenarios in workflows;
  • SQL collection: Not an actual database collection, but quickly presents SQL queries in a structured manner;
  • View collection: Connects to existing database views;
  • External collection: Allows the database system to directly access and query data in external data sources, based on FDW technology.