Tables [cohesion].[cc_session]
Properties
PropertyValue
Row Count4781
Created11:18:09 AM Friday, April 20, 2007
Last Modified11:18:09 AM Friday, April 20, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK__cc_session__117F9D94: session_idsession_idint4
No
Foreign Keys FK__cc_sessio__cendu__1273C1CD: [cohesion].[cc_user].cendura_idIndexes XIE1cc_session: cendura_idcendura_idint4
Yes
session_begindatetime8
Yes
session_enddatetime8
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__cc_session__117F9D94: session_idPK__cc_session__117F9D94session_id
Yes
XIE1cc_sessioncendura_id
Foreign Keys Foreign Keys
NameColumns
FK__cc_sessio__cendu__1273C1CDcendura_id->[cohesion].[cc_user].[cendura_id]
SQL Script
CREATE TABLE [cohesion].[cc_session]
(
[session_id] [int] NOT NULL,
[cendura_id] [int] NULL,
[session_begin] [datetime] NULL,
[session_end] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_session] ADD CONSTRAINT [PK__cc_session__117F9D94] PRIMARY KEY CLUSTERED ([session_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_session] ON [cohesion].[cc_session] ([cendura_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_session] ADD CONSTRAINT [FK__cc_sessio__cendu__1273C1CD] FOREIGN KEY ([cendura_id]) REFERENCES [cohesion].[cc_user] ([cendura_id])
GO
Uses
Used By