P0: Ensure uniqueness of fields in Teacher table

RaymondYounan / LEMIS

Literacy Education Management Information System

1 stars 0 forks source link

Closed DrJoeHage closed 8 years ago

DrJoeHage commented 8 years ago

TeacherCivilStatusNationalID TeacherCensusID TeacherCitizenshipNo

must have unique values to ensure a Teacher has one record.

RaymondYounan commented 8 years ago

Done

DrJoeHage commented 8 years ago

@RaymondYounan Should I make them required in the Table?

RaymondYounan commented 8 years ago

No, I changed the design since they can be null in the case of a foreign Teacher

DrJoeHage commented 8 years ago

Teacher is not unique message displayed even though the Teacher is unique.

RaymondYounan commented 8 years ago

Done

DrJoeHage commented 8 years ago

It is partially working: TeacherCensusID works fine but TeacherCivilStatusNationalID TeacherCitizenshipNo are allowing duplicates

DrJoeHage commented 8 years ago

Each one is individually not allowed to be duplicated, not the combination of all.

RaymondYounan commented 8 years ago

Done

DrJoeHage commented 8 years ago

Verified.