USE [POSTOFFICE]
GO

/****** Object:  Table [dbo].[TRACKING]    Script Date: 2018-03-17 01:05:10 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TRACKING](
	[Tracking_no] [nchar](10) NOT NULL,
	[Sender_ID] [nchar](10) NOT NULL,
	[Receiver_ID] [nchar](10) NOT NULL,
	[Failed_to_deliver] [bit] NULL,
	[Status] [nvarchar](max) NOT NULL,
	[Delivered_Date] [date] NULL,
	[Delivery_Date] [date] NOT NULL CHECK (Delivery_Date >= GetDate()),
	[Post_Office_ID] [nchar](10) NULL,
 CONSTRAINT [PK_TRACKING] PRIMARY KEY CLUSTERED
(
	[Tracking_no] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO