Data

Tools

Indexes

Applications

Experiments

Open Source Science

clinic-database

https://github.com/slugb0t/clinic-database

Science Score: 44.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ✓
    CITATION.cff file
    Found CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Academic email domains
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (4.2%) to scientific vocabulary
Last synced: 6 months ago · JSON representation ·

Repository

Basic Info
  • Host: GitHub
  • Owner: slugb0t
  • License: mit
  • Default Branch: main
  • Size: 909 KB
Statistics
  • Stars: 0
  • Watchers: 1
  • Forks: 0
  • Open Issues: 3
  • Releases: 7
Created over 5 years ago · Last pushed 10 months ago
Metadata Files
Readme License Citation Codemeta

README.md

Clinic-Database with MySQL

We have designed a backend relation database intended to be used with a proprietary application similar to Epic Systems with the goal of managing patients appointments, prescriptions and referrals, as well as interfacing with physician, nurse, and medication tables.

The relational datavase will handle all the inter-table constraints and foreign keys, as well as checking appointment times to ensure no scheduling overlaps exist, leaving the proprietary application with just managing access levels based on credentials and generating queries.

Database Diagram

Our function specification for the utilities provided is as follows: 1. Allows nurses to make, update, and cancel appointments for patients. 2. Allows physicians to make prescriptions and external referrals to other clinics or hospitals should the need for a specialist unavailable in the in the clinic arise. 3. Allow for the hiring and termination of nurses and physicians. 4. Allow for the creation of new departments and specialties to keep up with an expanding clinic.

Owner

  • Name: Dorian Portillo
  • Login: slugb0t
  • Kind: user
  • Location: San Diego, CA
  • Company: FAIR Data Innovations Hub

Always open to learn new tools :)

Citation (CITATION.cff) 

title: Clinic-Database
authors:
  - given-names: Dorian
    family-names: Portillo
    email: wheresdorian@gmail.com
    affiliation: FAIR Data Innovations Hub
cff-version: 1.2.0
message: If you use this software, please cite it using the metadata from this file.
type: software
abstract: test
keywords:
  - dfasdf
license: MIT
repository-code: https://github.com/slugb0t/Clinic-Database
doi: 10.5281/zenodo.214659
date-released: '2025-05-07'
version: 44.234.62.2

CodeMeta (codemeta.json) 

{
  "name": "Clinic-Database",
  "@context": "https://w3id.org/codemeta/3.0",
  "author": [
    {
      "affiliation": {
        "name": "FAIR Data Innovations Hub",
        "type": "Organization"
      },
      "email": "wheresdorian@gmail.com",
      "familyName": "Portillo",
      "id": "_:author_1",
      "givenName": "Dorian",
      "type": "Person"
    }
  ],
  "codeRepository": "https://github.com/slugb0t/Clinic-Database",
  "dateCreated": "2020-10-01",
  "description": "test",
  "issueTracker": "https://github.com/slugb0t/Clinic-Database/issues",
  "keywords": [
    "dfasdf"
  ],
  "license": "https://spdx.org/licenses/MIT",
  "programmingLanguage": [
    "Ada"
  ],
  "type": "SoftwareSourceCode",
  "identifier": "10.5281/zenodo.335746",
  "version": "23234",
  "dateModified": "2025-09-24"
}

GitHub Events

Total
  • Create event: 9
  • Release event: 7
  • Issues event: 1
  • Delete event: 2
  • Issue comment event: 3
  • Push event: 17
  • Pull request event: 4
Last Year
  • Create event: 9
  • Release event: 7
  • Issues event: 1
  • Delete event: 2
  • Issue comment event: 3
  • Push event: 17
  • Pull request event: 4

Issues and Pull Requests

Last synced: 9 months ago

All Time
  • Total issues: 4
  • Total pull requests: 3
  • Average time to close issues: about 1 month
  • Average time to close pull requests: 2 minutes
  • Total issue authors: 3
  • Total pull request authors: 1
  • Average comments per issue: 0.0
  • Average comments per pull request: 1.0
  • Merged pull requests: 2
  • Bot issues: 2
  • Bot pull requests: 3
Past Year
  • Issues: 1
  • Pull requests: 3
  • Average time to close issues: N/A
  • Average time to close pull requests: 2 minutes
  • Issue authors: 1
  • Pull request authors: 1
  • Average comments per issue: 0.0
  • Average comments per pull request: 1.0
  • Merged pull requests: 2
  • Bot issues: 1
  • Bot pull requests: 3
View more stats
Top Authors
Issue Authors
  • slugb0t (2)
  • codefair-test[bot] (1)
  • codefair-app[bot] (1)
Pull Request Authors
  • codefair-test[bot] (6)
Top Labels
Issue Labels
Pull Request Labels