JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
Second Brain
Second Brain
More
Share
Explore
Pageants
Pageant Binder
DB Schema
User Narratives (User Stories)
General
User can view all binders.
User can create a new binder.
User can delete a binder.
User can share access to a binder with others.
Binder Dashboard
User can view upcoming events and deadlines on the Binder Dashboard.
User can view days until the competition on the Binder Dashboard.
User can view urgent/upcoming tasks and appointments on the Binder Dashboard.
User can view budget overview on the Binder Dashboard.
Appearance Planner
User can add appearance information.
User can add trip details for appearances.
User can plan wardrobe for appearances.
User can add notes and photos from appearances.
Pageant Paperwork
User can upload and organize headshots in an album.
User can share headshot album for feedback.
User can view a paperwork checklist and reminders.
User can get an automatic review of paperwork.
User can upload paperwork for help and suggestions.
Training Resources
User can access a digital version of the pageant workbook.
User can view external resources like books, videos, and blogs.
User can maintain a food and fitness journal.
User can access meal plans.
User can access workout plans.
User can upload interview or walking videos for feedback.
Platform
User can plan platform projects.
User can view articles and statistics related to their platform.
User can view lists of potential partners.
User can access speaker topic ideas and generators.
Money Tracker
User can track budget and expenses.
User can manage receipts and reimbursements.
User can plan and track fundraising activities.
User can manage sponsorships.
Social Media
User can log in through titleholder accounts.
User can connect social media accounts for easier management.
User can get content ideas and suggestions.
Contacts
User can manage a list of pageant team members.
User can manage a list of pageant sisters.
User can manage a list of sponsors.
User can manage a list of appearance contacts.
User can connect email to receive all pageant-related emails in a specialized inbox.
Personal Inspiration
User can view quotes, advice, and scriptures.
User can receive and view words or notes of encouragement.
User can create a vision board.
Pageant Planner
User can add trip details for the pageant.
User can view and manage the pageant schedule.
User can plan areas of competition.
User can plan wardrobe associated with scheduled pageant events.
User can access quick links related to the pageant.
Reference Documents
User can access and view questions and FAQs.
User can access and view scores, contracts, and prizes.
User can access and view the handbook.
User can access and view articles.
User can access and view program books and other miscellaneous documents.
Pageant Packing List/Checklist
User can view a standard packing list.
User can generate a packing list based on age division, pageant type, and areas of competition.
Database Schema
Users
UserID (Primary Key)
Email
Password
Name
Role (Contestant)
Binders
BinderID (Primary Key)
UserID (Foreign Key)
Name
CompetitionDate
AppearancePlanner
AppearanceID (Primary Key)
BinderID (Foreign Key)
TripDetails
WardrobePlan
Notes
Photos
PageantPaperwork
PaperworkID (Primary Key)
BinderID (Foreign Key)
Headshots
CheckList
Uploads
TrainingResources
TrainingID (Primary Key)
BinderID (Foreign Key)
Workbook
MealPlan
WorkoutPlan
Videos
Platform
PlatformID (Primary Key)
BinderID (Foreign Key)
ProjectPlan
Articles
Partners
MoneyTracker
MoneyID (Primary Key)
BinderID (Foreign Key)
Budget
Expenses
Receipts
Fundraising
SocialMedia
SocialID (Primary Key)
BinderID (Foreign Key)
TitleholderLogins
ContentIdeas
Contacts
ContactID (Primary Key)
BinderID (Foreign Key)
TeamMembers
Sponsors
AppearanceContacts
Inspiration
InspirationID (Primary Key)
BinderID (Foreign Key)
Quotes
Encouragements
PageantPlanner
PlannerID (Primary Key)
BinderID (Foreign Key)
TripDetails
Schedule
AreasOfCompetition
WardrobePlan
ReferenceDocs
DocID (Primary Key)
BinderID (Foreign Key)
Questions
Scores
Contracts
PackingList
PackingID (Primary Key)
BinderID (Foreign Key)
StandardList
GeneratedList
User
User
Name
email
role
Binders
Name
email
role
Binders
1
Talisha White
myemail@gmail.com
contestant
RIM
There are no rows in this table
Binder
Binder
Name
owner
Pageants
Name
owner
Pageants
1
RIM
Talisha White
RIM Georgia
There are no rows in this table
Pageant
Pageant
Name
date
venue
location
website
Binder
Name
date
venue
location
website
Binder
1
RIM Georgia
12/10/2023
Waldoth Auditorium
Georgia
RIM
There are no rows in this table
input
AMPLIFY
{
globalAuthRule
:
AuthRule
=
{
allow
:
public
}
}
type
WorksheetAnswer
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
question
:
String
answer
:
String
worksheetsID
:
ID
!
@index
(
name
:
"byWorksheets"
)
}
type
PackingItems
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
itemName
:
String
itemType
:
String
isPacked
:
Boolean
packinglistID
:
ID
!
@index
(
name
:
"byPackingList"
)
}
type
PackingList
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
PackingItems
:
[
PackingItems
]
@hasMany
(
indexName
:
"byPackingList"
,
fields
:
[
"id"
]
)
}
type
Documents
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
name
:
String
description
:
String
document
:
AWSURL
tags
:
[
String
]
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
Comments
:
[
Comments
]
@hasMany
(
indexName
:
"byDocuments"
,
fields
:
[
"id"
]
)
}
type
Competition
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
name
:
String
description
:
String
isRequired
:
Boolean
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
}
type
Schedule
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
event
:
String
date
:
String
location
:
String
notes
:
String
sash
:
Boolean
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
}
type
EncouragingNotes
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
author
:
String
note
:
String
authorImage
:
AWSURL
images
:
[
AWSURL
]
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
}
type
Qoute
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
qoute
:
String
author
:
String
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
}
type
VisionBoard
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
title
:
String
description
:
String
images
:
[
String
]
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
}
type
ContentIdeas
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
site
:
String
idea
:
String
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
}
type
TitleholderLogins
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
site
:
String
username
:
String
password
:
String
url
:
AWSURL
notes
:
String
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
}
type
SocialMedia
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
type
:
String
link
:
AWSURL
notes
:
String
}
type
Sponsor
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
name
:
String
description
:
String
website
:
AWSURL
logo
:
AWSURL
sponsorshipLevel
:
String
sponsoredAmount
:
String
sponsorItem
:
String
agreement
:
AWSURL
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
Contacts
:
[
Contact
]
@hasMany
(
indexName
:
"bySponsor"
,
fields
:
[
"id"
]
)
}
type
PotentialSponsor
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
type
:
String
website
:
AWSURL
mission
:
String
status
:
String
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
Contacts
:
[
Contact
]
@hasMany
(
indexName
:
"byPotentialSponsor"
,
fields
:
[
"id"
]
)
}
type
Fundraising
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
title
:
String
description
:
String
goalAmount
:
String
currentAmount
:
String
startDate
:
String
endDate
:
String
DonationLink
:
AWSURL
status
:
String
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
}
type
ReceiptReimbursement
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
merchant
:
String
date
:
String
amount
:
String
returnPolicy
:
String
reimbursedAmount
:
String
reciept
:
String
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
}
type
Budget
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
item
:
String
description
:
String
amountAllotted
:
String
actualSpent
:
String
amountSponsored
:
String
dueDate
:
AWSDate
binderID
:
ID
!
@index
(
name
:
"byBinder"
)
ReceiptReimbursement
:
ReceiptReimbursement
@hasOne
}
type
Partner
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
name
:
String
description
:
String
website
:
AWSURL
logo
:
String
platformID
:
ID
!
@index
(
name
:
"byPlatform"
)
}
type
Article
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
title
:
String
url
:
AWSURL
tag
:
[
String
]
platformID
:
ID
!
@index
(
name
:
"byPlatform"
)
}
type
Project
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
name
:
String
description
:
String
startDate
:
AWSDate
endDate
:
AWSDate
status
:
String
platformID
:
ID
!
@index
(
name
:
"byPlatform"
)
}
type
Platform
@model
@auth
(
rules
:
[
{
allow
:
public
}
]
)
{
id
:
ID
!
name
:
String
description
:
String
website
:
AWSURL
logo
:
AWSURL
Articles
:
[
Article
]
@hasMany
(
indexName
:
"byPlatform"
,
fields
:
[
"id"
]
)
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.