Mysysusers

From SPGC Document Wiki
Revision as of 15:12, 5 August 2016 by Ojt2 (Talk | contribs)

Jump to: navigation, search

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

myadmin

myadmin
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
adminuser varchar 10 No No No
adminpass varchar 50 No No No

myempusers

myempusers
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
myusername varchar 10 No No No
myuserfulln varchar 50 No No No
myuserpass varchar 10 No No No
myuserlevel varchar 3 No No No
myuservalis datetime 0 No No No
myuservalie datetime 0 No No No
myusercostc varchar 10 No No No
myusergroup varchar 15 No No No
myuseracomp varchar 60 No No No
myusertype varchar 7 No No No


myusers

myusers
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
myusername varchar 10 No No No
myuserfulln varchar 50 No No No
myuserpass varchar 50 No No No
myuserlevel varchar 3 No No No
myuservalis datetime 0 No No No
myuservalie datetime 0 No No No
myusercostc varchar 10 No No No
myusergroup varchar 15 No No No
myuseracomp varchar 60 No No No
myusertype varchar 7 No No No
myuserremal longtext 0 No No No
myuserremcc longtext 0 No No No

payacc

payacc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
myusername varchar 10 No No No
myusermodule varchar 4 No No No
myusersubmod varchar 4 No No No
myuserdatea datetime 0 No No No

payacc_20160517

payacc_20160517
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
myusername varchar 10 No No No
myusermodule varchar 4 No No No
myusersubmod varchar 4 No No No
myuserdatea datetime 0 No No No


paymenu

paymenu
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
paymodule varchar 4 No No No
paydesc varchar 40 No No No