Untitled
unknown
sql
3 years ago
34 kB
2
Indexable
GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[INVOICE]( [ID] [int] IDENTITY(1,1) NOT NULL, [DATE] [datetime2](7) NOT NULL, [SALES_PERSON_ID] [int] NOT NULL, [CUSTOMER_ID] [int] NOT NULL, [OFFICE_ID] [int] NOT NULL, [WAREHOUSE_ID] [int] NOT NULL, [INVOICE_NUMBER] [nvarchar](50) NOT NULL, [TAX_NUMBER] [nvarchar](11) NOT NULL, [TAX_OFFICE] [nvarchar](50) NOT NULL, [ADDRESS_ID] [int] NOT NULL, [MERSIS_NO] [nvarchar](50) NOT NULL, [DUE_DATE] [datetime2](7) NOT NULL, [PAYMENT_METHOD] [nvarchar](50) NOT NULL, [PAYMENT_STATUS] [bit] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_INVOICE] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ADDRESS]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [TOWN_ID] [int] NOT NULL, [BUSINESS_ENTITY_ID] [int] NULL, [AVENUE] [nvarchar](50) NULL, [BLOCK] [nvarchar](50) NULL, [STREET] [nvarchar](50) NULL, [POSTCODE] [nvarchar](50) NULL, [TEL] [nvarchar](50) NULL, [EMAIL] [nvarchar](100) NULL, [IS_DEFAULT] [bit] NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_ADDRESS] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BANK_ACCOUNT]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [BUSINESS_ENTITY_ID] [int] NULL, [IBAN] [nvarchar](50) NULL, [ACCOUNT_NUMBER] [nvarchar](50) NULL, [BANK_ID] [int] NOT NULL, [IS_DEFAULT] [bit] NOT NULL, [CURRENCY] [nvarchar](50) NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_BANK_ACCOUNT] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CUSTOMER]( [BUSINESS_ENTITY_ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [SECTOR] [int] NULL, [CUSTOMER_TYPE] [int] NULL, [TAX_NUMBER] [nvarchar](11) NOT NULL, [CREDIT_LIMIT] [float] NULL, [FIRM_TYPE] [nvarchar](50) NULL, [TAX_OFFICE] [nvarchar](50) NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_CUSTOMER] PRIMARY KEY CLUSTERED ( [BUSINESS_ENTITY_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[VENDOR]( [UPDATED_USER] [nvarchar](50) NOT NULL, [BUSINESS_ENTITY_ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [SECTOR_ID] [int] NULL, [TAX_NUMBER] [nvarchar](11) NOT NULL, [TAX_OFFICE] [nvarchar](50) NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER1] [nvarchar](50) NULL, CONSTRAINT [PK_VENDOR] PRIMARY KEY CLUSTERED ( [BUSINESS_ENTITY_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PURCHASE_DETAIL]( [ID] [int] IDENTITY(1,1) NOT NULL, [PURCHASE_ID] [int] NULL, [PRODUCT_ID] [int] NOT NULL, [UNIT] [nvarchar](50) NOT NULL, [AMOUNT] [float] NOT NULL, [AMOUNT_WITHOUT_TAX] [float] NOT NULL, [QUANTITY] [float] NOT NULL, [TAX] [float] NOT NULL, [PRICE] [float] NOT NULL, [PAYMENT_METHOD] [float] NOT NULL, [TRANSFER_TYPE] [float] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_PURCHASE_DETAIL] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PURCHASE]( [ID] [int] IDENTITY(1,1) NOT NULL, [DATE] [datetime2](7) NOT NULL, [VENDOR_ID] [int] NOT NULL, [LEAD_TIME] [datetime2](7) NOT NULL, [PRUCHASE_TYPE] [nvarchar](50) NOT NULL, [OFFICE_ID] [int] NOT NULL, [PERSONEL_ID] [int] NOT NULL, [WAREHOUSE_ID] [int] NOT NULL, [PEYMENT_STATUS] [bit] NULL, [ADDRESS_ID] [int] NOT NULL, [SHIPMENT_ADDRESS_ID] [int] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_PURCHASE] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[HIERARCHY]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [H_LEVEL] [tinyint] NOT NULL, [UPPER_ID] [int] NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_HIERARCHY] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PRODUCT]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [HIERARCHY_ID] [int] NOT NULL, [COLOR] [nvarchar](50) NULL, [DIMENTION] [nvarchar](50) NULL, [UNIT] [nvarchar](50) NOT NULL, [HEIGHT] [float] NULL, [WIDTH] [float] NULL, [LENGTH] [float] NULL, [WEIGHT] [float] NULL, [BARCODE] [nvarchar](50) NULL, [MAX_STOCK] [float] NULL, [MIN_STOCK] [float] NULL, [LIST_PRICE] [nchar](10) NULL, [CREDIT_LIMIT] [float] NULL, [PRODUCT_TYPE] [int] NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_PRODUCT] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SHIPMENT_DETAIL]( [ID] [int] IDENTITY(1,1) NOT NULL, [PRODUCT_ID] [int] NULL, [QUANTITY] [float] NULL, [UNIT] [nvarchar](50) NOT NULL, [AMOUNT] [float] NOT NULL, [AMOUNT_WITHOUT_TAX] [float] NOT NULL, [TAX] [float] NOT NULL, [PRICE] [float] NOT NULL, [CURRENCY] [float] NOT NULL, [SHIPPING_ID] [int] NULL, [ORDER_ID] [int] NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_SHIPMENT_DETAIL] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BANK]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_BANK] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BUSINESS_ENTITY]( [ID] [int] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_BUSINESS_ENTITY] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CITY]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [REGION_ID] [int] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_CITY] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[COUNTRY]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [CONTINENT] [nvarchar](50) NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_COUNTRY] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DEPARTMENT]( [ID] [int] NOT NULL, [NAME] [nvarchar](50) NOT NULL, [MANAGER_ID] [int] NOT NULL, [OFFICE_ID] [int] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_DEPARTMENT] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[INVOICE_AUD]( [ID] [int] NULL, [DATE] [datetime2](7) NOT NULL, [SALES_PERSON_ID] [int] NOT NULL, [CUSTOMER_ID] [int] NOT NULL, [OFFICE_ID] [int] NOT NULL, [WAREHOUSE_ID] [int] NOT NULL, [INVOICE_NUMBER] [nvarchar](50) NOT NULL, [TAX_NUMBER] [nvarchar](11) NOT NULL, [TAX_OFFICE] [nvarchar](50) NOT NULL, [ADDRESS_ID] [int] NOT NULL, [MERSIS_NO] [nvarchar](50) NOT NULL, [DUE_DATE] [datetime2](7) NOT NULL, [PAYMENT_METHOD] [nvarchar](50) NOT NULL, [PAYMENT_STATUS] [bit] NOT NULL, [CREATED_DATE] [datetime] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, [OPERATION_DATE] [datetime2](7) NOT NULL, [OPERATION_TYPE] [nvarchar](50) NOT NULL, [OPERATION_USER] [nvarchar](50) NOT NULL ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[INVOICE_DETAIL_AUD]( [ID] [int] NULL, [PRODUCT_ID] [int] NULL, [QUANTITY] [float] NULL, [UNIT] [nvarchar](50) NOT NULL, [AMOUNT] [float] NOT NULL, [AMOUNT_WITHOUT_TAX] [float] NOT NULL, [TAX] [float] NOT NULL, [PRICE] [float] NOT NULL, [CURRENCY] [float] NOT NULL, [INVOICE_ID] [int] NOT NULL, [SHIPPING_ID] [int] NULL, [ORDER_ID] [int] NULL, [CREATED_DATE] [datetime] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, [OPERATION_DATE] [datetime2](7) NULL, [OPERATION_TYPE] [nvarchar](50) NOT NULL, [OPERATION_USER] [nvarchar](50) NOT NULL ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[OFFICE]( [BUSINESS_ENTITY_ID] [int] IDENTITY(1,1) NOT NULL, [MANAGER_PERSON_ID] [int] NULL, [NAME] [nvarchar](50) NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_OFFICE] PRIMARY KEY CLUSTERED ( [BUSINESS_ENTITY_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ORDER]( [ID] [int] NOT NULL, [DATE] [datetime2](7) NULL, [CUSTOMER_ID] [int] NULL, [SALES_PERSON_ID] [int] NULL, [OFFICE_ID] [int] NULL, [WAREHOUSE_ID] [int] NULL, [SHIPPING_ADDRESS_ID] [int] NULL, [TAX_NUMBER] [nvarchar](11) NULL, [TAX_OFFICE] [nvarchar](50) NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_ORDER] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ORDER_DETAIL]( [ID] [int] IDENTITY(1,1) NOT NULL, [PRODUCT_ID] [int] NOT NULL, [QUANTITY] [float] NOT NULL, [UNIT] [nvarchar](50) NOT NULL, [AMOUNT] [float] NOT NULL, [AMOUNT_WITHOUT_TAX] [float] NOT NULL, [TAX] [float] NOT NULL, [PRICE] [float] NOT NULL, [CURRENCY] [float] NOT NULL, [ORDER_ID] [int] NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_ORDER_DETAIL] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PERSONEL]( [BUSINESS_ENTITY_ID] [int] NOT NULL, [NAME] [nvarchar](50) NOT NULL, [MIDDLE_NAME] [nvarchar](50) NULL, [SURNAME] [nvarchar](50) NOT NULL, [TC] [nvarchar](11) NOT NULL, [TITTLE] [nvarchar](50) NOT NULL, [DEPARTMANT_ID] [int] NOT NULL, [MILITARY_STATUS] [tinyint] NULL, [GENDER] [bit] NOT NULL, [HIRED_DATE] [datetime2](7) NOT NULL, [RESIGN_DATE] [datetime2](7) NULL, [EDUCATION] [nvarchar](50) NOT NULL, [MANAGER_ID] [int] NULL, [OFFICE_ID] [int] NULL, [E-MAIL] [nvarchar](100) NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_PERSONEL] PRIMARY KEY CLUSTERED ( [BUSINESS_ENTITY_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PRODUCT_PRICE]( [ID] [int] IDENTITY(1,1) NOT NULL, [DATE] [datetime2](7) NOT NULL, [PRODUCT_ID] [int] NOT NULL, [VALID_DATE] [datetime2](7) NOT NULL, [PRICE] [float] NOT NULL, [CURRENCY] [nvarchar](50) NOT NULL, [UNIT] [float] NOT NULL, [IS_VALID] [bit] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_PRODUCT_PRICE] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[REGION]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [COUNTRY_ID] [int] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_REGION] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SHIPMENT]( [ID] [int] IDENTITY(1,1) NOT NULL, [DATE] [datetime2](7) NULL, [CUSTOMER_ID] [int] NULL, [SALES_PERSON_ID] [int] NULL, [VEHICLE_NUMBER] [nvarchar](50) NULL, [DRIVER_NAME] [nvarchar](50) NULL, [TRANSFER_TYPE] [int] NULL, [OFFICE_ID] [int] NULL, [WAREHOUSE_ID] [int] NULL, [SHIPPING_ADDRESS_ID] [int] NULL, [TAX_NUMBER] [nvarchar](11) NULL, [TAX_OFFICE] [nvarchar](50) NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_SHIPMENT] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SUB_CUSTOMER]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [TAX_NUMBER] [nvarchar](11) NULL, [TAX_OFFICE] [nvarchar](50) NULL, [CUSTOMER_ID] [int] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_SUB_CUSTOMER] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TOWN]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](50) NOT NULL, [CITY_ID] [int] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_TOWN] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TRANFER_TYPE]( [ID] [int] NOT NULL, [INCOTERM] [nvarchar](50) NOT NULL, [CITY_ID] [int] NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_TRANFER_TYPE] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[WAREHOUSE]( [BUSINESS_ENTITY_ID] [int] IDENTITY(1,1) NOT NULL, [MANAGER_PERSON_ID] [int] NULL, [WAREHOUSE_TYPE] [nvarchar](50) NULL, [OFFICE_ID] [int] NOT NULL, [LENGTH] [float] NULL, [WIDTH] [float] NULL, [HEIGHT] [float] NULL, [MAX_STOCK] [float] NULL, [MIN_STOCK] [float] NULL, [RAMP_NUMBER] [int] NULL, [NAME] [nvarchar](50) NOT NULL, [CREATED_DATE] [timestamp] NOT NULL, [UPDATED_DATE] [datetime2](7) NULL, [CREATED_USER] [nvarchar](50) NOT NULL, [UPDATED_USER] [nvarchar](50) NULL, CONSTRAINT [PK_WAREHOUSE] PRIMARY KEY CLUSTERED ( [BUSINESS_ENTITY_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] B. Alter Tables ALTER TABLE [dbo].[ADDRESS] WITH CHECK ADD CONSTRAINT [FK_ADDRESS_BUSINESS_ENTITY] FOREIGN KEY([BUSINESS_ENTITY_ID]) REFERENCES [dbo].[BUSINESS_ENTITY] ([ID]) GO ALTER TABLE [dbo].[ADDRESS] CHECK CONSTRAINT [FK_ADDRESS_BUSINESS_ENTITY] GO ALTER TABLE [dbo].[ADDRESS] WITH CHECK ADD CONSTRAINT [FK_ADDRESS_TOWN] FOREIGN KEY([TOWN_ID]) REFERENCES [dbo].[TOWN] ([ID]) GO ALTER TABLE [dbo].[ADDRESS] CHECK CONSTRAINT [FK_ADDRESS_TOWN] GO ALTER TABLE [dbo].[BANK_ACCOUNT] WITH CHECK ADD CONSTRAINT [FK_BANK_ACCOUNT_BANK] FOREIGN KEY([BANK_ID]) REFERENCES [dbo].[BANK] ([ID]) GO ALTER TABLE [dbo].[BANK_ACCOUNT] CHECK CONSTRAINT [FK_BANK_ACCOUNT_BANK] GO ALTER TABLE [dbo].[BANK_ACCOUNT] WITH CHECK ADD CONSTRAINT [FK_BANK_ACCOUNT_BUSINESS_ENTITY] FOREIGN KEY([ID]) REFERENCES [dbo].[BUSINESS_ENTITY] ([ID]) GO ALTER TABLE [dbo].[BANK_ACCOUNT] CHECK CONSTRAINT [FK_BANK_ACCOUNT_BUSINESS_ENTITY] GO ALTER TABLE [dbo].[BUSINESS_ENTITY] WITH CHECK ADD CONSTRAINT [FK_BUSINESS_ENTITY_CUSTOMER] FOREIGN KEY([ID]) REFERENCES [dbo].[CUSTOMER] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[BUSINESS_ENTITY] CHECK CONSTRAINT [FK_BUSINESS_ENTITY_CUSTOMER] GO ALTER TABLE [dbo].[BUSINESS_ENTITY] WITH CHECK ADD CONSTRAINT [FK_BUSINESS_ENTITY_OFFICE] FOREIGN KEY([ID]) REFERENCES [dbo].[OFFICE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[BUSINESS_ENTITY] CHECK CONSTRAINT [FK_BUSINESS_ENTITY_OFFICE] GO ALTER TABLE [dbo].[BUSINESS_ENTITY] WITH CHECK ADD CONSTRAINT [FK_BUSINESS_ENTITY_PERSONEL] FOREIGN KEY([ID]) REFERENCES [dbo].[PERSONEL] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[BUSINESS_ENTITY] CHECK CONSTRAINT [FK_BUSINESS_ENTITY_PERSONEL] GO ALTER TABLE [dbo].[BUSINESS_ENTITY] WITH CHECK ADD CONSTRAINT [FK_BUSINESS_ENTITY_VENDOR] FOREIGN KEY([ID]) REFERENCES [dbo].[VENDOR] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[BUSINESS_ENTITY] CHECK CONSTRAINT [FK_BUSINESS_ENTITY_VENDOR] GO ALTER TABLE [dbo].[BUSINESS_ENTITY] WITH CHECK ADD CONSTRAINT [FK_BUSINESS_ENTITY_WAREHOUSE] FOREIGN KEY([ID]) REFERENCES [dbo].[WAREHOUSE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[BUSINESS_ENTITY] CHECK CONSTRAINT [FK_BUSINESS_ENTITY_WAREHOUSE] GO ALTER TABLE [dbo].[CITY] WITH CHECK ADD CONSTRAINT [FK_CITY_REGION] FOREIGN KEY([REGION_ID]) REFERENCES [dbo].[REGION] ([ID]) GO ALTER TABLE [dbo].[CITY] CHECK CONSTRAINT [FK_CITY_REGION] GO ALTER TABLE [dbo].[DEPARTMENT] WITH CHECK ADD CONSTRAINT [FK_DEPARTMENT_PERSONEL] FOREIGN KEY([MANAGER_ID]) REFERENCES [dbo].[PERSONEL] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[DEPARTMENT] CHECK CONSTRAINT [FK_DEPARTMENT_PERSONEL] GO ALTER TABLE [dbo].[HIERARCHY] WITH CHECK ADD CONSTRAINT [FK_HIERARCHY_HIERARCHY] FOREIGN KEY([UPPER_ID]) REFERENCES [dbo].[HIERARCHY] ([ID]) GO ALTER TABLE [dbo].[HIERARCHY] CHECK CONSTRAINT [FK_HIERARCHY_HIERARCHY] GO ALTER TABLE [dbo].[INVOICE] WITH CHECK ADD CONSTRAINT [FK_INVOICE_ADDRESS] FOREIGN KEY([ADDRESS_ID]) REFERENCES [dbo].[ADDRESS] ([ID]) GO ALTER TABLE [dbo].[INVOICE] CHECK CONSTRAINT [FK_INVOICE_ADDRESS] GO ALTER TABLE [dbo].[INVOICE] WITH CHECK ADD CONSTRAINT [FK_INVOICE_CUSTOMER] FOREIGN KEY([CUSTOMER_ID]) REFERENCES [dbo].[CUSTOMER] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[INVOICE] CHECK CONSTRAINT [FK_INVOICE_CUSTOMER] GO ALTER TABLE [dbo].[INVOICE] WITH CHECK ADD CONSTRAINT [FK_INVOICE_OFFICE] FOREIGN KEY([OFFICE_ID]) REFERENCES [dbo].[OFFICE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[INVOICE] CHECK CONSTRAINT [FK_INVOICE_OFFICE] GO ALTER TABLE [dbo].[INVOICE] WITH CHECK ADD CONSTRAINT [FK_INVOICE_WAREHOUSE] FOREIGN KEY([WAREHOUSE_ID]) REFERENCES [dbo].[WAREHOUSE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[INVOICE] CHECK CONSTRAINT [FK_INVOICE_WAREHOUSE] GO ALTER TABLE [dbo].[INVOICE_DETAIL] WITH CHECK ADD CONSTRAINT [FK_INVOICE_DETAIL_INVOICE] FOREIGN KEY([INVOICE_ID]) REFERENCES [dbo].[INVOICE] ([ID]) GO ALTER TABLE [dbo].[INVOICE_DETAIL] CHECK CONSTRAINT [FK_INVOICE_DETAIL_INVOICE] GO ALTER TABLE [dbo].[INVOICE_DETAIL] WITH CHECK ADD CONSTRAINT [FK_INVOICE_DETAIL_ORDER_DETAIL] FOREIGN KEY([ORDER_ID]) REFERENCES [dbo].[ORDER_DETAIL] ([ID]) GO ALTER TABLE [dbo].[INVOICE_DETAIL] CHECK CONSTRAINT [FK_INVOICE_DETAIL_ORDER_DETAIL] GO ALTER TABLE [dbo].[INVOICE_DETAIL] WITH CHECK ADD CONSTRAINT [FK_INVOICE_DETAIL_PRODUCT] FOREIGN KEY([PRODUCT_ID]) REFERENCES [dbo].[PRODUCT] ([ID]) GO ALTER TABLE [dbo].[INVOICE_DETAIL] CHECK CONSTRAINT [FK_INVOICE_DETAIL_PRODUCT] GO ALTER TABLE [dbo].[INVOICE_DETAIL] WITH CHECK ADD CONSTRAINT [FK_INVOICE_DETAIL_SHIPMENT_DETAIL] FOREIGN KEY([SHIPPING_ID]) REFERENCES [dbo].[SHIPMENT_DETAIL] ([ID]) GO ALTER TABLE [dbo].[INVOICE_DETAIL] CHECK CONSTRAINT [FK_INVOICE_DETAIL_SHIPMENT_DETAIL] GO ALTER TABLE [dbo].[OFFICE] WITH CHECK ADD CONSTRAINT [FK_OFFICE_PERSONEL] FOREIGN KEY([MANAGER_PERSON_ID]) REFERENCES [dbo].[PERSONEL] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[OFFICE] CHECK CONSTRAINT [FK_OFFICE_PERSONEL] GO ALTER TABLE [dbo].[ORDER] WITH CHECK ADD CONSTRAINT [FK_ORDER_ADDRESS] FOREIGN KEY([SHIPPING_ADDRESS_ID]) REFERENCES [dbo].[ADDRESS] ([ID]) GO ALTER TABLE [dbo].[ORDER] CHECK CONSTRAINT [FK_ORDER_ADDRESS] GO ALTER TABLE [dbo].[ORDER] WITH CHECK ADD CONSTRAINT [FK_ORDER_CUSTOMER] FOREIGN KEY([CUSTOMER_ID]) REFERENCES [dbo].[CUSTOMER] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[ORDER] CHECK CONSTRAINT [FK_ORDER_CUSTOMER] GO ALTER TABLE [dbo].[ORDER] WITH CHECK ADD CONSTRAINT [FK_ORDER_OFFICE] FOREIGN KEY([OFFICE_ID]) REFERENCES [dbo].[OFFICE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[ORDER] CHECK CONSTRAINT [FK_ORDER_OFFICE] GO ALTER TABLE [dbo].[ORDER] WITH CHECK ADD CONSTRAINT [FK_ORDER_PERSONEL] FOREIGN KEY([SALES_PERSON_ID]) REFERENCES [dbo].[PERSONEL] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[ORDER] CHECK CONSTRAINT [FK_ORDER_PERSONEL] GO ALTER TABLE [dbo].[ORDER] WITH CHECK ADD CONSTRAINT [FK_ORDER_WAREHOUSE] FOREIGN KEY([WAREHOUSE_ID]) REFERENCES [dbo].[WAREHOUSE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[ORDER] CHECK CONSTRAINT [FK_ORDER_WAREHOUSE] GO ALTER TABLE [dbo].[ORDER_DETAIL] WITH CHECK ADD CONSTRAINT [FK_ORDER_DETAIL_ORDER] FOREIGN KEY([ORDER_ID]) REFERENCES [dbo].[ORDER] ([ID]) GO ALTER TABLE [dbo].[ORDER_DETAIL] CHECK CONSTRAINT [FK_ORDER_DETAIL_ORDER] GO ALTER TABLE [dbo].[ORDER_DETAIL] WITH CHECK ADD CONSTRAINT [FK_ORDER_DETAIL_PRODUCT] FOREIGN KEY([PRODUCT_ID]) REFERENCES [dbo].[PRODUCT] ([ID]) GO ALTER TABLE [dbo].[ORDER_DETAIL] CHECK CONSTRAINT [FK_ORDER_DETAIL_PRODUCT] GO ALTER TABLE [dbo].[PERSONEL] WITH CHECK ADD CONSTRAINT [FK_PERSONEL_DEPARTMENT] FOREIGN KEY([DEPARTMANT_ID]) REFERENCES [dbo].[DEPARTMENT] ([ID]) GO ALTER TABLE [dbo].[PERSONEL] CHECK CONSTRAINT [FK_PERSONEL_DEPARTMENT] GO ALTER TABLE [dbo].[PERSONEL] WITH CHECK ADD CONSTRAINT [FK_PERSONEL_OFFICE] FOREIGN KEY([OFFICE_ID]) REFERENCES [dbo].[OFFICE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[PERSONEL] CHECK CONSTRAINT [FK_PERSONEL_OFFICE] GO ALTER TABLE [dbo].[PERSONEL] WITH CHECK ADD CONSTRAINT [FK_PERSONEL_PERSONEL] FOREIGN KEY([MANAGER_ID]) REFERENCES [dbo].[PERSONEL] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[PERSONEL] CHECK CONSTRAINT [FK_PERSONEL_PERSONEL] GO ALTER TABLE [dbo].[PRODUCT] WITH CHECK ADD CONSTRAINT [FK_PRODUCT_HIERARCHY] FOREIGN KEY([HIERARCHY_ID]) REFERENCES [dbo].[HIERARCHY] ([ID]) GO ALTER TABLE [dbo].[PRODUCT] CHECK CONSTRAINT [FK_PRODUCT_HIERARCHY] GO ALTER TABLE [dbo].[PRODUCT_PRICE] WITH CHECK ADD CONSTRAINT [FK_PRODUCT_PRICE_PRODUCT] FOREIGN KEY([PRODUCT_ID]) REFERENCES [dbo].[PRODUCT] ([ID]) GO ALTER TABLE [dbo].[PRODUCT_PRICE] CHECK CONSTRAINT [FK_PRODUCT_PRICE_PRODUCT] GO ALTER TABLE [dbo].[PURCHASE] WITH CHECK ADD CONSTRAINT [FK_PURCHASE_ADDRESS] FOREIGN KEY([ADDRESS_ID]) REFERENCES [dbo].[ADDRESS] ([ID]) GO ALTER TABLE [dbo].[PURCHASE] CHECK CONSTRAINT [FK_PURCHASE_ADDRESS] GO ALTER TABLE [dbo].[PURCHASE] WITH CHECK ADD CONSTRAINT [FK_PURCHASE_ADDRESS1] FOREIGN KEY([SHIPMENT_ADDRESS_ID]) REFERENCES [dbo].[ADDRESS] ([ID]) GO ALTER TABLE [dbo].[PURCHASE] CHECK CONSTRAINT [FK_PURCHASE_ADDRESS1] GO ALTER TABLE [dbo].[PURCHASE] WITH CHECK ADD CONSTRAINT [FK_PURCHASE_OFFICE] FOREIGN KEY([OFFICE_ID]) REFERENCES [dbo].[OFFICE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[PURCHASE] CHECK CONSTRAINT [FK_PURCHASE_OFFICE] GO ALTER TABLE [dbo].[PURCHASE] WITH CHECK ADD CONSTRAINT [FK_PURCHASE_VENDOR] FOREIGN KEY([VENDOR_ID]) REFERENCES [dbo].[VENDOR] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[PURCHASE] CHECK CONSTRAINT [FK_PURCHASE_VENDOR] GO ALTER TABLE [dbo].[PURCHASE] WITH CHECK ADD CONSTRAINT [FK_PURCHASE_WAREHOUSE] FOREIGN KEY([WAREHOUSE_ID]) REFERENCES [dbo].[WAREHOUSE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[PURCHASE] CHECK CONSTRAINT [FK_PURCHASE_WAREHOUSE] GO ALTER TABLE [dbo].[PURCHASE_DETAIL] WITH CHECK ADD CONSTRAINT [FK_PURCHASE_DETAIL_PRODUCT] FOREIGN KEY([PRODUCT_ID]) REFERENCES [dbo].[PRODUCT] ([ID]) GO ALTER TABLE [dbo].[PURCHASE_DETAIL] CHECK CONSTRAINT [FK_PURCHASE_DETAIL_PRODUCT] GO ALTER TABLE [dbo].[PURCHASE_DETAIL] WITH CHECK ADD CONSTRAINT [FK_PURCHASE_DETAIL_PURCHASE] FOREIGN KEY([PURCHASE_ID]) REFERENCES [dbo].[PURCHASE] ([ID]) GO ALTER TABLE [dbo].[PURCHASE_DETAIL] CHECK CONSTRAINT [FK_PURCHASE_DETAIL_PURCHASE] GO ALTER TABLE [dbo].[REGION] WITH CHECK ADD CONSTRAINT [FK_REGION_COUNTRY] FOREIGN KEY([COUNTRY_ID]) REFERENCES [dbo].[COUNTRY] ([ID]) GO ALTER TABLE [dbo].[REGION] CHECK CONSTRAINT [FK_REGION_COUNTRY] GO ALTER TABLE [dbo].[SHIPMENT] WITH CHECK ADD CONSTRAINT [FK_SHIPMENT_ADDRESS] FOREIGN KEY([SHIPPING_ADDRESS_ID]) REFERENCES [dbo].[ADDRESS] ([ID]) GO ALTER TABLE [dbo].[SHIPMENT] CHECK CONSTRAINT [FK_SHIPMENT_ADDRESS] GO ALTER TABLE [dbo].[SHIPMENT] WITH CHECK ADD CONSTRAINT [FK_SHIPMENT_CUSTOMER] FOREIGN KEY([CUSTOMER_ID]) REFERENCES [dbo].[CUSTOMER] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[SHIPMENT] CHECK CONSTRAINT [FK_SHIPMENT_CUSTOMER] GO ALTER TABLE [dbo].[SHIPMENT] WITH CHECK ADD CONSTRAINT [FK_SHIPMENT_OFFICE] FOREIGN KEY([OFFICE_ID]) REFERENCES [dbo].[OFFICE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[SHIPMENT] CHECK CONSTRAINT [FK_SHIPMENT_OFFICE] GO ALTER TABLE [dbo].[SHIPMENT] WITH CHECK ADD CONSTRAINT [FK_SHIPMENT_PERSONEL] FOREIGN KEY([SALES_PERSON_ID]) REFERENCES [dbo].[PERSONEL] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[SHIPMENT] CHECK CONSTRAINT [FK_SHIPMENT_PERSONEL] GO ALTER TABLE [dbo].[SHIPMENT] WITH CHECK ADD CONSTRAINT [FK_SHIPMENT_TRANFER_TYPE] FOREIGN KEY([TRANSFER_TYPE]) REFERENCES [dbo].[TRANFER_TYPE] ([ID]) GO ALTER TABLE [dbo].[SHIPMENT] CHECK CONSTRAINT [FK_SHIPMENT_TRANFER_TYPE] GO ALTER TABLE [dbo].[SHIPMENT] WITH CHECK ADD CONSTRAINT [FK_SHIPMENT_WAREHOUSE] FOREIGN KEY([WAREHOUSE_ID]) REFERENCES [dbo].[WAREHOUSE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[SHIPMENT] CHECK CONSTRAINT [FK_SHIPMENT_WAREHOUSE] GO ALTER TABLE [dbo].[SHIPMENT_DETAIL] WITH CHECK ADD CONSTRAINT [FK_SHIPMENT_DETAIL_ORDER_DETAIL] FOREIGN KEY([ORDER_ID]) REFERENCES [dbo].[ORDER_DETAIL] ([ID]) GO ALTER TABLE [dbo].[SHIPMENT_DETAIL] CHECK CONSTRAINT [FK_SHIPMENT_DETAIL_ORDER_DETAIL] GO ALTER TABLE [dbo].[SHIPMENT_DETAIL] WITH CHECK ADD CONSTRAINT [FK_SHIPMENT_DETAIL_PRODUCT] FOREIGN KEY([PRODUCT_ID]) REFERENCES [dbo].[PRODUCT] ([ID]) GO ALTER TABLE [dbo].[SHIPMENT_DETAIL] CHECK CONSTRAINT [FK_SHIPMENT_DETAIL_PRODUCT] GO ALTER TABLE [dbo].[SHIPMENT_DETAIL] WITH CHECK ADD CONSTRAINT [FK_SHIPMENT_DETAIL_SHIPMENT] FOREIGN KEY([SHIPPING_ID]) REFERENCES [dbo].[SHIPMENT] ([ID]) GO ALTER TABLE [dbo].[SHIPMENT_DETAIL] CHECK CONSTRAINT [FK_SHIPMENT_DETAIL_SHIPMENT] GO ALTER TABLE [dbo].[SUB_CUSTOMER] WITH CHECK ADD CONSTRAINT [FK_SUB_CUSTOMER_CUSTOMER] FOREIGN KEY([CUSTOMER_ID]) REFERENCES [dbo].[CUSTOMER] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[SUB_CUSTOMER] CHECK CONSTRAINT [FK_SUB_CUSTOMER_CUSTOMER] GO ALTER TABLE [dbo].[TOWN] WITH CHECK ADD CONSTRAINT [FK_TOWN_CITY] FOREIGN KEY([CITY_ID]) REFERENCES [dbo].[CITY] ([ID]) GO ALTER TABLE [dbo].[TOWN] CHECK CONSTRAINT [FK_TOWN_CITY] GO ALTER TABLE [dbo].[WAREHOUSE] WITH CHECK ADD CONSTRAINT [FK_WAREHOUSE_OFFICE] FOREIGN KEY([OFFICE_ID]) REFERENCES [dbo].[OFFICE] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[WAREHOUSE] CHECK CONSTRAINT [FK_WAREHOUSE_OFFICE] GO ALTER TABLE [dbo].[WAREHOUSE] WITH CHECK ADD CONSTRAINT [FK_WAREHOUSE_PERSONEL] FOREIGN KEY([MANAGER_PERSON_ID]) REFERENCES [dbo].[PERSONEL] ([BUSINESS_ENTITY_ID]) GO ALTER TABLE [dbo].[WAREHOUSE] CHECK CONSTRAINT [FK_WAREHOUSE_PERSONEL] GO
Editor is loading...