Participant related table¶
Family table¶
Family table stores family related information, including contact information, parents’ demographic information, and some recruitment/participation notes.
Table colums¶
- NamePrimary: mother’s (or Primary Caregiver’s) name
- Type: varchar(30)
- NameSecondary: father’s (or secondary caregiver’s) name
- Type: varchar(30)
- Email: email address
- Type: varchar(40)
- Phone: phone number
- Type: varchar(10)
- RacePrimary: mother’s (or Primary Caregiver’s) race
- Type: varchar(20)
- RaceSecondary: father’s (or secondary caregiver’s) race
- Type: varchar(20)
- LanguagePrimary: mother’s (or Primary Caregiver’s) mostly used language
- Type: varchar(20)
- LanguageSecondary: father’s (or secondary caregiver’s) mostly used language
- Type: varchar(20)
- EnglishPercent: percentage of english spoken at home
- Type: int
- Note: notes about the family
- Type: text
- Vehicle: vehicle descriptions
- Type: text
- Address: home address or postal code
- Type: text
- LastContactDate: the date the family is contacted by us
- Type: date
- NextContactDate: the earliest date this family will show up in the search for eligible participants on the Schedule Page
- Type: date
- NextContactNote: the nature for the next contact, such as to follow up a undecided study schedule
- Type: text
- RecruitmentMethod: how this family was recruited
- Type: varchar(30)
- AssignedLab: id of lab, which has an on-going study with this family
- Type: int
- CreatedBy: id of the lab member who created this family record
- Type: int
- UpdatedBy: id of the lab member who updated this family’s inforamtion
- Type: int
- NoMoreContact: should this family be contacted in the future
- Type: int
Child table¶
Child table stores child related information.
Table colums¶
- Name: name of the child
- Type: varchar(30)
- Sex: biological sex of the child
- Type: enum(‘F’,’M’)
- DoB: date of birth
- Type: date
- Age: age in days
- Type: int
- Language: mostly spoken language
- Type: varchar(45)
- IdWithinFamily: code for the child within a family, such as a, b, c,& d
- Type: varchar(1)
- HearingLoss: whether this child has hearing loss
- Type: int
- VisionLoss: whether this child has vision loss
- Type: int
- PrematureBirth: whether this child was born prematurely
- Type: int
- Illness: whether this child has any illness
- Type: int
- BirthWeight: birth weight
- Type: int
- Note: notes for this child
- Type: text
- FK_Family: id of the family this child belongs to
- Type: int
Sibling table¶
Sibling table stores the kinships among children.
Table colums¶
- FK_Child: id of a child
- Type: int
- Sibling: id of the sibling of this child
- Type: int
Conversations table¶
Conversations table stores important conversations with a family. These conversation will help future communication with this family.
Table colums¶
- Conversation: content of a conversation
- Type: text
- Time: the date when this conversation is stored
- Type: datetime
- FK_Family: id of the family this conversation relates to
- Type: int