On 01/05/2013 12:21 PM, Carey Gagnon wrote:
Not sure what info you need Adrian. Will this do?
CREATE TABLE [dbo].[Companies](
[CompanyID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[CompanyName] [nvarchar](50) NOT NULL,
[Address] [nvarchar](50) NOT NULL,
[City] [nvarchar](50) NULL,
[CityID] [int] NULL,
[ProvinceState] [nvarchar](2) NULL,
[Country] [nvarchar](50) NULL,
[PostalZIP] [nvarchar](50) NULL,
[Phone] [nvarchar](50) NULL,
[Fax] [nvarchar](50) NULL,
[Website] [nvarchar](50) NULL,
[InactiveCompany] [bit] NOT NULL,
[CompanyActivationDate] [datetime] NOT NULL,
[CompanyInactivationDate] [datetime] NULL,
[CompanyCreator] [nvarchar](50) NOT NULL,
[ParentCompanyID] [int] NULL,
[CompanyRating] [nvarchar](50) NULL,
CONSTRAINT [PK_Companies] PRIMARY KEY CLUSTERED
There is no FK between Companies.CityID and Cities.CityID ?
CREATE TABLE [dbo].[Cities](
[CityID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[CityName] [nvarchar](64) NOT NULL,
[ProvinceState] [nvarchar](2) NOT NULL,
CONSTRAINT [PK_Cities] PRIMARY KEY CLUSTERED
ALTER TABLE [dbo].[Cities] WITH CHECK ADD CONSTRAINT
[FK_Cities_ProvinceState] FOREIGN KEY([ProvinceState])
REFERENCES [dbo].[ProvinceState] ([ProvinceState])
CREATE TABLE [dbo].[ProvinceState](
[ProvinceState] [nvarchar](2) NOT NULL,
[Country] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_ProvinceState] PRIMARY KEY CLUSTERED
Carey
--
Adrian Klaver
[email protected]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
