farmExpense

8156 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
farm_id uuid 2147483647 √ null
farm.farm_id farmexpense_farm_id_foreign R
expense_date timestamptz 35,6 null
picture varchar 255 √ null
note varchar 255 √ null
expense_type_id uuid 2147483647 √ null
farmExpenseType.expense_type_id farmexpense_expense_type_id_foreign R
farm_expense_id uuid 2147483647 uuid_generate_v1()
value float4 8,8 √ null
deleted bool 1 false
created_by_user_id varchar 255 √ '1'::character varying
users.user_id farmexpense_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ '1'::character varying
users.user_id farmexpense_updated_by_user_id_foreign R
created_at timestamptz 35,6 '1999-12-31 16:00:00-08'::timestamp with time zone
updated_at timestamptz 35,6 '1999-12-31 16:00:00-08'::timestamp with time zone

Indexes

Constraint Name Type Sort Column(s)
farmExpense_pkey Primary key Asc farm_expense_id

Relationships

Close relationships within degrees of separation