Difference between revisions of "Mysysusers"

From SPGC Document Wiki
Jump to: navigation, search
(Created page with "==pmtqota== {| class="wikitable" \ !colspan="7" | pmtqota |- ! style="text-align:left;" | Column Name ! Data Type ! Length ! Is PrimaryKey ! Is Not Null ! Auto Increment |- |Q...")
 
Line 1: Line 1:
−
==pmtqota==
+
==mod_sec_accs==
 
{| class="wikitable" \
 
{| class="wikitable" \
−
!colspan="7" | pmtqota
+
!colspan="7" | mod_sec_accs
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name
Line 10: Line 10:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|QTACODE
+
|recid
−
|varchar
+
|int
−
|5
+
|20
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 +
|Yes
 +
|-
 +
|MSA_USER
 +
|varchar
 +
|10
 +
|No
 +
|No
 
|No
 
|No
 
|-
 
|-
−
|QTAEDTE
+
|MSA_SYS
−
|date
+
|varchar
−
|0
+
|2
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|QTAREG
+
|MSA_MODULE
−
|bigint
+
|varchar
−
|20
+
|4
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|QTARTEQT
+
|MSA_SMODULE
−
|double
+
|varchar
−
|0
+
|5
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|QTARTEPC
+
|MSA_ENCDTE
−
|double
+
|datetime
 
|0
 
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|MSA_MRK
 +
|varchar
 +
|1
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 09:18, 5 August 2016

mod_sec_accs

mod_sec_accs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes Yes
MSA_USER varchar 10 No No No
MSA_SYS varchar 2 No No No
MSA_MODULE varchar 4 No No No
MSA_SMODULE varchar 5 No No No
MSA_ENCDTE datetime 0 No No No
MSA_MRK varchar 1 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mysysusers&oldid=2551"