Ga naar inhoud

Table Web_Admin

Purpose

Web user database. Remap to users table, add field 'uWebUser' 'uPassword' and uCompanyFK

Field definitions in table Web_Admin

No. Used Name Type Reqd. Description
1 Y ID INT N Unique ID
2 Y CompanyID INT Y Company ID in Warta?
3 Y Company VARCHAR(100) Y Company name
4 Y Username VARCHAR(50) N User login name
5 Y Password VARCHAR(50) N User password
6 Y FullName VARCHAR(100) N User full name
7 N Rights CHAR(1) N ?

Indexes