Today we are talking about a template named Reports on DbDesigner.net
This is a template on the DbDesigner template section which is called Reports and the Database is Postgres.
There are 10 Tables in the design.
Table names are:
- Fields
- Forms
- Form Fields
- Report
- Report Data
- Rebuild View
- Report Data View Form 1
- Report Data View Form 2
- Report Data Form 1
- Report Data Form 2
Fields Table
This Table has four fields in it
Fields | Type | Children | Parents |
id | serial | Fields & form_fields | fields |
parent_id | bigint | ||
name | character | ||
description | character |
Forms Table
This Table has two fields in it
Fields | Type | Children |
id | serial | form_fields, report_data_view_form_1, report_data_view_form_2 & rebuild_view |
name | character |
Form Fields Table
This Table has four fields in it
Fields | Type | Children | Parents |
field_id | bigserial | ||
form_id | bigserial | ||
id | serial | report_data | Forms & fields |
params | json |
Report Table
This Table has two fields in it
| Fields | Type | Children |
| id | serial | report_data |
| owner_id | bigint |
Report Data Table
This Table has three fields in it
| Fields | Type |
| form_field_id | bigserial |
| report_id | bigserial |
| value | TEXT |
Rebuild View Table
This Table has one field in it
| Fields | Type |
| form_id | bigint |
Report Data View Form 1 Table
This Table has two fields in it
| Fields | Type |
| form_id | bigint |
| report_data | json |
Report Data View Form 2 Table
This Table has two fields in it
| Fields | Type |
| form_id | bigint |
| report_data | json |
Report Data Form 1 Table
This Table has three fields in it
| Fields | Type |
| form_field_id | bigint |
| form_id | bigint |
| value | TEXT |
Report Data Form 2 Table
This Table has three fields in it
Fields | Type |
form_field_id | bigint |
form_id | bigint |
value | TEXT |
Template can be found on DbDesigner.net
Template Direct Link: https://dbdesigner.page.link/Zt2Tyi8oPrK2tqFN9
Tip of the Day:
How to publish Model as Template
Steps:
- Click on schema from the top bar
- Click on properties
- Check to Publish as a template
- Save changes
Recent Comments