Table: Filter_Range_Type
Tags: read-only Content of first 30 of 183 rows:
1 | 1 | ID | staff_id
2 | 1 | Name | description
3 | 3 | ID | office_id
4 | 3 | Name | description
5 | 2 | ID | staff_level_id
6 | 2 | Name | description
7 | 4 | ID | department_id
8 | 4 | Name | description
9 | 6 | ID | activity_id
10 | 6 | Name | description
13 | 9 | Description | description
14 | 10 | ID | client_id
15 | 10 | Name | description
17 | 7 | Name | description
18 | 17 | ID | activity_category_id
19 | 17 | Name | description
20 | 18 | Name | description
21 | 19 | Name | description
25 | 16 | Date | entry_date
26 | 12 | <IndustryCode> | industry_code
27 | 25 | Date | sheet_date
28 | 26 | Date | invoice_date
29 | 27 | Date | due_date
30 | 28 | Date | control_date
31 | 29 | Date | entry_date
32 | 20 | ID | engagement_template_id
33 | 20 | Name | description
34 | 24 | Name | description
35 | 14 | Name | description
36 | 14 | ID | entity_id
Columns
Name | Type | Constraints | Description
filter_range_type_KEY | int | NOT NULL | Database assigned primary key for this table.
filter_line_type_KEY | int | NOT NULL | Key to the Filter Line Type this Range Type belongs to.
description | nvarchar (30) | NOT NULL | Name of this range as it should appear to the user.
lookup_display_member | nvarchar (128) | NOT NULL | Name of the property in the lookup list that has the value that should be used for the range criteria.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Filter_Range_Type$filter_range_type_KEY | filter_range_type_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Filter_Range_Type$filter_line_type_KEY | filter_line_type_KEY | Index supports foreign key FK_Filter_Range_Type__Filter_Line_Type__filter_line_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Filter_Range_Type__Filter_Line_Type__filter_line_type_KEY | filter_line_type_KEY | Filter_Line_Type |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Filter_Line__Filter_Range_Type__filter_range_type_KEY | filter_range_type_KEY | Filter_Line |