5 DB - Schema

Jannik Meier edited this page 2023-11-28 11:35:15 +01:00

Table of Contents

• User
• Group
• UserxGroup
• GroupxRecordType
• RecordType
• RecordAttribute

This chapter contains the structure of our internal database tables.

• := unique

User

• Name
• Surname
• Username*
• E-Mail*
• Password
• UID*

Group

• Name (str)
• UID*

UserxGroup

• User (ref)
• Group (ref)

GroupxRecordType

• Group (ref)
• Recordtype (ref)

RecordType

• Name (str)

RecordAttribute

• RecordType (ref)
• Value (str)
• Datatype (str)
• Locked (bool)
• Unique (bool)