Events: Entity relations and description
- Nicolas Corvalan
- 1 Structure entities
- 1.1 Common transactional properties
- 1.2 Event
- 1.3 EventEntity
- 1.4 Event Schedule
- 1.5 State
- 1.6 EventType
- 1.7 Event Schedule Execution
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/#G1lP6w2o8eU2Wl6H2XOb9sJgKiMzBciYJVCommon 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 |
Event
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 |
event_type_id | int | EventType ID |
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 |
EventEntity
tRANSACTIONAL DATA
Represent an event.
Property | Type | Description |
|---|---|---|
event_id | int | Event ID |
entity_id | int | Entity ID (Master campaign ID o Campaign ID, depends on EventType) |
is_enabled | bool | Enable/Disable |
Event Schedule
tRANSACTIONAL DATA
Represents the schedules from the event.
Property | Type | Description |
|---|---|---|
event_entity_id | int | Event Entity ID |
due_date | DateTime | DateTime from Schedule |
State
MASTER DATA
Represents States used on Event Schedule Executions.
Property | Type | Description |
|---|---|---|
name | String | State name |
color | String | State Color (css code) |
EventType
MASTER DATA
Represents Types of Events.
Property | Type | Description |
|---|---|---|
name | String | Name |
code | String | Code |
Event Schedule Execution
tRANSACTIONAL DATA
Represents the executions from the events.
Property | Type | Description |
|---|---|---|
event_schedule_id | Int | Event Schedule ID |
campaign_id | Int | Campaign ID |
activity_id | Int | Activity |
state_id | int | State ID |
date | Date | Date of Execution |