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...
