|
|
| Legend: |
| Primary key columns |
| Columns with indexes |
| Implied relationships |
| Excluded column relationships |
| < n > number of related tables |
|
|
| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ASSIGN_ID |
number |
38 |
|
|
|
|
|
| ASSIGN_NUMBER |
varchar2 |
20 |
|
|
|
|
|
| ASSIGN_DATE |
date |
7 |
√ |
|
null |
|
|
| ASSIGN_COMMENT |
varchar2 |
1000 |
√ |
|
null |
|
|
| POSTED |
varchar2 |
1 |
√ |
|
null |
|
|
| AGENCY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
| ASSIGN_CODE |
varchar2 |
30 |
|
|
|
|
|
| ASSIGN_CODE_DESC |
varchar2 |
50 |
√ |
|
null |
|
|
| SHIFT_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| SHIFT_CODE_DESC |
varchar2 |
50 |
√ |
|
null |
|
|
| ASSIGN_STATUS |
varchar2 |
30 |
|
|
|
|
|
| ASSIGN_STATUS_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| ASSIGN_CREATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| ASSIGN_UPDATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| EQUIPMENT_ID |
number |
38 |
|
|
|
|
|
| COMMENTS |
varchar2 |
2000 |
√ |
|
null |
|
|
| START_DATE_TIME |
date |
7 |
√ |
|
null |
|
|
| END_DATE_TIME |
date |
7 |
√ |
|
null |
|
|
| DESCRIPTION |
varchar2 |
80 |
√ |
|
null |
|
|
| SERIAL_NUMBER |
varchar2 |
255 |
√ |
|
null |
|
|
| MAKE |
number |
0 |
√ |
|
null |
|
|
| MODEL |
number |
0 |
√ |
|
null |
|
|
| EQUIPMENT_TYPE |
varchar2 |
255 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
A.ASSIGN_ID,
A.ASSIGN_NUMBER,
A.ASSIGN_DATE,
A.ASSIGN_COMMENT,
A.POSTED,
A.AGENCY_CODE,
ACO.AGENCY_DESC,
A.ASSIGN_CODE,
AC.DESCRIPTION,
A.SHIFT_CODE,
SHFT.DESCRIPTION,
A.ASSIGN_STATUS,
EC.DESCRIPTION,
A.CREATOR_ID,
A.UPDATOR_ID,
AE.EQUIPMENT_ID,
AE.COMMENTS,
AE.START_DATE_TIME,
AE.END_DATE_TIME,
DE.DESCRIPTION,
DE.SERIAL_NUMBER,
DE.MAKE,
DE.MODEL,
DE.EQUIPMENT_TYPE
FROM ASSIGNMENTS A
INNER JOIN AGENCY_CODES ACO ON A.AGENCY_CODE = ACO.AGENCY_CODE
INNER JOIN ASSIGNMENT_SHIFT_CODES SHFT ON A.SHIFT_CODE = SHFT.SHIFT_CODE
INNER JOIN ASSIGNMENT_CODES AC ON A.ASSIGN_CODE = AC.ASSIGNMENT_CODE
INNER JOIN EJS_CODES EC ON A.ASSIGN_STATUS = EC.CODE AND A.ASSIGN_STATUS_TYPE = EC.CODE_TYPE
INNER JOIN ASSIGNMENT_EQUIPMENT AE ON A.ASSIGN_ID = AE.ASSIGN_ID
LEFT OUTER JOIN DEPARTMENT_EQUIPMENT DE ON AE.EQUIPMENT_ID = DE.EQUIPMENT_ID
Possibly Referenced Tables/Views:
