{ "_id": "6a1efa6ab401979e73418713", "Package": "ReDaMoR", "Type": "Package", "Title": "Relational Data Modeler", "Version": "1.0.0", "Authors@R": "c(\nperson(\n\"Patrice\", \"Godard\",\nrole = c(\"aut\", \"cre\",\"cph\"),\nemail = \"patrice.godard@gmail.com\"\n),\nperson(\n\"Kai\", \"Lin\",\nrole = c(\"ctb\")\n)\n)", "Maintainer": "Patrice Godard ", "Description": "The aim of this package is to manipulate relational data\nmodels in R. It provides functions to create, modify and export\ndata models in json format. It also allows importing models\ncreated with 'MySQL Workbench'\n(). These functions\nare accessible through a graphical user interface made with\n'shiny'. Constraints such as types, keys, uniqueness and\nmandatory fields are automatically checked and corrected when\nediting a model. Finally, real data can be confronted to a\nmodel to check their compatibility.", "URL": "https://patzaw.github.io/ReDaMoR/,\nhttps://github.com/patzaw/ReDaMoR/", "BugReports": "https://github.com/patzaw/ReDaMoR/issues", "License": "GPL-3", "Encoding": "UTF-8", "VignetteBuilder": "knitr", "Roxygen": "list(markdown = TRUE)", "Config/roxygen2/version": "8.0.0", "Config/pak/sysreqs": "cmake make libuv1-dev libx11-dev zlib1g-dev", "Repository": "https://patzaw.r-universe.dev", "Date/Publication": "2026-05-18 15:17:16 UTC", "RemoteUrl": "https://github.com/patzaw/redamor", "RemoteRef": "HEAD", "RemoteSha": "7b1aede73a77ba8182fb89f13098e9c5bc3ab229", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-18 15:24:33 UTC", "User": "root" }, "Author": "Patrice Godard [aut, cre, cph],\nKai Lin [ctb]", "MD5sum": "c94d3e37b94efb922290f26d1a277e8f", "_user": "patzaw", "_type": "src", "_file": "ReDaMoR_1.0.0.tar.gz", "_fileid": "e2027979d56fe42277bb5b2284314dbb9d3ff95fbcd8053ac7e6c0ae0ff442e7", "_filesize": 1706072, "_sha256": "e2027979d56fe42277bb5b2284314dbb9d3ff95fbcd8053ac7e6c0ae0ff442e7", "_created": "2026-05-18T15:24:33.000Z", "_published": "2026-06-02T15:44:42.240Z", "_distro": "noble", "_jobs": [ { "job": 79111562537, "time": 170, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7062067485" }, { "job": 79111561999, "time": 203, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7062081430" }, { "job": 79111562654, "time": 93, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7062034878" }, { "job": 79111562002, "time": 101, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7062038808" }, { "job": 79111561935, "time": 212, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7061995656" }, { "job": 79111561260, "time": 121, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7362677251" }, { "job": 79111562604, "time": 123, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7062048344" }, { "job": 79111562363, "time": 130, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7062050690" }, { "job": 79111562219, "time": 125, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7062049042" } ], "_buildurl": "https://github.com/r-universe/patzaw/actions/runs/26042800414", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/patzaw/redamor", "_commit": { "id": "7b1aede73a77ba8182fb89f13098e9c5bc3ab229", "author": "Patrice Godard ", "committer": "Patrice Godard ", "message": "Removed references to public instances no longer maintained\n", "time": 1779117436 }, "_maintainer": { "name": "Patrice Godard", "email": "patrice.godard@gmail.com", "login": "patzaw", "linkedin": "in/patrice-godard-65a25920", "description": "Data scientist and bioinformatician. Strong experience in multiomics data analysis applied to pharmaceutical research.", "uuid": 9802306 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1", "role": "Depends" }, { "package": "dplyr", "role": "Depends" }, { "package": "visNetwork", "role": "Depends" }, { "package": "readr", "role": "Imports" }, { "package": "shiny", "role": "Imports" }, { "package": "shinyjs", "role": "Imports" }, { "package": "jsonlite", "role": "Imports" }, { "package": "DT", "role": "Imports" }, { "package": "colourpicker", "role": "Imports" }, { "package": "rintrojs", "role": "Imports" }, { "package": "markdown", "role": "Imports" }, { "package": "rstudioapi", "role": "Imports" }, { "package": "crayon", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "graphics", "role": "Imports" }, { "package": "stats", "role": "Imports" }, { "package": "Matrix", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "igraph", "role": "Suggests" } ], "_owner": "patzaw", "_selfowned": true, "_usedby": 1, "_updates": [ { "week": "2026-17", "n": 5 }, { "week": "2026-18", "n": 1 }, { "week": "2026-19", "n": 1 }, { "week": "2026-21", "n": 4 } ], "_tags": [], "_stars": 19, "_contributors": [ { "user": "patzaw", "count": 170, "uuid": 9802306 }, { "user": "kai-lin-cci", "count": 2, "uuid": 206509970 } ], "_userbio": { "uuid": 9802306, "type": "user", "name": "Patrice Godard", "description": "Data scientist and bioinformatician. Strong experience in multiomics data analysis applied to pharmaceutical research." }, "_downloads": { "count": 244, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ReDaMoR" }, "_devurl": "https://github.com/patzaw/redamor", "_pkgdown": "https://patzaw.github.io/ReDaMoR/", "_searchresults": 23, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/readme.html", "extra/readme.md", "extra/ReDaMoR.html", "manual.pdf" ], "_homeurl": "https://github.com/patzaw/redamor", "_realowner": "patzaw", "_cranurl": true, "_releases": [ { "version": "0.4.2", "date": "2020-03-31" }, { "version": "0.4.3", "date": "2020-12-14" }, { "version": "0.5.2", "date": "2022-01-13" }, { "version": "0.6.3", "date": "2022-04-13" }, { "version": "0.6.5", "date": "2022-09-05" }, { "version": "0.7.1", "date": "2022-10-19" }, { "version": "0.7.2", "date": "2023-07-06" }, { "version": "0.7.4", "date": "2024-02-07" }, { "version": "0.7.6", "date": "2024-07-07" }, { "version": "0.8.2", "date": "2025-02-21" } ], "_exports": [ "add_field", "add_foreign_key", "add_index", "add_table", "as_type", "auto_layout", "check_foreign_keys", "check_types", "clean_autosaved_RelDataModels", "col_types", "confront_data", "confront_table_data", "conv_type_ref", "copy_fields", "correct_constraints", "df_to_model", "format_confrontation_report", "format_confrontation_report_md", "fromDBM", "get_foreign_keys", "guess_constraints", "identical_RelDataModel", "identical_RelTableModel", "index_table", "is_MM", "is.MatrixModel", "is.RelDataModel", "is.RelTableModel", "lengths", "list_autosaved_RelDataModel", "list_type_ref", "model_relational_data", "norm_type_ref", "order_fields", "order_indexes", "read_json_data_model", "read_named_MM", "read_named_MM_header", "read_SQL_data_model", "readSQLDataModel", "recover_RelDataModel", "RelDataModel", "RelTableModel", "remove_field", "remove_foreign_key", "remove_index", "remove_table", "rename_field", "rename_table", "set_primary_key", "set_unique_index", "SUPPTYPES", "toDBM", "update_field", "update_foreign_key", "update_table_display", "view_confrontation_report", "write_json_data_model" ], "_help": [ { "page": "sub-.RelDataModel", "title": "Subset a RelDataModel", "topics": [ "[.RelDataModel" ] }, { "page": "add_field", "title": "Add a field to a table in a RelDataModel", "topics": [ "add_field" ] }, { "page": "add_foreign_key", "title": "Add a foreign key between two tables", "topics": [ "add_foreign_key" ] }, { "page": "add_index", "title": "Add an index to a table in a RelDataModel", "topics": [ "add_index" ] }, { "page": "add_table", "title": "Add a table to a RelDataModel", "topics": [ "add_table" ] }, { "page": "as_type", "title": "Convert an object into a specific type", "topics": [ "as_type" ] }, { "page": "auto_layout", "title": "Pre-compute RelDataModel layout when missing any x or y table position", "topics": [ "auto_layout" ] }, { "page": "c.RelDataModel", "title": "Merge RelDataModel objects", "topics": [ "c.RelDataModel" ] }, { "page": "check_foreign_keys", "title": "Check the availability of foreign keys", "topics": [ "check_foreign_keys" ] }, { "page": "check_types", "title": "Check if a set of types is supported", "topics": [ "check_types" ] }, { "page": "clean_autosaved_RelDataModels", "title": "Remove all autosaved RelDataModel", "topics": [ "clean_autosaved_RelDataModels" ] }, { "page": "col_types", "title": "Get the types of the columns of a RelTableModel object", "topics": [ "col_types" ] }, { "page": "confront_data", "title": "Confront a RelDataModel to actual data", "topics": [ "confront_data" ] }, { "page": "confront_table_data", "title": "Confront a RelTableModel to actual data", "topics": [ "confront_table_data" ] }, { "page": "conv_type_ref", "title": "Convert a set of types from or to R supported types", "topics": [ "conv_type_ref" ] }, { "page": "copy_fields", "title": "Copy fields from one table to another in a RelDataModel", "topics": [ "copy_fields" ] }, { "page": "correct_constraints", "title": "Correct the constraints of a table to make them consistent", "topics": [ "correct_constraints" ] }, { "page": "df_to_model", "title": "Create a RelDataModel object from column names of data frames", "topics": [ "df_to_model" ] }, { "page": "format_confrontation_report", "title": "Format confrontation report for printing in console", "topics": [ "format_confrontation_report" ] }, { "page": "format_confrontation_report_md", "title": "Format confrontation report in markdown format", "topics": [ "format_confrontation_report_md" ] }, { "page": "format.RelTableModel", "title": "Format a RelTableModel object for printing", "topics": [ "format.RelTableModel" ] }, { "page": "fromDBM", "title": "Convert a list of 5 normalized tibbles in a RelDataModel object", "topics": [ "fromDBM" ] }, { "page": "get_foreign_keys", "title": "Get a foreign key table from an object", "topics": [ "get_foreign_keys" ] }, { "page": "get_foreign_keys.RelDataModel", "title": "Get foreign keys in RelDataModel", "topics": [ "get_foreign_keys.RelDataModel" ] }, { "page": "get_foreign_keys.RelTableModel", "title": "Get foreign keys from RelTableModel", "topics": [ "get_foreign_keys.RelTableModel" ] }, { "page": "guess_constraints", "title": "Guess RelDataModel constraints based on the provided or existing tables", "topics": [ "guess_constraints" ] }, { "page": "identical_RelDataModel", "title": "Check if two RelDataModel are identical", "topics": [ "identical_RelDataModel" ] }, { "page": "identical_RelTableModel", "title": "Check if two RelTableModel are identical", "topics": [ "identical_RelTableModel" ] }, { "page": "index_table", "title": "List indexes of a RelTableModel object", "topics": [ "index_table" ] }, { "page": "is_MM", "title": "Identify if a file is in MatrixMarket text format", "topics": [ "is_MM" ] }, { "page": "is.MatrixModel", "title": "Check if the object is a RelTableModel matrix object", "topics": [ "is.MatrixModel" ] }, { "page": "is.RelDataModel", "title": "Check if the object is a RelDataModel object", "topics": [ "is.RelDataModel" ] }, { "page": "is.RelTableModel", "title": "Check if the object is a RelTableModel object", "topics": [ "is.RelTableModel" ] }, { "page": "lengths", "title": "Lengths of object elements", "topics": [ "lengths" ] }, { "page": "list_autosaved_RelDataModel", "title": "List autosaved RelDataModel", "topics": [ "list_autosaved_RelDataModel" ] }, { "page": "list_type_ref", "title": "List supported types references", "topics": [ "list_type_ref" ] }, { "page": "model_relational_data", "title": "Relational data modeler GUI", "topics": [ "model_relational_data" ] }, { "page": "modelToVn", "title": "VisNetwork representation of a RelDataModel object", "topics": [ "modelToVn" ] }, { "page": "norm_type_ref", "title": "Normalize type names", "topics": [ "norm_type_ref" ] }, { "page": "order_fields", "title": "Order fields in a table in a RelDataModel", "topics": [ "order_fields" ] }, { "page": "order_indexes", "title": "Order index in a table in a RelDataModel", "topics": [ "order_indexes" ] }, { "page": "plot.RelDataModel", "title": "Plot a RelDataModel object", "topics": [ "plot.RelDataModel" ] }, { "page": "read_json_data_model", "title": "Read a data model from JSON", "topics": [ "read_json_data_model" ] }, { "page": "read_named_MM", "title": "Read a named sparse matrix in MatrixMarket text format", "topics": [ "read_named_MM" ] }, { "page": "read_named_MM_header", "title": "Read the header of a named sparse matrix in MatrixMarket text format", "topics": [ "read_named_MM_header" ] }, { "page": "read_SQL_data_model", "title": "Read a data model from an SQL file from the MySQL Workbench", "topics": [ "readSQLDataModel", "read_SQL_data_model" ] }, { "page": "recover_RelDataModel", "title": "Recover an autosaved RelDataModel", "topics": [ "recover_RelDataModel" ] }, { "page": "RelDataModel", "title": "Create a RelDataModel object", "topics": [ "RelDataModel" ] }, { "page": "RelTableModel", "title": "Create a RelTableModel object", "topics": [ "RelTableModel" ] }, { "page": "remove_field", "title": "Remove a field from a table in a RelDataModel", "topics": [ "remove_field" ] }, { "page": "remove_foreign_key", "title": "Remove a foreign key between two tables", "topics": [ "remove_foreign_key" ] }, { "page": "remove_index", "title": "Remove an index from a table in a RelDataModel", "topics": [ "remove_index" ] }, { "page": "remove_table", "title": "Remove a table from a RelDataModel", "topics": [ "remove_table" ] }, { "page": "rename_field", "title": "Rename an existing field in a RelDataModel table", "topics": [ "rename_field" ] }, { "page": "rename_table", "title": "Rename a table in a RelDataModel", "topics": [ "rename_table" ] }, { "page": "set_primary_key", "title": "Set the primary key a table in a RelDataModel", "topics": [ "set_primary_key" ] }, { "page": "set_unique_index", "title": "Set table index uniqueness in a RelDataModel", "topics": [ "set_unique_index" ] }, { "page": "SUPPTYPES", "title": "Supported R types", "topics": [ "SUPPTYPES" ] }, { "page": "toDBM", "title": "Convert a RelDataModel object in a list of 5 normalized tibbles", "topics": [ "toDBM" ] }, { "page": "update_field", "title": "Update field information in a table of a RelDataModel", "topics": [ "update_field" ] }, { "page": "update_foreign_key", "title": "Update a the cardinalities of a foreign key between two tables", "topics": [ "update_foreign_key" ] }, { "page": "update_table_display", "title": "Update the display of a table of a RelDataModel", "topics": [ "update_table_display" ] }, { "page": "view_confrontation_report", "title": "View confrontation report in rstudio viewer", "topics": [ "view_confrontation_report" ] }, { "page": "write_json_data_model", "title": "Write a data model in a JSON file", "topics": [ "write_json_data_model" ] } ], "_readme": "https://github.com/patzaw/redamor/raw/HEAD/README.md", "_rundeps": [ "base64enc", "bit", "bit64", "bslib", "cachem", "cli", "clipr", "colourpicker", "commonmark", "cpp11", "crayon", "crosstalk", "digest", "dplyr", "DT", "evaluate", "farver", "fastmap", "fontawesome", "fs", "generics", "ggplot2", "glue", "gtable", "highr", "hms", "htmltools", "htmlwidgets", "httpuv", "isoband", "jquerylib", "jsonlite", "knitr", "labeling", "later", "lattice", "lazyeval", "lifecycle", "litedown", "magrittr", "markdown", "Matrix", "memoise", "mime", "miniUI", "otel", "pillar", "pkgconfig", "prettyunits", "progress", "promises", "R6", "rappdirs", "RColorBrewer", "Rcpp", "readr", "rintrojs", "rlang", "rmarkdown", "rstudioapi", "S7", "sass", "scales", "shiny", "shinyjs", "sourcetools", "tibble", "tidyselect", "tinytex", "tzdb", "utf8", "vctrs", "viridisLite", "visNetwork", "vroom", "withr", "xfun", "xtable", "yaml" ], "_vignettes": [ { "source": "ReDaMoR.Rmd", "filename": "ReDaMoR.html", "title": "Modeling Relational Data in R with ReDaMoR", "author": "Patrice Godard", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Installation", "From CRAN", "Dependencies", "From github", "Creating and modifying relational data using the graphical user interface", "Running the app", "Model formalism", "Data model example: the Human Phenotype Ontology", "Tables", "Foreign keys", "App organization", "The main menu", "The model view", "The edition view", "Contextual help tour", "Keyboard shortcuts", "Adding foreign keys", "Confronting data", "Drafting a data model from data frames", "Support of matrices", "TKCat: Tailored Knowledge Catalog", "Acknowledgments", "References" ], "created": "2020-02-26 09:31:54", "modified": "2026-05-18 15:17:16", "commits": 29 } ], "_score": 6.418632687354066, "_indexed": true, "_nocasepkg": "redamor", "_universes": [ "patzaw" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.0", "date": "2026-05-18T15:27:02.000Z", "distro": "noble", "commit": "7b1aede73a77ba8182fb89f13098e9c5bc3ab229", "fileid": "026db175af98db30656ec6928cf9b708cd6fbac13b0300ceb20e3de77d1123cf", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26042800414" }, { "r": "4.6.0", "os": "linux", "version": "1.0.0", "date": "2026-05-18T15:27:37.000Z", "distro": "noble", "commit": "7b1aede73a77ba8182fb89f13098e9c5bc3ab229", "fileid": "64311229a72b26abbfe185d33ec41f082fe3fd76d3e8b7456e71f02c5a4a795e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26042800414" }, { "r": "4.5.3", "os": "mac", "version": "1.0.0", "date": "2026-05-18T15:26:04.000Z", "commit": "7b1aede73a77ba8182fb89f13098e9c5bc3ab229", "fileid": "b327ed2d9874c0499051c2963b06346b518939c6a0a18324b53cf3982e768f94", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26042800414" }, { "r": "4.6.0", "os": "mac", "version": "1.0.0", "date": "2026-05-18T15:26:07.000Z", "commit": "7b1aede73a77ba8182fb89f13098e9c5bc3ab229", "fileid": "4b2efb8fd57c0c90d1906a6a97c79ab8534f6c5ac160ac888fe6d7735ac84324", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26042800414" }, { "r": "4.7.0", "os": "win", "version": "1.0.0", "date": "2026-05-18T15:26:05.000Z", "commit": "7b1aede73a77ba8182fb89f13098e9c5bc3ab229", "fileid": "b89b866288c1716c52644f8947ed433522d6288fd0cbd67aad11d8e6300a566d", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26042800414" }, { "r": "4.5.3", "os": "win", "version": "1.0.0", "date": "2026-05-18T15:26:13.000Z", "commit": "7b1aede73a77ba8182fb89f13098e9c5bc3ab229", "fileid": "166db5404080d705d75f3bc9da98b3754cd4bb59d47bec53f30db890cd64dc6e", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26042800414" }, { "r": "4.6.0", "os": "win", "version": "1.0.0", "date": "2026-05-18T15:26:04.000Z", "commit": "7b1aede73a77ba8182fb89f13098e9c5bc3ab229", "fileid": "a71a79fe67e4e747ad710808e6e9a9020eb262116c31650b7aef5502c222d600", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26042800414" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.0", "date": "2026-06-02T15:44:15.000Z", "commit": "7b1aede73a77ba8182fb89f13098e9c5bc3ab229", "fileid": "b29ecaa2410a945ffc2406dafc71c6ca5c7cf43b4c0abbea55062c962e245f06", "status": "success", "buildurl": "https://github.com/r-universe/patzaw/actions/runs/26042800414" } ] }