On Wed, 17 Aug 2016, 1:36 p.m. Venkata B Nagothi, wrote:
> On Mon, Jun 13, 2016 at 8:37 AM, Patrick B
> wrote:
>
>> Hi guys,
>>
>> In the db I'm working one, it will be three tables:
>>
>> visits, work, others.
>>
>> Everything the customer do, will be logged. All inserts/updates/deletes
>> will
On Mon, Jun 13, 2016 at 8:37 AM, Patrick B wrote:
> Hi guys,
>
> In the db I'm working one, it will be three tables:
>
> visits, work, others.
>
> Everything the customer do, will be logged. All inserts/updates/deletes
> will be logged.
>
> Option 1: Each table would have its own log table.
> vis
Also...
if something is changed inside the visits table (delete/insert/update), the
visits_logs table will be logging the change.
However, some joins between those three tables will become necessary in
some point, as visits and works tables are related somehow...
Hi guys,
In the db I'm working one, it will be three tables:
visits, work, others.
Everything the customer do, will be logged. All inserts/updates/deletes
will be logged.
Option 1: Each table would have its own log table.
visits_logs, work_logs, others_logs
Option 2: All the logs would be stor
