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.