proj_project


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
doc_unit.project fk_doc_unit_project R
exc_import_report.project fk_exc_import_report_project R
lot_lot.project fk_lot_project R
proj_project_library.project fk_project_project_library R
proj_project_platform.project fk_project_project_platform R
proj_project_user.project fk_project_project_user R
train_train.project fk_train_project R
library VARCHAR 191 √ NULL
lib_library.identifier fk_project_library R
name VARCHAR 255 √ NULL
description VARCHAR 2000 √ NULL
start_date DATE 10 √ NULL
forecast_end_date DATE 10 √ NULL
real_end_date DATE 10 √ NULL
active BIT 1 √ NULL
status VARCHAR 255 √ NULL
version BIGINT 19 null
created_by VARCHAR 191 'system'
last_modified_by VARCHAR 191 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()
active_configuration_ftp VARCHAR 191 √ NULL
conf_configuration_ftp.identifier fk_project_configuration_ftp R
active_configuration_check VARCHAR 191 √ NULL
conf_configuration_check.identifier fk_project_configuration_check R
canceling_comment VARCHAR 191 √ NULL
provider VARCHAR 191 √ NULL
user_user.identifier fk_project_provider R
collection_omeka VARCHAR 191 √ NULL
conf_lists_omeka.identifier fk_proj_coll_omeka R
items_omeka VARCHAR 191 √ NULL
conf_lists_omeka.identifier fk_proj_items_omeka R
active_configuration_export_ftp VARCHAR 191 √ NULL
conf_export_ftp.identifier fk_project_configuration_export_ftp R
collection_ia VARCHAR 191 √ NULL
conf_collection_ia.identifier fk_proj_coll_ia R
classement_pac VARCHAR 191 √ NULL
conf_classement_pac.identifier fk_proj_pac R
workflow_model VARCHAR 191 √ NULL
workflow_model.identifier fk_project_workflow_model R
files_archived BIT 1 b'0'
active_format_configuration VARCHAR 191 √ NULL
conf_views_format_configuration.identifier fk_project_configuration_viewsformat R
lib_resp_name VARCHAR 191 √ NULL
lib_resp_phone VARCHAR 191 √ NULL
lib_resp_email VARCHAR 191 √ NULL
license_url VARCHAR 191 √ NULL
omeka_configuration VARCHAR 191 √ NULL
conf_omeka.identifier fk_proj_omeka_conf R
active_export_ftp_delivery_folder VARCHAR 191 √ NULL
conf_delivery_folder.identifier proj_delivery_folder_fk R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_proj_coll_ia Performance Asc collection_ia
fk_proj_coll_omeka Performance Asc collection_omeka
fk_proj_items_omeka Performance Asc items_omeka
fk_proj_omeka_conf Performance Asc omeka_configuration
fk_proj_pac Performance Asc classement_pac
fk_project_configuration_check Performance Asc active_configuration_check
fk_project_configuration_export_ftp Performance Asc active_configuration_export_ftp
fk_project_configuration_ftp Performance Asc active_configuration_ftp
fk_project_configuration_viewsformat Performance Asc active_format_configuration
fk_project_library Performance Asc library
fk_project_provider Performance Asc provider
fk_project_workflow_model Performance Asc workflow_model
proj_delivery_folder_fk Performance Asc active_export_ftp_delivery_folder

Relationships

Close relationships within degrees of separation