mcd and history table
-
HI!! Sory my english is bad! I work on a topic of management school I created this mcd I wish someone Regad if it is right or not. I was looking to create a history table for the table CAPITALISE_MODULE and CAPITALISE_SEMESTRE how to define the historical table should I linked to the other table?what are the identifiers.? Thank you for read me! Whay can i insert my file mcd? :-O
-
HI!! Sory my english is bad! I work on a topic of management school I created this mcd I wish someone Regad if it is right or not. I was looking to create a history table for the table CAPITALISE_MODULE and CAPITALISE_SEMESTRE how to define the historical table should I linked to the other table?what are the identifiers.? Thank you for read me! Whay can i insert my file mcd? :-O
I'm sorry, but i really can't understand your question. I don't think that we can help you to define tables when you have only given us the table names, but no other information. What is an mcd?
-
HI!! Sory my english is bad! I work on a topic of management school I created this mcd I wish someone Regad if it is right or not. I was looking to create a history table for the table CAPITALISE_MODULE and CAPITALISE_SEMESTRE how to define the historical table should I linked to the other table?what are the identifiers.? Thank you for read me! Whay can i insert my file mcd? :-O
foryou wrote:
I was looking to create a history table
If I understand you correctly, the structure of your "history" (or "audit") table will be the same as the source table except you need to add some sort of versioning column in there also. That can be a simple incremented integer, or it can be a datetime, or something else that suits your needs. To maintain the history you need to add triggers to the source table to copy any updates to the "history" table.
*Developer Day Scotland - Free community conference *Colin Angus Mackay's Blog *Latest Scottish Developers Newsletter
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.
-
foryou wrote:
I was looking to create a history table
If I understand you correctly, the structure of your "history" (or "audit") table will be the same as the source table except you need to add some sort of versioning column in there also. That can be a simple incremented integer, or it can be a datetime, or something else that suits your needs. To maintain the history you need to add triggers to the source table to copy any updates to the "history" table.
*Developer Day Scotland - Free community conference *Colin Angus Mackay's Blog *Latest Scottish Developers Newsletter
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Remember that the force of gravity can go up as well as down.
-
Thank you very much Colin Angus Mackay and Paddy Boyd. MCD is Conceptual data model. whay can i send you my MLD?
HI!! if my table history will be as my table source so my table history is: (id_student, id_module, id_validat_module, note) or informations about students are in student table. if I want to select students in their history with name_etudiants I have to link the history table to student table? Thanks