Transactional data

Data created and managed by users. Example: plots, scoutings, application orders, etc

Master data

Data created and managed by SIMA staff. Example: cultivations, formulated, phenological states, etc.

Structure entities

These entities organize all events data.

Source: https://app.diagrams.net/#G1UXljVb8Njm0dSbxhdoQVbF8oBlnM1y9U

Common transactional properties

These properties are shared by all transactional entites

Property	Type	Description
id	Integer	Autogenerated, incremental. Not visible to user
created_at	DateTime	DateTime created
updated_at	DateTime	DateTime modified
deleted_at	DateTime	DateTime deleted
created_by	Integer	Creation User ID
updated_by	Integer	Update User ID
deleted_by	Integer	Delete User ID
society_id	Integer	Society ID from Creation User

TRANSACTIONAL DATA

Represent an event.

Property	Type	Description
title	Int	Ttile of event
description	String	Description of event
date_start	DateTime	Global date start from event
date_end	DateTime	Global date end from event
from_planting_date	bool	Indicate if the event start from planting date
days_after_planting	int	Days after planting date
ends_days_after_planting	int	Ends days after planting date
associated_table_code_id	int	Associated Table Code ID
master_campaign_id	int	Master Campaign ID
override_event_id	int	Override event ID

TRANSACTIONAL DATA

Represents the schedules from the event.

MASTER DATA

Represents States used on Event Schedule Executions.

Property	Type	Description
name	String	State name
color	String	State Color (css code)

TRANSACTIONAL DATA

Represents the executions from the events.