One entry per family member.
|
column |
type |
description |
|
lms_application_id |
varchar(32) |
Primary index used for all applications. Corresponds with the FCC’s application identifier used in LMS and therefore can be used to cross reference with FCC raw data. Unless otherwise indicated, all relational tables in eLMS are linked by lms_application_id |
|
family_sequence |
int |
Sequence of family relationships within an application ID. |
|
frn1 |
varchar(11) |
FRN of first family member. |
|
name1 |
varchar(80) |
Name of first family member. |
|
frn2 |
varchar(11) |
FRN of second family member. |
|
name2 |
varchar(80) |
Name of second family member. |
|
relationship |
varchar(1) |
Familial relationship: [M]=spouses, [P]arent-child, [S]ibling. |
