Revision 2, Sql Server

Revision 2

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 27, rows affected: 18, absolute service time: 0,25 sec, absolute service time: 0,24 sec

fork mode | history

  
CustomerId
StatusName
PreviousStatus

1
1
Pending
NULL

2
1
Started
Pending

3
1
Finished
Started

4
2
Running
NULL

5
2
Stopped
Running

6
2
Finished
Stopped

7
3
Up
NULL

8
3
Down
Up

9
3
Finished
Down


  
CustomerStatusId
CustomerId
StatusId

1
1
1
1

2
2
1
2

3
3
1
3

4
4
2
11

5
5
2
12

6
6
2
13

7
7
3
44

8
8
3
45

9
9
3
46


  
StatusId
StatusName

1
1
Pending

2
2
Started

3
3
Finished

4
11
Running

5
12
Stopped

6
13
Finished

7
44
Up

8
45
Down

9
46
Finished

λ

                                      .NET NoSQL database for rapid development