HOME
ABOUT
- RESULTS
- differences
- BENEFITS
- HISTORY
- TEAM
- LOCATION
- FACILITIES
- BANKING
- MEMBERSHIPS
- APPROVALS
- LICENCES
- SUPPLIERS
- SPONSORSHIPS
- MEDIA
- PRIVACY
AUCTIONS
SHIPPING
FEES
- TS REWARDS
TOOLS
guides
FAQ
CONTACT
- CONNECT

VEHICLES
BRAND
- JAPANESE CARS
  - DAIHATSU
  - EUNOS
  - FORD
  - HONDA
  - ISUZU
  - LEXUS
  - MAZDA
  - MITSUBISHI
  - MITSUOKA
  - NISSAN
  - SUBARU
  - SUZUKI
  - TOYOTA
- GERMAN CARS
- AMERICAN CARS
- BRITISH CARS
- ITALIAN CARS
- FRENCH CARS
- SWEDISH CARS
- KOREAN CARS
TYPE
- mobility
- VENDING
- instruction
- TAXIS
- AMBULANCES
- FIRE ENGINES
- HEARSES
- LIMOUSINES
- COMMERCIAL
CLASS
FUEL
TRUCKS
minitrucks
- DAIHATSU
- HONDA
- MAZDA
- MITSUBISHI
- NISSAN
- SUBARU
- SUZUKI
- DUMP
- CRANE
- CAMPER
- REFRIGERATED
- 4WD
- NEW
BUSES
MOTORHOMES
- YAHOO!
- RAKUTEN
- DEALER

PARTS
- FREE REPORT
- PARTS CONTAINERS
- PARTS SYSTEMS
- PARTS PROTECTION
- BODY SHELLS
- DISMANTLING
- ONLINE PARTS
- NEW PARTS
- INTERIOR PARTS
- EXTERIOR PARTS
  - BONNETS
  - BUMPERS
  - GRILLES
  - FENDERS
  - DOORS
  - TRUNKS
  - SPOILERS
  - LIGHTS
  - EMBLEMS
  - CAMERAS
- ENGINES
- TRANSMISSIONS
- WHEELS & TYRES
  - WHEELS
  - TYRES
CUTS
PERFORMANCE PARTS
TRUCK PARTS
MOTORBIKE PARTS
- MOTORBIKE ENGINES
- MOTORBIKE ACCESSORIES

MOTORBIKES
MARINE
FORKLIFTS
MACHINERY
AGRICULTURAL
OTHER
COUNTRY
- AUSTRALIA
- CANADA
- KENYA
- MYANMAR
- NEW ZEALAND
- PAKISTAN
- TANZANIA
- UNITED STATES

CARVIEW

MOTORHOMES

Select Language

HTTP/2 200 date: Sat, 11 Oct 2025 12:32:35 GMT content-type: text/html; charset=UTF-8 server: cloudflare x-frame-options: DENY x-content-type-options: nosniff x-xss-protection: 1;mode=block vary: accept-encoding cf-cache-status: DYNAMIC content-encoding: gzip set-cookie: _csrf-frontend=601d9e199403897a0c6221bda2d191d098270f193347574b7ca51e2b01ec3dcea%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%225OrYSR1Tm13f1ZjAjtGflCm8RhndtLxl%22%3B%7D; HttpOnly; Path=/ cf-ray: 98ce618b3d20741b-BLR Test Schema - Pastebin.com

Pastebin

API tools faq

paste

Test Schema

Stevepy

Sep 4th, 2024

181

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

T-SQL 10.55 KB | Source Code | 0 0

raw download clone embed print report

CREATE SCHEMA TPC
CREATE SCHEMA TPH
CREATE SCHEMA TPT
CREATE SCHEMA MTO
USE [Inheritance]
GO
/****** Object: Table [MTO].[Address] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [MTO].[Address](
[AddressId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[UnitNum] [nvarchar](50) NULL,
[StreetNum] [nvarchar](10) NOT NULL,
[StreetName] [nvarchar](50) NOT NULL,
[StreetType] [nvarchar](50) NOT NULL,
[SuburbId] [int] NOT NULL,
[City] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Address] PRIMARY KEY CLUSTERED
(
[AddressId] 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
/****** Object: Table [MTO].[Client] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [MTO].[Client](
[ClientId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[ClientAddressId] [int] NOT NULL,
CONSTRAINT [PK_Client_2] PRIMARY KEY CLUSTERED
(
[ClientId] 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
/****** Object: Table [MTO].[ClientAddress] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [MTO].[ClientAddress](
[ClientAddressId] [int] IDENTITY(1,1) NOT NULL,
[AddressId] [int] NOT NULL,
CONSTRAINT [PK_ClientAddress] PRIMARY KEY CLUSTERED
(
[ClientAddressId] 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
/****** Object: Table [MTO].[Supplier] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [MTO].[Supplier](
[SupplierId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[SupplierAddressId] [int] NOT NULL,
CONSTRAINT [PK_Supplier] PRIMARY KEY CLUSTERED
(
[SupplierId] 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
/****** Object: Table [MTO].[SupplierAddress] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [MTO].[SupplierAddress](
[SupplierAddressId] [int] IDENTITY(1,1) NOT NULL,
[AddressId] [int] NOT NULL,
CONSTRAINT [PK_SupplierAddress] PRIMARY KEY CLUSTERED
(
[SupplierAddressId] 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
/****** Object: Table [TPC].[Client] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TPC].[Client](
[ClientId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[ClientAddressId] [int] NOT NULL,
CONSTRAINT [PK_Client] PRIMARY KEY CLUSTERED
(
[ClientId] 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
/****** Object: Table [TPC].[ClientAddress] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TPC].[ClientAddress](
[ClientAddressId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[UnitNum] [nvarchar](50) NULL,
[StreetNum] [nvarchar](10) NOT NULL,
[StreetName] [nvarchar](50) NOT NULL,
[StreetType] [nvarchar](50) NOT NULL,
[SuburbId] [int] NOT NULL,
[City] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Address] PRIMARY KEY CLUSTERED
(
[ClientAddressId] 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
/****** Object: Table [TPH].[Address] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TPH].[Address](
[AddressId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[UnitNum] [nvarchar](50) NULL,
[StreetNum] [nvarchar](10) NOT NULL,
[StreetName] [nvarchar](50) NOT NULL,
[StreetType] [nvarchar](50) NOT NULL,
[SuburbId] [int] NOT NULL,
[City] [nvarchar](50) NOT NULL,
[Discriminator] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Address] PRIMARY KEY CLUSTERED
(
[AddressId] 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
/****** Object: Table [TPH].[Client] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TPH].[Client](
[ClientId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[AddressId] [int] NOT NULL,
CONSTRAINT [PK_Client_1] PRIMARY KEY CLUSTERED
(
[ClientId] 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
/****** Object: Table [TPT].[Address] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TPT].[Address](
[AddressId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[UnitNum] [nvarchar](50) NULL,
[StreetNum] [nvarchar](10) NOT NULL,
[StreetName] [nvarchar](50) NOT NULL,
[StreetType] [nvarchar](50) NOT NULL,
[SuburbId] [int] NOT NULL,
[City] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Address] PRIMARY KEY CLUSTERED
(
[AddressId] 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
/****** Object: Table [TPT].[Client] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TPT].[Client](
[ClientId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[ClientAddressId] [int] NOT NULL,
CONSTRAINT [PK_Client_2] PRIMARY KEY CLUSTERED
(
[ClientId] 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
/****** Object: Table [TPT].[ClientAddress] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TPT].[ClientAddress](
[AddressId] [int] NOT NULL,
CONSTRAINT [PK_ClientAddress] PRIMARY KEY CLUSTERED
(
[AddressId] 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
/****** Object: Table [TPT].[Supplier] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TPT].[Supplier](
[SupplierId] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[SupplierAddressId] [int] NOT NULL,
CONSTRAINT [PK_Supplier] PRIMARY KEY CLUSTERED
(
[SupplierId] 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
/****** Object: Table [TPT].[SupplierAddress] Script Date: 5/09/2024 2:30:57 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [TPT].[SupplierAddress](
[AddressId] [int] NOT NULL,
CONSTRAINT [PK_SupplierAddress] PRIMARY KEY CLUSTERED
(
[AddressId] 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
ALTER TABLE [MTO].[Client] WITH CHECK ADD CONSTRAINT [FK_Client_ClientAddress] FOREIGN KEY([ClientAddressId])
REFERENCES [MTO].[ClientAddress] ([ClientAddressId])
GO
ALTER TABLE [MTO].[Client] CHECK CONSTRAINT [FK_Client_ClientAddress]
GO
ALTER TABLE [MTO].[ClientAddress] WITH CHECK ADD CONSTRAINT [FK_ClientAddress_Address] FOREIGN KEY([AddressId])
REFERENCES [MTO].[Address] ([AddressId])
GO
ALTER TABLE [MTO].[ClientAddress] CHECK CONSTRAINT [FK_ClientAddress_Address]
GO
ALTER TABLE [MTO].[Supplier] WITH CHECK ADD CONSTRAINT [FK_Supplier_SupplierAddress] FOREIGN KEY([SupplierAddressId])
REFERENCES [MTO].[SupplierAddress] ([SupplierAddressId])
GO
ALTER TABLE [MTO].[Supplier] CHECK CONSTRAINT [FK_Supplier_SupplierAddress]
GO
ALTER TABLE [MTO].[SupplierAddress] WITH CHECK ADD CONSTRAINT [FK_SupplierAddress_Address] FOREIGN KEY([AddressId])
REFERENCES [MTO].[Address] ([AddressId])
GO
ALTER TABLE [MTO].[SupplierAddress] CHECK CONSTRAINT [FK_SupplierAddress_Address]
GO
ALTER TABLE [TPC].[Client] WITH CHECK ADD CONSTRAINT [FK_Client_ClientAddress] FOREIGN KEY([ClientAddressId])
REFERENCES [TPC].[ClientAddress] ([ClientAddressId])
GO
ALTER TABLE [TPC].[Client] CHECK CONSTRAINT [FK_Client_ClientAddress]
GO
ALTER TABLE [TPH].[Client] WITH CHECK ADD CONSTRAINT [FK_Client_Address] FOREIGN KEY([AddressId])
REFERENCES [TPH].[Address] ([AddressId])
GO
ALTER TABLE [TPH].[Client] CHECK CONSTRAINT [FK_Client_Address]
GO
ALTER TABLE [TPT].[Client] WITH CHECK ADD CONSTRAINT [FK_Client_ClientAddress] FOREIGN KEY([ClientAddressId])
REFERENCES [TPT].[ClientAddress] ([AddressId])
GO
ALTER TABLE [TPT].[Client] CHECK CONSTRAINT [FK_Client_ClientAddress]
GO
ALTER TABLE [TPT].[ClientAddress] WITH CHECK ADD CONSTRAINT [FK_ClientAddress_Address] FOREIGN KEY([AddressId])
REFERENCES [TPT].[Address] ([AddressId])
GO
ALTER TABLE [TPT].[ClientAddress] CHECK CONSTRAINT [FK_ClientAddress_Address]
GO
ALTER TABLE [TPT].[Supplier] WITH CHECK ADD CONSTRAINT [FK_Supplier_SupplierAddress] FOREIGN KEY([SupplierAddressId])
REFERENCES [TPT].[SupplierAddress] ([AddressId])
GO
ALTER TABLE [TPT].[Supplier] CHECK CONSTRAINT [FK_Supplier_SupplierAddress]
GO
ALTER TABLE [TPT].[SupplierAddress] WITH CHECK ADD CONSTRAINT [FK_SupplierAddress_Address] FOREIGN KEY([AddressId])
REFERENCES [TPT].[Address] ([AddressId])
GO
ALTER TABLE [TPT].[SupplierAddress] CHECK CONSTRAINT [FK_SupplierAddress_Address]
GO

Add Comment

Please, Sign In to add comment

Public Pastes

⭐✅ MAKE $2500 IN 15 MIN⭐⭐⭐ 4
JavaScript | 7 sec ago | 0.24 KB
⭐ G2A Bug ⭐ (Get more on BTC swaps) ✅ NEVER S...
JavaScript | 7 sec ago | 0.24 KB
⭐✅ Jack's Profit Method ✅ NEVER SEEN BEF...
JavaScript | 16 sec ago | 0.24 KB
⭐✅ Exploit 2500$ in 15 Minutes⭐⭐⭐ C
JavaScript | 18 sec ago | 0.24 KB
⭐✅ Online Marketplace Exploit ✅ NEVER SEEN BE...
JavaScript | 25 sec ago | 0.24 KB
⭐✅ Trading Profit Method ✅ NEVER SEEN BEFORE...
JavaScript | 34 sec ago | 0.24 KB
Free Crypto Method (NEVER SEEN BEFORE)⭐⭐ 4
JavaScript | 39 sec ago | 0.24 KB
⭐ Instant BTC Profit Method ✅ NEVER SEEN BEFO...
JavaScript | 43 sec ago | 0.24 KB

create new paste / syntax languages / archive / faq / tools / night mode / api / scraping api / news / pro
privacy statement / cookies policy / terms of service / security disclosure / dmca / report abuse / contact

By using Pastebin.com you agree to our cookies policy to enhance your experience.
Site design & logo © 2025 Pastebin

We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand

Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!

HOME
ABOUT
AUCTIONS
SHIPPING
FEES
TOOLS
HOW
FAQ
CONTACT

Original Source | Taken Source