Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- module T {
- type A {
- Id : Integer32 = AutoNumber();
- } where identity Id;
- As : A*;
- type B {
- Id : Integer32 = AutoNumber();
- // A : A;
- // } where A in As && identity Id;
- } where identity Id;
- Bs : B*;
- type C {
- Id : Integer32 = AutoNumber();
- B : B;
- } where B in Bs && identity Id;
- Cs : C*;
- }
- set xact_abort on;
- go
- begin transaction;
- go
- set ansi_nulls on;
- go
- create schema [T];
- go
- create table [T].[As]
- (
- [Id] int not null identity,
- constraint [PK_As] primary key clustered ([Id])
- );
- go
- create table [T].[Bs]
- (
- [Id] int not null identity,
- constraint [PK_Bs] primary key clustered ([Id])
- );
- go
- create table [T].[Cs]
- (
- [Id] int not null identity,
- [B] int not null,
- constraint [PK_Cs] primary key clustered ([Id]),
- constraint [FK_Cs_B_T_Bs] foreign key ([B]) references [T].[Bs] ([Id])
- );
- go
- commit transaction;
- go
- A : A;
- } where A in As && identity Id;
- // } where identity Id;
- type A {
- Id : Integer32 = AutoNumber();
- } where identity Id;
- As : A*;
- type B {
- Id : Integer32 = AutoNumber();
- A : A;
- } where identity Id;
- Bs : (B where value.A in As)*;
- type C {
- Id : Integer32 = AutoNumber();
- B : B;
- } where identity Id && B in Bs;
- Cs : (C where value.B in Bs)*;
Add Comment
Please, Sign In to add comment