Shipment Dialogue Attachment

This table stores information about individual Attachment which is sent to during individual shipment dialogue.

Attributes

shipmentDialogueAttachmentId: primary key of the table.

shipmentDialogueId: Foreign key of Shipment Dialogue table. This field stores the information of the shipment dialogue where attachment is uploaded.

shipmentId: Foreign key of Shipment table. This field stores the information of the shipment where attachment is uploaded.

orgId: Foreign key of Organisation table. This field stores the information of the organisation whose shipment is being used to upload attachment.

url: URL of the attachment where file is uploaded to S3 bucket.

filename: Name of the file attached to dialogue.

source: Source of the attachment like whether user manually uploaded it or it's linked to email reply.

meta: JSON object to stores information about meta data of the attachment

---

Associations

Organisation

Shipment dialogue attachment always belongs any one organisation.

Shipment

Shipment dialogue attachment always belongs any one Shipment.

ShipmentDialogue

Shipmet dialogue attachment always belongs any one shipment dialog.