6 lines
875 B
Markdown
6 lines
875 B
Markdown
## Aufbau Tabelle OrdersMiniload in Relationenschreibweise
|
|
|
|
### Schema: TabellenName:(AttributName DatenTyp Restriktion)
|
|
### Schlüssel: PK: Primärschlüssel, FK: Fremdschlüssel
|
|
|
|
OrdersMiniload(Id [PK] int not_null, OrdersHostId [FK] int not_null, AisleName [FK] string not_null, DeviceName [FK] string not_null, StorageArea [FK] string not_null, Type string not_null, LeNo [FK] string, Status string not_null, StatusSrc string, IdSubOrder int not_null, TotalOrders int not_null, LoadDevice string, Error string, IsSourceBooked bool not_null, IsDestinationBooked bool not_null, IsManual bool not_null, Priority int not_null, StartTime datetime, Source_LocationId string, Source_Depth int, Destination_LocationId string, Destination_Depth int, Creator string not_null, Created datetime not_null, CcuVersion int not_null, Process string not_null, Timestamp datetime not_null) |