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