Z_EXPORT_USER |
Default Table Name | Z_EXPORT_USER |
Definition |
Z_EXPORT_USER Columns |
ColumnName | Domain | Datatype | NULL | Definition |
EMPL_ID![]() |
VARCHAR2(20) | NO | ||
BATCH_ID![]() |
VARCHAR2(10) | NO | ||
WORK_TABLE_NO | NUMBER(2, 0) | YES | ||
EXPORT_STEP_NO | NUMBER(2, 0) | YES | ||
S_TYPE_CD![]() |
VARCHAR2(1) | NO | ||
IN_PROCESS_FL | VARCHAR2(1) | YES |
Z_EXPORT_USER Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0104 | PrimaryKey | EMPL_ID, BATCH_ID, S_TYPE_CD |
SI_0078 | Index | WORK_TABLE_NO, S_TYPE_CD |
Z_EXPORT_USER Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |