22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[T_Follow] (
[FollowerID] [nvarchar](128) NOT NULL,
[LeaderID] [nvarchar](128) NOT NULL,
[FollowDate] [datetime] NOT NULL,
CONSTRAINT [PK_dbo.T_Follow] PRIMARY KEY ([FollowerID], [LeaderID])
)
CREATE INDEX [IX_FollowerID] ON [dbo].[T_Follow]([FollowerID])
CREATE INDEX [IX_LeaderID] ON [dbo].[T_Follow]([LeaderID])
ALTER TABLE [dbo].[T_Follow] ADD CONSTRAINT [FK_dbo.T_Follow_dbo.T_User_FollowerID] FOREIGN KEY ([FollowerID]) REFERENCES [dbo].[T_User] ([UserID]) ON DELETE CASCADE
ALTER TABLE [dbo].[T_Follow] ADD CONSTRAINT [FK_dbo.T_Follow_dbo.T_User_LeaderID] FOREIGN KEY ([LeaderID]) REFERENCES [dbo].[T_User] ([UserID]) ON DELETE CASCADE
-- Create table
create table TA
(
id varchar2(40) not null,
name varchar2(40)
)
;
-- Create/Recreate primary, unique and foreign key constraints
alter table TA
add constraint PK_TA_ID primary key (ID);
----------
-- Create table
create table TB
(
f_aid varchar2(40),
l_aid varchar2(40)
)
;
-- Create/Recreate primary, unique and foreign key constraints
alter table TB
add constraint FK_F_AID foreign key (F_AID)
references ta (ID) on delete cascade;
alter table TB
add constraint FK_L_AID foreign key (L_AID)
references ta (ID) on delete cascade;
CREATE TABLE T_User(
UserID [nvarchar](128) PRIMARY KEY,
UserName NVARCHAR(20)
)
CREATE TABLE [dbo].[T_Follow] (
[FollowerID] [nvarchar](128) NOT NULL,
[LeaderID] [nvarchar](128) NOT NULL,
[FollowDate] [datetime] NOT NULL,
CONSTRAINT [PK_dbo.T_Follow] PRIMARY KEY ([FollowerID], [LeaderID])
)
CREATE INDEX [IX_FollowerID] ON [dbo].[T_Follow]([FollowerID])
CREATE INDEX [IX_LeaderID] ON [dbo].[T_Follow]([LeaderID])
ALTER TABLE [dbo].[T_Follow] ADD CONSTRAINT [FK_dbo.T_Follow_dbo.T_User_FollowerID] FOREIGN KEY ([FollowerID]) REFERENCES [dbo].[T_User] ([UserID]) ON DELETE no ACTION;
ALTER TABLE [dbo].[T_Follow] ADD CONSTRAINT [FK_dbo.T_Follow_dbo.T_User_LeaderID] FOREIGN KEY ([LeaderID]) REFERENCES [dbo].[T_User] ([UserID]) ON DELETE no ACTION;