DT_MESLINK - Represent the links between Member, Exercise and Section. Although member and section is mandatory, exercice can be null. Therefore, for each member/section couple, you can have 2 records in this table:
Code | Type | Description |
MES_ID | Number | Identifier - Auto-generated |
MEB_ID | Foreign Key | Link to member. Mandatory |
EXC_ID | Foreign Key | Link to exercise. Not Mandatory |
SEC_ID | Foreign Key | Link to Section. Not Mandatory |
ROL_CD | System | Role in the section |
MES_AM_BALANCE | Number | Payment balance for referenced section, exercice and member. |
MES_BL_VALID | Number | Validity flag |