GridChem DB Layout with Groups

Columns
*	computeResourceID	int AUTOINCREMENT
*	diskTotalSpace	bigint
*	diskAvailableSpace	bigint DEFO 0
*	availableCPU	bigint DEFO 0
*	totalCPU	bigint
	supportEmail	varchar( 255 ) DEFO 'help@gridchem.org'
*	scratchDirectoryBase	varchar( 255 ) DEFO '$HOME'
	Pflag	varchar( 255 )
	SCPflag	varchar( 255 )
	reflag	varchar( 255 )
*	lindaIsAvailable	int DEFO 0
	jobsProgramPath	varchar( 255 )
	histProgramPath	varchar( 255 )
	killProgramPath	varchar( 255 )
*	showstartPath	varchar( 255 ) DEFO 'not available'
*	scheduler	enum
	siteAcronym	varchar( 10 ) DEFO ''
	description	varchar( 255 ) DEFO ''
*	system	varchar( 255 )
*	totalNodes	bigint
	peakPerformance	double DEFO 0
*	memory	int
	scratchDisk	varchar( 255 ) DEFO '0'
	webSite	varchar( 255 ) DEFO 'http://www.gridchem.org'
*	CPULoad	int DEFO 0
*	diskLoad	int DEFO 0
*	memoryLoad	int DEFO 0
*	queueLoad	int DEFO 0
*	jobsRunning	int DEFO 0
*	jobsQueued	int DEFO 0
*	jobsOther	int DEFO 0
*	lastUpdated	timestamp DEFO CURRENT_TIMESTAMP
Indexes
Pk	pk_computeresources	ON computeResourceID

Columns
*	DN	varchar( 255 ) DEFO ''
*	userID	int DEFO 0
	lastUpdated	datetime
	created	datetime
Indexes
Pk	pk_dns	ON DN, userID

Columns
*	id	int AUTOINCREMENT
*	userId	int
*	uuid	varchar( 255 )
*	localPath	varchar( 255 )
	remotePath	varchar( 255 ) DEFO '0'
*	jobId	int
*	length	int
*	created	datetime DEFO '2007-04-01 12:00:00'
*	lastUpdated	timestamp DEFO CURRENT_TIMESTAMP
	description	varchar( 255 ) DEFO ''
Indexes
Pk	pk_files	ON id

Columns
*	id	int AUTOINCREMENT
*	jobID	int
*	type	enum DEFO 'EMAIL'
*	status	enum DEFO 'SCHEDULED'
	subject	varchar( 255 )
	message	text
	created	datetime
	lastUpdated	datetime
	grmsJobStatusNotificationID	varchar( 255 ) DEFO ''
*	delivered	int DEFO 0
Indexes
Pk	pk_jobnotifications	ON id

Columns
*	jobID	int AUTOINCREMENT
	localJobID	varchar( 255 )
*	grmsJobID	varchar( 255 ) DEFO 'UNKNOWN'
*	name	varchar( 255 )
*	researchProjectName	varchar( 255 )
*	allocationName	varchar( 255 )
	scratchDir	text
*	requestedCPUs	int
*	requestedCpuTime	datetime
*	requestedMemory	int
	created	datetime
*	queueID	int
*	projectID	int
*	userID	int
	cost	double
	startTime	datetime DEFO '3000-01-01 12:00:00'
	stopTime	datetime DEFO '3000-01-01 12:00:00'
*	status	enum DEFO 'INITIAL'
*	usedCPUTime	double DEFO 0
	usedWallTime	double DEFO 0
*	lastUpdated	timestamp DEFO CURRENT_TIMESTAMP
*	usedCPUs	int DEFO 0
*	computeResourceID	varchar( 11 ) DEFO ''
*	softwareResourceID	varchar( 11 ) DEFO ''
*	storageResourceID	int DEFO 23
	input	mediumtext
*	isMultiinput	bit DEFO 0
	metaData	mediumtext
*	cellNotify	int DEFO 0
*	imNotify	int DEFO 0
*	hidden	int DEFO 0
*	deleted	int DEFO 0
	workflowID	int
Indexes
Pk	pk_jobs	ON jobID

Columns
*	networkResourceID	int DEFO 0
	mask	varchar( 30 )
	networkName	varchar( 255 )
	bandwidth	float( 12, 0 )
	latency	float( 12, 0 )
	bwMaeForecast	float( 12, 0 )
	bwMseError	float( 12, 0 )
	bwMaeError	float( 12, 0 )
	bwMSeForecast	float( 12, 0 )
	ltMaeForecast	float( 12, 0 )
	ltMaeError	float( 12, 0 )
	ltMseForecast	float( 12, 0 )
	ltMseError	float( 12, 0 )
*	toResourceID	int DEFO 1
*	fromResourceID	int DEFO 1
Indexes
Pk	pk_networkresources	ON networkResourceID

Columns
*	nodeID	int AUTOINCREMENT
*	computeResourceID	int DEFO 0
	CPUSpeed	bigint
	CPUsPerNode	bigint
	memoryPerNode	bigint
	memoryAvailable	bigint
	ramTotal	bigint
	ramAvailable	bigint
	occurances	bigint
	localDiskSpace	bigint
	localDiskDir	varchar( 255 )
	accessByQueues	varchar( 255 )
	swapSpace	bigint
	created	datetime
	lastUpdated	datetime
Indexes
Pk	pk_nodes	ON nodeID

Columns
*	id	int AUTOINCREMENT
*	projectId	int DEFO 0
*	renewalDate	datetime DEFO '2008-03-11 12:00:00'
*	expirationDate	datetime DEFO '2008-03-11 12:00:00'
*	created	date DEFO '2008-03-11'
	allocationAmount	double
Indexes
Pk	pk_projectrenewals	ON id

Columns
*	ID	int AUTOINCREMENT
*	projectID	int DEFO 0
*	resourceID	int DEFO 0
*	allocationName	varchar( 255 ) DEFO ''
*	SUsLocalAwarded	double DEFO 0
*	SUsLocalUsed	double DEFO 0
*	SUsLocalBalance	double DEFO 0
*	startDate	datetime DEFO '2006-04-01 00:00:00'
*	endDate	datetime DEFO '2007-09-30 00:00:00'
*	enabled	bit DEFO 1
Indexes
Pk	pk_projectresource	ON ID

Columns
*	projectID	int AUTOINCREMENT
*	projectName	varchar( 80 ) DEFO 'unknown'
*	projectType	enum DEFO 'COMMUNITY'
	funder	text
	projectDescription	text
	comment	text
	sponsorClass	enum DEFO 'UNIVERSITY'
	sponsorName	varchar( 255 ) DEFO 'self'
*	projectStatus	enum DEFO 'PENDING'
*	projectStart	datetime DEFO '2007-04-01 00:00:01'
*	projectEnd	datetime DEFO '2007-04-01 00:00:01'
	createdByUserID	int DEFO 0
*	lastUpdated	timestamp DEFO CURRENT_TIMESTAMP
*	isDefault	int DEFO 0
	SUsRequested	bigint DEFO 0
	SUsAwarded	double DEFO 0
	SUsUsed	double DEFO 0
	memoryMBperCPU	int DEFO 0
	SUsPerJob	int DEFO 0
	diskGBperJob	int DEFO 0
	CPUsPerJob	int DEFO 0
	extProjectHostList	text
	appsRequested	text
*	created	datetime DEFO '0000-00-00 00:00:00'
*	enabled	bit DEFO 0
Indexes
Pk	pk_projects	ON projectID
U	name	ON projectName

Columns
*	queueID	int AUTOINCREMENT
	computeResourceID	int
*	name	varchar( 255 ) DEFO 'default'
	comment	varchar( 255 )
*	isDefault	int DEFO 1
*	status	enum DEFO 'UP'
*	assignedCPUNumber	bigint DEFO 1
*	queueLimit	bigint DEFO 100
*	runLimit	bigint DEFO 10
*	wallClockLimit	datetime DEFO '1970-01-05 00:00:00'
*	running	int DEFO 0
*	waiting	int DEFO 0
*	other	int DEFO 0
*	cpuTimeLimit	datetime DEFO '1970-01-05 00:00:00'
*	maxCPUs	int DEFO 1
*	maxNodes	int DEFO 1
*	lastUpdated	datetime DEFO '2007-05-01 12:10:00'
*	memLimitPerCPU	bigint DEFO 2000
*	valid	bit DEFO 1
*	canShareNode	tinyint DEFO 0
Indexes
Pk	pk_queues	ON queueID

Columns
*	resourceID	int AUTOINCREMENT
*	name	varchar( 255 ) DEFO ''
*	comment	text
	type	enum DEFO 'COMPUTE'
*	IPAddress	varchar( 255 ) DEFO 'not applicable'
	created	datetime DEFO '2006-01-19 11:53:00'
	lastDownTime	datetime DEFO '2006-01-19 11:53:00'
	lastUpdated	datetime DEFO '2006-01-19 11:53:00'
	status	enum DEFO 'UNKNOWN'
*	hostname	varchar( 255 ) DEFO 'not applicable'
*	valid	int DEFO 1
*	siteID	int
Indexes
Pk	pk_resources	ON resourceID

Columns
*	id	int AUTOINCREMENT
*	token	varchar( 255 )
	destroyed	datetime
*	expires	datetime
*	created	datetime
	projectId	int
	macAddress	varchar( 255 ) DEFO ''
*	userId	int
*	proxy	text
*	type	enum
Indexes
Pk	pk_sessions	ON id
U	token	ON token

Columns
*	siteID	int AUTOINCREMENT
	acronym	varchar( 10 )
	name	varchar( 128 )
	description	text
	lastUpdated	datetime
Indexes
Pk	pk_sites	ON siteID

Columns
*	softwareResourceID	int AUTOINCREMENT
*	moduleID	int DEFO 0
*	authorName	varchar( 255 ) DEFO 'set_me'
*	authorEmail	varchar( 255 ) DEFO 'set_me'
*	authorStreet	varchar( 255 ) DEFO 'set_me'
	authorCity	varchar( 255 )
*	authorState	varchar( 100 ) DEFO 'set_me'
*	authorZipCode	varchar( 10 ) DEFO 'set_me'
*	acronym	varchar( 20 ) DEFO 'set_me'
*	versionRelease	varchar( 255 ) DEFO 'set_me'
*	versionDate	datetime DEFO '0000-00-00 00:00:00'
	shortDescription	varchar( 80 ) DEFO ''
	longDescription	varchar( 255 ) DEFO ''
*	name	varchar( 255 ) DEFO 'chemistry_app'
	helpWebSite	varchar( 255 ) DEFO 'not available'
*	inputFileExtension	varchar( 8 ) DEFO '.inp'
*	comment	varchar( 255 )
*	created	datetime
*	lastUpdated	timestamp DEFO CURRENT_TIMESTAMP
Indexes
Pk	pk_software	ON softwareResourceID

Columns
*	inputFileID	int AUTOINCREMENT
*	softwareResourceID	int DEFO 0
*	gridchemjobID	int UNSIGNED DEFO 0
*	inputfiledescription	enum DEFO 'molecularStructure'
*	suffix	varchar( 255 ) DEFO ''
*	pathname	text
*	lastUpdated	datetime DEFO '0000-00-00 00:00:00'
Indexes
Pk	pk_softwareinputfiles	ON inputFileID, softwareResourceID

Columns
*	softwareResourceID	int DEFO 11
*	computeResourceID	int DEFO 100
*	compileDate	datetime DEFO '0000-00-00 00:00:00'
*	compilerName	varchar( 255 ) DEFO 'set_me'
*	compilerVersion	varchar( 255 ) DEFO '-1'
*	homeDir	varchar( 255 ) DEFO 'set_me'
*	module	varchar( 255 ) DEFO 'set_me'
*	softenv	varchar( 255 ) DEFO ''
*	executablePath	varchar( 255 ) DEFO 'set_me'
*	scriptPath	varchar( 255 ) DEFO 'set_me'
*	arguments	varchar( 255 ) DEFO 'set_me'
*	usage	varchar( 255 ) DEFO 'set_me'
*	licenseType	varchar( 80 ) DEFO 'set_me'
*	totalLicenses	int DEFO 0
*	licenseInfo	varchar( 255 ) DEFO '-1'
*	licenseServer	varchar( 255 ) DEFO 'set_me'
*	startupEnvironment	varchar( 255 ) DEFO 'set_me'
*	argComments	varchar( 255 ) DEFO 'set_me'
*	name	varchar( 255 ) DEFO 'chemistry_app'
*	lastUpdated	datetime DEFO '1900-01-01 00:00:00'
*	valid	int DEFO 1
Indexes
	computeResourceID	ON computeResourceID

Columns
*	storageResourceID	int AUTOINCREMENT
	diskTotalSpace	bigint DEFO 0
	diskFreeSpace	bigint DEFO 0
	diskSeekTime	bigint DEFO 5
	diskRpm	bigint DEFO 5
*	access	enum DEFO 'GSIFTP'
	quota	bigint
*	purgeData	bit DEFO 0
*	backup	bit DEFO 0
	webSite	varchar( 255 )
Indexes
Pk	pk_storageresources	ON storageResourceID

Columns
*	ID	int AUTOINCREMENT
*	userID	int DEFO 0
*	projectID	int DEFO 0
*	userType	enum DEFO 'USER'
*	SUsUsedUser	double DEFO 0
*	SUsLimitUser	double DEFO 0
*	SUsBalanceUser	double DEFO 0
*	mss	int
*	enabled	bit DEFO 0
Indexes
Pk	pk_userproject	ON ID

Columns
*	userID	int DEFO 0
*	projectID	int DEFO 0
*	resourceID	int DEFO 0
*	allocationName	varchar( 255 ) DEFO ''
*	loginName	varchar( 255 ) DEFO ''
*	localUserType	enum DEFO 'USER'
*	SUsLocalUserAwarded	double DEFO 0
*	SUsLocalUserUsed	double DEFO 0
*	SUsLocalUserBalance	double DEFO 0
*	banned	bit DEFO 0
*	enabled	bit DEFO 1
Indexes
Pk	pk_userprojectresource	ON userID, projectID, resourceID, allocationName

Columns
*	userID	int AUTOINCREMENT
*	firstName	varchar( 80 ) DEFO ''
*	lastName	varchar( 80 ) DEFO ''
	middleInitial	varchar( 5 ) DEFO ''
*	userName	varchar( 80 ) DEFO ''
*	initialPassword	varchar( 255 ) DEFO ''
*	password	varchar( 255 ) DEFO ''
*	privilege	enum DEFO 'USER'
*	created	datetime DEFO '0000-00-00 00:00:00'
*	createdByUserID	int DEFO 0
*	active	int DEFO 0
*	researchStatus	enum DEFO 'FACULTY'
*	institute	varchar( 255 ) DEFO ''
*	department	varchar( 255 ) DEFO ''
*	addr1	varchar( 80 ) DEFO ''
	addr2	varchar( 80 ) DEFO ''
*	city	varchar( 255 ) DEFO ''
*	state	varchar( 100 ) DEFO ''
*	zipCode	varchar( 10 ) DEFO ''
*	country	varchar( 80 ) DEFO ''
*	phone	varchar( 40 ) DEFO ''
	cell	varchar( 14 ) DEFO 'none provided'
	imHandle	varchar( 50 ) DEFO 'none provided'
	fax	varchar( 40 ) DEFO ''
*	email	varchar( 255 ) DEFO ''
	comment	text
*	dataVersion	varchar( 11 ) DEFO '0.2.0'
*	lastUpdated	datetime DEFO '2006-04-01 00:00:00'
*	resetKey	varchar( 21 ) DEFO ''
*	enabled	smallint DEFO 0
Indexes
Pk	pk_users	ON userID
U	uname	ON userName

Columns
*	visualizationResourceID	int DEFO 1
*	numNodes	bigint DEFO 1
*	numProcessors	bigint DEFO 1
	peakPerformance	float( 12, 0 )
	memory	bigint
	scratchDisk	varchar( 255 ) DEFO '/u/ac/'
	peakPolygons	bigint
	graphicsHw	varchar( 255 ) DEFO 'unknown'

Columns
*	id	int AUTOINCREMENT
*	name	varchar( 255 )
	description	varchar( 255 )
	startTime	datetime
	stopTime	datetime
*	status	enum DEFO 'INITIAL'
	lastUpdated	timestamp
*	hidden	bit DEFO 0
*	deleted	bit DEFO 0
*	created	datetime
*	userID	int
Indexes
Pk	pk_workflows	ON id

GridChem DB Layout with Groups

Table blacklist

Table computeresources

Table dns

Table files

Table jobnotifications

Table jobs

Table networkresources

Table nodes

Table preferences

Table projectrenewals

Table projectresource

Table projects

Table queues

Table resources

Table sessions

Table sites

Table software

Table softwareinputfiles

Table softwareinstallation

Table softwaremodules

Table storageresources

Table userproject

Table userprojectresource

Table users

Table visualizationresources

Table workflows

Columns
*	userID	int DEFO 0
*	softwareID	int DEFO 0
*	created	date DEFO '0000-00-00'
*	lastUpdated	date DEFO '0000-00-00'
*	enabled	bit DEFO 1
Indexes
Pk	pk_blacklist	ON userID, softwareID

Columns
*	ID	int AUTOINCREMENT
*	userID	int
	preferences	text
*	lastUpdated	timestamp DEFO CURRENT_TIMESTAMP
*	created	datetime DEFO '2006-04-27 14:24:00'
Indexes
Pk	pk_preferences	ON ID
U	user	ON userID