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

De BrapciWiki
Ir para navegação Ir para pesquisar
 
(18 revisões intermediárias pelo mesmo usuário não estão sendo mostradas)
Linha 1: Linha 1:
−
=Tables=
+
=Categoria das Tabelas Dataverse= Table
 
==dataverse==
 
==dataverse==
 
* affiliation
 
* affiliation
Linha 15: Linha 15:
 
* defaultcontributorrole_id
 
* defaultcontributorrole_id
 
* 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
 +
 +
==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==
 
==dataversefacet==
Linha 20: 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 29: Linha 127:
 
* datasetfieldtype_id
 
* datasetfieldtype_id
 
* dataverse_id
 
* dataverse_id
 +
=Categoria Dataverse e Dataset=
 
==dvobject==
 
==dvobject==
 
* dtype
 
* dtype
Linha 45: 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
 +
 +
==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==
 +
* 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 =
 +
 +
==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

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”