Please enable JavaScript.
Coggle requires JavaScript to display documents.
camplifebridge, CampArticle, userextra table, ContentPost Table, Location…
camplifebridge
CampArticle
camparticle.access
household
"Registered Campers"
web
"Everyone"
private
not used In WP
followers
not used In WP
camplife
not used In WP
camparticle.id
camparticle.title
camparticle.status
camparticle.summary
camparticle.postUrl
camparticle.feedImageUrl
camparticle.counselorCampName
camparticle.wp_postId
camparticle.wp_postRevision
camparticle.typeId
userextra table
UserExtra.id
userextra.iCampPro_id
userextra.gender
userextra.birthdate
userextra.cellphone
userextra.grade
userextra.staffCampName
userextra.userId
ContentPost Table
contentpost.sourceObject
camparticle
CampMailFromCamper
campMailToParent
campphoto
campphotogallery
campvideo
ContentPost.type
article
photo
photogallery
other
video
contentpost.status
Posted
Published
Hidden
Deleted
ContentPost.id
ContentPost.campLife_postid
ContentPost.sourceId
contentpost.sourceContentTypeId
Location Table
location.id
location.address
location.city
location.state
location.timeZone
location.postalCode
location.name
registration table
registration.id
registration.icamppro_attendeeId
registration.icampproenrollment_id
registration.status
registration.sessionid
registration.userid
registration.householdid
campmailfromcamper table
campmailfromcamper.id
campmailfromcamper.status
campmailfromcamper.batchId
campmailfromcamper.imageId
campmailfromcamper.senderId (child)
campmailfromcamper.sessionId
campmailfromcamper.scanFileName
Video Table
video.status
created
stagedforcreation
published
video.id
video.title
video.folderpath
video.typeId
video.filename
TaggedImage Table
TaggedImage.imageId
TaggedImage.sessionId
TaggedImage.id (Camper Photos before 2023)
TaggedImage.typeId
taggedimage.status
CabinSessionGroup
CabinSessionGroup.id
CabinSessionGroup.sessionId
cabinsessiongroup.cabinid
CabinSessionGroup.counselorId
CabinSessionGroup.cabinNickname
userLimited table
userLimited.id
userLimited.iCampPro_id
userLimited.firstName
userLimited.lastName
userLimited.email
photo gallery table
photogallery.status
stagedforcreation
published
created
photogallery.id
photogallery.title
photogallery.folderpath
photogallery.typeId
campmailtocamper table
campmailtocamper.id
campmailtocamper.recipientId (child)
campmailtocamper.deliverAt
campmailtocamper.text
campmailtocamper.senderName
CampSession Table
campsession.name
{year} {camp} Week {#}
CampSession.id
campsession.campid
campsession.locationId
Camp
camp.type
Youth Camp
Unknown
Day Camp
Family Camp
camp.id
camp.locationId (city goes to {region} Main Office)
camp.name
Staff Table
staff.id
Staff.userId
staff.campName
staff.bioid
Household table
household.id
household.name (HoH)
household.contactid (owner)
household.contactId (HoH)
HouseholdMember
householdmember.type
adult
child
owner
householdmember.id
householdmember.userid
householdmember.householdId
EntityTag Table
EntityTag.targetid
Household.id
userLimited.id
cabin.id
camp.id
entitytag.targetType
Household
User
Cabin
Camp
EntityTag.id
CabinCamper Table
CabinCamper.camperId
userLimited.id
CabinCamper.id
CabinCamper.cabinGroupId
Image Table
Image.source
Path for cloudinary folder and photo name
Image.id
Image.id (Camper Photos 2023 and later)
campsessionVideo Table
campsessionvideo.id
campsessionvideo.campsessionId
campsessionvideo.videoId
campsessionPhotogallery table
campsessionphotogallery.id
campsessionphotogallery.campSessionid
campsessionphotogallery.photogalleryId
contententitytag table
contententitytag.id
contententitytag.tagId
contententitytag.imageId
MediaType Table
mediatype.code
Birthday Rap
Cabin
Camp Map
Camper Clip
Camper CQ Feed
Camper CQ Image
Camper Headshot
Camper Photo
Camper Profile
Daily Highlight Video
Daily Photo Gallery
Family
Leadership Closing Video
Leadership Welcome Video
Pit 'n Palace
Scheduled Simple Photo-Contact
Scheduled Simple Photo-Household
Spirit Stick
Story Video 1
Story Video 2
Two-Week Bonus Gallery
Two-Week Bonus Video
Weekly Highlight Video
Year Separator
mediatype.id
Cabin Table
cabin.id
Cabin.name
Media Config
mediaconfig.contentTypeId
mediaConfig.id
camparticletype table
camparticletype.id
camparticletype.contentTypeId
CampMediaConfig Table
campmediaconfig.campId
campmediaconfig.mediaconfigId
campsessionarticle table
campsessionarticle.camparticleId
campsessionarticle.sessionId
campsessionlocation table
campsessionlocation.id
campsessionlocation.locationid
contenttype table
contenttype.category
tagged-photo
Birthday Rap
Camper Headshot
Camper Photo
Camper Profile
Pit 'n Palace
Spirit Stick
article
Blog Post
City Bible Study
City Bible Study Friday
City Bible Study Monday
City Bible Study Thursday
City Bible Study Tuesday
City Bible Study Wednesday
City Info Post 1
Counselor Bio
Daily Post
Director Welcome
End of Week Info
Friday Afternoon
Friday Evening
Friday Morning
Global Thank You Post
Global Welcome Post
Meet The Staff
Monday Afternoon
Monday Evening
Monday Morning
Saturday Morning
Sunday Afternoon
Sunday Evening
Thursday Afternoon
Thursday Evening
Thursday Morning
Tuesday Afternoon
Tuesday Evening
Tuesday Morning
Wednesday Afternoon
Wednesday Evening
Wednesday Morning
group-photo
Cabin Photo
Family Photo
other
Camp Map
Scheduled Simple Photo Contact
Scheduled Simple Photo Household
Year Separator
video
Camper Clip
Daily Highlight Video
Story Video 1
Story Video 2
Two-Week Bonus Video
Weekly Highlight Video
mail
Mail To Camper
Camper Mail
cq
character qualities
gallery
Daily Photo Gallery
Gallery Photo
Gallery Video
Two-Week Bonus Gallery
tagged-video
Tagged Video
contenttype.id
UserAuthority
UserAuthority.authorityName
ROLE_USER
default for everyone. editor and reviewer are added records and does not replace this one
ROLE_EDITOR
ability to shadow other accounts and hide/unhide content
ROLE_ADMIN
unknown feature
ROLE_REVIEWER
ability to shadow other accounts
UserAuthority.userId (manual record; not iCP user)
Follower Table
follower.id
FollowInvitation Table
followinvitation.id
Notification Table
notification.id