SELECT * FROM eCMS_MST_CATALOGUE
SELECT * FROM eCMS_MST_CATALOGUE_ITEM

USE [ECMS_TESTING]
GO
/****** Object:  Table [dbo].[ECMS_MST_CATALOGUE]    Script Date: 07/01/2011 14:27:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ECMS_MST_CATALOGUE](
    [CATALOGUE_ID] [bigint] IDENTITY(1,1) NOT NULL,
    [CATALOGUE_CODE] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [CATALOGUE_ITEM_DESCRIPTION] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ITEM_CODE] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ITEM_CATEGORY_CODE] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CATALOGUE_DESCRIPTION] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_ECMS_MST_ITEM_CATALOGUE] PRIMARY KEY CLUSTERED
(
    [CATALOGUE_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]


USE [ECMS_TESTING]
GO
/****** Object:  Table [dbo].[ECMS_MST_CATALOGUE_ITEM]    Script Date: 07/01/2011 14:27:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ECMS_MST_CATALOGUE_ITEM](
    [CATALOGUE_ITEM_ID] [bigint] IDENTITY(1,1) NOT NULL,
    [CATALOGUE_CODE] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CATALOGUE_ITEM_DESCRIPTION] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_CODE] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_DESCRIPTION] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ITEM_RATE] [money] NOT NULL,
    [ITEM_QTY] [int] NOT NULL,
    [EFFECTIVE_FROM] [datetime] NOT NULL,
    [EFFECTIVE_TO] [datetime] NOT NULL,
    [REMARK_1] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [REMARK_2] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UPLOAD_SPECIFICATIONS] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [UPLOAD_IMAGE] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [VENDOR_ITEM_CODE] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 CONSTRAINT [PK_ECMS_MST_CATALOGUE_ITEM] PRIMARY KEY CLUSTERED
(
    [CATALOGUE_ITEM_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]