RQDATables {RQDA}R Documentation

Data Tables in rqda file

Description

The internal data table structures in rqda file, which is a SQLite data base.

Details

Table "attributes" contatins information about the name list of attributes.
name: name of attributes.
status: .
date: .
dateM: .
owner: .
memo: .

Table "caseAttr" contatins information about attributes of cases.
variable: name of case attributes, coresponding to name in attributes table.
value: .
caseID: .
date: .
dateM: .
owner: .

Table "caselinkage" contatins information about the relationship between case and files of case.
caseid: .
fid: .
selfirst: .
selend: .
status: .
owner: .
date: .
memo: .

Table "cases" contatins information about case list.
name: .
memo: .
owner: .
date: .
dateM: .
id: .
status: .

Table "codecat" contatins information about upper-level of code list.
name: .
cid: .
catid: .
owner: .
date: .
dateM: .
memo: .
status: .

Table "coding" contains information on codings.
cid :
fid :
seltext :
selfirst :
selend :
status :
owner :
date :
memo :

Table "fileAttr" contatins information about attributes of files.
variable: .
value: .
fileID: .
date: .
dateM: .
owner: .

Table "filecat" contains information on the file categorization.
name: name of the file category.
fid: Not used.
catid: if of file category.
owner: creator of file-category.
date:
dateM:
memo:
status:

Table "freecode" contains information on the codes list.
name :
memo :
owner :
date :
dateM :
id :
status :

Table "journal" contatins information about field work journal.
name: .
journal: .
date: .
dateM: .
owner: .
status: .

Table "project" contatins information about the project and *.rqda file.
encoding: .
databaseversion: .
date: .
dateM: .
memo: .
BOM: .

Table "source" contains the content of files.
name: name of the file.
id: id of the file.
file: content of a file.
memo: memo of the file.
owner: creator the the file.
date: the date of the file-import.
dataM: not used now.
status: 1 for standard status and 0 for temporarily deleted file.

The "treecode" table contains information on the codes categorization (relationship between codes and the codecat).
cid: .
catid: .
date: .
dateM: .
memo: .
status: .

Table "treefile" contatins information about file categorization (relation between source files and filecat).
fid: .
catid: .
date: .
dateM: .
memo: .
status: .

Author(s)

HUANG Ronggui


[Package RQDA version 0.1-8 Index]