Data Dictionary

System_Default Table

System_Default Table
  Data Type Constraints Default Value Description

Sys_Default_Id

Int

Primary Key

 

System Generated Sequential Key

Sys_Ind_Mem_Price

Float

Not NULL

24.00

Approved Annual Fee for Individual Memberships

Sys_Inst_Mem_Price

Float

Not NULL

48.00

Approved Annual Fee for Institutional Memberships

Sys_Reg_User_Price

Float

Not NULL

0.00

Approved Annual Fee for Registered Non-member users

Sys_PPP_Price

Float

Not NULL

125.00

Approved Annual Fee for Graphical PPP Access

Sys_DB_Price

Float

Not NULL

 

Approved Annual Fee for Database Hosting

Sys_VirtualDomain_Price

Float

Not NULL

 

Approved Annual Fee for Virtual Domain Hosting

Sys_TimeQuota1

Float

Not NULL

?

Maximum allowed time per single session for users

Sys_TimeQuota2

Float

Not NULL

?

Maximum allowed sessions per day for users

Sys_SSL_Price

Float

Not NULL

 

Approved Additional Annual Fee for SSL encrypted Virtual Domain Hosting

Sys_ListServer_Price

Float

Not NULL

100.00

Approved Annual Fee for Listserver Hosting

Sys_Next_UserId

String (5)

Not NULL

 

Next available UserName for Registered User accounts following the Csuite naming convention of aannn1

Sys_ExtraDiskQuota_Price

Float

Not NULL

?

Approved Annual Pricing per Mb of extra Disk Quota above the approved included amounts

Sys_Incl_Quota1

Int

Not NULL

 

Approved Amount of basic disk space in filesystem1

Sys_Incl_Quota2

Int

Not NULL

 

Approved Amount of basic disk space in filesystem2

Sys_Incl_Quota3

Int

Not NULL

 

Approved Amount of basic disk space in filesystem3

Sys_Quota1_Mnt

 String (8)

Not NULL

 

Mount point on the system for quota1

Sys_Quota2_Mnt

 String (8)

Not NULL

 

Mount point on the system for quota2

Sys_Quota3_Mnt

 String (8)

Not NULL

 

Mount point on the system for quota3

Sys_Last_Annual_Cycle

Time­stamp

 

 

The timestamp of the last generated invoice cycle. This is used to frequent duplicate invoice cycles within the same fiscal year.