|
|
| 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 |
| PROPERTY_ID |
number |
0 |
|
|
|
|
|
| PROPERTY_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
| EVIDENCE |
varchar2 |
1 |
|
|
|
|
|
| DOCUMENT |
varchar2 |
30 |
|
|
|
|
|
| TYPE_OF_QUANTITY |
varchar2 |
30 |
√ |
|
null |
|
|
| PRIMARY_COLOR |
varchar2 |
30 |
√ |
|
null |
|
|
| SECONDARY_COLOR |
varchar2 |
30 |
√ |
|
null |
|
|
| DRUG_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| QUANTITY |
number |
20,3 |
√ |
|
null |
|
|
| DESCRIPTION |
varchar2 |
2500 |
√ |
|
null |
|
|
| MAKE |
varchar2 |
20 |
√ |
|
null |
|
|
| MODEL |
varchar2 |
25 |
√ |
|
null |
|
|
| SERIAL_NUMBER |
varchar2 |
25 |
√ |
|
null |
|
|
| VALUE |
number |
11,2 |
√ |
|
null |
|
|
| MISC |
varchar2 |
160 |
√ |
|
null |
|
|
| DOCUMENT_NUMBER |
varchar2 |
6 |
√ |
|
null |
|
|
| BANK |
varchar2 |
40 |
√ |
|
null |
|
|
| DOCUMENT_DATE |
date |
7 |
√ |
|
null |
|
|
| ACCOUNT_NAME |
varchar2 |
40 |
√ |
|
null |
|
|
| ACCOUNT_NUMBER |
number |
16 |
√ |
|
null |
|
|
| PAYABLE_TO |
varchar2 |
40 |
√ |
|
null |
|
|
| AMOUNT |
number |
12,2 |
√ |
|
null |
|
|
| ENDORSEE |
varchar2 |
40 |
√ |
|
null |
|
|
| BARREL_LENGTH |
varchar2 |
20 |
√ |
|
null |
|
|
| CALGAG_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| GUN_ACT_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| GUN_TYP_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PRO_PROPERTY_ID |
number |
38 |
|
|
|
|
|
| ID |
number |
38 |
|
|
|
|
|
| TICKET_NUMBER |
varchar2 |
20 |
|
|
|
|
|
| OWNED_DURATION |
varchar2 |
30 |
√ |
|
null |
|
|
| DATE_PAWNED |
date |
7 |
|
|
|
|
|
| MATURITY_DATE |
date |
7 |
√ |
|
null |
|
|
| BUSNS_BUSINESS_NUMBER |
number |
38 |
|
|
|
|
|
| PER_PERSON_ID |
number |
38 |
|
|
|
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT
P.PROPERTY_ID
,P.PROPERTY_TYPE_CODE
,P.EVIDENCE
,P.DOCUMENT
,P.TYPE_OF_QUANTITY
,P.PRIMARY_COLOR
,P.SECONDARY_COLOR
,P.DRUG_TYPE
,P.QUANTITY
,P.DESCRIPTION
,P.MAKE
,P.MODEL
,P.SERIAL_NUMBER
,P.VALUE
,P.MISC
,P.DOCUMENT_NUMBER
,P.BANK
,P.DOCUMENT_DATE
,P.ACCOUNT_NAME
,P.ACCOUNT_NUMBER
,P.PAYABLE_TO
,P.AMOUNT
,P.ENDORSEE
,P.BARREL_LENGTH
,P.CALGAG_CODE
,P.GUN_ACT_CODE
,P.GUN_TYP_CODE
,PP.PRO_PROPERTY_ID
,PT.ID
,PT.TICKET_NUMBER
,PT.OWNED_DURATION
,PT.DATE_PAWNED
,PT.MATURITY_DATE
,PT.BUSNS_BUSINESS_NUMBER
,PT.PER_PERSON_ID
FROM PROPERTIES P,
PAWN_TICKETS PT,
PAWN_PROPERTIES PP
WHERE P.PROPERTY_ID = PP.PRO_PROPERTY_ID
and PT.ID = PP.PT_ID
AND PT.TICKET_NUMBER = PP.PT_TICKET_NUMBER
Possibly Referenced Tables/Views:
