6 lines
815 B
Markdown
6 lines
815 B
Markdown
## Aufbau Tabelle OrdersHost in Relationenschreibweise
|
|
|
|
### Schema: TabellenName:(AttributName DatenTyp Restriktion)
|
|
### Schlüssel: PK: Primärschlüssel, FK: Fremdschlüssel
|
|
|
|
OrdersHost(Id [PK] int not_null, LeNo [FK] string not_null, Type string not_null, Source string not_null, Destination string not_null, HostDestination string not_null, Status string not_null, IdOrderWmsHead int, IdOrderWms int, IdOrderWmsPos int, Priority int not_null, PriorityDate datetime, StartTime datetime, Info string, Error string, IsEmptyLeRequest bool not_null, SequenceWms int, IsDirectPicking bool, IsStolen bool, SequencerRetrievalTime datetime, Creator string not_null, Created datetime not_null, CcuVersion int not_null, Process string not_null, Timestamp datetime not_null, DepartureFlag bool, DepartureLocation string, ) |