friedhof:microcontrollerforum:verwaltungssoftware
Inhaltsverzeichnis
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?
friedhof/microcontrollerforum/verwaltungssoftware.txt · Zuletzt geändert: 2020-07-20 10:23 von neos