Skip to content

Add option to create schema tables without constraints #81

@anthonysena

Description

@anthonysena

Currently, generateSqlSchema will generate SQL to create a schema based on the results data model specification which may include constraints (primary keys at the moment). In the case that we are bulk-loading results from a study, we may want to add constraints after data is loaded.

I'd propose we extend generateSqlSchema to allow for a new parameter includeConstraints = TRUE so we can optionally disable constraints. The add another function generateSqlContraints to generate the SQL necessary to apply any/all constraints.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions