Home

-Manor DB Documentation- // UNDER CONSTRUCTION//

---

Column Types:

the Data Types Supported by this database manager.

Column Type	Summary	Value Type	Default Value
Primary Key	A unique identifier for the row of the table.	string	`null`
Text	A String of text.	string	`null`
Numerical	Any number value.	double	`null`
Integer	A number value without a fractional component.	int	`null`
Bool	A true or false value.	bool	`false`
SubTable	A value containing table data with a structure that is tied to the column.	Dictionary<int,<string,dynamic>>	`{}`
Foreign Key Refrence	A value tied to the primary key in the row of another main table. cells of this column provide a dropdown menu of primary keys in the refrenced table.	string	`null`
Parent SubTable Foreign Key Refrence	A value tied to the primary key in the row of subtables at and above the the column within the same dictionary branch.	string	`null`
Auto Table Constructor Script	A script which defines a table's columns that is used by the "Auto Table Constructor Script Receiver" column type to construct a subtable structure.	string	`null`
Auto Table Constructor Script Receiver	A subtable structured from another table's "Auto Table Constructor Script" column cell data.	Dictionary<int,<string,dynamic>>	`{}`

Column Management:

right click the column header for options that alter columns, these options are listed here.

Restrictors:

Restrictors are features that can be used to minimize mistakes when writing to your database through restrictions imposed via the editor.

• Adjacent Column Disabler: You can clarify columns that aren't meant to be filled out at the same time by restricting a column to disable itself when another column at the same row contains data.

• Subtable Single Row Restriction: If your subtable column data functions more as a folder rather than a list, you can restrict the subtable column's data to a single row to indicate this. (it will appear as an additional option in the dropdown menu that appears when right clicking the subtable's column header.)

File Regex Reference Table:

A "File Regex Reference Table" can be built when creating a new table and selecting the "File Regex Reference Table" Table Type. The table references its row data from an external file that is defined via the "Regex Reference Table Constructor Editor". It is opened via the "Edit Regex Reference Table Constructor" button in the top menu bar while the table is selected and contains instructions on how to use it.

Other Functionality:

• Hide/Unhide Columns: this feature can be used to hide/minimize columns and better see the columns you want to edit if you have a wide and shallow data model that stores many columns across one row. With this feature, there's no need for unnecessary categorization just so the data can be more easily viewed in the editor (this is only for the main table columns and not for subtables).

• Colored Bookmarks for Table Tabs: by right-clicking a tab, you can select the "Bookmark" option which allows you to add a colored line at the top of the tab's text to increase its visibility if you have a lot of tables to sift through.