Tables [dbo].[CoCompanies]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)3
Created11:24:18 AM Wednesday, May 9, 2018
Last Modified11:24:51 AM Wednesday, May 9, 2018
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_CoCompanies: CompanyIDCompanyIDvarchar(15)15
False
CompanyNamevarchar(50)50
False
Addressvarchar(60)60
False
Cityvarchar(30)30
False
Statevarchar(15)15
False
Zipvarchar(10)10
False
Countryvarchar(15)15
False
Phone1varchar(30)30
False
Phone2varchar(30)30
False
Faxvarchar(30)30
False
EINvarchar(15)15
False
Remarksvarchar(255)255
False
DBNamevarchar(30)30
False
Foreign Keys FK_CoCompanies_DBTypeID_CoDBTypes: [dbo].[CoDBTypes].DBTypeIDDBTypeIDint4
False
((1))
Locksint4
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
Address_MapPointvarchar(60)60
True
City_MapPointvarchar(30)30
True
State_MapPointvarchar(15)15
True
Zip_MapPointvarchar(10)10
True
AnalyticsServervarchar(32)32
True
AnalyticsDatabasevarchar(32)32
True
TaskEngineSuspendedbit1
False
((1))
ADSEnabledbit1
False
((1))
ADSEndpointvarchar(1024)1024
True
ADSLastContactdatetime8
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_CoCompanies: CompanyIDPK_CoCompaniesCompanyID
True
NameANSI Nulls OnQuoted Identifier OnOn
tdCoCompanies
True
True
After Delete
NameColumns
FK_CoCompanies_DBTypeID_CoDBTypesDBTypeID->[dbo].[CoDBTypes].[DBTypeID]
CREATE TABLE [dbo].[CoCompanies]
(
[CompanyID] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CompanyName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone1] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone2] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Fax] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EIN] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DBName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DBTypeID] [int] NOT NULL CONSTRAINT [DF_CoCompanies_DBTypeID] DEFAULT ((1)),
[Locks] [int] NOT NULL CONSTRAINT [DF_CoCompanies_Locks] DEFAULT ((0)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_CoCompanies_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_CoCompanies_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[Address_MapPoint] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City_MapPoint] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[State_MapPoint] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Zip_MapPoint] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AnalyticsServer] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AnalyticsDatabase] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaskEngineSuspended] [bit] NOT NULL CONSTRAINT [DF_CoCompanies_TaskEngineSuspended] DEFAULT ((1)),
[ADSEnabled] [bit] NOT NULL CONSTRAINT [DF_CoCompanies_ADSEnabled] DEFAULT ((1)),
[ADSEndpoint] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ADSLastContact] [datetime] NULL
) ON [PRIMARY]
GO

CREATE TRIGGER [dbo].[tdCoCompanies] ON [dbo].[CoCompanies]
FOR DELETE
AS
BEGIN
   IF EXISTS(SELECT 1 FROM deleted WHERE Locks > 0)
   BEGIN
       RAISERROR('Attempt to delete row from CoCompanies where Locks is greater than zero.', 11, 2)
       ROLLBACK TRANSACTION
       RETURN
   END
END

GO
ALTER TABLE [dbo].[CoCompanies] ADD CONSTRAINT [PK_CoCompanies] PRIMARY KEY CLUSTERED  ([CompanyID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CoCompanies] ADD CONSTRAINT [FK_CoCompanies_DBTypeID_CoDBTypes] FOREIGN KEY ([DBTypeID]) REFERENCES [dbo].[CoDBTypes] ([DBTypeID])
GO