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
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.