P 2 K_AM_SITES
Back to current versionRestore this version

Alias: MST#

Unique Keys: SITE_CODE

ERD: ERD-AM20

A physical location where products are installed.

Note that only one record is expected in this table

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
SITE_CODEVarchar2(16)CODEY
MST_IDNumber(10)ID link to P2K_AM_SITES
DESCRIPTIONVarchar2(50)DESCRIPTION
USER_PASSWORD_DAYSNumber(5)NUMBER5
USER_PASSWORD_LENGTHNumber(10)NUMBER10
PIN_NUMBER_DAYSNumber(5)NUMBER5
DEMO_KEYVarchar2(16)ENCRYPTED
DEMO_EXPIRY_DATEDate()DATE
ACTIVATION_KEYVarchar2(16)ENCRYPTED
CONCURRENT_USERSNumber(5)NUMBER5
LICENSE_TYPEVarchar2(2)X_LICENSE_TYPE
ENVIRONMENTVarchar2(2000)VARCHAR2000
MAIL_HOSTVarchar2(200)URL
MAIL_DOMAINVarchar2(200)URL
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
USER_PASSWORD_DIGITVarchar2(1)TOGGLE
USER_PASSWORD_PUNCTUATIONVarchar2(1)TOGGLE
J2EE_LAST_PINGDate()TIMESTAMP

User Fields: Not Allowed
Audit Logging: Not Allowed