Difference between revisions of "Albatross Projects"
Jump to navigation
Jump to search
PeterHarding (talk | contribs) |
PeterHarding (talk | contribs) |
||
| Line 1: | Line 1: | ||
=Project Management Tool= | =Project Management Tool= | ||
==MySQL Tables== | |||
===ProjectRequest=== | |||
<pre> | |||
</pre> | |||
===ReleaseOrder=== | |||
<pre> | |||
DROP TABLE IF EXISTS ReleaseOrder; | |||
CREATE TABLE ReleaseOrder ( | |||
Title varchar(256) default null, | |||
RequestorName varchar(64) default null, | |||
RequestorEmail varchar(32) default null, | |||
RequestorPhone varchar(20) default null, | |||
RequestorMobile varchar(20) default null, | |||
VzB_ChangeManager varchar(32) default null, | |||
VzB_ProjectId varchar(32) default null, | |||
ProjectManager varchar(32) default null, | |||
AllocatedDate date, | |||
RelationshipManager varchar(32) default null, | |||
AAB_Ticket varchar(32) default null, | |||
SS_Number varchar(32) default null, | |||
RFS_Number varchar(32) default null, | |||
Description text, | |||
PropsalDocument varchar(64) default null, | |||
ProposalVersion varchar(20) default null, | |||
ProposalDate date, | |||
) TYPE=InnoDB; | |||
</pre> | |||
===Change Request=== | |||
<pre> | |||
DROP TABLE IF EXISTS ChangeRequest; | |||
CREATE TABLE ChangeRequest ( | |||
Title varchar(256) default null, | |||
AAB_Ticket varchar(32) default null, | |||
VzB_IMAC varchar(32) default null, | |||
RequestorName varchar(64) default null, | |||
RequestorEmail varchar(32) default null, | |||
RequestorPhone varchar(20) default null, | |||
RequestorMobile varchar(20) default null, | |||
SubmitterName varchar(64) default null, | |||
SubmitterEmail varchar(32) default null, | |||
SubmitterPhone varchar(20) default null, | |||
SubmitterMobile varchar(20) default null, | |||
SubmitterHDTicketNo varchar(32) default null, | |||
DesiredChangeDate date, | |||
Region varchar(32) default null, | |||
SubmitDate date, | |||
ChangeDescription text default null, | |||
EquipmentDescription text default null, | |||
Site1_AAB_TNS_SiteCode varchar(32) default null, | |||
Site1_Country varchar(32) default null, | |||
Site1_ContactPerson varchar(64) default null, | |||
Site1_ContactEmail varchar(32) default null, | |||
S1te1_ContactPhone varchar(20) default null, | |||
S1te1_ContactMobile varchar(20) default null, | |||
Site1_Description text default null, | |||
Site2_AAB_TNS_SiteCode varchar(32) default null, | |||
Site2_Country varchar(32) default null, | |||
Site2_ContactPerson varchar(64) default null, | |||
Site2_ContactEmail varchar(32) default null, | |||
S2te1_ContactPhone varchar(20) default null, | |||
S2te1_ContactMobile varchar(20) default null, | |||
Site2_Description text default null, | |||
DetailedDescription text default null, | |||
) TYPE=InnoDB; | |||
</pre> | |||
See... [Images:Project.zip] | See... [Images:Project.zip] | ||
Revision as of 09:10, 6 February 2008
Project Management Tool
MySQL Tables
ProjectRequest
ReleaseOrder
DROP TABLE IF EXISTS ReleaseOrder; CREATE TABLE ReleaseOrder ( Title varchar(256) default null, RequestorName varchar(64) default null, RequestorEmail varchar(32) default null, RequestorPhone varchar(20) default null, RequestorMobile varchar(20) default null, VzB_ChangeManager varchar(32) default null, VzB_ProjectId varchar(32) default null, ProjectManager varchar(32) default null, AllocatedDate date, RelationshipManager varchar(32) default null, AAB_Ticket varchar(32) default null, SS_Number varchar(32) default null, RFS_Number varchar(32) default null, Description text, PropsalDocument varchar(64) default null, ProposalVersion varchar(20) default null, ProposalDate date, ) TYPE=InnoDB;
Change Request
DROP TABLE IF EXISTS ChangeRequest; CREATE TABLE ChangeRequest ( Title varchar(256) default null, AAB_Ticket varchar(32) default null, VzB_IMAC varchar(32) default null, RequestorName varchar(64) default null, RequestorEmail varchar(32) default null, RequestorPhone varchar(20) default null, RequestorMobile varchar(20) default null, SubmitterName varchar(64) default null, SubmitterEmail varchar(32) default null, SubmitterPhone varchar(20) default null, SubmitterMobile varchar(20) default null, SubmitterHDTicketNo varchar(32) default null, DesiredChangeDate date, Region varchar(32) default null, SubmitDate date, ChangeDescription text default null, EquipmentDescription text default null, Site1_AAB_TNS_SiteCode varchar(32) default null, Site1_Country varchar(32) default null, Site1_ContactPerson varchar(64) default null, Site1_ContactEmail varchar(32) default null, S1te1_ContactPhone varchar(20) default null, S1te1_ContactMobile varchar(20) default null, Site1_Description text default null, Site2_AAB_TNS_SiteCode varchar(32) default null, Site2_Country varchar(32) default null, Site2_ContactPerson varchar(64) default null, Site2_ContactEmail varchar(32) default null, S2te1_ContactPhone varchar(20) default null, S2te1_ContactMobile varchar(20) default null, Site2_Description text default null, DetailedDescription text default null, ) TYPE=InnoDB;
See... [Images:Project.zip]