Tables: M
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
- pears.mailerselection - Mailchimp 'LISTS'
- pears.mailerselectionmember - Candidate/client contacts on mailchimp list.
- pears.mailmerge - Pointers to OLE documents in Blobstore (class M) which are individual users own Word mail merge templates.
- pears.MailServer - Mail Server configuration
- pears.MasterRoster - Header records for each Master Roster
- pears.MasterRosterChangeLog - Record of changes to a Master Roster.
- pears.MasterRosterChangeReason - Look-up of allowed change reasons for Master Rosters.
- pears.MasterRosterFailLog - Records of failure to create or fill shifts from a Master Roster.
- pears.MasterRosterPreferredPerson - Preferred candidates (with rank) for each Master Roster.
- pears.MasterRosterShift - Detail records for Master Rosters
- pears.MasterRosterShiftInstance - Shifts instantiated by the Master Roster. The delete restrict foreign key blocks deletion of MasterRosterShifts once instantiated
- pears.MIMEMessage - Used in constructing MIME email message.
- pears.MRShiftID2s - Temp Table - Used by Master Roster Process
- pears.MRShiftIDs - Temp Table - Used by Master Roster Process
127.0.0.1