Skip to contents

Convert a RelDataModel object in a list of 5 normalized tibbles

Usage

toDBM(rdm)

Arguments

rdm

a RelDataModel object

Value

A list with the following tibbles:

  • tables: The tables in the model with the following information

    • name: the name of the table

    • x: the x coordinate of the table in the model drawing (NA ==> position undefined)

    • y: the y coordinate of the table in the model drawing (NA ==> position undefined)

    • color: the color of the table in the model drawing (NA ==> undefined)

    • comment: comment about the table

  • fields: The fields in the model with the following information

    • name: the name of the field

    • type: the type of the field

    • nullable: a logical indicating if the field can be null

    • comment: comment about the field

    • table: the name of the table to which the field belongs

  • primaryKeys: The primary keys in the model with the following information

    • table: the name of the relevant table

    • field: the name of the field participating to the primary key

  • foreignKeys: The foreign keys in the model with the following information

    • table: the name of the referring table

    • fki: the identifier of the foreign key (by referring table)

    • field: the name of the referring field

    • refTable: the name of the referred table

    • refField: the name of the referred field

  • indexes: The indexes in the model with the following information

    • table: the name of the relevant table

    • idx: the identifier of the index (by table)

    • field: the name of the field participating to the index

    • unique: a logical indicating if the field is unique