Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
|||||||||||
| report_name | text | 2147483647 | null |
|
|
||||||||||||
| category | t_report_category | 24 | √ | null |
|
|
category for report form_types for print_form |
||||||||||
| report_type | t_report_types | 14 | null |
|
|
||||||||||||
| options | json | 2147483647 | √ | null |
|
|
|||||||||||
| path_url | text | 2147483647 | √ | null |
|
|
|||||||||||
| report_filename | text | 2147483647 | √ | null |
|
|
name of file name report - Use store report name in report service - Referent in frontend |
||||||||||
| permission_code | bpchar | 5 | √ | ('8'::text || lpad((id)::text, 4, '0'::text)) |
|
|
|||||||||||
| interface_codes | _text | 2147483647 | √ | null |
|
|
PMS interfaces that expose this report; NULL means always available and any enabled code is sufficient. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| reports_pk | Primary key | Asc | id |
| reports_category_idx | Performance | Asc | category |
| reports_report_name_idx | Performance | Asc | report_name |
Relationships
Close relationships within degrees of separation
