Table: Filter_Range_Type
Tags: read-only

Content of first 30 of 184 rows:
11IDstaff_id
21Namedescription
33IDoffice_id
43Namedescription
52IDstaff_level_id
62Namedescription
74IDdepartment_id
84Namedescription
96IDactivity_id
106Namedescription
139Descriptiondescription
1410IDclient_id
1510Namedescription
177Namedescription
1817IDactivity_category_id
1917Namedescription
2018Namedescription
2119Namedescription
2516Dateentry_date
2612<IndustryCode>industry_code
2725Datesheet_date
2826Dateinvoice_date
2927Datedue_date
3028Datecontrol_date
3129Dateentry_date
3220IDengagement_template_id
3320Namedescription
3424Namedescription
3514Namedescription
3614IDentity_id
Columns
NameTypeConstraintsDescription
filter_range_type_KEYintNOT NULLDatabase assigned primary key for this table.
filter_line_type_KEYintNOT NULLKey to the Filter Line Type this Range Type belongs to.
descriptionnvarchar (30)NOT NULLName of this range as it should appear to the user.
lookup_display_membernvarchar (128)NOT NULLName of the property in the lookup list that has the value that should be used for the range criteria.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Filter_Range_Type$filter_range_type_KEYfilter_range_type_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Filter_Range_Type$filter_line_type_KEYfilter_line_type_KEYIndex supports foreign key FK_Filter_Range_Type__Filter_Line_Type__filter_line_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Range_Type__Filter_Line_Type__filter_line_type_KEYfilter_line_type_KEYFilter_Line_Type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Line__Filter_Range_Type__filter_range_type_KEYfilter_range_type_KEYFilter_Line

Schema diagram