Variables Overview
Cunitec uses a standard database model called relational. A relational database system contains one or more objects called tables. The data that you enter into the database is stored in these tables. Tables are uniquely identified by their names and are comprised of columns and rows. Columns contain the variable name, data type, and any other attributes for the column. Rows contain the records, or data, for the columns. Here is a sample table called Female table.
The columns are the variable names, in this example ID, BirthDate, Location, CurParity, Genetics, EID.
Each record, or row, in the Female table is a female. The rows contain the variables related to her current parity (or her last parity if she has been removed). This table contains the variables that are in the data fields of the Current Status sheet such as genetics, birthdate, origin, entry date, and others which do not change for the life of the female.
ID |
BirthDate |
Location |
CurParity |
Genetics |
EID |
|---|---|---|---|---|---|
| 2350 | 2021-12-05 | M1-521 | 4 | Landrace | 125241524242 |
Primary tables
| Table | Description |
|---|---|
| Female table | Each record is a female. It contains the variables in the Current Status sheet, such as genetics, birthdate, origin, entry date, and other variables related to the current parity of the female (or her last parity if she has been removed) |
| Mating table | Each record is a mating event. |
| Parity table | Each record is a parity. The data of each record refers to a specific parity and contains the variables related to the birth and weaning of pigs. |
| Performance table | Each record is a period of time as defined by the user. This table includes statistical data incurred in the breeding herd. |
| PWDeath table | Each record is a preweaned death event. |
| Service table | Each record is a service. The data of each record refers to a specific service. |
| Treatment table | Each record is a treatment event. |
Complex tables
Primary tables are joined to build more complex tables, by combining variables from multiple tables:
| Table | Description |
|---|---|
| FemaleEx Table | FemaleEx table joins the columns of the Female+Parity+Service tables. Each record is a female and includes variables related to the current parity, the last service in the parity. |
| ParityEx Table | ParityEx table joins the columns of the Female+Parity+Service tables. Each record is a parity, and includes the female data, the birthing and weaning variables, and the service variables related to the last service in the parity. Important: The record begins with a birthing event. Service related variables in this table are of the same parity as the birthing and refer to the service after the weaning event. |
| PwDeathEx Table | PwDeathEx table joins the columns of the Female+Parity+PwDeath tables. Each record is a pre-weaned death event, and includes the female and the parity table information. |
| ServiceEx Table | ServiceEx table joins the columns of the Female+Parity+Service tables. Each record is a service, and includes the female, the parity, and all services in a single parity. Note that in a service that results in a birthing, the birthing occurs in the next parity, so if you need birthing information pertaining to a service result use ServiceResult table instead of ServiceEx. |
| ServiceResult Table | ServiceResult table joins the the Female+Service+Parity tables. Each record is a service, and includes the female data, services data, and the next parity birthing variables that may result from the service. The record begins with a service event and ends with the weaning event in the next parity. |
| FemaleTreatment Table | FemaleTreatment table joins the columns of the Female+Parity+Treatment tables. Each record is a treatment, and includes the female and the parity table information. |
Other tables
| Table | Description |
|---|---|
| AllAnimal | It includes all animals plus references to external animals for genealogy tree. |
| Animal | Each row is an animal. It includes breeding males and females and individual. |
| CommentParityEx | Comment table joined with Parity table. |
| EventRecord | All events |
| EventRecordEx | Event + animal |
| FemaleTreatment | Treatment + animal + service result tied to treatment (if exists). It includes Breeding and Individual females. |
| Foster | Foster events |
| HeatNs | Heat not Served events |
| HeatNsEx | HeatNs table + Animal record |
| Male | Each row is a breeding male. |
| Mating | Mating events |
| MatingEx | Mating + female + service + parity |
| MatingResult | Mating + female + service result |
| MovInd | In and out movements of animals |
| ParityConception | Parity table joined with the conception service record |
| ParityLifeEx | It is similar to ParityEx table but it includes birthings that occurred in donor farms. |
| PCondition | Physical Condition events |
| PwDeath | Pre-wean death events |
| PwDeathEx | PwDeath table + female + parity record |
| RemovalEx | Removal events + female |
| Semen | Each row is a semen code |
| ServicesLifeEx | It is similar to ServiceEx table but it includes services that occurred in donor farms. |
| Treatment | Treatment events |
| Wean | Wean events |