Difference between revisions of "Myclearance"

From SPGC Document Wiki
Jump to: navigation, search
(→‎executive_users)
Line 10: Line 10:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|recid
+
|Company
−
|int
+
|varchar
−
|30
+
|255
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|-
 
|-
−
|LOG_USER
+
|Department
 
|varchar
 
|varchar
−
|25
+
|255
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|LOG_MODULE
+
|Emp#
 
|varchar
 
|varchar
−
|50
+
|255
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|LOG_KEYREC
+
|Employee Name
 
|varchar
 
|varchar
−
|50
+
|255
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_TBL
+
|Position
 
|varchar
 
|varchar
−
|50
+
|255
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_DATE
+
|Joblelvel
−
|datetime
+
|varchar
−
|0
+
|255
 
|Yes
 
|Yes
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_ENUMB
+
|User IDs
 
|varchar
 
|varchar
 
|25
 
|25
Line 59: Line 59:
 
|No
 
|No
 
|-
 
|-
−
|LOG_MODFLD
+
|lname
−
|longtext
+
−
|0
+
−
|No
+
−
|Yes
+
−
|No
+
−
|-
+
−
|LOG_FIELD
+
 
|varchar
 
|varchar
−
|25
+
|50
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|LOG_OLDVAL
+
|fname
 
|varchar
 
|varchar
−
|40
+
|50
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|LOG_NEWVAL
+
|mname
 
|varchar
 
|varchar
−
|40
+
|50
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|LOG_SQLEXEC
+
|email
−
|longtext
+
−
|0
+
−
|No
+
−
|No
+
−
|No
+
−
|-
+
−
|LOG_CHANGE
+
 
|varchar
 
|varchar
−
|25
+
|50
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|-
 
|-
−
|LOG_IPADDR
+
|fullname
 
|varchar
 
|varchar
−
|25
+
|150
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
−
|-
 
−
|LOG_PRNT
 
−
|varchar
 
−
|25
 
−
|No
 
−
|Yes
 
 
|No
 
|No
 
|}
 
|}

Revision as of 17:03, 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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Myclearance&oldid=2501"