quota


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('quota_id_seq'::regclass)
criteria.quota_id FK_30b995bc5807a0f181e34d19e48 R
opportunity_quota_link.quota_id FK_8ca757a0c50780d88cc63a36393 R
target.quota_id FK_22349975d53b56848bf89b7a824 R
uuid varchar 2147483647 null
name varchar 2147483647 null
code varchar 2147483647 null
id_mc varchar 2147483647 null
cpi_buyer float8 17,17 '0'::double precision
description varchar 2147483647 null
target varchar 2147483647 null
redirect_url varchar 2147483647 null
statistics json 2147483647 null
qualifications json 2147483647 null
state varchar 2147483647 'active'::character varying
status varchar 2147483647 'unassigned'::character varying
type varchar 2147483647 'sample_only'::character varying
raw_data json 2147483647 null
created_at timestamp 29,6 now()
updated_at timestamp 29,6 now()
deleted_at timestamp 29,6 null
bid_id int4 10 null
bid.id FK_3db51525168d97e04f44df7571f R
project_id int4 10 null
project.id FK_dde02766138adf72287acf6f7fc R

Indexes

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

Relationships