Aller à : navigation, rechercher

Maarch Framework 3/Data model

Sommaire

Maarch Framework 3 Data Model

Graphical DM for Maarch v3.1 :
Maarch v3.1 Data Model.png


Core

actions

Column Type Comment
id integer Action identifier
label_action character varying(255) Action description
id_status character varying(10) Status identifier
is_system character(1) 'Y' if the status is system, 'N' otherwise
history character(1) 'Y' if the action must be saved in the maarch history, 'N' otherwise
enabled character(1) 'Y' if the action is enabled, 'N' otherwise
action character varying(255) Action page identifier defined in the actions_pages.xml file

docservers

Column Type Comment
docserver_id character varying(32) Document server identifier
device_type character varying(32) Example : DVD, CD, HDD, etc. Reserved word : EXT - External storage system
device_label character varying(255) Device label (ex: DVD label)
is_readonly character(1) Readonly flag (Y/N)
enabled character(1) ENABLED char(1) Enabled flag (Y/N)
size_limit bigint Size limit in bytes (0 : no size limit)
actual_size bigint Actual remaining space in bytes
path_template character varying(255) Path template (not used yet - path schema is calculated by ingestion modules)
ext_docserver_info character varying(255) Complementary information to access external storage (ex: Ascent document server)
chain_before character varying(32) Chained removable medias : previous media
chain_after character varying(32) Chained removable medias : next media
creation_date timestamp without time zone Creation date and time
closing_date timestamp without time zone Closing date and time
coll_id character varying(32) Collection identifier
priority integer(8) Priority, used in indexing_searching to choose a docserver for a collection

doctypes

Column Type Comment
coll_id character varying(32) Collection identifier
type_id integer Doctype identifier
description character varying(255) Label of the doctype
enabled character(1) -
doctypes_first_level_id integer -
doctypes_second_level_id integer -
retention character varying(50) -
custom_t1 character varying(10) -
custom_n1 character varying(10) -
custom_f1 character varying(10) -
custom_d1 character varying(10) -
custom_t2 character varying(10) -
custom_n2 character varying(10) -
custom_f2 character varying(10) -
custom_d2 character varying(10) -
custom_t3 character varying(10) -
custom_n3 character varying(10) -
custom_f3 character varying(10) -
custom_d3 character varying(10) -
custom_t4 character varying(10) -
custom_n4 character varying(10) -
custom_f4 character varying(10) -
custom_d4 character varying(10) -
custom_t5 character varying(10) -
custom_n5 character varying(10) -
custom_f5 character varying(10) -
custom_d5 character varying(10) -
custom_t6 character varying(10) -
custom_d6 character varying(10) -
custom_t7 character varying(10) -
custom_d7 character varying(10) -
custom_t8 character varying(10) -
custom_d8 character varying(10) -
custom_t9 character varying(10) -
custom_d9 character varying(10) -
custom_t10 character varying(10) -
custom_d10 character varying(10) -
custom_t11 character varying(10) -
custom_t12 character varying(10) -
custom_t13 character varying(10) -
custom_t14 character varying(10) -
custom_t15 character varying(10) -
is_master character(1) -
bitmask integer(20) (related to physical archive module, must be removed in futur evolutions)

ext_docserver

Not used

Column Type Comment
doc_id character varying(255) Logical adress in external storage
path character varying(255) External application path (here for Ascent Capture release)

groupsecurity

Not used

Column Type Comment
group_id character varying(32) -
resgroup_id character varying(32) -
can_view character(1) -
can_add character(1) -
can_delete character(1) -

history

Column Type Comment
id integer History system id (auto-increment)
table_name character varying(32) Table concerned
record_id character varying(255) Record concerned in the table
event_type character varying(32) Event type - Ex: "INSERT, DELETE, LOGIN, LOGOUT, VIEW ..."
user_id character varying(50) User identifier
event_date timestamp without time zone Event date and time
info text Complementary information
id_module character varying(50) Module concerned by the event

parameters

Column Type Comment
id character varying(50) -
param_value_string character varying(50) -
param_value_int integer -

resgroups

Not used

Column Type Comment
resgroup_id character varying(32) -
resgroup_desc character varying(255) -
created_by character varying(255) -
creation_date timestamp without time zone -

resgroup_content

Not used

Column Type Comment
coll_id character varying(8) -
res_id bigint -
resgroup_id character varying(32) -
sequence integer -

security

Column Type Comment
group_id character varying(32) Group identifier
coll_id character varying(32) Collection identifier
where_clause character varying(255) Security restriction on the collection
comment text -
can_insert character(1) -
can_update character(1) -
can_delete character(1) -

status

Column Type Comment
id character varying(10) Status identifier
label_status character varying(50) Status description
is_system character(1) 'Y' if the status is system, 'N' otherwise
img_filename character varying(255) Path to the image corresponding to the status
module character varying(255) Module name or apps
can_be_searched character(1) 'Y' if the status is searchable, 'N' otherwise

usergroups

Column Type Comment
group_id character varying(32) -
group_desc character varying(255) -
administrator character(1) -
custom_right1 character(1) -
custom_right2 character(1) -
custom_right3 character(1) -
custom_right4 character(1) -
enabled character(1) -

usergroup_content

Column Type Comment
user_id character varying(32) -
group_id character varying(32) -
primary_group character(1) -
role character varying(255) -

usergroups_services

Declare access to a module service for a group (only useful for non system services)

Column Type Comment
group_id character varying -
service_id character varying -

users

Column Type Comment
user_id character varying(32) User identifier
password character varying(255) Crypted password (if standalone security)
firstname character varying(255) Firstname
lastname character varying(255) Lastname
phone character varying(15) Phone
mail character varying(255) Mail (used for notification)
department character varying(50) Departement, service, unit, etc.
custom_t1 character varying(50) -
custom_t2 character varying(50) -
custom_t3 character varying(50) -
cookie_key character varying(255) COOKIE_KEY varchar(255) System field
cookie_date timestamp without time zone COOKIE_DATE datetime System field
enabled character(1) ENABLED char(1) Enabled flag (Y/N)
change_password character(1) -
delay timestamp without time zone -

Apps

doctypes_first_level

First level of the document type structure.

Column Type Comment
doctypes_first_level_id integer -
doctypes_first_level_label character varying(255) -
enabled character(1) -

doctypes_second_level

Second level of the document type structure.

Column Type Comment
doctypes_second_level_id integer -
doctypes_second_level_label character varying(255) -
doctypes_first_level_id integer Refers to first level
enabled character(1) -

res_x

Column Type Comment
res_id bigint Resource system identifier
title character varying(255) Title (DC)
subject text Subject (DC)
description text Description (DC)
publisher character varying(255) Publisher (DC)
contributor character varying(255) Contributor (DC)
type_id bigint Resource type (DC)
format character varying(50) FORMAT varchar(50) Format (DC)
typist character varying(50) Typist : user identifier that created the record in Maarch
creation_date timestamp without time zone Resource creation time in Maarch
fulltext_result character varying(10) Result of full-text batch
ocr_result character varying(10) Result of ocr batch
author character varying(255) Author (DC) - Multivalued
author_name text Author name(s) - copied from authors table -
identifier character varying(255) Unique identifier for the resource (DC)
source character varying(255) Source (DC)
doc_language character varying(50) Language (DC)
relation bigint Relation (DC)
coverage character varying(255) Coverage (DC)
doc_date timestamp without time zone Date (DC)
rights character varying(20) Rights (DC) - not used in security schema
docserver_id character varying(32) Document server containing the image
folders_system_id bigint Logical folder of the resource
arbox_id character varying(32) Archive box containing the paper copy
path character varying(255) Path in Maarch document server
filename character varying(255) Filename in Maarch document server
offset_doc character varying(255) Place of the document in the image file (used for COLD compression)
logical_adr character varying(255) Logical adress in an external storage
fingerprint character varying(255) MD5 fingerprint
filesize bigint File size in Maarch document server
is_paper character(1) Paper only resource (Y/N)
page_count integer Page count
scan_date timestamp without time zone Scan date
scan_user character varying(50) Scan user
scan_location character varying(255) Scan location
scan_wkstation character varying(255) Scanning workstation identifier
scan_batch character varying(50) Scan batch identifier
burn_batch character varying(50) CD/DVD copy identifier
scan_postmark character varying(50) Scan postmarking string
envelop_id bigint Envelop containing the documents (grouping)
status character varying(3) Status
destination character varying(50) Destination (basket)
initiator character varying(50) Initiator (basket)
approver character varying(50) Approver
validation_date timestamp without time zone Validation date and time
work_batch bigint Work batch (videocoding batch)
origin character varying(50) Origin (paper, fax, email, etc.)
is_ingoing character(1) Ingoing or outgoing (Y/N)
priority smallint Priority
arbatch_id varchar(32) Physical archive batch id
custom_t1 text Custom fields
custom_n1 bigint -
custom_f1 numeric -
custom_d1 timestamp without time zone -
custom_t2 character varying(255) -
custom_n2 bigint -
custom_f2 numeric -
custom_d2 timestamp without time zone -
custom_t3 character varying(255) -
custom_n3 bigint -
custom_f3 numeric -
custom_d3 timestamp without time zone -
custom_t4 character varying(255) -
custom_n4 bigint -
custom_f4 numeric -
custom_d4 timestamp without time zone -
custom_t5 character varying(255) -
custom_n5 bigint -
custom_f5 numeric -
custom_d5 timestamp without time zone -
custom_t6 character varying(255) -
custom_d6 timestamp without time zone -
custom_t7 character varying(255) -
custom_d7 timestamp without time zone -
custom_t8 character varying(255) -
custom_d8 timestamp without time zone -
custom_t9 character varying(255) -
custom_d9 timestamp without time zone -
custom_t10 character varying(255) -
custom_d10 timestamp without time zone -
custom_t11 character varying(255) -
custom_d11 timestamp without time zone -
custom_t12 character varying(255) -
custom_d12 timestamp without time zone -
custom_t13 character varying(255) -
custom_d13 timestamp without time zone -
custom_t14 character varying(255) -
custom_d14 timestamp without time zone -
custom_t15 character varying(255) -
tablename character varying(32) Name of the table (res_x)
initiator character varying(50) -
dest_user character varying(50) -
video_batch int(8) Postindexing batch id
video_time int(11) Postindexing timestamp used for locking records
video_user character varying(50) Postindexing user that reserves the records

Modules

Maarch APA

Maarch APA is the Advanced Physical Archive module designed to help running storage warehouses.

Zoom in the image beside to view table organisation :
Ar datamodel.png
'
ar_sites
Column Type Comment
site_id character varying (32) site identifier
site_desc character varying (255) site description
id_entity character varying (32) entity identifier
address character varying (255) site address
ar_positions
Column Type Comment
postion_id big integer position identifier
site_id character varying (32) site identifier
pos_row character varying (32 position row
pos_col integer position column
pos_level integer position level
pos_max_uc integer Maximum
ar_nature
Column Type Comment
arnature_id character varying (32) nature identifier
arnature_desc character varying (255) nature description
arnature_retention integer
id_entity character varying (32) Entity identifier
enabled caractère (1) enable or disavle(Y or N)
ar_containertype
Column Type Comment
ctype_id character varying (32) Container identifier
ctype_desc character varying (255) Container description
size_x float container length
size_y float container width
size_z float conainer height
ar_deposits
Column Type Comment
deposit_id big integer deposit identifier
deposit_label character varying (255) deposit label
deposit_desc texte deposit description
fg_closed tiny integer (1) closed (=1) or not (=0)
closing date datetmie Closed date if the deposit is closed
user_id character varying (32) user identifier


ar_header
Column Type Comment
header_id big integer header identifier
creation_date date Creation date
year1 integer
year2 integer
entity_id character varying (32) entity identifier
site_id character varying (32) site identifier
destruction_date date destruction date
allow_transmission_date date Transmission permssion date
weight integer weight
reservation_id grand integer reservation_id
deposit_id big integer deposit identifier
header_desc texte description
nature_id character varying (32) Nature identifier
ar_container
Column Type Comment
entity_id character varying (32) Entity identifier
arcontainer_id integer(8) Container identifier
arcontainer_desc character varying (255) COntainer description
status character varying (3) Container status
ctype_id character varying (32) Container type identifier
position_id big integer Position identifier
retention_time character varying (50)
custom_t1 character varying (50)
custom_n1 integer
custom_f1 decimal
custom_d1 datetime
custom_t2 character varying (50)
custom_n2 integer
custom_f2 decimal
custom_d2 datetime
ar_box
Column Type Comment
arbox_id integer(8) Box identifier
title character varying (255) Box title
subject character varying (255) Box Subject
description text Box desciption
entity_id character varying (32) Entity identifier
arcontainer_id integer(8) Conatainer identifier
status character varying (3) status
creation_date date creation date
retention_time character varying (50)
custom_t1 character varying (50)
custom_n1 integer
custom_f1 décimal
custom_d1 datetime
custom_t2 character varying (50)
custom_n2 integer
custom_f2 décimal
custom_d2 datetime
custom_t3 character varying (50)
custom_n3 integer
custom_f3 décimal
custom_d3 datetime
custom_t4 character varying (50)
custom_n4 integer
custom_f4 décimal
custom_d4 datetime
custom_t5 character varying (50)
custom_n5 integer
custom_f5 décimal
custom_d5 datetime
custom_t6 character varying (50)
custom_t7 character varying (50)
custom_t8 character varying (50)
custom_t9 character varying (50)
custom_t10 character varying (50)
custom_t11 character varying (50)

alert_diffusion

alert_insts
Column Type Comment
alert_id bigint
sequence integer
due_date date
status character varying(5)
alert_users
Column Type Comment
alert_id bigint
user_id character varying(255)
alert
Column Type Comment
alert_id bigint
alert_label character varying(255)
alert_type character varying(255)
coll_id character varying(255)
alert_table character varying(255)
identifier character varying(255)
model_id character varying(255)
use_listinstance character(1)
use_alerts_users character(1)
alert_unit character varying(15)
alert_frequency cinteger
alert_parameter character varying(255)
alert_begin_date date
alert_end_date date
alert_creation_date datetime
alert_status character varying(5)
alert_text text
alert_sql_clause character varying(1024)
preprocess_script character varying(1024)
alert_creator character varying(255)
postprocess_script character varying(1024)

attachments

res_attachments
Column Type Comment
res_id bigint Resource system identifier
title character varying(255) Title (DC)
subject text Subject (DC)
description text Description (DC)
publisher character varying(255) Publisher (DC)
contributor character varying(255) Contributor (DC)
type_id bigint Resource type (DC)
format character varying(50) FORMAT varchar(50) Format (DC)
typist character varying(50) Typist : user identifier that created the record in Maarch
creation_date timestamp without time zone Resource creation time in Maarch
fulltext_result character varying(10) Result of full-text batch
ocr_result character varying(10) Result of ocr batch
author character varying(255) Author (DC) - Multivalued
author_name text Author name(s) - copied from authors table -
identifier character varying(255) Unique identifier for the resource (DC)
source character varying(255) Source (DC)
doc_language character varying(50) Language (DC)
relation bigint Relation (DC)
coverage character varying(255) Coverage (DC)
doc_date timestamp without time zone Date (DC)
docserver_id character varying(32) Document server containing the image
folders_system_id bigint Logical folder of the resource
arbox_id character varying(32) Archive box containing the paper copy
path character varying(255) Path in Maarch document server
filename character varying(255) Filename in Maarch document server
offset_doc character varying(255) Place of the document in the image file (used for COLD compression)
logical_adr character varying(255) Logical adress in an external storage
fingerprint character varying(255) MD5 fingerprint
filesize bigint File size in Maarch document server
is_paper character(1) Paper only resource (Y/N)
page_count integer Page count
scan_date timestamp without time zone Scan date
scan_user character varying(50) Scan user
scan_location character varying(255) Scan location
scan_wkstation character varying(255) Scanning workstation identifier
scan_batch character varying(50) Scan batch identifier
burn_batch character varying(50) CD/DVD copy identifier
scan_postmark character varying(50) Scan postmarking string
envelop_id bigint Envelop containing the documents (grouping)
status character varying(3) Status
destination character varying(50) Destination (basket)
initiator character varying(50) Initiator (basket)
approver character varying(50) Approver
validation_date timestamp without time zone Validation date and time
work_batch bigint Work batch (videocoding batch)
origin character varying(50) Origin (paper, fax, email, etc.)
is_ingoing character(1) Ingoing or outgoing (Y/N)
priority smallint Priority
initiator character varying(50) -
dest_user character varying(50) -
coll_id character varying(32) id of the collection (coll_1)
res_id_master bigint id of master res_id

autofoldering

autofoldering_node_item

Contains all items of all trees declared in Autofoldering. R/O table only updated by batch process autofoldering_load_db.

Column Type Comment
item_id integer System id for the item
tree_id character varying Tree id
level integer Tree node level
key_value character varying Key used to select lesser levels
label_value character varying Displayed label on tree
parent_item_id integer Parent item id
status character(3) Used to validate tree completion. Should be set to OK.
node_id character varying(255) Node id of the item
autofoldering_security

Gives rights to user groups to access a tree. Updated by tree management service in administration console.

Column Type Comment
group_id character varying(50) Group id
tree_id character(50) Tree id in XML tree definition file (modules/autofoldering/xml/autofoldering.xml)
where_clause text Restrictions applied to the group on this tree (applied on autofoldering_node_item)

basket

actions_groupbaskets
Column Type Comment
id_action bigint Action identifier (system id)
group_id character varying(32) identifier of the group (key for groupbaket table with the basket_id)
basket_id character varying(32) identifier of the basket (key for groupbaket table with the group_id)
where_clause text where clause
used_in_basketlist character(1) 'Y' if the action is used in the basket result page (list), 'N' otherwise
used_in_action_page character(1) 'Y' if the action is used in action page (defined in the basket result page, ex : process or validation pages), 'N' otherwise
default_action_list character(1) 'Y' if the action is the default action when you click on an line on the results list of the basket, 'N' otherwise
baskets
Column Type Comment
coll_id character varying(32) Collection identifier
basket_id character varying(32) Basket Id
basket_name character varying(50) Description
basket_desc character varying(255) Where clause to display the basket
basket_clause text -
is_generic character varying(6) -
enabled character(1) -
groupbasket
Column Type Comment
group_id character varying(32) Group identifier
basket_id character varying(32) Basket identifier
sequence integer -
redirect_basketlist character varying(255) -
redirect_grouplist character varying(255) -
can_redirect character(1) obsolete
can_delete character(1) obsolete
can_insert character(1) obsolete
result_page character varying(255) Page to show for the group
listinstance
Column Type Comment
coll_id character varying(32) Collection identifier
res_id character varying(32) Item identifier
sequence bigint List sequence
user_id character varying(32) User identifier
type_listinstance character varying(32) 'DOC' by default
listmodels
Column Type Comment
coll_id character varying(32) Collection identifier
id character varying(32) Item identifier
sequence bigint List sequence
user_id character varying(32) User identifier

doc_project

project_res
Column Type Comment
project_id bigint Project identifier
res_id bigint Resource Identifier
coll_id character varying(32) Collection identifier
project_users
Column Type Comment
project_id bigint Project identifier
user_id character varying(32) User identifier
projects
Column Type Comment
project_id bigint Project identifier
project_label character varying(65) Project label
description character varying(255) Project description
creator character varying(255) Project creator
custom_t1 character varying(255)
rights bigint
creation_date datetime Project creation date

entities

entities

Reflexive table to manage hierarchical organisation

Column Type Comment
entity_id character varying(32) Entity identifier
entity_label character varying(32) Entity label
enabled character(1) 'Y' if enabled, 'N' otherwise
adrs_1 character varying(255) Address field 1
adrs_2 character varying(255) Address field 2
adrs_3 character varying(255) Address field 3
zipcode character varying(32) Postal code
city character varying(64) City
country character varying(64) Country
email character varying(64) Email
business_id character varying(32) SIRET, APE, ...
parent_entity_id character varying(32) Parent entity identifier, if any parent
entity_type character varying(64) Entity type (Exploitant, customer, partner, ...)
users_entities
Column Type Comment
user_id character varying(32) User identifier
entity_id character varying(32) Entity identifier
user_role character varying(255) Role of the user in the entity
primary_entity character(1) 'Y' if the entity is the primary entity of the user, 'N' otherwise
listmodels
Column Type Comment
coll_id character varying(50) Collection identifier
object_id character varying(50) Object identifier
object_type character varying(255) Object type ('entity_id', 'type_id', etc..)
sequence bigint Rank of the item in the list
item_id character varying(50) Item identifier
item_type character varying(255) Item type ('user_id', 'entity_id')
item_mode character varying(50) Item mode ('dest', 'cc', 'cci', etc...)
listmodel_type character varying(50) type of list ('DOC')
listinstance
Column Type Comment
coll_id character varying(50) Collection identifier
res_id bigint(8) identifier of a ressource(res_id)
listinstance_type character varying(50) 'DOC' by default
sequence bigint Rank of the user in the list
item_id character varying(50) item identifier
item_type character varying(255) type identifier (user_id, entity_id)
item_mode character varying(50) type identifier (Principal, cc, cci, etc...)
groupbasket_redirect
Column Type Comment
system_id integer System identifier
group_id character varying(32) Usersgroup identifier
basket_id character varying(32) Basket identfier
entity_id character varying(32) Entity identifier
keyword character varying(255) Keyword defined in entities modules (ex : MY_ENTITIES, MY_PRIMARY_ENTITY)
redirect_mode character varying(32) 'USERS' or 'ENTITIES'


folders

folders
Column Type Comment
folders_system_id integer System identifier of the folder
folder_id character varying(255) Folder identifier
foldertype_id integer Foldertype identifier
parent_id bigint -
folder_name character varying(255) -
subject character varying(255) -
description character varying(255) -
author character varying(255) -
typist character varying(255) -
status character varying(50) -
folder_level smallint -
creation_date timestamp without time zone -
folder_out_id bigint -
custom_t1 character varying(255) -
custom_n1 bigint -
custom_f1 numeric -
custom_d1 timestamp without time zone -
custom_t2 character varying(255) -
custom_n2 bigint -
custom_f2 numeric -
custom_d2 timestamp without time zone -
custom_t3 character varying(255) -
custom_n3 bigint -
custom_f3 numeric -
custom_d3 timestamp without time zone -
custom_t4 character varying(255) -
custom_n4 bigint -
custom_f4 numeric -
custom_d4 timestamp without time zone -
custom_t5 character varying(255) -
custom_n5 bigint -
custom_f5 numeric -
custom_d5 timestamp without time zone -
custom_t6 character varying(255) -
custom_d6 timestamp without time zone -
custom_t7 character varying(255) -
custom_d7 timestamp without time zone -
custom_t8 character varying(255) -
custom_d8 timestamp without time zone -
custom_t9 character varying(255) -
custom_d9 timestamp without time zone -
custom_t10 character varying(255) -
custom_d10 timestamp without time zone -
custom_t11 character varying(255) -
custom_d11 timestamp without time zone -
custom_t12 character varying(255) -
custom_d12 timestamp without time zone -
custom_t13 character varying(255) -
custom_d13 timestamp without time zone -
custom_t14 character varying(255) -
custom_d14 timestamp without time zone -
custom_t15 character varying(255) -
is_complete character(1) -
is_folder_out character(1) -
folders_out
Column Type Comment
folder_out_id integer -
folder_system_id bigint -
last_name character varying(255) -
first_name character varying(255) -
last_name_folder_out character varying(255) -
first_name_folder_out character varying(255) -
put_out_pattern character varying(255) -
put_out_date timestamp without time zone -
return_date timestamp without time zone -
return_flag character varying(1) -
foldertypes

Foldertypes gives indication on how should be managed documents contained in the folder : list of descriptors needed, list of mandatory document types in the folder using relation foldertypes_doctypes.

Column Type Comment
foldertype_id integer Folder type identifier
foldertype_label character varying(255) Folder type label
comment text -
retention_time character varying(50) -
custom_d1 character varying(10) -
custom_f1 character varying(10) -
custom_n1 character varying(10) -
custom_t1 character varying(10) -
custom_d2 character varying(10) -
custom_f2 character varying(10) -
custom_n2 character varying(10) -
custom_t2 character varying(10) -
custom_d3 character varying(10) -
custom_f3 character varying(10) -
custom_n3 character varying(10) -
custom_t3 character varying(10) -
custom_d4 character varying(10) -
custom_f4 character varying(10) -
custom_n4 character varying(10) -
custom_t4 character varying(10) -
custom_d5 character varying(10) -
custom_f5 character varying(10) -
custom_n5 character varying(10) -
custom_t5 character varying(10) -
custom_d6 character varying(10) -
custom_t6 character varying(10) -
custom_d7 character varying(10) -
custom_t7 character varying(10) -
custom_d8 character varying(10) -
custom_t8 character varying(10) -
custom_d9 character varying(10) -
custom_t9 character varying(10) -
custom_d10 character varying(10) -
custom_t10 character varying(10) -
custom_t11 character varying(10) -
custom_t12 character varying(10) -
custom_t13 character varying(10) -
custom_t14 character varying(10) -
custom_t15 character varying(10) -
coll_id character varying(32) Collection identifier
foldertypes_doctypes

Foldertypes_doctypes lists mandatory document types for a folder type.

Column Type Comment
foldertype_id integer -
doctype_id integer -
foldertypes_doctypes_level1

Makes the link between a folder type and the first level of the tree structure, in case we add the Folders module.

Column Type Comment
foldertype_id integer -
doctypes_first_level_id integer -

models

models
Column Type Comment
id bigint Model identifier
label character varying(50) Model label
creation_date datetime Model creation date
comment character varying(255) Model description
content text Model content
models_doctype_ext
Column Type Comment
model_id bigint Model identifier
type_id bigint Document type identifier
is_generated character(1) 'Y' if the document type is generated with a model, 'N' otherwise
models_entities
Column Type Comment
id_entity bigint Entity identifier
id_model bigint Model identifier

notes

notes
Column Type Comment
id bigint Note identifier
identifier bigint
tablename character varying(50)
user_id character varying(50)
date datetime
note text
coll_id character varying(50)

physical_archive

ar_batch
Column Type Comment
arbatch_id integer Archive batch identifier
title character varying(255) Title
subject character varying(255) Subject
description text Description
arbox_id bigint Id of the archive box
status character varying(3) Status
creation_date datetime Creation date and time
retention_time datetime Previsional retention time
custom_t1 character varying(3) Custom fields...
custom_n1 integer Put here your own business informations
custom_f1 numeric -
custom_d1 datetime -
custom_t2 character varying(3) -
custom_n2 integer -
custom_f2 numeric -
custom_d2 datetime -
custom_t3 character varying(50) -
custom_n3 integer -
custom_f3 numeric -
custom_d3 datetime -
custom_t4 character varying(50) -
custom_n4 integer -
custom_f4 numeric -
custom_d4 datetime -
custom_t5 character varying(255) -
custom_n5 integer -
custom_f5 numeric -
custom_d5 datetime -
custom_t6 character varying(255) -
custom_t7 character varying(255) -
custom_t8 character varying(255) -
custom_t9 character varying(255) -
custom_t10 character varying(255) -
custom_t11 character varying(255) -
ar_boxes
Column Type Comment
arbox_id integer Archive box identifier
title character varying(255) Title
subject character varying(255) Subject
description text Description
arcontainer_id integer Id of the container where the archive box is stored
status character varying(3) Status
creation_date datetime Creation date and time
retention_time datetime Previsional retention time
custom_t1 character varying(3) Custom fields...
custom_n1 integer Put here your own business informations
custom_f1 numeric -
custom_d1 datetime -
custom_t2 character varying(3) -
custom_n2 integer -
custom_f2 numeric -
custom_d2 datetime -
custom_t3 character varying(50) -
custom_n3 integer -
custom_f3 numeric -
custom_d3 datetime -
custom_t4 character varying(50) -
custom_n4 integer -
custom_f4 numeric -
custom_d4 datetime -
custom_t5 character varying(255) -
custom_n5 integer -
custom_f5 numeric -
custom_d5 datetime -
custom_t6 character varying(255) -
custom_t7 character varying(255) -
custom_t8 character varying(255) -
custom_t9 character varying(255) -
custom_t10 character varying(255) -
custom_t11 character varying(255) -
ar_containers
Column Type Comment
arcontainer_id intger Container identifier
title character varying(255) Title
subject text Subject
description text Description
status character varying(3) Status
storage_id character varying(30) Storage identifier. There is no storage table. Just mention a location (company, warehouse, town, ...)
address character varying(255) Adress in the storage location (ex: x,y,z)
creation_date datetime Creation date and time
retention_time datetime Previsional retention time
custom_t1 character varying(50) Custom fields...
custom_n1 integer Put here your own business informations
custom_f1 numeric -
custom_d1 datetime -
custom_t2 character varying(3) -
custom_n2 integer -
custom_f2 numeric -
custom_d2 datetime -
custom_t3 character varying(255) -
custom_n3 integer -
custom_f3 numeric -
custom_d3 datetime -
custom_t4 character varying(255) -
custom_n4 integer -
custom_f4 numeric -
custom_d4 datetime -
custom_t5 character varying(255) -
custom_n5 integer -
custom_f5 numeric -
custom_d5 datetime -
custom_t6 character varying(255) -
custom_t7 character varying(255) -
custom_t8 character varying(255) -
custom_t9 character varying(255) -
custom_t10 character varying(255) -

workflow

wf_actors
Column Type Comment
wf_id character varying(255)
task_id character varying(32)
sequence integer
user_id character varying(32)
group_id character varying(32)
redirect_grouplist character varying(255)
can_redirect character(1)
wf_events
Column Type Comment
wf_id character varying(255)
task_id character varying(32)
sequence integer
event_desc character varying(255)
event_label character varying(255)
rnext_task_id character varying(255)
branch_id bigint
where_clause text
sort_order bigint
event_id character varying(32)
res_status character varying(32)
wf_groupworklist
Column Type Comment
worklist_security_id bigint
worklist_id bigint
group_id character varying(255)
user_id character varying(255)
wf_insts
Column Type Comment
wf_id character varying(255)
res_id bigint
sequence integer
task_id character varying(255)
user_id character varying(255)
group_id character varying(255)
begin_date date
inst_date date
actual_user_id character varying(255)
status character varying(255)
due_date date
wf_tasks
Column Type Comment
wf_id character varying(255)
task_id character varying(255)
task_desc character varying(255)
pre_process_script character varying(255)
post_process_script character varying(255)
coll_id character varying(255)
where_clause character varying(1024)
process_script character varying(255)
task_delay bigint
wf_worklist
Column Type Comment
worklist_id bigint
worklist_name character varying(255)
worklist_desc character varying(255)
worklist_clause text
is_generic character(1)
enabled character(1)
result_page character varying(255)
custom_stamp character(1)
wf_id character varying(255)
wf_worklist_stamps
Column Type Comment
worklist_id bigint
stamp_id bigint
stamp_label character varying(255)
x_pos integer
y_pos integer
rotation integer