|
|
| 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 |
| PERSON_ID |
number |
0 |
|
|
|
|
|
| SEX_SEX_CODE |
varchar2 |
30 |
|
|
|
|
|
| RACE_RACE_CODE |
varchar2 |
30 |
|
|
|
|
|
| MN_ID |
number |
0 |
|
|
|
|
|
| NME_TYP_NAME_TYPE_CODE |
varchar2 |
30 |
|
|
|
|
|
| LNAME |
varchar2 |
100 |
√ |
|
null |
|
|
| FNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| MNAME |
varchar2 |
80 |
√ |
|
null |
|
|
| DOB |
date |
7 |
√ |
|
null |
|
|
| SSN |
number |
0 |
√ |
|
null |
|
|
| SLNAME |
varchar2 |
4 |
√ |
|
null |
|
|
| SFNAME |
varchar2 |
4 |
√ |
|
null |
|
|
| TITLE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PERSON_VERIFIED |
varchar2 |
1 |
|
|
|
|
|
| MASTER_PERSON_ID |
number |
0 |
|
|
|
|
|
| CREATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| LOADED_BY |
varchar2 |
100 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT p.person_id, mp.sex_code sex_sex_code, mp.race_code race_race_code,
m.mn_id, m.name_type_code nme_typ_name_type_code, m.lname, m.fname,
m.mname, m.dob, m.ssn, m.slname, m.sfname, m.title_code,
mp.person_verified, mp.master_person_id,
p.creator_date, p.loaded_by
FROM people p, master_names m, master_people mp
WHERE m.per_person_id = p.person_id
AND p.master_person_id = mp.master_person_id
Possibly Referenced Tables/Views:
