process_library_record


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
process_library_log.record_id FK7E3A6FF067DEC566 R
process_library_record_accountable.record_id FK71A2DFED67DEC566 R
process_library_record_category.record_id FK946F7D867DEC566 R
process_library_record_consulted.record_id FKA92ADDF167DEC566 R
process_library_record_informed.record_id FK10ED10A267DEC566 R
process_library_record_phase.record_id FK2A5A4CE167DEC566 R
process_library_record_project_type.record_id FKB998427A67DEC566 R
process_library_record_responsible.record_id FKAC1DE5DC67DEC566 R
process_library_record_site_brand.record_id FKABC4A8E967DEC566 R
process_library_record_site_channel.record_id FKF11409E567DEC566 R
process_library_user_permits.record_id FKDAC14C1867DEC566 R
version BIGINT 19 null
active BIT 1 null
additional_information LONGTEXT 2147483647 √ null
audit_date DATETIME 19 √ null
change_notes LONGTEXT 2147483647 √ null
code VARCHAR 25 null
dark BIT 1 null
date_modified DATETIME 19 null
description LONGTEXT 2147483647 √ null
important_links LONGTEXT 2147483647 √ null
next_step LONGTEXT 2147483647 √ null
preceding_step LONGTEXT 2147483647 √ null
program_details LONGTEXT 2147483647 √ null
requirement LONGTEXT 2147483647 √ null
stake_holders VARCHAR 255 null
title_id INT 10 null
process_library_title.id FK5C1850257952D7EE R
process_holder VARCHAR 50 √ null
retirement_audit_comments VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
code Must be unique Asc code
FK5C1850257952D7EE Performance Asc title_id

Relationships

Close relationships within degrees of separation