Specs definition for the List-Project api

[MTG2000]

We want to allow makers to add their own projects from the platform directly, and the front-end components have already been developed, and are currently in QA. Here is a preview build for that: https://deploy-preview-128--makers-bolt-fun-preview.netlify.app/projects/list-project

And now we need to build the back-end for that. So I've written a brief specs regarding how the api interface is supposed to look.

A project model has the following fields:

id: number
name: string
website: string
tagline: string
description: string
thumbnail_image: string
cover_image: string
twitter: string
discord: string
github: string
launch_status: "wip" | "launched"
screenshots: string[]

// Relations:

category: Category

members: User & { role: Team_Member_Role }

capabilities: Capability[]

recruit_roles: Role[]

tournaments: Tournament[]

---

The interface graphql api for creating/updating a project could be something like:

id?: number // Exist only if update
name: string
website: string
tagline: string
description: string
thumbnail_image?: string
cover_image?: string
twitter?: string
discord?: string
github?: string
launch_status: "wip" | "launched"
screenshots: string[]

category_id: number
capabilities: number[] // ids
members: {
    id: number,
    role: Team_Member_Role,
}[]
recruit_roles: number[] // ids
tournaments: number[] // ids

---

The currently existing relation tables are: Category Member (User) Role

So the new needed tables are:

• Capability Will contain basic fields similar to Tag like:

  model Tag {
  id          Int     @id @default(autoincrement())
  title       String  @unique
  icon        String?
  description String?
  }

• Tournament But this one doesn't have a clear spec yet, so just a very basic version should be enough until the full specs are defined:

  model Tournament {
  id          Int      @id @default(autoincrement())
  title       String
  start_date  DateTime @db.Date
  end_date    DateTime @db.Date
  cover_image String
  description String
  location    String
  website     String
  }