Student - ArthurWar/EagleLife GitHub Wiki

StID

Internal Name
StID

External Name
Student ID

Type of Data
int

Description
Unique identifier for students.

Key
Primary Key


StName

Internal Name
StName

External Name
Student Name

Type of Data
nchar

Description
Names for students. Used in search queries.

Size, Decimal Places
(25,0)


StEmail

Internal Name
StEmail

External Name
Student Email

Type of Data
nchar

Description
Email address contact info for students.

Size, Decimal Places
(50,0)


StPhone

Internal Name
StPhone

External Name
Student Phone

Type of Data
nchar

Description
Phone number contact info for students.

Size, Decimal Places
(20,0)


StSchool

Internal Name
StSchool

External Name
Student School

Type of Data
nchar

Description
School associated with a specific student.

Size, Decimal Places
(20,0)


StLeaderCode

Internal Name
StLeaderCode

External Name
Student Leader Code

Type of Data
int

Description
Code for associating a student with a specific leader.

Key Foreign Key to Leader


StHasGroup

Internal Name
StHasGroup

External Name
Student Has Group?

Type of Data
int

Description
Check for if a student does [1] or does not [0] have a group.


StGroupCode

Internal Name
StGroupCode

External Name
Student Group Code

Type of Data
int

Description
Code for associating a student with a specific group (if applicable).

Key
Foreign Key to SmallGroup