Tables on UCD

  • Table name is stored in an entity named "Table," which is of synonym type, and has the table name as the value after replacing the spaces in the table name with underscores, and as the synonym, the complete and actual table name.
  • The columns of the tables are stored in an entity named “queriedColumns” as its value, and the type is synonym.
  • Synonyms for the entity can be added by the user from the column form, and they will be stored as synonyms of the given column value.
  • If the datatype of a column/parameter is "enum," in that case, it will be added as a value in “queriedColumns” as well as a separate entity will be created for it.
  • Example: Assume the column name is “gender” and the datatype for this is "enum," then the entity name will be "enum_gender," as well as the values of this entity that are added by the user and default values uploaded during importing the database information will also be appended to the values.