opportunity


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('opportunity_id_seq'::regclass)
attempt.opportunity_id FK_5f39265b0b52efb132f0430e917 R
audience.opportunity_id FK_c7c7d822880da077bd1ffea20aa R
opportunity_quota_link.opportunity_id FK_1716aa7715f2ac2ebb2a828342f R
target.opportunity_id FK_efef0d2a5a250a021b2eba74f4f R
uuid varchar 2147483647 null
name varchar 2147483647 null
code varchar 2147483647 null
state varchar 2147483647 'active'::character varying
cpi_buyer float8 17,17 '0'::double precision
cpi_supplier float8 17,17 '0'::double precision
cpi_supplier_for_quota varchar 2147483647 '0'::character varying
country_code varchar 2147483647 √ null
sample_router_url_start varchar 2147483647 √ null
sample_router_url_start_test varchar 2147483647 √ null
redirect_url varchar 2147483647 √ null
return_url_complete varchar 2147483647 null
return_url_terminate varchar 2147483647 null
return_url_quota varchar 2147483647 √ null
return_url_quality varchar 2147483647 √ null
return_url_screenout varchar 2147483647 √ null
return_url_timeout varchar 2147483647 √ null
return_url_duplicate varchar 2147483647 √ null
created_at timestamp 29,6 now()
updated_at timestamp 29,6 now()
deleted_at timestamp 29,6 √ null
survey_uuid varchar 2147483647 √ null
project_id int4 10 √ null
project.id FK_d9545fc417ff7c8047bf2d5c9ad R
supplier_id int4 10 √ null
supplier.id FK_68867cbf0619d31664495089dcb R
buyer_id int4 10 √ null
buyer.id FK_8f7bf46954419c5b3d7ab604658 R

Indexes

Constraint Name Type Sort Column(s)
PK_085fd6d6f4765325e6c16163568 Primary key Asc id
UQ_603f27ab45b4ac33078362430a5 Must be unique Asc uuid

Relationships

Close relationships within degrees of separation