[AccessD] Re: Code Librarian 2

Here is the current SQL for the tables:

CREATE TABLE [dbo].[tbl_CodeBase] (
         [CodeBaseID] [int] IDENTITY (1, 1) NOT NULL ,
         [Category] [varchar] (15) NOT NULL ,
         [Short_Desc] [varchar] (75) NOT NULL ,
         [Contributor_Name] [varchar] (50) NULL ,
         [Contributor_Email] [varchar] (50) NULL ,
         [Full_Desc] [text] NOT NULL ,
         [Code_Text] [text] NOT NULL ,
         [KnownIssues] [text] NULL ,
         [Audt_Create_Dt] [datetime] NOT NULL ,
         [Audt_Create_UID] [varchar] (20) NOT NULL ,
         [Audt_Modify_Dt] [datetime] NULL ,
         [Audt_Modify_UID] [varchar] (20) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[tbl_CodeBaseReferences] (
         [CodeBaseReferenceID] [int] IDENTITY (1, 1) NOT NULL ,
         [CodeBaseID] [int] NOT NULL ,
         [RequiredReference] [varchar] (75) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tbl_CodeBaseSoftware] (
         [CodeBaseSoftwareID] [int] IDENTITY (1, 1) NOT NULL ,
         [CodeBaseID] [int] NOT NULL ,
         [SoftwareVersionID] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tbl_CodebaseFiles] (
         [Code_Link_ID] [int] IDENTITY (1, 1) NOT NULL ,
         [CodeBaseID] [int] NOT NULL ,
         [CodeFile] [binary] (50) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tbl_CodebaseKeyword] (
         [CodeBaseKeywordID] [int] IDENTITY (1, 1) NOT NULL ,
         [CodeBaseID] [int] NOT NULL ,
         [Keyword] [varchar] (10) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tlkp_Category] (
         [Category] [varchar] (15) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tlkp_SoftwareName] (
         [SoftwareName] [varchar] (20) NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[tlkp_SoftwareVersion] (
         [SoftwareVersionID] [int] IDENTITY (1, 1) NOT NULL ,
         [SoftwareName] [varchar] (20) NOT NULL ,
         [SoftwareVersion] [varchar] (10) NOT NULL
) ON [PRIMARY]
GO

If you catch something that I forgot, drop me a note and I will
get it in there.

Robert

At 02:12 AM 2/6/2004 -0600, you wrote:
>Date: Thu, 5 Feb 2004 16:27:29 -0600
>From: "John Bartow" <john at winhaven.net>
>Subject: RE: [AccessD] Re: Code Librarian 2
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID: <LPBBLAKMHEDAKJKENHKICECOFBAA.john at winhaven.net>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>Pedro,
>References needed is a good one. Right now I put it into the details and it
>isn't easy to find there.
>Contributor is a better description for what I listed as "Who (or where) it
>came from"
>
>John
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Pedro Janssen
> > Sent: Thursday, February 05, 2004 3:25 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Re: Code Librarian 2
> >
> >
> > Hello,
> >
> > The fields that you mentioned and the fields that
> > John Bartow suggested are ok with me.
> > Other fields that i would recomment are:
> > references (that are needed), expected problems,
> > Contributor, Email.
> >
> > Greetings
> >
> > Pedro