|
|
| 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 |
|
|
| DATE_OF_INFO |
date |
7 |
|
|
|
|
|
| BUSNS_BUSINESS_NUMBER |
number |
38 |
|
|
|
|
|
| PPRC_ROLE_CODE |
varchar2 |
30 |
|
|
|
|
|
| BUSINESS_NAME |
varchar2 |
80 |
|
|
|
|
|
| BTC_TYPE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| BUSINESS_ID |
varchar2 |
30 |
√ |
|
null |
|
|
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
, BP.DATE_OF_INFO
, BP.BUSNS_BUSINESS_NUMBER
, BP.PPRC_ROLE_CODE
, B.BUSINESS_NAME
, B.BTC_TYPE_CODE
, B.BUSINESS_ID
FROM PROPERTIES P,
BUSINESS_PROPERTIES BP,
businesses B
WHERE P.PROPERTY_ID = BP.PRO_PROPERTY_ID
and B.BUSINESS_NUMBER = BP.BUSNS_BUSINESS_NUMBER
Possibly Referenced Tables/Views:
