Tables [dbo].[wsm_advanced_psk_sched]
Properties
PropertyValue
HeapYes
Row Count0
Created11:08:02 AM Wednesday, March 07, 2007
Last Modified11:09:57 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Foreign Keys r_1542: [dbo].[wsm_advanced_psk].advanced_psk_sched_idIndexes xif1wsm_advanced_psk_sched: advanced_psk_sched_idIndexes xwsm_advpsk_schd_index: advanced_psk_sched_id\start_timeadvanced_psk_sched_idint4
Yes
Indexes xwsm_advpsk_schd_index: advanced_psk_sched_id\start_timestart_timeint4
No
pskbinary(1024)1024
No
Indexes Indexes
NameColumnsUnique
xwsm_advpsk_schd_indexadvanced_psk_sched_id, start_time
Yes
xif1wsm_advanced_psk_schedadvanced_psk_sched_id
Foreign Keys Foreign Keys
NameColumns
r_1542advanced_psk_sched_id->[dbo].[wsm_advanced_psk].[advanced_psk_sched_id]
Permissions
TypeActionOwning Principal
GrantInsertwsm_admin_group
GrantDeletewsm_admin_group
GrantSelectwsm_admin_group
GrantUpdatewsm_admin_group
SQL Script
CREATE TABLE [dbo].[wsm_advanced_psk_sched]
(
[advanced_psk_sched_id] [int] NULL,
[start_time] [int] NOT NULL,
[psk] [binary] (1024) NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_advanced_psk_sched] ON [dbo].[wsm_advanced_psk_sched] ([advanced_psk_sched_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xwsm_advpsk_schd_index] ON [dbo].[wsm_advanced_psk_sched] ([advanced_psk_sched_id], [start_time]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_advanced_psk_sched] ADD CONSTRAINT [r_1542] FOREIGN KEY ([advanced_psk_sched_id]) REFERENCES [dbo].[wsm_advanced_psk] ([advanced_psk_sched_id])
GO
GRANT SELECT ON  [dbo].[wsm_advanced_psk_sched] TO [wsm_admin_group]
GRANT INSERT ON  [dbo].[wsm_advanced_psk_sched] TO [wsm_admin_group]
GRANT DELETE ON  [dbo].[wsm_advanced_psk_sched] TO [wsm_admin_group]
GRANT UPDATE ON  [dbo].[wsm_advanced_psk_sched] TO [wsm_admin_group]
GO
Uses