Shows the sub registry and its properties. It can show the different types of rates (Monthly / Daily / Hourly) or what kind of leave entitlement there is (Sick / Annual). It also includes the different data types where you are able to customise according to your needs.

Shows all the different identities of the sub registry. It can show the different types of rates (Monthly / Daily / Hourly) or what kind of entitlement there is (Sick / Annual). This holds the primary key for the SubRegistry table.

Shows the registry property.

Shows the registry property.

Shows the registry property.

Shows the registry property.

Shows the registry property.

Shows the registry property.

Shows the registry property.

Shows the registry property.

Shows the registry property.

Shows the registry property.

A double attribute, with real or rational numbers.

An attribute with an integer, i.e. whole numbers.

A character attribute. It can store text information, such as names and contact numbers.
Example: Phone numbers / zip codes, although they are mostly numbers, it is best stored as character values.

A boolean attribute, usually in a form of a checkbox can either be true or false. Ticking the box will show "1" in the database while not checking the box will show "0".

A short string attribute. It can include letters, digits and special characters. It is a sequence of characters.
Example: BRPDayFormula1 / the title of the person, i.e. Mr.

A string attribute. It is a data type which includes letters, digits and special characters. It is a sequence of characters.

An attribute with a date with the format DD-MM-YYYY.

An attribute with the date and time, usually showing the date first followed by the time.