一个基于C#实现的Postgres数据库向导式创建的程序代码

CREATE TABLE Min_Application ( Application_Id UUID NOT NULL PRIMARY KEY, Application_Name varchar (50) NOT NULL, Unique (Application_Name) ) WITH (OIDS=FALSE); COMMENT ON TABLE Min_Application IS 'Application table'; COMMENT ON COLUMN Min_Application.Application_Id IS 'Id of Application table.'; CREATE TABLE Min_DBNames ( DBNames_Id UUID NOT NULL PRIMARY KEY, DBNames_Name varchar (50) NOT NULL , Unique (DBNames_Name) ) WITH (OIDS=FALSE); CREATE TABLE Min_OpSys ( OpSys_Id UUID NOT NULL PRIMARY KEY, OpSys_Name varchar (50) NOT NULL, Unique (OpSys_Name) ) WITH (OIDS=FALSE); CREATE TABLE Min_Build ( Build_Id UUID NOT NULL PRIMARY KEY, Build_Number varchar (50) NOT NULL, Build_Application varchar (50) NOT NULL, FOREIGN KEY (Build_Application) REFERENCES Min_application (application_name) ) WITH (OIDS=FALSE); CREATE TABLE Min_Module ( Module_Id UUID NOT NULL PRIMARY KEY , Module_Name varchar (50) NOT NULL, Module_Application varchar (50) NOT NULL, UNIQUE (module_name), UNIQUE (module_name, module_application), FOREIGN KEY (module_application) REFERENCES Min_application (application_name) ) WITH (OIDS=FALSE); CREATE TABLE Min_SubModule ( SubModule_Id UUID NOT NULL PRIMARY KEY, SubModule_Name varchar (50) NOT NULL, SubModule_Module varchar (50) NOT NULL, UNIQUE (SubModule_Name, SubModule_Module), FOREIGN KEY (SubModule_Module) REFERENCES Min_Module (Module_Name) ) WITH (OIDS=FALSE); CREATE TABLE Min_Priority ( Pri_Id UUID NOT NULL PRIMARY KEY, Pri_Name varchar (50) NOT NULL, UNIQUE (Pri_Name) ) WITH (OIDS=FALSE); CREATE TABLE Min_Severity ( Sev_Id UUID NOT NULL PRIMARY KEY, Sev_Name varchar (50) NOT NULL, UNIQUE (Sev_Name) ) WITH (OIDS=FALSE); CREATE TABLE Min_Status ( Status_Id UUID NOT NULL PRIMARY KEY, Status_Name varchar (50) NOT NULL, UNIQUE (Status_Name) ) WITH (OIDS=FALSE); CREATE TABLE Min_User ( User_Id UUID NOT NULL PRIMARY KEY, User_Name varchar (50) NOT NULL, User_Password varchar (50) NOT NULL, User_Email varchar (50), User_Role varchar (50), UNIQUE (User_Name) ) WITH (OIDS=FALSE); CREATE TABLE Min_Version ( Version_Id UUID NOT NULL PRIMARY KEY, Version_Number varchar (50) NOT NULL, Version_Application varchar (50) NOT NULL, UNIQUE (Version_Number, Version_Application), FOREIGN KEY (Version_Application) REFERENCES Min_application (application_name) ) WITH (OIDS=FALSE); CREATE TABLE Min_Customer ( Customer_Id UUID NOT NULL PRIMARY KEY, Customer_Name varchar (50) NOT NULL, UNIQUE (Customer_Name) ) WITH (OIDS=FALSE); CREATE TABLE Min_Defect ( Defect_Id Serial PRIMARY KEY, Defect_Summary varchar (100) NOT NULL, Defect_Description varchar (1000) NOT NULL, Defect_Priority varchar (50) NOT NULL, Defect_Severity varchar (50) NOT NULL, Defect_Application varchar (50) NOT NULL, Defect_Status varchar (50) NOT NULL, Defect_ReportedBuild varchar (50) NOT NULL, Defect_Reproducible integer, Defect_ReportedBy varchar (50) NOT NULL, Defect_ReportedVersion varchar (50) NOT NULL, Defect_ReportedDate timestamp NOT NULL, Defect_Blocking integer, Defect_ClientOS varchar (50) NOT NULL, Defect_AppServerOS varchar (50) NOT NULL, Defect_Module varchar (50) NOT NULL, Defect_SubModule varchar (50) NOT NULL, Defect_Database varchar (50) NOT NULL, Defect_CustomerName varchar (50) NOT NULL, Defect_ClosedVersion varchar (50) NOT NULL, Defect_ClosedDate timestamp, Defect_ClosedBuild varchar (50) NOT NULL, Defect_PlannedClosingVersion varchar (50) NOT NULL, Defect_RDComments varchar (50) NOT NULL, Defect_QATester varchar (50) NOT NULL, Defect_AssignedTo varchar (50) NOT NULL, Defect_RegressedDate timestamp ) WITH (OIDS=FALSE); CREATE TABLE Min_GridOrder ( GridOrder_Id UUID NOT NULL PRIMARY KEY, GridOrder_UserName varchar (50) NOT NULL, GridOrder_Type integer NOT NULL, GridOrder_Seq integer NOT NULL, GridOrder_DispName varchar (100) NOT NULL, GridOrder_ColName varchar (100) NOT NULL, GridOrder_Width integer ) WITH (OIDS=FALSE); CREATE TABLE Min_Role ( Role_Id UUID NOT NULL PRIMARY KEY, Role_Name varchar (50) NOT NULL ) WITH (OIDS=FALSE); CREATE TABLE Min_StatusFlow ( StatusFlow_Id UUID NOT NULL PRIMARY KEY, StatusFlow_NameFrom varchar (50) NOT NULL, StatusFlow_NameTo varchar (50) NOT NULL, StatusFlow_Role varchar (50) NOT NULL ) WITH (OIDS=FALSE); CREATE TABLE Min_ScreenAccess ( ScreenAccess_Id UUID NOT NULL PRIMARY KEY, ScreenAccess_Role varchar (50) NOT NULL, ScreenAccess_ScreenName varchar (50) NOT NULL, ScreenAccess_Access varchar (50) NOT NULL ) WITH (OIDS=FALSE); CREATE TABLE Min_DefectDefaults ( Defect_Id Serial PRIMARY KEY, Defect_Summary varchar (100) NOT NULL, Defect_Description varchar (1000) NOT NULL, Defect_Priority varchar (50) NOT NULL, Defect_Severity varchar (50) NOT NULL, Defect_Application varchar (50) NOT NULL, Defect_Status varchar (50) NOT NULL, Defect_ReportedBuild varchar (50) NOT NULL, Defect_Reproducible integer, Defect_ReportedBy varchar (50) NOT NULL, Defect_ReportedVersion varchar (50) NOT NULL, Defect_ReportedDate timestamp NOT NULL, Defect_Blocking integer, Defect_ClientOS varchar (50) NOT NULL, Defect_AppServerOS varchar (50) NOT NULL, Defect_Module varchar (50) NOT NULL, Defect_SubModule varchar (50) NOT NULL, Defect_Database varchar (50) NOT NULL, Defect_CustomerName varchar (50) NOT NULL, Defect_ClosedVersion varchar (50) NOT NULL, Defect_ClosedDate timestamp, Defect_ClosedBuild varchar (50) NOT NULL, Defect_PlannedClosingVersion varchar (50) NOT NULL, Defect_RDComments varchar (50) NOT NULL, Defect_QATester varchar (50) NOT NULL, Defect_AssignedTo varchar (50) NOT NULL, Defect_RegressedDate timestamp ) WITH (OIDS=FALSE); CREATE TABLE Min_AInfo ( AInfo_Id UUID NOT NULL PRIMARY KEY, AInfo_Name varchar (50) NOT NULL, AInfo_Version varchar (50) NOT NULL ) WITH (OIDS=FALSE); CREATE TABLE Min_Reports ( Reports_Id UUID NOT NULL PRIMARY KEY, Reports_Description varchar (50) NOT NULL, Reports_Name varchar (50) NOT NULL ) WITH (OIDS=FALSE);