Difference between revisions of "Test"

From SPGC Document Wiki
Jump to: navigation, search
(Created page with "==mst_attlogs== {| class="wikitable" \ !colspan="7" | rcuser_accounts |- ! style="text-align:left;" | Column Name ! Data Type ! Length ! Is PrimaryKey ! Is Not Null ! Auto Inc...")
 
(→‎mst_attlogs)
Line 10: Line 10:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|recID
+
|recid
 
|int
 
|int
−
|10
+
|30
−
|Yes
+
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 +
|No
 
|-
 
|-
−
|Username
+
|FP_ID
 
|varchar
 
|varchar
−
|50
+
|25
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|Surname
+
|FP_TRXDATE
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|FP_SITE
 
|varchar
 
|varchar
−
|30
+
|25
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
−
|Firstname
+
|MYF3
 
|varchar
 
|varchar
−
|30
+
|1
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
 +
|FP_INOUT
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|MYF5
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|MYF6
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|FP_IDNO
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|FP_EMPNAME
 +
|varchar
 +
|200
 +
|No
 +
|No
 +
|No
 +
|-
 +
|FP_DPCD
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|FP_COCD
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|FP_LCCD
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|FP_USER
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|FP_DTEUP
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|}

Revision as of 08:22, 10 August 2016

mst_attlogs

rcuser_accounts
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes No
FP_ID varchar 25 No No No
FP_TRXDATE datetime 0 No No No
FP_SITE varchar 25 No No No
MYF3 varchar 1 No No No
FP_INOUT varchar 1 No No No
MYF5 varchar 1 No No No
MYF6 varchar 1 No No No
FP_IDNO varchar 25 No No No
FP_EMPNAME varchar 200 No No No
FP_DPCD varchar 25 No No No
FP_COCD varchar 25 No No No
FP_LCCD varchar 25 No No No
FP_USER varchar 25 No No No
FP_DTEUP datetime 0 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Test&oldid=2792"