Treetracker Schema Attributes

**Capture**

id	Not null, default uuid(), immutable
reference_id	Nullable, immutable
session_id	Not null, immutable
tree_id	Nullable, immutable but clearable
image_url	Not null, immutable
lat	Not null, immutable
lon	Not null, immutable
gps_accuracy	Not null, immutable
estimated_geometric_location	Not null, immutable
estimated_geographic_location	Not null, immutable
planter_id	Not null, immutable
planter_photo_url	Not null, immutable
planter_username	Not null, immutable
planting_organization_id	Not null, immutable
device_configuration_id	Not null, immutable
species_id	Nullable, mutable (for now)
morphology	Nullable, mutable (for now)
age	Nullable, mutable (for now)
attributes	Nullable, immutable
note	Nullable, immutable
domain_specific_data	Nullable, immutable
status	Not null, mutable
created_at	Default now() on create, not null, immutable
updated_at	Default now() on create or update, not null, mutable

**Tree**

id	Not null, default uuid(), immutable
latest_capture_id	Not null, mutable
image_url	Not null, mutable
lat	Not null, immutable
lon	Not null, immutable
gps_accuracy	Not null, immutable
estimated_geometric_location	Not null, immutable
estimated_geographic_location	Not null, immutable
species_id	Nullable, mutable (for now)
morphology	Nullable, mutable (for now)
age	Nullable, mutable (for now)
attributes	Nullable, immutable
status	Not null, mutable
created_at	Default now() on create, not null, immutable
updated_at	Default now() on create or update, not null, mutable

**Tag**

id	Not null, default uuid(), immutable
name	Not null, immutable
public	Not null, mutable
status	Not null, mutable
created_at	Default now() on create, not null, immutable
updated_at	Default now() on create or update, not null, mutable

**Capture_Tag**

id	Not null, default uuid(), immutable
capture_id	Not null, immutable
tag_id	Not null, immutable
status	Not null, mutable
created_at	Default now() on create, not null, immutable
updated_at	Default now() on create or update, not null, mutable

**Tree_Tag**

id	Not null, default uuid(), immutable
tree_id	Not null, immutable
tag_id	Not null, immutable
status	Not null, mutable
created_at	Default now() on create, not null, immutable
updated_at	Default now() on create or update, not null, mutable

**Grower_Account**

id	Not null, default uuid(), immutable
wallet_id	Not null, immutable
wallet	Not null, immutable
person_id	Nullable, uuid of stakeholder
organization_id	Nullable, uuid of stakeholder
name	Not null, mutable
email	Nullable, mutable - one of email or phone required to be non-null
phone	Nullable, mutable - one of email or phone required to be non-null
image_url	Not null, mutable
image_rotation	Default 0, not null
status	Not null, default active
first_registration_at	Immutable, timestamp of first field registration
created_at	Default now() on create, not null, immutable
updated_at	Default now() on create or update, not null, mutable

**Status Enumeration** active deleted Session - Field Data Schema Device Configuration - Field Data Schema