Add `CampType` (string), `DreamID` (string), `DreamStatus` (string) to group table

[NitayRabi]

CampType - Column is specific for groupType - camp.
DreamId - Column is specific for groupType - art
DreamStatus - column is specific for groupType - art
Should be enum for certain group types - consult with Michal regarding types meaning.

[Michal-Leizerowitz]

This year there are 3 types of camps:
Content, Hospitality, Spontaneous.
Known issues relevant to Spark are here:
https://www.notion.so/midburn/46612c972293467db07f24c456fe4b2e?v=b1e4bff3b23848c0bc168472a740b89f&p=18621ec10f644330bd6927aa17729790

[yonatanbashan]

I don't have access. Michal, can you please give me access?

[yonatanbashan]

OK, so from what I can see, differences are:

Fields existing in the Google Docs but not in the model:

• Additional E-mail
• "בחרו את האפשרויות שמציגות אתכם בצורה הטובה ביותר וממצים את הפעילויות שאתם רוצים לעשות" - Is this called "Character"? Not clear.
• Is Family Camp
• Is Camp 18+
• Is Camp new or Old
• "האם תרצו שהמחולל יהיה עמכם בקשר כדי לבחון אפשרות של שת"פ לעשייה קהילתית של המחנה שלכם?" - What is this?

Other differences:

• Number of people: In the model it is a number. In the Google Docs it's a range (20-30, 30-40, etc.)
• Content is defined under different name to each camp type... Honestly in the DB we can all save it under "content" and that's it.
• Of course we have to add campType as mentioned by Nitay.

[Michal-Leizerowitz]

Hi Yonatan,
I can't answer all because I'm pending for some answers from Adir,
but some info is here:
https://www.notion.so/midburn/46612c972293467db07f24c456fe4b2e?v=b1e4bff3b23848c0bc168472a740b89f&p=9ae3c1f4dc4b415cb1e0f20180c8fa9a
And specifically for what you wrote:

1. Additional E-mail
   --- Don't import

2. "בחרו את האפשרויות שמציגות אתכם בצורה הטובה ביותר וממצים את הפעילויות שאתם רוצים לעשות" - Is this called "Character"?
   Previous spark had something similar, see screenshot below. we need to adjust to the form.

3. Is Family Camp - add to DB

4. Is Camp 18+ - Add to DB

5. Is Camp new or Old - Dismiss, we don't need it in spark.

6. "האם תרצו שהמחולל יהיה עמכם בקשר כדי לבחון אפשרות של שת"פ לעשייה קהילתית של המחנה שלכם?" - What is this?
   Dismiss, we don't need it in spark.

Other differences:
Number of people: In the model it is a number. In the Google Docs it's a range (20-30, 30-40, etc.)
Dismiss, we don't need it in spark.

Content is defined under different name to each camp type... Honestly in the DB we can all save it under "content" and that's it.
---Sure, sounds good, note that for Spontaneous camp it can be empty.

[Michal-Leizerowitz]

Updated - we only import the leader's burn profile email (מייל פרופיל המידברן של מוביל המחנה), not the additional emails

[NitayRabi]

@yonatanbashan - Please see my PR which is relevant for this, i can merge it and you can extend it later.
@Michal-Leizerowitz - so we won't display the other roles (content,safty,moop) details ? we can remove them?