From dbscript Online Help
|
|
| Line 3: |
Line 3: |
| | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
| | |- | | |- |
| − | | '''Table | + | | '''table |
| | | HR.EMPLOYEES | | | HR.EMPLOYEES |
| | |- | | |- |
| − | |}
| |
| − |
| |
| − |
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Column
| |
| − | | '''Data Type
| |
| − | | '''Nullable
| |
| − | | '''Default
| |
| − | | '''PK
| |
| − | | '''Index
| |
| − |
| |
| − | |-
| |
| − | | EMPLOYEE_ID
| |
| − | | NUMBER
| |
| − | | not null
| |
| − | |
| |
| − | | EMP_EMP_ID_PK
| |
| − | |
| |
| − | |-
| |
| − | | FIRST_NAME
| |
| − | | VARCHAR2
| |
| − | | null
| |
| − | |
| |
| − | |
| |
| − | | EMP_NAME_IX
| |
| − | |-
| |
| − | | LAST_NAME
| |
| − | | VARCHAR2
| |
| − | | not null
| |
| − | |
| |
| − | |
| |
| − | | EMP_NAME_IX
| |
| − | |-
| |
| − | | EMAIL
| |
| − | | VARCHAR2
| |
| − | | not null
| |
| − | |
| |
| − | |
| |
| − | | EMP_EMAIL_UK
| |
| − | |-
| |
| − | | PHONE_NUMBER
| |
| − | | VARCHAR2
| |
| − | | null
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |-
| |
| − | | HIRE_DATE
| |
| − | | DATE
| |
| − | | not null
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |-
| |
| − | | JOB_ID
| |
| − | | VARCHAR2
| |
| − | | not null
| |
| − | |
| |
| − | |
| |
| − | | EMP_JOB_IX
| |
| − | |-
| |
| − | | SALARY
| |
| − | | NUMBER
| |
| − | | null
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |-
| |
| − | | COMMISSION_PCT
| |
| − | | NUMBER
| |
| − | | null
| |
| − | |
| |
| − | |
| |
| − | |
| |
| − | |-
| |
| − | | MANAGER_ID
| |
| − | | NUMBER
| |
| − | | null
| |
| − | |
| |
| − | |
| |
| − | | EMP_MANAGER_IX
| |
| − | |-
| |
| − | | DEPARTMENT_ID
| |
| − | | NUMBER
| |
| − | | null
| |
| − | |
| |
| − | |
| |
| − | | EMP_DEPARTMENT_IX
| |
| − | |}
| |
| − |
| |
| − |
| |
| − |
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Relation
| |
| − | | '''Column
| |
| − | | '''Referenced Column
| |
| − |
| |
| − | |-
| |
| − | | [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]]
| |
| − | | DEPARTMENT_ID
| |
| − | | DEPARTMENT_ID
| |
| − | |-
| |
| − | | [[HR.JOBS_(table)|HR.JOBS]]
| |
| − | | JOB_ID
| |
| − | | JOB_ID
| |
| − | |-
| |
| − | | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
| |
| − | | MANAGER_ID
| |
| − | | EMPLOYEE_ID
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Detail Table
| |
| − | | '''Column
| |
| − | | '''Referencing Column
| |
| − |
| |
| − | |-
| |
| − | | [[OE.CUSTOMERS_(table)|OE.CUSTOMERS]]
| |
| − | | EMPLOYEE_ID
| |
| − | | ACCOUNT_MGR_ID
| |
| − | |-
| |
| − | | [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]]
| |
| − | | EMPLOYEE_ID
| |
| − | | MANAGER_ID
| |
| − | |-
| |
| − | | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
| |
| − | | EMPLOYEE_ID
| |
| − | | MANAGER_ID
| |
| − | |-
| |
| − | | [[HR.JOB_HISTORY_(table)|HR.JOB_HISTORY]]
| |
| − | | EMPLOYEE_ID
| |
| − | | EMPLOYEE_ID
| |
| − | |-
| |
| − | | [[OE.ORDERS_(table)|OE.ORDERS]]
| |
| − | | EMPLOYEE_ID
| |
| − | | SALES_REP_ID
| |
| | |} | | |} |
Revision as of 19:56, 24 August 2009
