Skip to content
Gallery
Second Brain
Second Brain
Share
Explore
Pageant Binder

DB Schema

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"])
Projects: [Project] @hasMany(indexName: "byPlatform", fields: ["id"])
Partners: [Partner] @hasMany(indexName: "byPlatform", fields: ["id"])
}

type Library @model @auth(rules: [{allow: public}]) {
id: ID!
name: String
description: String
link: AWSURL
isFavorite: Boolean
}

type ProgressTracker @model @auth(rules: [{allow: public}]) {
id: ID!
date: AWSDate
weightMeasurement: Float
weightLossGain: Float
chestMeasurement: Float
chestLossGain: Float
leftArmMeasurement: Float
leftArmLossGain: Float
rightArmMeasurement: Float
rightArmLossGain: Float
waistMeasurement: Float
waistLossGain: Float
hipsMeasurement: Float
hipsLossGain: Float
leftThighMeasurement: Float
leftThighLossGain: Float
rightThighMeasurement: Float
rightThighLossGain: Float
binderID: ID! @index(name: "byBinder")
}

type FitnessJournal @model @auth(rules: [{allow: public}]) {
id: ID!
date: AWSDate
workoutType: String
exerciseName: String
sets: String
reps: String
weight: String
duration: String
distance: String
pace: String
notes: String
binderID: ID! @index(name: "byBinder")
}

type FoodJournal @model @auth(rules: [{allow: public}]) {
id: ID!
date: AWSDate
breakfast: String
snack1: String
lunch: String
snack2: String
dinner: String
snack3: String
Notes: 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.