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 22: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