Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
|
|
||||||
| deleted | timestamptz | 35,6 | √ | null |
|
|
|||||
| code | varchar | 255 | null |
|
|
||||||
| code_brinks | varchar | 255 | √ | null |
|
|
|||||
| identification_number | varchar | 255 | null |
|
|
||||||
| name | varchar | 255 | null |
|
|
||||||
| alias | varchar | 255 | √ | null |
|
|
|||||
| abbreviation | varchar | 255 | √ | null |
|
|
|||||
| varchar | 255 | √ | null |
|
|
||||||
| phone | varchar | 255 | √ | null |
|
|
|||||
| web | varchar | 255 | √ | null |
|
|
|||||
| address | varchar | 255 | √ | null |
|
|
|||||
| is_carrier | bool | 1 | null |
|
|
||||||
| is_financial_institution | bool | 1 | null |
|
|
||||||
| is_active | bool | 1 | null |
|
|
||||||
| created_at | timestamptz | 35,6 | null |
|
|
||||||
| updated_at | timestamptz | 35,6 | null |
|
|
||||||
| history_id | serial | 10 | √ | nextval('api_historicalcompany_history_id_seq'::regclass) |
|
|
|||||
| history_date | timestamptz | 35,6 | null |
|
|
||||||
| history_change_reason | varchar | 100 | √ | null |
|
|
|||||
| history_type | varchar | 1 | null |
|
|
||||||
| history_user_id | int4 | 10 | √ | null |
|
|
|||||
| segment_company_id | int4 | 10 | √ | null |
|
|
|||||
| type_company_id | int4 | 10 | √ | null |
|
|
|||||
| is_commercial_institution | bool | 1 | null |
|
|
||||||
| is_government_institution | bool | 1 | null |
|
|
||||||
| logo | text | 2147483647 | √ | null |
|
|
|||||
| dubious_reputation | bool | 1 | null |
|
|
||||||
| office_belongs_id | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| api_historicalcompany_pkey | Primary key | Asc | history_id |
| api_historicalcompany_code_4f1214d3 | Performance | Asc | code |
| api_historicalcompany_code_4f1214d3_like | Performance | Asc | code |
| api_historicalcompany_history_user_id_bcbe41b3 | Performance | Asc | history_user_id |
| api_historicalcompany_id_ebbc7b82 | Performance | Asc | id |
| api_historicalcompany_identification_number_6e2c5418 | Performance | Asc | identification_number |
| api_historicalcompany_identification_number_6e2c5418_like | Performance | Asc | identification_number |
| api_historicalcompany_name_fe41a6c4 | Performance | Asc | name |
| api_historicalcompany_name_fe41a6c4_like | Performance | Asc | name |
| api_historicalcompany_office_belongs_id_a393ca8f | Performance | Asc | office_belongs_id |
| api_historicalcompany_segment_company_id_a65f86f0 | Performance | Asc | segment_company_id |
| api_historicalcompany_type_company_id_924cd837 | Performance | Asc | type_company_id |