Data Dictionary Framework

zhaozj2021-02-16  73

Data Dictionary Frame Catalog ?????? Table ?????? Table Total Directory ????????????? VIEW Total Directory ????????????? Table 1 ?????? ...... XX section ?????? Table 1 ?????? ...?

TABLE Total

Sequence Chinese Name Type Object Name Maximum Static Data Quantity (MB) Maximum Dynamic Data Quantity (MB) Remarks 1. Supply Order Table Book ProVideBill?

?

?

34. Sequence table reference table SEQUENCEBILL?

?

The serial number (ID) of all tables is taken from the table: ?????? Name: Chinese fill in; ?????? Type: Optional value as follows: 1. Basic table (in the table data from the table User entry or calculation generation) 2. Refer to tables (records in the table for name and identity, such as subject types and ticket type tables) 3. Comprehensive table (some data comes from user entry or calculation generation, data for name and identification) 4. Temporary table (the temporary data is recorded in the table, or the data used for temporary exchange), foreign key: The column name of the table is represented by the column name; if the UserID ProductId static data amount: Mode is: n * rbyte / 1000 ?????????????? N: record number ????????????? RBYTE: The amount of dynamic data volume of single record bytes Value (Estimation Time Period): MAXN * RBYTE * Period / 1000 ????????????? Maxn: record number ????????????? RBYTE: single documentary word The number of hours; ????????????? period: Estimate time period specification: ?????? View total directory

The serial number Chinese name object name is referenced the table name by the reference table Name Number Number Remarks?

?

?

?

?

?

?

?

1, XX Table PROVIDEBILL

Field Name Chinese Name Data Type Length Empty Primary Key Remarks PROVIDEID Supply Order Number VARCHAR 64 NO YES?

2, xx table xxxxx

Field Name Chinese Name Data Type Constrained Remark ID Sequence VARCHAR2 (64) Key?

FunctionName function name varchar2 (64) NULL?

Function Name: 1, operator; 2, seller; ...... All possible names of the record company 3, XX table xxxxx

English Name Data Type Remarks Chinese Name Outstockid VARCHAR (64) PK Out Book Number Note VARCHAR (64 NULL Remarks Flag Varchar (2) 0 Sign?

转载请注明原文地址:https://www.9cbs.com/read-15248.html

New Post(0)