Dataverse:Postgtess-Tables

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

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 (*)

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

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
• 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

==