RQDATables: Data Tables in rqda file

Description Details Author(s)

Description

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

Details

Table "annotation" contatins file annotations.

fid: file id.
position: position of annotation.
annotation: content of annotation.
owner: owner of annotation.
date: created date.
dateM: not used currently.
status: 1 for standard status and 0 for temporarily deleted annotation.

Table "attributes" contatins information about the name list of attributes. They are held in the widget of ".AttrNamesWidget".

name: name of attributes.
status: 1 for standard status and 0 for a temporarily deleted attribute.
date: created date of as attribute.
dateM: not used currently.
owner: owner of an attribute.
memo: memo of an attribute. Useful for definition of attributes.
class: class of an attribute. It might be "character" or "numeric".

Table "caseAttr" contatins information about attributes of cases.

variable: name of case attributes, coresponding to name in attributes table.
value: variable value.
caseID: corresponding case id of a variable value.
date: created date of a case attribute record.
dateM: not used currently.
owner: creator of the case attribute record.

Table "caselinkage" contatins information about the relationship between case and files of case.

caseid: case id.
fid: file id.
selfirst: beginning position of a text segment associated with a case.
selend: ending position of a text segment associated with a case..
status: 1 for standard status and 0 for temporarily deleted record.
owner: creator of the case linkage.
date: date of a created case linkage.
memo: not used currently.

Table "cases" contatins information about case list.

name: name of a case.
memo: case memo.
owner: creator of a case.
date: date of creation of a case.
dateM: not used currently.
id: case id.
status: 1 for standard status and 0 for temporarily deleted record.

Table "codecat" contatins information about upper-level of code list.

name: name of code category.
cid: not used currently.
catid: id of code category.
owner: creator of code category.
date: date of creation of code category.
dateM: not used currently.
memo: code category memo.
status: 1 for standard status and 0 for temporarily deleted record.

Table "coding" contains information on codings.

cid : code id.
fid : file id.
seltext : a coding, that is the coded text segment.
selfirst : beginning position of the coded text segment.
selend : ending position of the coded text segment.
status : 1 for standard status. 0 for deleted codeings (for example when a code is deleted, the status of all associated codings is set to 0) and -1 for unmarked codings.
owner : name of coder or creator of a coding.
date : date of creation of a coding.
memo : coding memo.

Table "fileAttr" contatins information about attributes of files.

variable: charater, name of file attribute, coresponding to name in attributes table
value: value of the file attribute.
fileID: corresponding file id of the attribute.
date: created date of the file attribute.
dateM: not used currently.
owner: creator of the file attribute.

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: date of creation of a file category.
dateM: not used currently.
memo: file category memo.
status: 1 for standard status and 0 for temporarily deleted record.

Table "freecode" contains information on the codes list.

name : code name.
memo : code memo.
owner : creator of a code.
date : date of creation of a code.
dateM : not used currently.
id : code id.
status : 1 for standard status and 0 for temporarily deleted record.
color: color for code marker (added in version 0.19)

Table "image" contatins information about images. It is not used currently.

Table "imageCoding" contatins images coding. It is not used currently.

Table "journal" contatins information about field work journal. Journal titles are held in widget of ".JournalNamesWidget".

name: name of a journal.
journal: content of a journal.
date: created date of a journal.
dateM: not used currently.
owner: owner of a journal.
status: 1 for standard status and 0 for temporarily deleted journal.

Table "project" contatins information about the project and *.rqda file.

encoding: not used currently.
databaseversion: version of RQDAtables.
date: created date of the project.
dateM: not used currently.
memo: project memo.
BOM: not used curently.
imageDir: directory of image. Not used currently.
about: meta information about the rqda file.

Table "source" contains the content of files. Files are held in widget of ".fnames_rqda".

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: date of last editing of the file content.
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). They are held in widget of ".CodeCatWidget". Codes of specific category are held in widget of ".CodeofCat".

cid: code id.
catid: code category id.
date: date of creation of a code categorization.
dateM: not used currently.
memo: not used currently.
status: 1 for standard status and 0 for temporarily deleted file.
owner: creator the the treecode.

Table "treefile" contatins information about file categorization (relation between source files and filecat).

fid: file id.
catid: file category id.
date: date of creation of the file categorization.
dateM: not used currently.
memo: not used currently.
status: 1 for standard status and 0 for temporarily deleted record.
owner: creator the the tree file.

Author(s)

HUANG Ronggui


RQDA documentation built on May 31, 2017, 2:52 a.m.