Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('bid_id_seq'::regclass) |
|
|
|||||
| uuid | varchar | 2147483647 | null |
|
|
||||||
| id_mc | varchar | 2147483647 | √ | null |
|
|
|||||
| buyer_account_id | uuid | 2147483647 | null |
|
|
||||||
| buyer_id | uuid | 2147483647 | null |
|
|
||||||
| closed_at | timestamp | 29,6 | √ | null |
|
|
|||||
| country_id | varchar | 2 | null |
|
|
||||||
| end_date | timestamp | 29,6 | √ | null |
|
|
|||||
| exclusions | json | 2147483647 | √ | null |
|
|
|||||
| language_ids | json | 2147483647 | null |
|
|
||||||
| name | varchar | 2147483647 | null |
|
|
||||||
| published_at | timestamp | 29,6 | √ | null |
|
|
|||||
| status | varchar | 2147483647 | 'unread'::character varying |
|
|
||||||
| state | varchar | 2147483647 | null |
|
|
||||||
| statistics | json | 2147483647 | √ | null |
|
|
|||||
| supplier_exclusive | bool | 1 | √ | null |
|
|
|||||
| survey_type | varchar | 2147483647 | √ | null |
|
|
|||||
| timeout | int4 | 10 | √ | null |
|
|
|||||
| topic_id | varchar | 2147483647 | √ | null |
|
|
|||||
| raw_data | json | 2147483647 | √ | null |
|
|
|||||
| created_at | timestamp | 29,6 | now() |
|
|
||||||
| updated_at | timestamp | 29,6 | now() |
|
|
||||||
| deleted_at | timestamp | 29,6 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ed405dda320051aca2dcb1a50bb | Primary key | Asc | id |
| UQ_38708187cffb1d824b6c2188b92 | Must be unique | Asc | uuid |