project_type


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
milestone_task_project_type.project_type_id FK3CDFA00B9C0630F6 R
process_library_record_project_type.project_type_id FKB998427A9C0630F6 R
program_project_type.project_type_id FK_bwdbyp9hrckfa2wdfmxi7bi33 R
project.project_type_id FK_k0iaw5c7hylidf45rts7ce7yb R
project_support_auto.project_type_id FK_project_support_auto_project_type R
project_type_default_page.default_page_id FK_g94s8tvb9iii8osgfbe5lefs7 R
project_type_pages.project_type_id FKC4875F659C0630F6 R
survey_participation.project_type_id FK_onj1i2q37uuj85tvnqrc08169 R
vendor_survey_project_type.project_type_id FK_qi1i2gaygqilbnbv5a6grd81b R
name VARCHAR 100 null
info_form INT 10 √ null
note_required BIT 1 √ null
active BIT 1 √ null
allow_on_complete_workflow_types VARCHAR 600 √ null
allow_workflow_on_completed BIT 1 null
note_required_dates_locked_milestone BIT 1 √ null
note_required_today_or_future BIT 1 √ null
note_required_today_or_past BIT 1 √ null
default_page_id BIGINT 19 √ null
project_page.id FK_t2ttjeemgor0wrhdrvh75yw06 R
store_watch_eligible BIT 1 b'1'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_t2ttjeemgor0wrhdrvh75yw06 Performance Asc default_page_id
ix_Project_Type_Name Performance Asc name

Relationships

Close relationships within degrees of separation