No description, website, or topics provided.
Python HTML
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
ISS
ISStuRa
developing
README.markdown
manage.py

README.markdown

IS-StuRa

IS-StuRa is a inventary database software with webui.

Features

Add, remove, change, listing, and search of inventary.

Require

  • py27-django18
  • sqlite3

Running

python manage.py migrate

python manage.py createsuperuser

python manage.py makemigrations ISStuRa

python manage.py migrate ISStuRa

python manage.py loaddata initial_data

python manage.py runserver

Datenbase Schema

Inventary Table

  • ID (Primary Key)
  • ID_typ (Foreign Key typ)
  • ID_location (Foreign Key location)
  • ID_tbr (Foreign Key time_between_replacement)
  • ID_category (Foreign Key category)
  • objectname
  • vendor_id
  • amount
  • date_of_purchase
  • single (Brutto)
  • total (Brutto)
  • fair_value (Brutto)

Location Table

  • ID
  • location
    • Z 123
    • S 522
    • S 523
    • A 103
    • A 104
    • A 105
    • A 106
    • A 107
    • A 108
    • ...

Typ Table

  • ID
  • typ
    • Scanner
    • Tisch
    • Stuhl
    • Switch
    • Server
    • Computer
    • ...

time_between_replacement Table

  • ID
  • tbr (in year)
    • 0 (GWG; Kleininventar)
    • 3
    • 5
    • 7
    • 8
    • 10
    • 13
    • 14
    • ...

Category Table

  • ID
  • category
    • Kleininventar (< 410 Euro Netto)
    • Buchinventar (> 410 Euro Netto)

Format

  • CSV
  • Plain Text