Table: IGS_GE_NOTE

Product:	IGS - Student System
Description:	This table is used to store notes that may be recorded against many major entities for example courses, units, persons. The note may be an OLE object like word document, excel spreadsheet, and so on.
Implementation/DBA Data:	IGS.IGS_GE_NOTE

Primary Key: IGS_GE_NOTE_PK

1. REFERENCE_NUMBER

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_PS_OFR_NOTE		IGS_GE_NOTE	IGS_PS_OFR_NOTE.REFERENCE_NUMBER
IGS_PS_OFR_OPT_NOTE		IGS_GE_NOTE	IGS_PS_OFR_OPT_NOTE.REFERENCE_NUMBER
IGS_PS_OFR_PAT_NOTE		IGS_GE_NOTE	IGS_PS_OFR_PAT_NOTE.REFERENCE_NUMBER
IGS_PS_VER_NOTE		IGS_GE_NOTE	IGS_PS_VER_NOTE.REFERENCE_NUMBER
IGS_FI_P_SA_NOTES		IGS_GE_NOTE	IGS_FI_P_SA_NOTES.REFERENCE_NUMBER
IGS_PE_PRIV_LEVEL		IGS_GE_NOTE	IGS_PE_PRIV_LEVEL.REF_NOTES_ID
IGS_PE_PERS_NOTE		IGS_GE_NOTE	IGS_PE_PERS_NOTE.REFERENCE_NUMBER
IGS_AS_SC_ATMPT_NOTE		IGS_GE_NOTE	IGS_AS_SC_ATMPT_NOTE.REFERENCE_NUMBER
IGS_TR_GROUP_NOTE		IGS_GE_NOTE	IGS_TR_GROUP_NOTE.REFERENCE_NUMBER
IGS_TR_ITEM_NOTE		IGS_GE_NOTE	IGS_TR_ITEM_NOTE.REFERENCE_NUMBER
IGS_TR_STEP_NOTE		IGS_GE_NOTE	IGS_TR_STEP_NOTE.REFERENCE_NUMBER
IGS_TR_TYP_STEP_NOTE		IGS_GE_NOTE	IGS_TR_TYP_STEP_NOTE.REFERENCE_NUMBER
IGS_PS_UNIT_OFR_NOTE		IGS_GE_NOTE	IGS_PS_UNIT_OFR_NOTE.REFERENCE_NUMBER
IGS_PS_UNT_OFR_OPT_N		IGS_GE_NOTE	IGS_PS_UNT_OFR_OPT_N.REFERENCE_NUMBER
IGS_PS_UNT_OFR_PAT_N		IGS_GE_NOTE	IGS_PS_UNT_OFR_PAT_N.REFERENCE_NUMBER
IGS_EN_UNIT_SET_NOTE		IGS_GE_NOTE	IGS_EN_UNIT_SET_NOTE.REFERENCE_NUMBER
IGS_PS_UNIT_VER_NOTE		IGS_GE_NOTE	IGS_PS_UNIT_VER_NOTE.REFERENCE_NUMBER