Dataset: Referrals
Dataset name:
ds_referrals
Description
Referrals
Fields in this dataset
| Name | Field Name | Description | Field Type | Field Example |
|---|---|---|---|---|
| Complete Time |
complete_time
|
Complete Time as UNIX timestamp | int | 1642137822 |
| Contact Name |
contact_name
|
text | Juliet Alexander | |
| Contact Number |
contact_number
|
text | 07123456789 | |
| Contact Title |
contact_title
|
text | Mrs | |
| Created Timestamp |
created_timestamp
|
Created Timestamp. | int | 1638375529 |
| Duration |
duration
|
Duration of the referral as a UNIX timestamp | int | 1642137822 |
| End Time |
end_time
|
End Time of the referral as a UNIX timestamp | int | 1642137822 |
| External ID |
external_id
|
External ID. | int | 1 |
| Referrals ID |
id
|
The primary identifier for this record. | serial | 3 |
| Referrals Instance |
instance
|
The instance this item relates to. | int | |
| Is processed |
is_processed
|
Is processed | int | 1 |
| Memo |
memo
|
Memo | int | Text note here |
| Referree Availability |
referree_availability
|
The referree availability. | blob | "{ "AM": [ "Monday", "Tuesday", "Friday" ], "PM": [ "Monday", "Tuesday", "Wednesday", "Thursday" ] }" |
| Referree Background |
referree_background
|
The referree background. | text | The first day that we attended is the first day that we have started to introduce ourselves to friends and families. We wanted those who already know me |
| Referree Requirements |
referree_requirements
|
The referree requirements. | text | Fruit, vegetables, legumes (e.g. lentils and beans), nuts and whole grains (e.g. unprocessed maize, millet, oats, wheat and brown rice). |
| Referrer Name |
referrer_name
|
text | Romeo Santos | |
| Service Description |
service_description
|
text | Lorem ipsum dolor sit amet, consectetur adipiscing elit. | |
| Service Email |
service_email
|
text | service@email.com | |
| Service ID |
service_id
|
Service ID | int | 56 |
| Service Name |
service_name
|
text | Service | |
| Service Url |
service_url
|
text | www.service.com | |
| Referrals Source |
source
|
The source of the data - user or connection. | varchar | |
| Start Time |
start_time
|
Start Time of the referral as a UNIX timestamp | int | 1642137111 |
| Status |
status
|
The status of the referral. | text | waiting |
| Type |
type
|
The type of the referral. | text | self referral |
| Updated Timestamp |
updated_timestamp
|
Updated Timestamp. | int | 1639153129 |