Dashboard Application built with Django displaying the status of deployable assets and their related elements.

Overview

Status Dashboard

Dashboard application displaying the state of deployable server sets and their core elements.

Database schema

erDiagram
    DSS ||--|{ Build: contains
    DSS ||--o{ Message: contains
    User ||--|{ Message: contains
    Message ||--|{ Reply: contains
    User ||--|{ Reply: contains
    DSS ||--|{ Fault: contains
    User ||--|{ Fault: contain
    User ||--|{ AdhockTask: contains
    DSS ||--o{ ScheduledTask: "may contain"
    DSS ||--o{ AdhockTask: "may contain"
    ScheduledTask ||--|{ TodaysTasks: contains
    User ||--|{ TodaysTasks: contains
    DSS{
        Text db_num PK "The database Number"
        Text title
        Text serviceable
        Text comments
    }
    User{
        Text id PK "Unique User ID"
        Text first_name
        Text last_name     
    }
    Build {
        Text id PK "Unique Build Ref ID"
        Text DSS_database FK "DSS Table Database Number"
        Numeric date_started
        Text current_stage
        Numeric date_completed
        Text comments
    }
    Message {
        Text id PK "Unique Message ID"
        Text created_by FK "User Table ID"
        Text DSS_database FK "DSS Table Database Number"
        Text content
        Numeric date_created
    }
    Reply {
        Numeric id PK "Unique Reply ID"
        Text initial_message_id FK "Unique Message ID"
        Text created_by FK "User Table ID"
        Text content
        Numeric date_created       
    }
    Fault {
        Text fault_ref PK "Unique Fault ID"
        Text raised_by FK "User Table ID"
        Text DSS_database FK "DSS Table Database Number"
        Numeric date_created
        Text status
        Text description
    }
    ScheduledTask {
        Numeric id PK "Unique Fault ID"
        Text raised_by FK "User Table ID"
        Text description
        Numeric date_due
        Text status
        Text notes
        Numeric date_created
    }
    AdhockTask {
        Text id PK "Unique Fault ID"
        Text raised_by FK "User Table ID"
        Text completed_by FK "User Table ID"
        Text description
        Numeric date_due
        Text status
        Text notes
        Numeric date_time_completed
        Numeric date_created
    }
    TodaysTasks {
        Numeric id PK "Todays Task ID"
        Numeric sheduled_task FK "Schedulaed Task ID"
        Text completed_by FK "User Table ID"
        Numeric date_time_completed
    }

Database Schema Tasking

erDiagram
    User ||--|{ AdhockTask: contains
    DSS ||--o{ ScheduledTask: "may contain"
    DSS ||--o{ AdhockTask: "may contain"
    ScheduledTask ||--|{ TodaysTasks: contains
    User ||--|{ TodaysTasks: contains
    DSS{
        Text db_num PK "The database Number"
        Text title
        Text serviceable
        Text comments
    }
    User{
        Text id PK "Unique User ID"
        Text first_name
        Text last_name     
    }
    ScheduledTask {
        Numeric id PK "Unique Fault ID"
        Text raised_by FK "User Table ID"
        Text description
        Numeric date_due
        Text status
        Text notes
        Numeric date_created
    }
    AdhockTask {
        Text id PK "Unique Fault ID"
        Text raised_by FK "User Table ID"
        Text completed_by FK "User Table ID"
        Text description
        Numeric date_due
        Text status
        Text notes
        Numeric date_time_completed
        Numeric date_created
    }
    TodaysTasks {
        Numeric id PK "Todays Task ID"
        Numeric sheduled_task FK "Schedulaed Task ID"
        Text completed_by FK "User Table ID"
        Numeric date_time_completed
    }

Database Schema Messaging

erDiagram

    DSS ||--o{ Message: contains
    User ||--|{ Message: contains
    Message ||--|{ Reply: contains
    User ||--|{ Reply: contains
    DSS{
        Text db_num PK "The database Number"
        Text title
        Text serviceable
        Text comments
    }
    User{
        Text id PK "Unique User ID"
        Text first_name
        Text last_name     
    }
    Message {
        Text id PK "Unique Message ID"
        Text created_by FK "User Table ID"
        Text DSS_database FK "DSS Table Database Number"
        Text content
        Numeric date_created
    }
    Reply {
        Numeric id PK "Unique Reply ID"
        Text initial_message_id FK "Unique Message ID"
        Text created_by FK "User Table ID"
        Text content
        Numeric date_created       
    }
You might also like...

A package to count reads mapping on transposable elements subfamilies, families and classes.

TEcount A package to count reads mapping on transposable elements (TEs) subfamilies, families and classes. Features TEcount counts high-throughput seq

Sep 11, 2022

A cellular automaton that models the earth and the interactions between weather elements.

A cellular automaton that models the earth and the interactions between weather elements.

cellular-automaton-model-for-weather A cellular automaton that models the earth and the interactions between weather elements. Alongside a visual repr

Sep 21, 2022

Google Maps Crawler takes Google Maps List and it scrape elements from all items such as: title, rating, reviews, location url, website,etc.

Google Maps Crawler Google Maps Crawler takes Google Maps List and it scrape elements from all items such as: title, rating, reviews, location url, we

Sep 15, 2022

Extension for python-capella-mbse that adds automatically generated context diagrams for arbitrary model elements.

Context Diagram extension for capellambse This extension of py-capellambse enables generation of views (diagrams) that describe an element context (fr

Jul 20, 2022

A tool to quantify transposable elements expression in scRNA-seq

IRescue IRescue is a software for quantifying the expression of transposable elements (TEs) subfamilies in single cell RNA sequencing (scRNA-seq) data

Sep 27, 2022

Automatic Email Marketing / Newsletter Application. Built using Django and PostgreSQL.

Mailchamp Automatic Email Marketing / Newsletter Application. Built using Django and PostgreSQL. Description MailChamp is an Email Marketing / Newslet

May 6, 2022

A barebones django application to be built by backend and fullstack candidates.

BackendCodingChallenge This repository contains the beginnings of a django application. The purpose of the application is to (1) handle database inter

Aug 10, 2022

Live HTTP/GLTF2 link between Blender and any tool that can stream assets like Babylon.js Playground

Live HTTP/GLTF2 link between Blender and any tool that can stream assets like Babylon.js Playground

Blender Live Update Live HTTP/GLTF2 link between Blender and any tool that can stream assets like Babylon.js Playground. Installation Run BlenderLiveU

Sep 2, 2022

A blender addon for automatically downloading and importing free assets from the internet.

A blender addon for automatically downloading and importing free assets from the internet.

Download free assets in a few clicks Asset bridge is a blender addon to make downloading free assets from online sites easy. With it you can simply se

Sep 18, 2022
To check mysql read/write status and server status.

mysql-rw-status To check mysql read/write status and server status. Installation: (Linux machines only) 1. Install Pipenv. !pip install pipenv

Shipu 1 Sep 12, 2022
Built a GUI Based Face Recognition Module. Functionality that allows people to register their faces along with their name and enrollment number to make a paperless and smooth attendance system.

Face_recognition_based_attendance_system A python GUI integrated attendance system using face recognition to take attendance. In this python project,

null 1 Aug 17, 2022
Using Python and Scrapy, this repository aims to scrape the data of books for use such as a book recommendation system with pre-built assets.

Scrapy-GoodReads Description ?? This repository marks my first attempt at web scraping using Scrapy and what better way to do it than doing it on Good

Immanuel Vivek 1 Sep 22, 2022
Spatial region-related embedding and Cell type-related embedding of spatial transcriptomics.

SECE Spatial region-related embedding and Cell type-related embedding of spatial transcriptomics. Spatially resolved transcriptomics sequencing (ST-se

null 1 Sep 20, 2022
Calculating probability and displaying it's distribution

ProbabilityVisualization Calculating probability and displaying it's distribution Display probability for a given X on mouse hover: Display expected v

Marcel Homšak 1 Sep 18, 2022
Ahmed Zaid 3 Apr 26, 2022
Python scripts for searching and displaying Homebrew package metadata, made for Alfred.

homebrew-alfred Python scripts for searching and displaying Homebrew package metadata, made for Alfred. homebrew-alfred Features The Alfred workflow D

Teddy / Xinyuan Chen 4 May 3, 2022
A Discord bot for displaying whatsnew.txt for the OHRRPGCE

OHRWhatsNewDiscordBot A Discord bot for displaying whatsnew.txt for the OHRRPGCE Requires: Python3 Discord.py (pip install discord.py) (yes, literally

Rue Lazzaro 2 Apr 25, 2022
Used for displaying the number of beds left for GaTech housing.

GaTech-Room-Parser Used for displaying the number of beds left for GaTech housing. The data is collected from https://housing.gatech.edu/available-roo

IanBoraks 2 Jul 28, 2022
This Python script parses Spotify playlist emails from their description related to user inputed keywords.

CLARK KEY'S SPOTIFY PLAYLIST EMAIL PARSER FOLLOW CLARK KEY @CLARKKEYMUSIC SOUNDCLOUD: https://soundcloud.com/clarkkeymusic INSTAGRAM: https://www.inst

Clark Key 8 Aug 4, 2022