(The main AFE document table is an exception “AFE_TOP”) Child tables are typically prefixed by the document name (ACCOUNT) and will have a foreign key to explain the relationship. The main table only stores the latest data for that record. It may also have a series of child tables (ACCOUNT_CUSTOM). The main table for a document has no suffix (ACCOUNTS) and is responsible for storing most of the data. There will be one row in this table for every “edit” of a document (an edit may be comprised of many individual field changes). The document version tables end in “_DOC_V” (ACCOUNT_DOC_V). The versions table identifies each version of a document, who created it, the date and some comments about the version (whether it was created by a script, for example). ![]() It introduces the document and tracks whether it is deleted or not. The master document table ends in “_DOC” (ACCOUNT_DOC). Here is an example schema for the Account Document. All Documents have a similar structure when stored in the database.
0 Comments
Leave a Reply. |