Skip to content

leamsigc/hub-example

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

NuxtHub Starter Template

This starter lets you get started with NuxtHub in seconds.

Features

Setup

Make sure to install the dependencies with pnpm.

pnpm install

Development Server

Start the development server on http://localhost:3000:

pnpm dev

Production

Build the application for production:

pnpm build

Check out the deployment documentation for more information.

Deploy

Deploy the application on the Edge with NuxtHub on your Cloudflare account:

npx nuxthub deploy

Then checkout your server logs, analaytics and more in the NuxtHub Admin.

You can also deploy using Cloudflare Pages CI.


##Database overview

erDiagram
    Users {
      int id PK "Primary Key, Auto Increment"
      text email "Unique, Not Null"
      text emailToVerify
      text name "Not Null"
      text avatar
      int githubId "Unique"
      text githubToken
      text twitchId "Unique"
      text twitchToken
      text verifiedAt
      text createdAt "Not Null, Default: current_timestamp"
      text updatedAt "Not Null, Default: current_timestamp, On Update: current_timestamp"
    }

    Tools {
      int id PK "Primary Key, Auto Increment"
      text url
      text description
      int likes
      text tags
      text pricing
      text image_url
    }

    Promotions {
      int id PK "Primary Key, Auto Increment"
      int toolId FK "Foreign Key to Tools"
      text from
      text to
      text tag "Tag for Promotion"
    }

    Tags {
      int id PK "Primary Key, Auto Increment"
      text name
      text label
    }

    Stats {
      int id PK "Primary Key, Auto Increment"
      int toolId FK "Foreign Key to Tools"
      int views
      int clicks
      int likes
    }

    Images {
      int id PK "Primary Key, Auto Increment"
      int toolId FK "Foreign Key to Tools"
      text url "Image URL"
      text tag "Tag for Main Image"
    }

  Roles {
      int id PK "Primary Key, Auto Increment"
      text name "Role name"
      text label "Role label"
    }
    %% Relationships
    Users ||--o{ Tools : "User can create many tools"
    Tools ||--o{ Images : "One tool has many images"
    Tools ||--o| Promotions : "One tool has one promotion"
    Tools ||--|| Stats : "One tool has one stat"
    Tools ||--o{ Tags : "Tools can have multiple tags"
    Images ||--o| Tags : "Images can have one tag"
    Promotions ||--o| Tags : "Promotions can have one tag"
    Users ||--o| Roles : "Users can have one or more roles"

Loading

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages