De Maarch Wiki.
Maarch Framework 3 Data Model
Graphical DM for Maarch v3.1 :
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_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 |
|
France
Sénégal
