Skip to content
Gallery
Second Brain
Second Brain
Share
Explore
Pageants

icon picker
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
Name
email
role
Binders
1
Talisha White
myemail@gmail.com
contestant
RIM
There are no rows in this table
⁠
Binder
Name
owner
Pageants
1
RIM
Talisha White
RIM Georgia
There are no rows in this table
⁠
Pageant
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
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.