Tables [dbo].[al_link_ca_arg_crncy]
Properties
PropertyValue
Row Count36
Created12:30:40 PM Sunday, December 05, 2010
Last Modified5:11:58 PM Tuesday, April 26, 2011
Columns
NameData TypeCollationMax Length (Bytes)Allow NullsDefault
Cluster Primary Key pk_al_link_ca_arg_crncy: dlkey\currency_type_codedlkeysmallint2
No
Cluster Primary Key pk_al_link_ca_arg_crncy: dlkey\currency_type_codeForeign Keys al_link_ca_arg_crncy_fk01: [dbo].[ca_currency_type].currency_type_codecurrency_type_codevarchar(3)SQL_Latin1_General_CP1_CS_AS3
No
creation_usernvarchar(255)SQL_Latin1_General_CP1_CI_AS510
Yes
creation_dateint4
Yes
last_update_usernvarchar(255)SQL_Latin1_General_CP1_CI_AS510
Yes
last_update_dateint4
Yes
version_numberint4
Yes
('0')
culture_defaultint4
No
((1))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_al_link_ca_arg_crncy: dlkey\currency_type_codepk_al_link_ca_arg_crncydlkey, currency_type_code
Yes
Foreign Keys Foreign Keys
NameColumns
al_link_ca_arg_crncy_fk01currency_type_code->[dbo].[ca_currency_type].[currency_type_code]
Permissions
TypeActionOwning Principal
GrantDeleteswcmadmin
GrantInsertswcmadmin
GrantSelectswcmadmin
GrantUpdateswcmadmin
SQL Script
CREATE TABLE [dbo].[al_link_ca_arg_crncy]
(
[dlkey] [smallint] NOT NULL,
[currency_type_code] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__al_link_c__versi__5BAFFECD] DEFAULT ('0'),
[culture_default] [int] NOT NULL CONSTRAINT [DF__al_link_c__cultu__2E0568C5] DEFAULT ((1))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_link_ca_arg_crncy] ADD CONSTRAINT [pk_al_link_ca_arg_crncy] PRIMARY KEY CLUSTERED ([dlkey], [currency_type_code]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_link_ca_arg_crncy] ADD CONSTRAINT [al_link_ca_arg_crncy_fk01] FOREIGN KEY ([currency_type_code]) REFERENCES [dbo].[ca_currency_type] ([currency_type_code])
GO
GRANT SELECT ON  [dbo].[al_link_ca_arg_crncy] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_link_ca_arg_crncy] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_link_ca_arg_crncy] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_link_ca_arg_crncy] TO [swcmadmin]
GO
Uses