Difference between revisions of "Myclearance"

From SPGC Document Wiki
Jump to: navigation, search
(→‎executive_users)
Line 2: Line 2:
 
{| class="wikitable" \
 
{| class="wikitable" \
 
!colspan="7" | executive_users
 
!colspan="7" | executive_users
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|Company
 +
|varchar
 +
|255
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|Department
 +
|varchar
 +
|255
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Emp#
 +
|varchar
 +
|255
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Employee Name
 +
|varchar
 +
|255
 +
|No
 +
|No
 +
|No
 +
|-
 +
|Position
 +
|varchar
 +
|255
 +
|No
 +
|No
 +
|No
 +
|-
 +
|Joblelvel
 +
|varchar
 +
|255
 +
|Yes
 +
|No
 +
|No
 +
|-
 +
|User IDs
 +
|varchar
 +
|25
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|lname
 +
|varchar
 +
|50
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|fname
 +
|varchar
 +
|50
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|mname
 +
|varchar
 +
|50
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|email
 +
|varchar
 +
|50
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|fullname
 +
|varchar
 +
|150
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==mod_sec_accs==
 +
{| class="wikitable" \
 +
!colspan="7" | mod_sec_accs
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name

Revision as of 17:16, 4 August 2016

executive_users

executive_users
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Company varchar 255 Yes Yes Yes
Department varchar 255 No Yes No
Emp# varchar 255 No Yes No
Employee Name varchar 255 No No No
Position varchar 255 No No No
Joblelvel varchar 255 Yes No No
User IDs varchar 25 No Yes No
lname varchar 50 No Yes No
fname varchar 50 No Yes No
mname varchar 50 No Yes No
email varchar 50 No Yes No
fullname varchar 150 No No No

mod_sec_accs

mod_sec_accs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Company varchar 255 Yes Yes Yes
Department varchar 255 No Yes No
Emp# varchar 255 No Yes No
Employee Name varchar 255 No No No
Position varchar 255 No No No
Joblelvel varchar 255 Yes No No
User IDs varchar 25 No Yes No
lname varchar 50 No Yes No
fname varchar 50 No Yes No
mname varchar 50 No Yes No
email varchar 50 No Yes No
fullname varchar 150 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Myclearance&oldid=2502"