revenue_type

405 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
revenue_type_id serial 10 √ nextval('revenue_type_revenue_type_id_seq'::regclass)
sale.revenue_type_id sale_revenue_type_id_foreign R
revenue_name varchar 255 null
farm_id uuid 2147483647 √ null
farm.farm_id revenue_type_farm_id_foreign R
deleted bool 1 false
created_by_user_id varchar 255 √ null
users.user_id revenue_type_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ null
users.user_id revenue_type_updated_by_user_id_foreign R
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
revenue_translation_key varchar 255 null
agriculture_associated bool 1 √ true
crop_generated bool 1 √ false
custom_description varchar 255 √ null
retired bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
revenue_type_pkey Primary key Asc revenue_type_id

Relationships

Close relationships within degrees of separation