pacifica / pacifica-metadata

Pacifica core service that stores the metadata for the system
GNU Lesser General Public License v3.0
1 stars 8 forks source link

Update metadata model documentation to reflect actual model. #231

Closed GitBytes closed 5 years ago

GitBytes commented 5 years ago

Pacifica Metadata version

pacifica-metadata 0.10.2

Scenario:

I am trying to find a list of released transactions

Steps to Reproduce:

Install v0.10.2 with postgresql

Expected Result:

Table called TransactionRelease or something to that effect per transactionrelease metadata model description

Actual Result:

                List of relations
 Schema |         Name         | Type  |  Owner
--------+----------------------+-------+----------
 public | analyticaltools      | table | pacifica
 public | atoolproject         | table | pacifica
 public | atooltransaction     | table | pacifica
 public | citationcontributor  | table | pacifica
 public | citationdoi          | table | pacifica
 public | citationkeyword      | table | pacifica
 public | citationproject      | table | pacifica
 public | citations            | table | pacifica
 public | citationtransaction  | table | pacifica
 public | contributors         | table | pacifica
 public | datasources          | table | pacifica
 public | doiauthormapping     | table | pacifica
 public | doiauthors           | table | pacifica
 public | doidatasets          | table | pacifica
 public | doientries           | table | pacifica
 public | doiinfo              | table | pacifica
 public | doiresource          | table | pacifica
 public | doitransaction       | table | pacifica
 public | filekeyvalue         | table | pacifica
 public | files                | table | pacifica
 public | groups               | table | pacifica
 public | institutions         | table | pacifica
 public | institutionuser      | table | pacifica
 public | instrumentdatasource | table | pacifica
 public | instrumentgroup      | table | pacifica
 public | instrumentkeyvalue   | table | pacifica
 public | instruments          | table | pacifica
 public | instrumentuser       | table | pacifica
 public | journals             | table | pacifica
 public | keys                 | table | pacifica
 public | keywords             | table | pacifica
 public | metadatasystem       | table | pacifica
 public | projectgroup         | table | pacifica
 public | projectinstrument    | table | pacifica
 public | projects             | table | pacifica
 public | projectuser          | table | pacifica
 public | relationships        | table | pacifica
 public | transactionkeyvalue  | table | pacifica
 public | transactions         | table | pacifica
 public | transactionuser      | table | pacifica
 public | transsap             | table | pacifica
 public | transsip             | table | pacifica
 public | usergroup            | table | pacifica
 public | users                | table | pacifica
 public | values               | table | pacifica
(45 rows)
GitBytes commented 5 years ago

@dmlb2000 bump

dmlb2000 commented 5 years ago

This got moved to transactionuser table and you need to look for the relationship authorized_releaser.

GitBytes commented 5 years ago

I think this should still be open. The docs are no longer correct and should be updated.

GitBytes commented 5 years ago

@dmlb2000 bump

I did find what you were referring to though, so fyi there.

dmlb2000 commented 5 years ago

@GitBytes Please put reference to the docs and I'll update them.

GitBytes commented 5 years ago

@dmlb2000 Please see original link in first post.