Talk:Current DB Structure

From Scire Wiki

use cases for jobs:

single client job: one job entry in the jobs table. uses jc_id (job-client id) to find the client (will be one row, 1-1 relation). query checks the job_conditions table for misc parameters such as scheduling for the job and recurrancy.

multiple-client job: job is made for a group of clients (not necessarially a "group" as defined in the interface, can be + or - clients), a single job entry is added to the jobs table. uses jc_id to find the clients. query checks the job_conditions table ... should the query make individual jobs in the jobs table for each client when it's time to send them off to the clients?