pg-litefarm.public

TABLES 147

COLUMNS 1140

Constraints 279

Anomalies 25

Routines 0

Database Properties

Database Type: PostgreSQL - 13.2 (Debian 13.2-1.pgdg100+1)

Schema public

standard public schema

Tables

Table / View	Children	Parents	Columns	Rows	Type
soil_amendment_task	0	2	5	1945	Table
animal_identifier_type	1	0	2	0	Table
default_animal_breed	2	1	3	0	Table
nomination	2	4	8	688	Table
water_valve	0	1	4	643	Table
custom_animal_type	3	3	8	107	Table
farmExpenseType	1	3	11	297	Table
farm	35	4	18	8556	Table
management_plan	3	4	17	22000	Table
nomination_type	2	2	6	0	Table
task_type	2	3	9	1437	Table
animal_batch_sex_detail	0	4	9	946	Table
animal_origin	2	0	2	0	Table
custom_location	0	1	4	0	Table
document	2	3	14	590	Table
broadcast_method	0	1	5	2189	Table
cleaning_task	0	2	10	594	Table
hs_code	2	0	2	236	Table
animal_batch_use_relationship	0	2	3	128	Table
soil_task	0	1	23	38	Table
harvest_task	1	1	6	25374	Table
countries	2	0	7	227	Table
farm_site_boundary	0	1	1	2762	Table
finance_report	0	3	8	235	Table
knex_migrations_lock	0	0	1	1	Table
planting_management_plan	8	2	11	25111	Table
soil_amendment_fertiliser_type	1	0	2	0	Table
field	2	2	4	10740	Table
certifier_country	0	2	3	16	Table
crop_management_plan	0	1	17	21805	Table
migration_deletion_logs	0	0	5	314	Table
disease	1	3	12	524	Table
users	92	1	16	9755	Table
crop_variety	2	5	55	19893	Table
maintenance_task	0	1	2	0	Table
animal_movement_task	0	1	1	51	Table
location	27	3	9	29620	Table
addon_partner	1	0	6	0	Table
irrigation_type	2	3	10	44	Table
rolePermissions	0	2	2	593	Table
animal_use_relationship	0	2	3	313	Table
buffer_zone	0	1	1	664	Table
revenue_type	1	3	13	405	Table
soil_sample_location	0	1	1	0	Table
userFarm	6	3	19	12084	Table
waterBalance	0	2	6	12406	Table
soil_amendment_method	1	0	2	0	Table
role	2	0	3	5	Table
management_plan_group	1	2	8	1255	Table
residence	0	1	1	1604	Table
wash_and_pack_task	0	1	1	23	Table
crop_variety_sale	0	2	5	5288	Table
transport_task	0	1	1	110	Table
organic_history	0	3	9	16249	Table
animal_identifier_color	1	0	2	0	Table
file	0	1	5	621	Table
supportTicket	0	3	14	378	Table
animal_group	2	2	9	0	Table
animal_group_relationship	0	2	3	0	Table
ceremonial_area	0	1	1	332	Table
sale	1	4	12	3203	Table
social_task	0	1	2	43	Table
weather	0	1	10	42049	Table
transplant_task	0	3	3	3001	Table
yield	0	2	6	2315	Table
animal_movement_task_purpose_relationship	0	2	3	100	Table
nomination_workflow	1	3	8	0	Table
soil_sample_task	0	1	5	0	Table
farm_addon	0	4	10	2	Table
notification	1	3	12	63730	Table
emailToken	0	2	6	3082	Table
harvest_use	0	2	5	11829	Table
pin	0	1	1	0	Table
soil_amendment_product	0	2	16	793	Table
animal_batch_group_relationship	0	2	3	0	Table
knex_migrations	0	0	4	396	Table
figure	3	1	3	28686	Table
nomination_status	0	4	9	688	Table
userLog	0	2	16	160368	Table
permissions	1	0	3	131	Table
shiftTask	0	6	11	2585	Table
cropDisease	0	2	2	27	Table
bed_method	0	1	14	3696	Table
scouting_task	0	1	2	100	Table
soil_amendment_task_products_purpose_relationship	0	2	3	1668	Table
crop	6	4	70	3139	Table
nomination_crop	0	2	2	688	Table
harvest_use_type	1	1	4	117	Table
area	0	1	6	24101	Table
nitrogenBalance	0	1	4	290	Table
management_tasks	0	2	2	39708	Table
animal_movement_purpose	1	0	2	0	Table
location_tasks	0	2	2	41737	Table
product	4	3	12	1232	Table
waterBalanceSchedule	0	1	3	119	Table
irrigation_task	0	3	19	692	Table
default_animal_type	5	0	2	0	Table
weather_station	4	0	4	228	Table
animal_use	3	0	2	0	Table
natural_area	0	1	1	1260	Table
task	24	5	26	49179	Table
nitrogenSchedule	0	1	5	57	Table
animal	3	13	32	1842	Table
animal_batch	4	10	27	385	Table
farmDataSchedule	0	2	6	0	Table
field_work_type	1	3	9	836	Table
price	0	2	6	2366	Table
barn	0	1	4	1411	Table
location_defaults	0	4	11	0	Table
sale_task	0	1	1	562	Table
notification_user	0	4	9	74350	Table
password	0	1	4	2842	Table
test	0	0	1	0	Table
plant_task	0	2	2	7653	Table
animal_sex	2	0	2	0	Table
animal_removal_reason	2	0	2	0	Table
task_document	0	2	2	0	Table
greenhouse	0	1	6	1536	Table
pest_control_task	0	2	9	1397	Table
user_status	1	0	2	3	Table
watercourse	0	1	4	512	Table
shift	1	4	11	549	Table
farmExpense	0	4	12	8156	Table
fertilizer	0	3	15	68	Table
garden	0	2	4	4023	Table
line	0	1	8	2184	Table
organicCertifierSurvey	0	9	12	8155	Table
custom_animal_breed	2	5	10	168	Table
certifications	2	0	3	2	Table
showedSpotlight	0	1	41	8854	Table
weatherHourly	0	1	10	3421	Table
soil_amendment_task_products	1	4	16	1912	Table
field_work_task	0	4	6	5069	Table
gate	0	1	1	870	Table
surface_water	0	1	2	1027	Table
task_animal_relationship	0	2	2	436	Table
fence	0	1	2	825	Table
pesticide	0	3	13	32	Table
row_method	0	1	16	6132	Table
task_animal_batch_relationship	0	2	2	31	Table
certifiers	2	1	5	16	Table
untitled_table	0	0	1	0	Table
point	0	1	2	1691	Table
animal_type_use_relationship	0	2	2	0	Table
release_badge	0	1	4	3395	Table
container_method	0	1	11	4149	Table
soil_amendment_purpose	1	0	2	0	Table
animal_union_batch_id_view	0	1	5	0	View