Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-16810

Butler schema changes to run on Oracle

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: butler
    • Labels:
    • Templates:
    • Story Points:
      1
    • Team:
      Data Release Production

      Description

      We had a few issues importing the Butler schema into Oracle that should be relatively easy correct.

      Oracle does not have a boolean data type for table columns. The column actual in table Datasetconsumers is a boolean in SQLite. We suggest changing that to varchar2(1) and adding a "actual in ('T','F')"check constraint in Oracle.

      "Size" is a reserved word in Oracle. The size column in table posixdatastorerecords will need to be renamed.

      "Group" is a reserved word in Oracle. The group column in table detector will need to be renamed.

      There is a data type mismatch in constraint Dataset_fk6 between column detector (number) in table detector and column detector (varchar) in table dataset. Data types must match in columns defined in FK/PK constraints.

        Attachments

          Activity

            People

            • Assignee:
              jbosch Jim Bosch
              Reporter:
              cs2018 Christopher Stephens
              Reviewers:
              Michelle Gower
              Watchers:
              Christopher Pond, Christopher Stephens, Jim Bosch, Michelle Gower
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Summary Panel