intake_request_type


Columns

Column Type Size Nulls Auto Default Children Parents Comments
request_type_id BIGINT 19 √ null
intake.request_type_id FKB971272C9D32BD2D R
intake_display_field.type_id fk_intake_display_request_type R
intake_request_type.parent_id fk_intake_req_parent R
request_type VARCHAR 50 null
active BIT 1 √ null
always_display_sla BIT 1 √ null
keywords VARCHAR 255 √ null
sla INT 10 √ null
default_user_id INT 10 √ null
sys_users.user_id FK_sqkki9h9pfch04qucx9st80th R
default_user_type INT 10 null
sys_monitor_types.type Implied Constraint R
system_id BIGINT 19 √ null
intake_system.system_id fk_intake_req_system R
parent_id BIGINT 19 √ null
intake_request_type.request_type_id fk_intake_req_parent R
is_public BIT 1 √ null
is_group BIT 1 √ null
instructions TEXT 65535 √ null
description VARCHAR 128 √ null
full_path TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc request_type_id
fk_intake_req_parent_idx Performance Asc parent_id
fk_intake_req_system_idx Performance Asc system_id
FK_sqkki9h9pfch04qucx9st80th Performance Asc default_user_id

Relationships

Close relationships within degrees of separation