reference table for errors

Question

Post reply

reference table for errors

samirca007

SSC-Addicted

Points: 417
More actions
December 12, 2019 at 7:32 am

#3707265
Hello everyone
I have on each table of my base two columns used to store my anomalies Functional [error_id] and [description_error]
```
create table produit
(
id int , 
nom varchar(50),
id_erreur int ,
description_erreur  varchar(50),
)
```
```
create table magazin
(
id int , 
nom varchar(50),
id_erreur int ,
description_erreur  varchar(50),
)
```
I would like to store all my errors with their descriptions with the name of the source table in a single reference table by going through all the error_id the table reference error is the following
```
create table list_erreur
(nom_table varchar(50),
id_erreur int ,
descritption varchar(50)
)
```
Who has an idea please
Thank you for your return

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Check how you've spelt "description" in your list_erreur table
Remove the description_erreur column from the rest of your tables
Create a foreign key constraint between the id_erreur column in each of the rest of your tables and the id_erreur column in your new table
Change your application logic so that it no longer provides a value for the description column

John

Phil Parkin SSC Guru Points: 246960 More actions · Answer 2

Instead of providing us with a list of requirements and forcing us to play "guess the question", why not ask us something specific?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

jonas.gunnarsson 52434 Ten Centuries Points: 1240 More actions · Answer 3

Is the errors from database procedures/functions or from outside the database?
Do you use a stored procedure to save the error?
Do you not need a timestamp of the error?