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

FieldsTypeChildren
idserialreport_data
owner_idbigint

 

  • Report Data Table

This Table has three fields in it

FieldsType
form_field_idbigserial
report_idbigserial
valueTEXT

 

  • Rebuild View Table

This Table has one field in it

FieldsType
form_idbigint

 

  • Report Data View Form 1 Table

This Table has two fields in it

FieldsType
form_idbigint
report_datajson

 

  • Report Data View Form 2 Table

This Table has two fields in it

FieldsType
form_idbigint
report_datajson

 

  • Report Data Form 1 Table

This Table has three fields in it

FieldsType
form_field_idbigint
form_idbigint
valueTEXT

 

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

  1. Click on schema from the top bar
  2. Click on properties 
  3. Check to Publish as a template
  4. Save changes