[dbo].[ARCCustomerContactPhoneNumber]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count (~)	0
Created	7:48:55 PM Saturday, February 7, 2026
Last Modified	7:48:55 PM Saturday, February 7, 2026

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count (~)

Created

7:48:55 PM Saturday, February 7, 2026

Last Modified

7:48:55 PM Saturday, February 7, 2026

	Name	Data Type	Max Length (Bytes)	Identity
	ARCCustomerContactPhoneNumberId	int	4	1 - 1
	CountryCodeStandardFID	int	4
	AreaCode	[dbo].[PhoneAreaCode]	4
	LocalNumber	[dbo].[PhoneLocalNumber]	20
	Extension	[dbo].[PhoneExtension]	10
$Indexes IX_ARCCustomerContactPhoneNumber_ContactAndPhoneType: ARCCustomerContactFid\ARCCustomerContactPhoneTypeFid$	ARCCustomerContactFid	int	4
$Indexes IX_ARCCustomerContactPhoneNumber_ContactAndPhoneType: ARCCustomerContactFid\ARCCustomerContactPhoneTypeFid$	ARCCustomerContactPhoneTypeFid	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

ARCCustomerContactPhoneNumberId

int

1 - 1

CountryCodeStandardFID

int

AreaCode

[dbo].[PhoneAreaCode]

LocalNumber

[dbo].[PhoneLocalNumber]

Extension

[dbo].[PhoneExtension]

$Indexes IX_ARCCustomerContactPhoneNumber_ContactAndPhoneType: ARCCustomerContactFid\ARCCustomerContactPhoneTypeFid$

ARCCustomerContactFid

int

Foreign Keys FK_ARCCustomerContactPhoneNumber_ARCCustomerContactPhoneType: [dbo].[ARCCustomerContactPhoneType].ARCCustomerContactPhoneTypeFid

$Indexes IX_ARCCustomerContactPhoneNumber_ContactAndPhoneType: ARCCustomerContactFid\ARCCustomerContactPhoneTypeFid$

ARCCustomerContactPhoneTypeFid

int

	Name	Columns	Unique
	PK_ARCCustomerContactPhoneNumber	ARCCustomerContactPhoneNumberId
	IX_ARCCustomerContactPhoneNumber_ContactAndPhoneType	ARCCustomerContactFid, ARCCustomerContactPhoneTypeFid

Name

Columns

Unique

PK_ARCCustomerContactPhoneNumber

ARCCustomerContactPhoneNumberId

IX_ARCCustomerContactPhoneNumber_ContactAndPhoneType

ARCCustomerContactFid, ARCCustomerContactPhoneTypeFid

Name	Delete	Columns
FK_ARCCustomerContactPhoneNumber_ARCCustomerContact	Cascade	ARCCustomerContactFid->[dbo].[ARCCustomerContact].[ARCCustomerContactId]
FK_ARCCustomerContactPhoneNumber_ARCCustomerContactPhoneType		ARCCustomerContactPhoneTypeFid->[dbo].[ARCCustomerContactPhoneType].[ARCCustomerContactPhoneTypeId]
FK_ARCCustomerContactPhoneNumber_CountryCodeStandard		CountryCodeStandardFID->[dbo].[CountryCodeStandard].[CountryCodeStandardID]

Name

Delete

Columns

FK_ARCCustomerContactPhoneNumber_ARCCustomerContact

Cascade

ARCCustomerContactFid->[dbo].[ARCCustomerContact].[ARCCustomerContactId]

FK_ARCCustomerContactPhoneNumber_ARCCustomerContactPhoneType

ARCCustomerContactPhoneTypeFid->[dbo].[ARCCustomerContactPhoneType].[ARCCustomerContactPhoneTypeId]

FK_ARCCustomerContactPhoneNumber_CountryCodeStandard

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

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].[ARCCustomerContactPhoneNumber]
(
[ARCCustomerContactPhoneNumberId] [int] NOT NULL IDENTITY(1, 1),
[CountryCodeStandardFID] [int] NULL,
[AreaCode] [dbo].[PhoneAreaCode] NULL,
[LocalNumber] [dbo].[PhoneLocalNumber] NULL,
[Extension] [dbo].[PhoneExtension] NULL,
[ARCCustomerContactFid] [int] NOT NULL,
[ARCCustomerContactPhoneTypeFid] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARCCustomerContactPhoneNumber] ADD CONSTRAINT [PK_ARCCustomerContactPhoneNumber] PRIMARY KEY NONCLUSTERED  ([ARCCustomerContactPhoneNumberId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARCCustomerContactPhoneNumber] ADD CONSTRAINT [IX_ARCCustomerContactPhoneNumber_ContactAndPhoneType] UNIQUE NONCLUSTERED  ([ARCCustomerContactFid], [ARCCustomerContactPhoneTypeFid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARCCustomerContactPhoneNumber] ADD CONSTRAINT [FK_ARCCustomerContactPhoneNumber_ARCCustomerContact] FOREIGN KEY ([ARCCustomerContactFid]) REFERENCES [dbo].[ARCCustomerContact] ([ARCCustomerContactId]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ARCCustomerContactPhoneNumber] ADD CONSTRAINT [FK_ARCCustomerContactPhoneNumber_ARCCustomerContactPhoneType] FOREIGN KEY ([ARCCustomerContactPhoneTypeFid]) REFERENCES [dbo].[ARCCustomerContactPhoneType] ([ARCCustomerContactPhoneTypeId])
GO
ALTER TABLE [dbo].[ARCCustomerContactPhoneNumber] ADD CONSTRAINT [FK_ARCCustomerContactPhoneNumber_CountryCodeStandard] FOREIGN KEY ([CountryCodeStandardFID]) REFERENCES [dbo].[CountryCodeStandard] ([CountryCodeStandardID])
GO
GRANT SELECT ON  [dbo].[ARCCustomerContactPhoneNumber] TO [MssExec]
GRANT INSERT ON  [dbo].[ARCCustomerContactPhoneNumber] TO [MssExec]
GRANT DELETE ON  [dbo].[ARCCustomerContactPhoneNumber] TO [MssExec]
GRANT UPDATE ON  [dbo].[ARCCustomerContactPhoneNumber] TO [MssExec]
GO