MariaDB is an open-source relational database management system that started as a fork of MySQL. It is widely used as an application database and as a staging area for analytics. Dawiso reads the structure of your MariaDB databases from INFORMATION_SCHEMA: tables, views, columns, stored procedures and functions with their parameters and code, sequences, events, triggers, and foreign keys. Dawiso doesn’t read the data stored in your tables.
Default hierarchy
The chart below shows the organizational structure of MariaDB objects. Objects are represented in green and folders are in yellow. Folders group the objects of one type and are hidden when they are empty.
Dawiso creates one Schema for each database you list in the data source. Each schema holds Tables, Views, Functions, Stored Procedures, Sequences, and Events folders. Tables also hold a Triggers folder for their columns’ triggers.
Object types
Schema
Maps to the MariaDB Schema object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| schema_name | Name |
Table
Maps to the MariaDB Table object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| table_name | Name |
| table_comment | Scanned Description |
| table_rows | Row count |
| data_length + index_length (in MB) | Size MB |
| engine | Engine |
| table_type | System Versioned |
| partition_method | Partition Method |
| number of partitions | Partition count |
| partition_expression | Partition Expression |
| create_time | Created at |
| update_time | Modified at |
| table_collation | Collation |
For system-versioned tables, System Versioned is true.
Table column
Maps to the MariaDB Table Column object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| column_name | Name |
| column_comment | Scanned Description |
| ordinal_position | Ordinal position |
| is_nullable | Nullable |
| data_type | Data Type |
| column_type | Data type name |
| column_key | Key |
| numeric_scale | Numeric scale |
| character_maximum_length | Length |
| column_default | Default value |
| character_set_name | Character Set |
| collation_name | Collation |
| is_generated | Is Computed |
| generation_expression | Generation Expression |
| extra (INVISIBLE) | Is hidden |
View
Maps to the MariaDB View object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| table_name | Name |
| table_comment | Scanned Description |
| view_definition | Definition (SQL) |
| check_option | Check Option |
| is_updatable | Is Updatable |
| definer | Definer |
| security_type | Security type |
MariaDB views have no comment, so Scanned Description is empty for a valid view. If a view references a table, column, or function that no longer exists, MariaDB reports an error in place of the comment, and Scanned Description shows that error text, for example View 'sales.v_orders' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them.
View column
Maps to the MariaDB View Column object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| column_name | Name |
| column_comment | Scanned Description |
| ordinal_position | Ordinal position |
| is_nullable | Nullable |
| data_type | Data Type |
| column_type | Data type name |
| numeric_scale | Numeric scale |
| character_maximum_length | Length |
| column_default | Default value |
| character_set_name | Character Set |
| collation_name | Collation |
Function
Maps to the MariaDB Function object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| routine_name | Name |
| routine_comment | Scanned Description |
| data_type | Data Type |
| dtd_identifier | Data type name |
| character_maximum_length | Length |
| numeric_precision | Numeric precision |
| numeric_scale | Numeric scale |
| character_set_name | Character Set |
| collation_name | Collation |
| routine_definition | Definition (SQL) |
| is_deterministic | Is deterministic |
| sql_data_access | SQL Data Access |
| security_type | Security type |
| sql_mode | SQL Mode |
| definer | Definer |
| created | Created at |
| last_altered | Modified at |
Function parameter
Maps to the MariaDB Function Parameter object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| parameter_name | Name |
| parameter_mode | Mode |
| ordinal_position | Ordinal position |
| data_type | Data Type |
| dtd_identifier | Data type name |
| character_maximum_length | Length |
| numeric_precision | Numeric precision |
| numeric_scale | Numeric scale |
| collation_name | Collation |
| character_set_name | Character Set |
Procedure
Maps to the MariaDB Procedure object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| routine_name | Name |
| routine_comment | Scanned Description |
| routine_definition | Definition (SQL) |
| is_deterministic | Is deterministic |
| sql_data_access | SQL Data Access |
| security_type | Security type |
| sql_mode | SQL Mode |
| definer | Definer |
| created | Created at |
| last_altered | Modified at |
Procedure parameter
Maps to the MariaDB Procedure Parameter object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| parameter_name | Name |
| parameter_mode | Mode |
| ordinal_position | Ordinal position |
| data_type | Data Type |
| dtd_identifier | Data type name |
| character_maximum_length | Length |
| numeric_precision | Numeric precision |
| numeric_scale | Numeric scale |
| collation_name | Collation |
| character_set_name | Character Set |
Sequence
Maps to the MariaDB Sequence object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| table_name | Name |
| start_value | Start Value |
| minimum_value | Minimum Value |
| maximum_value | Maximum Value |
| increment | Increment |
| cycle_option | Cycle |
The sequence values come from INFORMATION_SCHEMA.SEQUENCES, which MariaDB provides from version 11.5. On earlier versions, Dawiso ingests sequences without these values.
Event
Maps to the MariaDB Event object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| event_name | Name |
| event_comment | Scanned Description |
| event_definition | Definition (SQL) |
| event_type | Event Type |
| interval_value + interval_field | Interval |
| status | Status |
| starts | Starts |
| ends | Ends |
| definer | Definer |
| created | Created at |
| last_altered | Modified at |
Trigger
Maps to the MariaDB Trigger object type.
| Source attribute | Target attribute in Dawiso |
|---|---|
| trigger_name | Name |
| action_statement | Definition (SQL) |
| event_manipulation | Trigger Event |
| action_timing | Trigger Timing |
| action_order | Action Order |
| definer | Definer |
| created | Created at |
Triggers are shown under the table they belong to.
Relations
| From object type | Relation type | To object type | Note |
|---|---|---|---|
| Table | foreign key child / foreign key parent | Table | Foreign keys between tables. Read from INFORMATION_SCHEMA.KEY_COLUMN_USAGE. |
| Table Column | foreign key child / foreign key parent | Table Column | Foreign keys between table columns. Read from INFORMATION_SCHEMA.KEY_COLUMN_USAGE. |
The table or column that holds the foreign key is the child, and the referenced table or column is the parent. Dawiso creates these relations only when both tables are in the same database.
System objects
Dawiso skips the MariaDB system databases mysql, information_schema, performance_schema, and sys, even if you list them in the data source.