Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| refid | serial | 10 | √ | nextval('tbl_tender_episode_data_refid_seq'::regclass) |
|
|
||||
| episode_type | varchar | 100 | √ | null |
|
|
||||
| invoice_code | varchar | 100 | √ | null |
|
|
||||
| not_applicable | bool | 1 | √ | null |
|
|
||||
| risk_level | varchar | 10 | √ | null |
|
|
||||
| risk_level_comment | text | 2147483647 | √ | null |
|
|
||||
| notes | text | 2147483647 | √ | null |
|
|
||||
| markup | numeric | 5,2 | √ | null |
|
|
||||
| department | varchar | 100 | √ | null |
|
|
||||
| currency | int2 | 5 | √ | null |
|
|
||||
| monetary_value | numeric | 131089 | √ | null |
|
|
||||
| succeeded_refid | int4 | 10 | √ | null |
|
|
||||
| date_won | date | 13 | √ | null |
|
|
||||
| won_comments | text | 2147483647 | √ | null |
|
|
||||
| won_by | varchar | 100 | √ | null |
|
|
||||
| winning_amount | numeric | 131089 | √ | null |
|
|
||||
| min_amount | numeric | 131089 | √ | null |
|
|
||||
| max_amount | numeric | 131089 | √ | null |
|
|
||||
| number_of_tenders | int4 | 10 | √ | null |
|
|
||||
| comments | text | 2147483647 | √ | null |
|
|
||||
| uploaded_to_kt | bool | 1 | √ | null |
|
|
||||
| central_file_destroyed | bool | 1 | √ | null |
|
|
||||
| project_name | varchar | 200 | √ | null |
|
|
||||
| description | varchar | 100 | √ | null |
|
|
||||
| also_known_as | varchar | 500 | √ | null |
|
|
||||
| source | varchar | 50 | √ | null |
|
|
||||
| project_created_by | int4 | 10 | √ | null |
|
|
||||
| the_geom | varchar | 50 | √ | null |
|
|
||||
| second_geom | varchar | 50 | √ | null |
|
|
||||
| grid_reference | varchar | 100 | √ | null |
|
|
||||
| country | varchar | 100 | √ | null |
|
|
||||
| district | varchar | 100 | √ | null |
|
|
||||
| no_location | bool | 1 | √ | null |
|
|
||||
| linear_site | bool | 1 | √ | null |
|
|
||||
| tender_number | int4 | 10 | √ | null |
|
|
||||
| tender_created_by | int4 | 10 | √ | null |
|
|
||||
| tender_created_on | date | 13 | √ | null |
|
|
||||
| tender_officer | int4 | 10 | √ | null |
|
|
||||
| non_competitive | bool | 1 | √ | null |
|
|
||||
| job_description | varchar | 200 | √ | null |
|
|
||||
| stay_away | bool | 1 | √ | null |
|
|
||||
| date_tendered | date | 13 | √ | null |
|
|
||||
| date_tendered_comments | text | 2147483647 | √ | null |
|
|
||||
| date_required | date | 13 | √ | null |
|
|
||||
| date_required_comments | text | 2147483647 | √ | null |
|
|
||||
| date_received | date | 13 | √ | null |
|
|
||||
| date_received_comments | text | 2147483647 | √ | null |
|
|
||||
| tender_status | varchar | 100 | √ | null |
|
|
||||
| tender_hierarchy | varchar | 100 | √ | null |
|
|
||||
| box_number | varchar | 20 | √ | null |
|
|
||||
| cost_centres | text | 2147483647 | √ | null |
|
|
||||
| status | text | 2147483647 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
