Reminder¶
This table stores information about individual reminder which needs to be sent to specified email addresses. User can create any number of reminder and send emails to any one on specified date.
Attributes¶
reminderId Primary key of the table.
orgId Foreign key of Organisation table. This field stores the information of the organisation in which reminder created.
shipmentId Foreign key of Shipment table. This field stores the information of the shipment which is linked to Reminder. This will be null if reminder is created for some other document.
salesOrderId Foreign key of Sales Order table. This field stores the information of the order which is linked to reminder. This will be null if reminder is created for some other document.
purchaseOrderId Foreign key of Purchase Order table. This field stores the information of the order which is linked to reminder. This will be null if reminder is created for some other document.
invId Foreign key of Invoice table. This field stores the information of the invoice/vendor bill which is linked to reminder. This will be null if reminder is created for some other document.
eventName Name of the event, which will be used as subject of the email.
description Description of the reminder event. This will be the body of email.
toEmail Array of email addresses to whom reminder email should be sent.
targetDate Date when reminder should be triggered & email should be sent to listed email addresses.
attachmentUrl URL of the uploaded attachment in reminder, which is uploaded to S3 bucket.
attachmentData JSON object which stores information about attachment like name of file, content type of file etc.
isSeen Boolean value indicating whether the reminder is seen or not.
Association¶
Organisation¶
Reminder always belongs any one organisation.
Invoice¶
Reminder always belongs any one Invoice.
PurchaseOrder¶
Reminder always belongs any one Import/Purchase Order.
SalesOrder¶
Reminder always belongs any one Export/Sales Order.
Shipment¶
Reminder always belongs any one Shipment.