Databases, Tables and Columns: Difference between revisions
Jump to navigation
Jump to search
(Created page with "* MemCP has a data folder which defaults to "./data". Every subdirectory of that folder is a database. * Databases consist of tables * Tables consist of columns and shards") |
No edit summary |
||
Line 2: | Line 2: | ||
* Databases consist of tables | * Databases consist of tables | ||
* Tables consist of columns and [[Shards, RecordIDs, Main Storage, Delta Storage|shards]] | * Tables consist of columns and [[Shards, RecordIDs, Main Storage, Delta Storage|shards]] | ||
* Columns have a name, a type, type dimensions | |||
* Some columns can be "computed columns" that are not filled by INSERT values but rather computed from an expression |
Latest revision as of 21:26, 17 May 2024
- MemCP has a data folder which defaults to "./data". Every subdirectory of that folder is a database.
- Databases consist of tables
- Tables consist of columns and shards
- Columns have a name, a type, type dimensions
- Some columns can be "computed columns" that are not filled by INSERT values but rather computed from an expression