organicCertifierSurvey

8155 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
survey_id uuid 2147483647 uuid_generate_v1()
farm_id uuid 2147483647 √ null
userFarm.farm_id organiccertifiersurvey_farm_id_updated_by_user_id_foreign R
farm.farm_id organiccertifiersurvey_farm_id_foreign R
created_by_user_id varchar 255 √ null
users.user_id organiccertifiersurvey_created_by_user_id_foreign R
userFarm.user_id organiccertifiersurvey_farm_id_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ null
users.user_id organiccertifiersurvey_updated_by_user_id_foreign R
userFarm.user_id organiccertifiersurvey_farm_id_updated_by_user_id_foreign R
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
interested bool 1 false
deleted bool 1 √ false
requested_certification varchar 255 √ null
requested_certifier varchar 255 √ null
certifier_id int4 10 √ null
certifiers.certifier_id organiccertifiersurvey_certifier_id_foreign R
certification_id int4 10 √ null
certifications.certification_id organiccertifiersurvey_certification_id_foreign R

Indexes

Constraint Name Type Sort Column(s)
organicCertifierSurvey_pkey Primary key Asc survey_id
organiccertifiersurvey_farm_id_unique Must be unique Asc farm_id

Relationships

Close relationships within degrees of separation