[dbo].[InternationalLinehaulCarrierPhoneNumber]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count (~)	0
Created	9:11:13 AM Friday, December 7, 2018
Last Modified	9:11:26 AM Friday, December 7, 2018

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count (~)

Created

9:11:13 AM Friday, December 7, 2018

Last Modified

9:11:26 AM Friday, December 7, 2018

	Name	Data Type	Max Length (Bytes)	Identity
	InternationalLinehaulCarrierPhoneNumberID	int	4	1 - 1
$Indexes IX_InternationalLinehaulCarrier_PhoneType: InternationalLinehaulCarrierFID\PhoneTypeFID$	InternationalLinehaulCarrierFID	int	4
$Indexes IX_InternationalLinehaulCarrier_PhoneType: InternationalLinehaulCarrierFID\PhoneTypeFID$	PhoneTypeFID	int	4
	CountryCodeStandardFID	int	4
	AreaCode	[dbo].[PhoneAreaCode]	4
	LocalNumber	[dbo].[PhoneLocalNumber]	20
	Extension	[dbo].[PhoneExtension]	10

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

InternationalLinehaulCarrierPhoneNumberID

int

1 - 1

Foreign Keys FK_InternationalLinehaulCarrierPhoneNumber_InternationalLinehaulCarrier: [dbo].[InternationalLinehaulCarrier].InternationalLinehaulCarrierFID

$Indexes IX_InternationalLinehaulCarrier_PhoneType: InternationalLinehaulCarrierFID\PhoneTypeFID$

InternationalLinehaulCarrierFID

int

Foreign Keys FK_InternationalLinehaulCarrierPhoneNumber_PhoneType: [dbo].[PhoneType].PhoneTypeFID

$Indexes IX_InternationalLinehaulCarrier_PhoneType: InternationalLinehaulCarrierFID\PhoneTypeFID$

PhoneTypeFID

int

CountryCodeStandardFID

int

AreaCode

[dbo].[PhoneAreaCode]

LocalNumber

[dbo].[PhoneLocalNumber]

Extension

[dbo].[PhoneExtension]

	Name	Columns	Unique
	PK_InternationalLinehaulCarrierPhoneNumber	InternationalLinehaulCarrierPhoneNumberID
	IX_InternationalLinehaulCarrier_PhoneType	InternationalLinehaulCarrierFID, PhoneTypeFID

Name

Columns

Unique

PK_InternationalLinehaulCarrierPhoneNumber

InternationalLinehaulCarrierPhoneNumberID

IX_InternationalLinehaulCarrier_PhoneType

InternationalLinehaulCarrierFID, PhoneTypeFID

Name	On Column	Constraint
CK_InternationalLinehaulCarrierPhoneNumber_PhoneType	PhoneTypeFID	([dbo].[GetPhoneNumberTypeName]([PhoneTypeFID])='Fax' OR [dbo].[GetPhoneNumberTypeName]([PhoneTypeFID])='Main')

Name

On Column

Constraint

CK_InternationalLinehaulCarrierPhoneNumber_PhoneType

PhoneTypeFID

([dbo].[GetPhoneNumberTypeName]([PhoneTypeFID])='Fax' OR [dbo].[GetPhoneNumberTypeName]([PhoneTypeFID])='Main')

Name	Delete	Columns
FK_InternationalLinehaulCarrierPhoneNumber_CountryCodeStandard		CountryCodeStandardFID->[dbo].[CountryCodeStandard].[CountryCodeStandardID]
FK_InternationalLinehaulCarrierPhoneNumber_InternationalLinehaulCarrier	Cascade	InternationalLinehaulCarrierFID->[dbo].[InternationalLinehaulCarrier].[InternationalLinehaulCarrierID]
FK_InternationalLinehaulCarrierPhoneNumber_PhoneType		PhoneTypeFID->[dbo].[PhoneType].[PhoneTypeID]

Name

Delete

Columns

FK_InternationalLinehaulCarrierPhoneNumber_CountryCodeStandard

CountryCodeStandardFID->[dbo].[CountryCodeStandard].[CountryCodeStandardID]

FK_InternationalLinehaulCarrierPhoneNumber_InternationalLinehaulCarrier

Cascade

InternationalLinehaulCarrierFID->[dbo].[InternationalLinehaulCarrier].[InternationalLinehaulCarrierID]

FK_InternationalLinehaulCarrierPhoneNumber_PhoneType

PhoneTypeFID->[dbo].[PhoneType].[PhoneTypeID]

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

Type

Action

Owning Principal

Grant

Delete

MssExec

Grant

Insert

MssExec

Grant

Select

MssExec

Grant

Update

MssExec

SQL Script

CREATE TABLE [dbo].[InternationalLinehaulCarrierPhoneNumber]
(
[InternationalLinehaulCarrierPhoneNumberID] [int] NOT NULL IDENTITY(1, 1),
[InternationalLinehaulCarrierFID] [int] NOT NULL,
[PhoneTypeFID] [int] NOT NULL,
[CountryCodeStandardFID] [int] NULL,
[AreaCode] [dbo].[PhoneAreaCode] NULL,
[LocalNumber] [dbo].[PhoneLocalNumber] NULL,
[Extension] [dbo].[PhoneExtension] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[InternationalLinehaulCarrierPhoneNumber] ADD CONSTRAINT [CK_InternationalLinehaulCarrierPhoneNumber_PhoneType] CHECK (([dbo].[GetPhoneNumberTypeName]([PhoneTypeFID])='Fax' OR [dbo].[GetPhoneNumberTypeName]([PhoneTypeFID])='Main'))
GO
ALTER TABLE [dbo].[InternationalLinehaulCarrierPhoneNumber] ADD CONSTRAINT [PK_InternationalLinehaulCarrierPhoneNumber] PRIMARY KEY NONCLUSTERED  ([InternationalLinehaulCarrierPhoneNumberID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[InternationalLinehaulCarrierPhoneNumber] ADD CONSTRAINT [IX_InternationalLinehaulCarrier_PhoneType] UNIQUE NONCLUSTERED  ([InternationalLinehaulCarrierFID], [PhoneTypeFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[InternationalLinehaulCarrierPhoneNumber] ADD CONSTRAINT [FK_InternationalLinehaulCarrierPhoneNumber_CountryCodeStandard] FOREIGN KEY ([CountryCodeStandardFID]) REFERENCES [dbo].[CountryCodeStandard] ([CountryCodeStandardID])
GO
ALTER TABLE [dbo].[InternationalLinehaulCarrierPhoneNumber] ADD CONSTRAINT [FK_InternationalLinehaulCarrierPhoneNumber_InternationalLinehaulCarrier] FOREIGN KEY ([InternationalLinehaulCarrierFID]) REFERENCES [dbo].[InternationalLinehaulCarrier] ([InternationalLinehaulCarrierID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[InternationalLinehaulCarrierPhoneNumber] ADD CONSTRAINT [FK_InternationalLinehaulCarrierPhoneNumber_PhoneType] FOREIGN KEY ([PhoneTypeFID]) REFERENCES [dbo].[PhoneType] ([PhoneTypeID])
GO
GRANT SELECT ON  [dbo].[InternationalLinehaulCarrierPhoneNumber] TO [MssExec]
GRANT INSERT ON  [dbo].[InternationalLinehaulCarrierPhoneNumber] TO [MssExec]
GRANT DELETE ON  [dbo].[InternationalLinehaulCarrierPhoneNumber] TO [MssExec]
GRANT UPDATE ON  [dbo].[InternationalLinehaulCarrierPhoneNumber] TO [MssExec]
GO