|
|
| 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 |
|
|
| PERSON_ID |
number |
38 |
|
|
|
|
|
| ROLE_CODE |
varchar2 |
30 |
|
|
|
|
|
| DATE_OF_INFO |
date |
7 |
|
|
|
|
|
| LNAME |
varchar2 |
100 |
√ |
|
null |
|
|
| FNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| MNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| SFNAME |
varchar2 |
4 |
√ |
|
null |
|
|
| SLNAME |
varchar2 |
4 |
√ |
|
null |
|
|
| DOB |
date |
7 |
√ |
|
null |
|
|
| SSN |
number |
0 |
√ |
|
null |
|
|
| NME_TYP_NAME_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
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.person_id, pp.role_code, pp.date_of_info,
mn.lname, mn.fname, mn.mname, mn.sfname, mn.slname, mn.dob, mn.ssn,
mn.name_type_code nme_typ_name_type_code
FROM properties p, people_properties pp, master_names mn
WHERE p.property_id = pp.property_id AND mn.per_person_id = pp.person_id
Possibly Referenced Tables/Views:
