Architectural Principles Column Field Type
From PPDM Wiki
Also known as Column DATA TYPES
Guidelines
The following field (data) types are supported in PPDM version 3.7: 1. DATE
2. CHAR
- VARCHAR2 (Oracle DDL)
- VARCHAR (SQL*Server DDL)
3. NUMBER
4. BLOB information. It should be noted that occurrences of this type should place the column in a separate table with only primary keys and standard audit columns, rather than embedding it in a business table with other attribute information. The type of BLOB to implement should be determined by the work group.
- CLOB etc. (Oracle DDL only)
- TEXT / IMAGE / VBINARY (SQL*Server only)
- Note that LONGRAW should be avoided, as it is due to be deprecated.
Go to
- Architectural Principles NULL Data
- Architectural Principles Dates
- Architectural Principles Versioning
- Architectural Principles Vertical Tables
- Architectural Principles Sequence Control
- Architectural Principles Economics and Financial
- Architectural Principles Column Precision
- Architectural Principles Column Field Type
- Architectural Principles Standardized Columns
- Architectural Principles SQL View Definitions
- Architectural Principles Other SQL Definitions
