Data Models

Data modeling helps to demonstarte the types of data used and stored within your data bases, their relationships and the ways they can be grouped. data modelling allows you to get everyone on the same platform as it is easy to understand them, improve the quality of your data, save your valuable time and money and to make correct decisions.

How to create a Data Model

1. Click on My Data Model button on the menu and select the type of data model you are planning to use.
2. Specify whether you are going to use the Rapidomize’s default data base or a custom data base. Rapidomize provides you space to create your data models. You may use it.
3. If you are using a custom data base, you should provide details such as the port, IP address etc. and authorize Rapidomize to access it.
4. You will be directed to the screen where you can create data models.
5. Select your database schema.
6. You can either open and edit your existing data models or create a new data model by clicking on the (+) button.
7. Give a name for your new data model and press enter to create it.
8. Select your new data model and add the column/field names of each column of the data model/table by clicking on the (+) button.

• Type - Data type.

  If there is already data in the model/table, you are not allowed to change them. Therefore, correctly decide the data type before you input data to your table/model. Otherwise, you will need to use SQL to transform/update your data to a different type. Data type depends on the database type that you select. For the default database type based on PostgreSQL:

  Data Type	Description
  bigint	Signed eight-byte integer
  bit	Fixed-length bit string
  char	Fixed-length character string
  date	Calendar date (year, month, day)
  double precision	Double precision floating-point number
  integer	Signed four-byte integer
  json	Textual JSON data
  jsonb	Binary JSON data, decomposed
  numeric	Exact numeric of selectable precision
  real	Single precision floating-point number
  smallint	Signed two-byte integer
  time	Time of day
  timestamp	Date and time
  varchar (text)	Variable-length character string

  For more information see PostgreSQL Data Types

• Length - Can specify the length of a field

• Primary key - Allows to uniquely access a particular row/record

• Foreign key - Allows to build a relationship between two data models/tables. If Table 1 consists of two columns (Employee ID and Department) where Employee ID is the primary key and Department is a foreign key and Table 2 consistes of columns where Department is the primary key, you can refer the foreign key of table 1 (Department) to the primary key of Table 2 (Department) and build a relationship between the two tables.

• NOT NULL - Particular row/record of a given column must have a value

• Unique - Values of these columns can’t be duplicated

• Default - Assigns a default value automatically

9. Once you finish creating your data model/table, save it. Now, the data model/table is ready to input data either using workflows or SQL.
10. You can view the existing data of a model/table at any time by clicking the data tab.
11. If you know SQL, you can use the SQLtab to manage your data model/table and data.