Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| refid | serial | 10 | √ | nextval('tbl_project_monitor_reports_refid_seq'::regclass) |
|
|
||||
| invoice_code | varchar | 20 | null |
|
|
|||||
| report_year | int2 | 5 | √ | null |
|
|
||||
| report_month | int2 | 5 | √ | null |
|
|
||||
| current_budget | text | 2147483647 | √ | null |
|
|
||||
| form_of_contract | text | 2147483647 | √ | null |
|
|
||||
| budget_variation_mechanism | text | 2147483647 | √ | null |
|
|
||||
| issues_to_consider | text | 2147483647 | √ | null |
|
|
||||
| tasks_complete_percentage | numeric | 5,2 | √ | null |
|
|
||||
| estimated_tasks_complete_against_resources_details | text | 2147483647 | √ | null |
|
|
||||
| predicted_percentage_overrun_percentage | numeric | 5,2 | √ | null |
|
|
||||
| predicted_percentage_overrun_details | text | 2147483647 | √ | null |
|
|
||||
| ew_client | text | 2147483647 | √ | null |
|
|
||||
| ew_management | text | 2147483647 | √ | null |
|
|
||||
| ew_measures | text | 2147483647 | √ | null |
|
|
||||
| invoicing_status | text | 2147483647 | √ | null |
|
|
||||
| debt_status | text | 2147483647 | √ | null |
|
|
||||
| timestamp | timestamp | 22 | √ | now() |
|
|
||||
| entered_by | int4 | 10 | √ | null |
|
|
||||
| agreed_actions | text | 2147483647 | √ | null |
|
|
||||
| resources_used_percentage | numeric | 5,2 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_project_monitor_reports_pkey | Primary key | Asc | refid |
| tbl_project_monitor_reports_invoice_code_report_month_key | Must be unique | Asc/Asc/Asc | invoice_code + report_year + report_month |
Relationships
Close relationships within degrees of separation
