COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | PK | COMMENTS |
---|---|---|---|---|---|---|
ID | NUMBER | No | null | 1 | 1 | Primary Key |
MAP_ID_FK | NUMBER | No | null | 2 | null | The map to which this rule belongs //PARENTFIELD |
SOURCE_DATA_TYPE_NAME | VARCHAR2(4000 BYTE) | No | null | 3 | null | Source data type |
SOURCE_PRECISION | NUMBER | Yes | null | 4 | null | Precison to match |
SOURCE_SCALE | NUMBER | Yes | null | 5 | null | scale to match |
TARGET_DATA_TYPE_NAME | VARCHAR2(4000 BYTE) | No | null | 6 | null | data type name to transform to |
TARGET_PRECISION | NUMBER | Yes | null | 7 | null | precision to map to |
TARGET_SCALE | NUMBER | Yes | null | 8 | null | scale to map to |
SECURITY_GROUP_ID | NUMBER | No | 0 | 9 | null | null |
CREATED_ON | DATE | No | sysdate | 10 | null | null |
CREATED_BY | VARCHAR2(255 BYTE) | Yes | null | 11 | null | null |
LAST_UPDATED_ON | DATE | Yes | null | 12 | null | null |
LAST_UPDATED_BY | VARCHAR2(255 BYTE) | Yes | null | 13 | null | null |