This page (revision-10) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by Administrator

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
10 26-Nov-2021 10:22 734 bytes RForbes to previous
9 26-Nov-2021 10:22 589 bytes RForbes to previous | to last NON-TRANSFERRABLE ==> NON-TRANSFERABLE
8 26-Nov-2021 10:22 589 bytes RForbes to previous | to last Non-transferrab ==> NON-TRANSFERRABLE
7 26-Nov-2021 10:22 589 bytes RForbes to previous | to last Non-transferrable ==> Non-transferrab
6 26-Nov-2021 10:22 589 bytes RForbes to previous | to last Non-transferrabl ==> NON-TRANSFERRABLE
5 26-Nov-2021 10:22 589 bytes RForbes to previous | to last Non-transferrable ==> Non-transferrabl
4 26-Nov-2021 10:22 589 bytes RForbes to previous | to last
3 26-Nov-2021 10:22 6 bytes RForbes to previous | to last
2 26-Nov-2021 10:22 559 bytes Administrator to previous | to last
1 26-Nov-2021 10:22 443 bytes Administrator to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed 7 lines
Non Transferable is a property of a [foreign key] link where the link cannot be changed from one parent table record to another. On Entity Relationship Diagrams, this is shown as a diamond symbol on the link.
[{Image src='ERD_Tranferable.JPG' width='323' align='right' link='attach/Nontransferrable/ERD_Tranferable.JPG'}]
In the example above, the Alias record cannot be altered to point to a different Identity. That is, the alias is for one person and cannot be switched to another person.
This is managed by a BEFORE UPDATE [data base trigger]
huh?