program


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_asset_categories.program_id FK_nhmr5qxap224rq93lyfyf7rxj R
program_asset_responsible_roles.program_id FK_kfbt8fiqji624uomyk9yh5xnd R
program_asset_templates.program_id FK_941lut3oc8iti4c37vffoibq8 R
program_company.program_id FK_6iyb6d3wp0iqtnempvlh96e5o R
program_company_contact.program_id FK_cgrc9je8uifh5ge9u15pkv45q R
program_contact.program_id FK_26ighsholsf7srl5snt2iai69 R
program_document_layout.program_id FK_2r20baccdb84hnx58fr812mdt R
program_end_design.program_id FK_c50o6sx7yq7waddcgojgahrcw R
program_folder.program_id FK_rov7cjd3aoreli3gt9bn4yvgb R
program_log.program_id FK_pnhc1jj16a48cn72yr2pnunbr R
program_message.program_id FK_lgxc68rnwpv824qkg57pbimbr R
program_milestone.program_id FK_94f1es7fuwfx6eodfhede9sf9 R
program_plg.program_id FK_plg_program_program R
program_project_type.program_project_types_id FK_go3f9alibru05hjggy7cxf7ng R
program_site_channel.program_channels_id FK_689e9cea957gddc2p85yefkts R
program_site_design.program_end_designs_id FK_ie87dpl8hxk68iepaev4v1rds R
program_site_design.program_start_designs_id FK_nx6a0fl83vk7ae6i6uayml3e5 R
program_start_design.program_id FK_a57wtu76m8tojec51cja9wdln R
program_support.program_id FK_42qfyd1rka0harvr565kcfwk5 R
program_workflow.program_id FK_1ufc40kbcsjgayxmf6ywfmpgn R
version BIGINT 19 null
budget DECIMAL 19,2 null
goal_count TEXT 65535 √ null
goals TEXT 65535 √ null
manager_id INT 10 √ null
sys_users.user_id FK_n9jmarp1n8tq1g959gd55knxo R
revised_budget DECIMAL 19,2 √ null
staffing TEXT 65535 √ null
status_id BIGINT 19 null
program_status.id FK_e0hbc9fvamd89q4ll6aoke43s R
type_id INT 10 null
project_sd_group.group_id FK_3e48e26m2gno1rdgnndnbvoy0 R
year_id INT 10 null
project_program_year.id FK_eauuikvg13axl13upd9aq8em9 R
classified BIT 1 null
assets_required BIT 1 null
no_asset_reason VARCHAR 500 √ null
list_id INT 10 √ null
projectlist_custom.id FK_3g55e7kmn4wpntgyvxaevtoyq R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_3g55e7kmn4wpntgyvxaevtoyq Performance Asc list_id
FK_e0hbc9fvamd89q4ll6aoke43s Performance Asc status_id
FK_eauuikvg13axl13upd9aq8em9 Performance Asc year_id
FK_n9jmarp1n8tq1g959gd55knxo Performance Asc manager_id
unique_year_id Must be unique Asc/Asc type_id + year_id

Relationships

Close relationships within degrees of separation