_ALL - Multi org tables. Show data for all orgs.
_V - Views. Mostly show data specific to the orgs user has logged in.
_TL - Translation table. Store name, description etc. in mutliple languages.
_VL - View which selects only one row from _TL table based on the user session's language and org_id. Uses USERENV ('LANG') to fetch data from join of _V and _TL
_B - Base table. Mostly used for non-org specific data.
_V - Views. Mostly show data specific to the orgs user has logged in.
_TL - Translation table. Store name, description etc. in mutliple languages.
_VL - View which selects only one row from _TL table based on the user session's language and org_id. Uses USERENV ('LANG') to fetch data from join of _V and _TL
_B - Base table. Mostly used for non-org specific data.
No comments:
Post a Comment