The ORM Foundation

Hi Ken,  Thank you for your answer.  I create model like yours but I don't have same result. This is what I get.   Lets asume that I get same result. Verbalisation of ExclusionConstraint is: For each Employee, at most one of the following holds: that Employee is allocated some ParkingSpace; that Employee claims ...

Hi, When I add Exclusion constraint on diagram I expect that NORMA generate some code behind, for example:  alter table Employee add constraint Employee _excl check ( (ParkingSpaceID is null) or (ExpenseID is null) ) go alter table Employee add constraint Employee_MR check ( (ParkingSpaceID is not null) or (ExpenseID is not ...

Cheers to you to Terry and Ken and John 

 

Hi, In firs image you see ORM model. In second image you see DDL that generate Norma. In third image you see "good practice". There is no things that I can do with ordered columns that I can't with unordered columns but....  

Hi Ken, I agree that column order does not important from that point of view but I think that is good practice order columns in data table.  

Hi Ken,  Thank you for your help, but  I do not find solutions for my problem yet.  In firs image you see ORM model. In second image you see ER model In third image you see DDL that generate Norma. In table Patinet I want column isSmoker to be before column patientName. Is it possible? You also see that column order ...

How can I define column order for columns in my tables in ddl output.  Thank yuo for help