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.

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.