Primary key
The unique identifier for the MaihueStreet transaction record.
Specific attributes
The status of the authorization for the transaction.
Rules: Max length: 50 characters
Indicates whether the dispensing process has finished.
The quantity of water dispensed in the transaction.
Rules: Precision: 12, Scale: 2
Indicates whether a dispensing request has been made.
Indicates whether there has been a response to the dispensing request.
Indicates whether the transaction was initiated using NFC.
Indicates whether the transaction was initiated using a QR code.
Indicates whether a new transaction has been created as a result of this transaction.
Indicates whether the bottle was removed during the transaction/dispensation.
The quantity of water requested in the transaction.
Rules: Precision: 6, Scale: 0
The current status of the transaction.
Rules: Max length: 50 characters
Foreign keys
The unique identifier of the associated machine. Ref: MaihueStreetMachine Schema
The unique identifier of the associated user. Ref: User Schema
The unique identifier of the associated user alias. Ref: MaihueStreetUserAlias
Schema
The unique identifier of the associated user bottle. Ref: MaihueStreetUserBottle
Schema
The unique identifier of the associated water type. Ref: MaihueStreetWaterType
Schema
The unique identifier of the associated workflow. Ref: MaihueStreetWorkflow Schema
The unique identifier of the associated workflow step. Ref: MaihueStreetWorkflowStep
Schema
Tracking attributes
The timestamp when the MaihueStreet transaction record was created.
Rules: Precision: 6, with timezone
The timestamp when the MaihueStreet transaction record was deleted, if applicable.
Rules: Precision: 6, with timezone
Indicates whether the MaihueStreet transaction record is active.
Indicates whether the MaihueStreet transaction record has been deleted.