Dataverse:Postgtess-Tables

=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

• id
• authenticationproviderid (builtin|shib)
• persistentuserid (https://idp3.cafeexpresso.rnp.br/idp/shibboleth%7Cca0cd09a12abade3bf0777574d9f987f@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