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

De BrapciWiki
Ir para navegação Ir para pesquisar
 
(13 revisões intermediárias pelo mesmo usuário não estão sendo mostradas)
Linha 1: Linha 1:
−
=Categoria Dataverse=
+
=Categoria das Tabelas Dataverse= Table
 
==dataverse==
 
==dataverse==
 
* affiliation
 
* affiliation
Linha 47: Linha 47:
 
* guestbook_id
 
* guestbook_id
 
* thumbnailfile_id
 
* thumbnailfile_id
 +
 +
==datasetfieldtype==
 +
'''Perfil de Aplicação''' - Arquivo TSV
 +
* id
 +
* advancedsearchfieldtype
 +
* allowcontrolledvocabulary
 +
* allowmultiples
 +
* description
 +
* displayformat
 +
* displayoncreate
 +
* displayorder
 +
* facetable
 +
* fieldtype
 +
* name
 +
* required
 +
* title
 +
* uri
 +
* validationformat
 +
* watermark
 +
* metadatablock_id
 +
* parentdatasetfieldtype_id (*)
 +
==datasetversion==
 +
* id
 +
* unf
 +
* archivalcopylocation
 +
* archivenote
 +
* archivetime
 +
* createtime
 +
* deaccessionlink
 +
* lastupdatetime
 +
* minorversionnumber
 +
* releasetime
 +
* version
 +
* versionnote
 +
* versionnumber
 +
* versionstate (DRAFT ou RELEASED ou DEACCESSIONED)
 +
* dataset_id
 +
* termsofuseandaccess_id
  
 
==datasetfield==
 
==datasetfield==
Linha 74: Linha 112:
 
* datasetfieldtype_id
 
* datasetfieldtype_id
 
* dataverse_id
 
* dataverse_id
 +
 +
==dataverse_metadatablock==
 +
'''Perfil de aplicação ativo'''
 +
* dataverse_id
 +
* metadatablocks_id
 +
 
==dataversefeatureddataverse==
 
==dataversefeatureddataverse==
 
* displayorder
 
* displayorder
Linha 100: Linha 144:
 
* storageidentifier (file://10.19132/1808-5245251.83-86)
 
* storageidentifier (file://10.19132/1808-5245251.83-86)
 
* creator_id
 
* creator_id
−
* owner_id
+
* owner_id (Dataverse principal - Hierarquia)
 
* releaseuser_id
 
* releaseuser_id
  
Linha 128: Linha 172:
  
 
==variablecategory==
 
==variablecategory==
 +
'''Variáveis dos arquivos'''
 +
* id
 
* catorder
 
* catorder
 
* frequency
 
* frequency
Linha 134: Linha 180:
 
* value
 
* value
 
* datavariable_id
 
* datavariable_id
 +
 +
==datavariable==
 +
* id
 +
* fileendposition
 +
* filestartposition
 +
* format
 +
* formatcategory
 +
* interval
 +
* label
 +
* name
 +
* numberofdecimalpoints
 +
* orderedfactor
 +
* recordsegmentnumber
 +
* type
 +
* unf
 +
* weighted
 +
* datatable_id
  
 
= Categoria Vocabulários =
 
= Categoria Vocabulários =
Linha 152: Linha 215:
  
 
==authenticateduser==
 
==authenticateduser==
 +
* id
 
* affiliation (UFRGS)
 
* affiliation (UFRGS)
 
* createdtime
 
* createdtime
Linha 165: Linha 229:
 
* superuser (TRUE ou FALSE)
 
* superuser (TRUE ou FALSE)
 
* useridentifier
 
* useridentifier
−
 
  
 +
==authenticateduserlookup==
 +
* id
 +
* authenticationproviderid (builtin|shib)
 +
* persistentuserid (https://idp3.cafeexpresso.rnp.br/idp/shibboleth|ca0cd09a12abade3bf0777574d9f987f@cafeexpresso.rnp.br)
 +
* authenticateduser_id (1,2,...)
 +
 +
==datasetversionuser==
 +
* id
 +
* lastupdatedate
 +
* authenticateduser_id
 +
* datasetversion_id
  
−
 
 
= Categoria LOGS =
 
= Categoria LOGS =
  
Linha 181: Linha 254:
 
* useridentifier
 
* useridentifier
  
−
==ingestreport== (Erros e acertos de Admissão)
+
==ingestreport==  
 +
'''Erros e acertos de Admissão'''
 
* endtime
 
* endtime
 
* report
 
* report
Linha 189: Linha 263:
 
* datafile_id
 
* datafile_id
  
−
==
+
=Categoria metadados=
 +
==foreignmetadatafieldmapping==
 +
* id
 +
* datasetfieldname
 +
* foreignfieldxpath
 +
* isattribute
 +
* foreignmetadataformatmapping_id
 +
* parentfieldmapping_id
 +
 
 +
=Configurações do Dataverse=
 +
==setting==
 +
'''Configurações do Dataverse'''
 +
* id
 +
* content
 +
* lang
 +
* name

Edição atual tal como às 18h14min de 23 de novembro de 2023

=Categoria das Tabelas Dataverse= Table

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

datasetfieldtype

Perfil de Aplicação - Arquivo TSV

  • id
  • advancedsearchfieldtype
  • allowcontrolledvocabulary
  • allowmultiples
  • description
  • displayformat
  • displayoncreate
  • displayorder
  • facetable
  • fieldtype
  • name
  • required
  • title
  • uri
  • validationformat
  • watermark
  • metadatablock_id
  • parentdatasetfieldtype_id (*)

datasetversion

  • id
  • unf
  • archivalcopylocation
  • archivenote
  • archivetime
  • createtime
  • deaccessionlink
  • lastupdatetime
  • minorversionnumber
  • releasetime
  • version
  • versionnote
  • versionnumber
  • versionstate (DRAFT ou RELEASED ou DEACCESSIONED)
  • dataset_id
  • termsofuseandaccess_id

datasetfield

  • id
  • datasetfieldtype_id
  • datasetversion_id
  • parentdatasetfieldcompoundvalue_id
  • template_id

datasetfieldvalue

  • id
  • displayorder
  • value
  • datasetfield_id (*)

datasetfield_controlledvocabularyvalue

  • datasetfield_id
  • controlledvocabularyvalues_id (*datasetfield)

datasetfieldcompoundvalue

  • id
  • displayorder
  • parentdatasetfield_id (*)

dataversefacet

  • displayorder
  • datasetfieldtype_id
  • dataverse_id

dataverse_metadatablock

Perfil de aplicação ativo

  • dataverse_id
  • metadatablocks_id

dataversefeatureddataverse

  • displayorder
  • dataverse_id
  • featureddataverse_id

dataversefieldtypeinputlevel

  • include
  • required
  • datasetfieldtype_id
  • dataverse_id

Categoria Dataverse e Dataset

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 (Dataverse principal - Hierarquia)
  • 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

Variáveis dos arquivos

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

datavariable

  • id
  • fileendposition
  • filestartposition
  • format
  • formatcategory
  • interval
  • label
  • name
  • numberofdecimalpoints
  • orderedfactor
  • recordsegmentnumber
  • type
  • unf
  • weighted
  • datatable_id

Categoria Vocabulários

controlledvocabalternate

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

controlledvocabularyvalue

  • id
  • displayorder
  • identifier
  • strvalue
  • datasetfieldtype_id

Categoria Users

authenticateduser

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

authenticateduserlookup

datasetversionuser

  • id
  • lastupdatedate
  • authenticateduser_id
  • datasetversion_id

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

Categoria metadados

foreignmetadatafieldmapping

  • id
  • datasetfieldname
  • foreignfieldxpath
  • isattribute
  • foreignmetadataformatmapping_id
  • parentfieldmapping_id

Configurações do Dataverse

setting

Configurações do Dataverse

  • id
  • content
  • lang
  • name
Disponível em “https://brapci.inf.br/wiki/index.php?title=Dataverse:Postgtess-Tables&oldid=1556”