Mudanças entre as edições de "Dataverse:Postgtess-Tables"

De BrapciWiki
Ir para navegação Ir para pesquisar
Linha 1: Linha 1:
=Tables=
+
=Categoria Dataverse=
 
==dataverse==
 
==dataverse==
 
* affiliation
 
* affiliation
Linha 16: Linha 16:
 
* defaulttemplate_id
 
* defaulttemplate_id
  
 +
=Categoria Files (Arquivos)=
 +
 +
==datafile==
 +
* id
 +
* checksumtype
 +
* checksumvalue
 +
* contenttype
 +
* filesize
 +
* ingeststatus (A ou D)
 +
* prov_entityname
 +
* restricted
 +
* rootdatafileid
 +
 +
==datafilecategory==
 +
* id
 +
* name
 +
* dataset_id
 +
 +
=Categoria Datasets (Conjunto de Dados)=
 +
 +
==dataset==
 +
* id
 +
* fileaccessrequest (FALSE ou TRUE)
 +
* harvestidentifier
 +
* lastexporttime
 +
* storagedriver
 +
* usegenericthumbnail
 +
* citationdatedatasetfieldtype_id
 +
* harvestingclient_id
 +
* guestbook_id
 +
* thumbnailfile_id
 +
*
 +
*
 
==dataversefacet==
 
==dataversefacet==
 
* displayorder
 
* displayorder
Linha 61: Linha 94:
 
* filecategories_id
 
* filecategories_id
 
* filemetadatas_id
 
* filemetadatas_id
 +
 +
 +
 +
==metric==
 +
* datalocation (all ou local ou remote ou NULL)
 +
* daystring (30 ou 2021-12)
 +
* lastcalleddate (date)
 +
* name (datasetsPastDays)
 +
* valuejson ({"count":351})
 +
* dataverse_id
 +
 +
==variablecategory==
 +
* catorder
 +
* frequency
 +
* label
 +
* missing
 +
* value
 +
* datavariable_id
 +
 +
= Categoria Vocabulários =
 +
==controlledvocabalternate==
 +
* id
 +
* strvalue (string)
 +
* controlledvocabularyvalue_id (*)
 +
* datasetfieldtype_id (*)
 +
 +
==controlledvocabularyvalue==
 +
* id
 +
* displayorder
 +
* identifier
 +
* strvalue
 +
* datasetfieldtype_id
 +
 +
= Categoria Users =
 +
 +
==authenticateduser==
 +
* affiliation (UFRGS)
 +
* createdtime
 +
* deactivated
 +
* deactivatedtime
 +
* email
 +
* emailconfirmed
 +
* firstname
 +
* lastapiusetime
 +
* lastlogintime
 +
* lastname
 +
* position (Professor)
 +
* superuser (TRUE ou FALSE)
 +
* useridentifier
 +
 +
 +
 +
 +
= Categoria LOGS =
 +
 +
==actionlogrecord==
 +
* id (89aca72e-5d86-43d5-8ac7-11c39d3a082f)
 +
* actionresult (OK)
 +
* actionsubtype (loadDatasetFields, createBuiltInRole)
 +
* actiontype (Admin)
 +
* endtime
 +
* info
 +
* starttime
 +
* useridentifier
  
 
==ingestreport== (Erros e acertos de Admissão)
 
==ingestreport== (Erros e acertos de Admissão)
Linha 69: Linha 166:
 
* type
 
* type
 
* datafile_id
 
* datafile_id
 
==metric==
 
* datalocation
 
* daystring
 
* lastcalleddate
 
* name
 
* valuejson
 
* dataverse_id
 
 
 
  
 
==
 
==

Edição das 12h55min de 9 de dezembro de 2021

Categoria Dataverse

dataverse

  • affiliation
  • alias
  • dataversetype
  • description
  • facetedroot
  • guestbookroot
  • metadatablockroot
  • name
  • permissionroot
  • storagedriver
  • templatroot
  • themeroot
  • defaultcontributorrole_id
  • defaulttemplate_id

Categoria Files (Arquivos)

datafile

  • id
  • checksumtype
  • checksumvalue
  • contenttype
  • filesize
  • ingeststatus (A ou D)
  • prov_entityname
  • restricted
  • rootdatafileid

datafilecategory

  • id
  • name
  • dataset_id

Categoria Datasets (Conjunto de Dados)

dataset

  • id
  • fileaccessrequest (FALSE ou TRUE)
  • harvestidentifier
  • lastexporttime
  • storagedriver
  • usegenericthumbnail
  • citationdatedatasetfieldtype_id
  • harvestingclient_id
  • guestbook_id
  • thumbnailfile_id

dataversefacet

  • displayorder
  • datasetfieldtype_id
  • dataverse_id

dataversefeatureddataverse

  • displayorder
  • dataverse_id
  • featureddataverse_id

dataversefieldtypeinputlevel

  • include
  • required
  • datasetfieldtype_id
  • dataverse_id

dvobject

  • dtype
  • authority
  • createdate
  • globalidcreatetime
  • identifier
  • identifierregistered
  • indextime
  • modificationtime
  • permissionindextime
  • permissionmodificationtime timestamp
  • previewimageavailable
  • protocol (doi, hdl)
  • publicationdate
  • storageidentifier (file://10.19132/1808-5245251.83-86)
  • creator_id
  • owner_id
  • releaseuser_id

filemetadata

  • description
  • directorylabel (turmas)
  • label (Tabelas Auxiliares.tab)
  • prov_freeform
  • restricted
  • version
  • datafile_id
  • datasetversion_id

filemetadata_datafilecategory

  • filecategories_id
  • filemetadatas_id


metric

  • datalocation (all ou local ou remote ou NULL)
  • daystring (30 ou 2021-12)
  • lastcalleddate (date)
  • name (datasetsPastDays)
  • valuejson ({"count":351})
  • dataverse_id

variablecategory

  • catorder
  • frequency
  • label
  • missing
  • value
  • datavariable_id

Categoria Vocabulários

controlledvocabalternate

  • id
  • strvalue (string)
  • controlledvocabularyvalue_id (*)
  • datasetfieldtype_id (*)

controlledvocabularyvalue

  • id
  • displayorder
  • identifier
  • strvalue
  • datasetfieldtype_id

Categoria Users

authenticateduser

  • affiliation (UFRGS)
  • createdtime
  • deactivated
  • deactivatedtime
  • email
  • emailconfirmed
  • firstname
  • lastapiusetime
  • lastlogintime
  • lastname
  • position (Professor)
  • superuser (TRUE ou FALSE)
  • useridentifier



Categoria LOGS

actionlogrecord

  • id (89aca72e-5d86-43d5-8ac7-11c39d3a082f)
  • actionresult (OK)
  • actionsubtype (loadDatasetFields, createBuiltInRole)
  • actiontype (Admin)
  • endtime
  • info
  • starttime
  • useridentifier

==ingestreport== (Erros e acertos de Admissão)

  • endtime
  • report
  • starttime
  • status
  • type
  • datafile_id

==