McDewey

2.3.216 grtreport (TI-484) Description: A report Fields: 2.3.216.1 description (FI-3600) Type: string [1000] Default Value: EMPTY Validation: ^[]a-zA-Z0-9 !#$'()*+,./:;=?@[^`{|}~-]{0,1000}$ 2.3.216.2 isstandard (FI-3599) Type: bool (Not Modifiable) Default Value: FALSE 2.3.216.3 name (FI-3598) Type: string [50] (Unique, Not Modifiable) Validation: ^[a-zA-Z 0-9.-]{1,50}$ 2.3.216.4 pkid (FI-3597) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. Uniqueness: No multicolumn uniqueness constraints 2.3.217 grtreportsourcemap (TI-485) Description: A mapping table to map GRTSource and GRTReport Fields: 2.3.217.1 fkgrtreport (FI-3606) Type: guid Default Value: EMPTY 2.3.217.2 fkgrtsource (FI-3607) Type: guid Default Value: EMPTY 2.3.217.3 isstandard (FI-3605) Type: bool (Not Modifiable) Default Value: FALSE 2.3.217.4 pkid (FI-3603) Type: guid (Unique, Indexed, Not Modifiable) Default Value: newid() Remarks: Unique ID to identify a record. 2.3.217.5 priority (FI-3608) Type: long (Null OK) Check Constraint: (priority >= 1) AND (priority < 499)