...
8. Data Model:The DM for Patron is going to reside in the Rice2.x Schema
Tables involved as per the requirement given in LocationhandlinginOLE.pdf and JIRA No. OLE-2558 OLE_LOCN_LEVEL_T and OLE_LOCN_T
OLE_LOCN_LEVEL_T:
- LEVEL_ID – varchar2(40)(Primary key)
- OBJ_ID – varchar2(Not Null)
- VER_NBR – Number(8)(Not Null)
- LEVEL_CD – varchar2(40)(Unique & Not Null)
- LEVEL_NAME – varchar2(100)(Not Null)
- PARENT_LEVEL – varchar2(40) (Nullable) - References OLE_LOCN_LEVEL_T.LEVEL_ID. Varchar2(40)
OLE_LOCN_T:
...
