Code tao csdl_môn họ Hệ quản trị cơ sở dữ liệu

Link download:[You must be registered and logged in to see this link.]


Create database qlvattu
on primary
(Name=qlvattu_data,
Filename='G:\qlvattu.MDF',
Size=50MB,
Maxsize=200MB,
FileGrowth=10%)
Log on
(Name=qlvattu_Log,
Filename='G:\qlvattu.LDF',
Size=10MB,
Maxsize=Unlimited,
Filegrowth=5MB)
go
use qlvattu
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTDONDH_VATTU]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CTDONDH] DROP CONSTRAINT FK_CTDONDH_VATTU
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTPNHAP_VATTU]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CTPNHAP] DROP CONSTRAINT FK_CTPNHAP_VATTU
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTPxuat_VATTU]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CTPxuat] DROP CONSTRAINT FK_CTPxuat_VATTU
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Ton Kho_VATTU]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[TonKho] DROP CONSTRAINT FK_Ton Kho_VATTU
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_DONDH_NHACC]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[DONDH] DROP CONSTRAINT FK_DONDH_NHACC
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTPxuat_PXUAT]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CTPxuat] DROP CONSTRAINT FK_CTPxuat_PXUAT
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTDONDH_DONDH]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CTDONDH] DROP CONSTRAINT FK_CTDONDH_DONDH
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_PNHAP_DONDH]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[PNHAP] DROP CONSTRAINT FK_PNHAP_DONDH
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTPNHAP_PNHAP]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CTPNHAP] DROP CONSTRAINT FK_CTPNHAP_PNHAP
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CTPNHAP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CTPNHAP]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CTDONDH]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CTDONDH]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PNHAP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PNHAP]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CTPxuat]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CTPxuat]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DONDH]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[DONDH]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TonKho]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TonKho]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VATTU]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[VATTU]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NHACC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NHACC]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PXUAT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PXUAT]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[temp1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[temp1]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vattu_temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[vattu_temp]
GO

CREATE TABLE [dbo].[VATTU] (
[mavtu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[tenvtu] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[dvtinh] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[phantram] [real] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[NHACC] (
[MANHCC] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[TENNHACC] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DIACHI] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DIENTHOAI] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PXUAT] (
[SoPx] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Ngayxuat] [datetime] NULL ,
[TenKh] [char] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[temp1] (
[tenvtu] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[mavtu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[sopx] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[dgxuat] [money] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[vattu_temp] (
[mavtu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[tenvtu] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CTPxuat] (
[SoPx] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[MaVTu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Slxuat] [int] NULL ,
[Dgxuat] [money] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[DONDH] (
[SODH] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[NGAYDH] [datetime] NULL ,
[MANHACC] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[TonKho] (
[NamThang] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[MaVTu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SLDau] [int] NULL ,
[TongSLN] [int] NULL ,
[TongSLX] [int] NULL ,
[SLCuoi] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CTDONDH] (
[SODH] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[MAVTU] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SLDAT] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[PNHAP] (
[SOPN] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[NGAYNHAP] [datetime] NULL ,
[SODH] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[CTPNHAP] (
[SoPn] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[MavTu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[SlNhap] [int] NULL ,
[DgNhap] [money] NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[VATTU] WITH NOCHECK ADD
CONSTRAINT [PK_VATTU] PRIMARY KEY CLUSTERED
(
[mavtu]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[NHACC] WITH NOCHECK ADD
CONSTRAINT [PK__NHACC__1A14E395] PRIMARY KEY CLUSTERED
(
[MANHCC]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[PXUAT] WITH NOCHECK ADD
CONSTRAINT [PK_PXUAT] PRIMARY KEY CLUSTERED
(
[SoPx]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CTPxuat] WITH NOCHECK ADD
CONSTRAINT [PK_CTPxuat] PRIMARY KEY CLUSTERED
(
[SoPx],
[MaVTu]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[DONDH] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[SODH]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[TonKho] WITH NOCHECK ADD
CONSTRAINT [PK_Ton Kho] PRIMARY KEY CLUSTERED
(
[NamThang],
[MaVTu]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CTDONDH] WITH NOCHECK ADD
CONSTRAINT [PK_CTDONDH] PRIMARY KEY CLUSTERED
(
[SODH],
[MAVTU]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[PNHAP] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[SOPN]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CTPNHAP] WITH NOCHECK ADD
CONSTRAINT [PK_CTPNHAP] PRIMARY KEY CLUSTERED
(
[SoPn],
[MavTu]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CTPxuat] ADD
CONSTRAINT [FK_CTPxuat_PXUAT] FOREIGN KEY
(
[SoPx]
) REFERENCES [dbo].[PXUAT] (
[SoPx]
),
CONSTRAINT [FK_CTPxuat_VATTU] FOREIGN KEY
(
[MaVTu]
) REFERENCES [dbo].[VATTU] (
[mavtu]
)
GO

ALTER TABLE [dbo].[DONDH] ADD
CONSTRAINT [FK_DONDH_NHACC] FOREIGN KEY
(
[MANHACC]
) REFERENCES [dbo].[NHACC] (
[MANHCC]
)
GO

ALTER TABLE [dbo].[TonKho] ADD
CONSTRAINT [FK_Ton Kho_VATTU] FOREIGN KEY
(
[MaVTu]
) REFERENCES [dbo].[VATTU] (
[mavtu]
)
GO

ALTER TABLE [dbo].[CTDONDH] ADD
CONSTRAINT [FK_CTDONDH_DONDH] FOREIGN KEY
(
[SODH]
) REFERENCES [dbo].[DONDH] (
[SODH]
),
CONSTRAINT [FK_CTDONDH_VATTU] FOREIGN KEY
(
[MAVTU]
) REFERENCES [dbo].[VATTU] (
[mavtu]
)
GO

ALTER TABLE [dbo].[PNHAP] ADD
CONSTRAINT [FK_PNHAP_DONDH] FOREIGN KEY
(
[SODH]
) REFERENCES [dbo].[DONDH] (
[SODH]
)
GO

ALTER TABLE [dbo].[CTPNHAP] ADD
CONSTRAINT [FK_CTPNHAP_PNHAP] FOREIGN KEY
(
[SoPn]
) REFERENCES [dbo].[PNHAP] (
[SOPN]
),
CONSTRAINT [FK_CTPNHAP_VATTU] FOREIGN KEY
(
[MavTu]
) REFERENCES [dbo].[VATTU] (
[mavtu]
)
GO