friedhof:microcontrollerforum:verwaltungssoftware

Inhaltsverzeichnis

Verwaltungssoftware
- Anforderungen
- Datenbank

Verwaltungssoftware

Anforderungen

Verwaltung von
- Einzelteilen
- Datenblaettern
- Bausaetzen
Benutzertypen
- Verbraucher
- Administrator
Use-cases
- Verwaltete Objekte
  - Anlegen
  - Aendern
  - Loeschen
- Einzelteile
  - Einchecken
  - Auschecken
  - Reservieren
  - Reservierungen aufheben
  - Bestand ausgeben
  - Bestandsliste erstellen
  - Einkaufsliste erstellen (basierend auf Bestand und aktuell reservierten Teilen/Saetzen)
    - High/Low Watermark triggert Warnung/Bestellung
- Bausaetze
  - Anzahl baubarer Saetze bestimmen
  - Baussaetze reservieren / reservierungen aufheben
  - Bausaetze/Listen von Bausaetzen („heute bauen wir 10x X und 20x Y, sind Teile da?“)

Datenbank

Table: Part

Field	Type	Comment
id	unique, pk, auto increment
name
description
image		opt
datasheet
watermarkhigh		if below, order if ordering anyway
watermarklow		if below, order required
stock		how much is currently in stock

Table: Vendor

add other address / contact related field

Field	Type	Comment
id	unique, pk, auto increment
name
website
customerid		our customer id for ordering

Table: Assembly

Field	Type	Comment
id	unique, pk, auto increment
name
description

Table: LinkAssemblyPart

link parts together to an assembly
does not allow for 'assemblies of assemblies' / baugruppen, would need one more layer ob abstraction

Field	Type	Comment
assemblyid	fk
partid	fk
numrequired		number of 'partid' required to build on 'assemblyid'

Table: LinkVendorPart

link parts to vendors so we know where to buy something.
not solved: prices for different mininum / recommended order quantities

Field	Type	Comment
partid	fk
vendorid	fk
quantity		minimum/recommended order quantity
price

other open issues

how to track parts and assembly pre-allocations / reservations in a way that allows you to keep allocations separate and allow to cancel individuall allocations in a clean way.
now to store datasheets? blobs?
do we have to associate / track similar parts by different manufactureres? („part X is out, but use Y instead“); possibly too complicated and overengineered
how to track part prices for resale? by part? fixed multiplicator?