text:
#set( $symbol_pound = '#' )
#set( $symbol_dollar = '$' )
#set( $symbol_escape = '\' )
/**
 * Copyright (C) 2012 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package filters;

import ninja.Context;
import ninja.Filter;
import ninja.FilterChain;
import ninja.Result;

import org.slf4j.Logger;

import com.google.inject.Inject;

/**
 * This is just a demo for a filter. This filter just logs a request in level
 * info. Be inspired and use your own filter.
 *
 * Filters can be attached to classes or methods via @FilterWith(LoggerFilter.class)
 *
 * @author ra
 *
 */
public class LoggerFilter implements Filter {

    private final Logger logger;

    @Inject
    public LoggerFilter(Logger logger) {
        this.logger = logger;

    }

    @Override
    public Result filter(FilterChain chain, Context context) {

        logger.info("Got request from : " + context.getRequestPath());
        return chain.next(context);
    }

}


text:
Clinical significance|Count
:--|:--
Benign/Likely benign|10289
Pathogenic/Likely pathogenic|4554
Likely benign, other|17
Benign, other|16
Pathogenic, risk factor|14
Pathogenic, other|11
Conflicting interpretations of pathogenicity, other|10
Uncertain significance, other|8
Uncertain significance, risk factor|6
Pathogenic, Affects|5
Likely pathogenic, other|4
Benign, risk factor|3
Conflicting interpretations of pathogenicity, risk factor|3
Pathogenic/Likely pathogenic, other|2
Likely pathogenic, risk factor|2
Pathogenic, drug response|2
Conflicting interpretations of pathogenicity, association, risk factor|2
Likely benign, risk factor|2
Pathogenic, association|2
other, risk factor|2
Benign/Likely benign, risk factor|1
Uncertain significance, Affects|1
Pathogenic/Likely pathogenic, risk factor|1
Pathogenic/Likely pathogenic, association|1
Conflicting interpretations of pathogenicity, association|1
Benign/Likely benign, other|1
Likely pathogenic, Affects|1

## All clinical significance levels
Clinical significance|Count
:--|:--
uncertain significance|570108
likely benign|255243
benign|200028
pathogenic|153707
likely pathogenic|68972
not provided|17992
conflicting interpretations of pathogenicity|16512
drug response|2721
other|2284
risk factor|1064
association|371
affects|195
conflicting data from submitters|193
protective|95
confers sensitivity|13
association not found|2

## Records with multiple mode of inheritance values
RCV|Modes of inheritance
:--|:--
[RCV000005614](https://www.ncbi.nlm.nih.gov/clinvar/RCV000005614/)|Autosomal dominant inheritance, Autosomal recessive inheritance
[RCV000019333](https://www.ncbi.nlm.nih.gov/clinvar/RCV000019333/)|Autosomal dominant inheritance, Autosomal recessive inheritance
[RCV000056231](https://www.ncbi.nlm.nih.gov/clinvar/RCV000056231/)|Autosomal dominant inheritance, Autosomal recessive inheritance
[RCV000077045](https://www.ncbi.nlm.nih.gov/clinvar/RCV000077045/)|Autosomal dominant inheritance, Autosomal recessive inheritance
[RCV000116222](https://www.ncbi.nlm.nih.gov/clinvar/RCV000116222/)|Autosomal dominant inheritance, Autosomal recessive inheritance
[RCV000169276](https://www.ncbi.nlm.nih.gov/clinvar/RCV000169276/)|Autosomal dominant inheritance, Autosomal recessive inheritance
[RCV000379715](https://www.ncbi.nlm.nih.gov/clinvar/RCV000379715/)|Autosomal dominant inheritance, Autosomal recessive inheritance
[RCV000408777](https://www.ncbi.nlm.nih.gov/clinvar/RCV000408777/)|Autosomal dominant inheritance, Autosomal recessive inheritance
[RCV000475238](https://www.ncbi.nlm.nih.gov/clinvar/RCV000475238/)|Autosomal dominant inheritance, Autosomal recessive inheritance
[RCV000029440](https://www.ncbi.nlm.nih.gov/clinvar/RCV000029440/)|Autosomal dominant inheritance, Autosomal unknown
[RCV000029850](https://www.ncbi.nlm.nih.gov/clinvar/RCV000029850/)|Autosomal dominant inheritance, Autosomal unknown
[RCV000030128](https://www.ncbi.nlm.nih.gov/clinvar/RCV000030128/)|Autosomal dominant inheritance, Autosomal unknown
[RCV000030518](https://www.ncbi.nlm.nih.gov/clinvar/RCV000030518/)|Autosomal dominant inheritance, Autosomal unknown
[RCV000030535](https://www.ncbi.nlm.nih.gov/clinvar/RCV000030535/)|Autosomal dominant inheritance, Autosomal unknown
[RCV000146115](https://www.ncbi.nlm.nih.gov/clinvar/RCV000146115/)|Autosomal dominant inheritance, Autosomal unknown
[RCV000208873](https://www.ncbi.nlm.nih.gov/clinvar/RCV000208873/)|Autosomal dominant inheritance, Autosomal unknown
[RCV000037676](https://www.ncbi.nlm.nih.gov/clinvar/RCV000037676/)|Autosomal dominant inheritance, Somatic mutation
[RCV000123070](https://www.ncbi.nlm.nih.gov/clinvar/RCV000123070/)|Autosomal dominant inheritance, Somatic mutation
[RCV000157426](https://www.ncbi.nlm.nih.gov/clinvar/RCV000157426/)|Autosomal dominant inheritance, Somatic mutation
[RCV000211849](https://www.ncbi.nlm.nih.gov/clinvar/RCV000211849/)|Autosomal dominant inheritance, Somatic mutation
[RCV000211850](https://www.ncbi.nlm.nih.gov/clinvar/RCV000211850/)|Autosomal dominant inheritance, Somatic mutation
[RCV000440827](https://www.ncbi.nlm.nih.gov/clinvar/RCV000440827/)|Autosomal dominant inheritance, Somatic mutation
[RCV000023087](https://www.ncbi.nlm.nih.gov/clinvar/RCV000023087/)|Autosomal dominant inheritance, Sporadic
[RCV000054404](https://www.ncbi.nlm.nih.gov/clinvar/RCV000054404/)|Autosomal dominant inheritance, Sporadic
[RCV000145972](https://www.ncbi.nlm.nih.gov/clinvar/RCV000145972/)|Autosomal dominant inheritance, Sporadic
[RCV000147730](https://www.ncbi.nlm.nih.gov/clinvar/RCV000147730/)|Autosomal dominant inheritance, Sporadic
[RCV000381002](https://www.ncbi.nlm.nih.gov/clinvar/RCV000381002/)|Autosomal dominant inheritance, Sporadic
[RCV000414819](https://www.ncbi.nlm.nih.gov/clinvar/RCV000414819/)|Autosomal dominant inheritance, Sporadic
[RCV000416146](https://www.ncbi.nlm.nih.gov/clinvar/RCV000416146/)|Autosomal dominant inheritance, Sporadic
[RCV000496159](https://www.ncbi.nlm.nih.gov/clinvar/RCV000496159/)|Autosomal dominant inheritance, Sporadic
[RCV000496332](https://www.ncbi.nlm.nih.gov/clinvar/RCV000496332/)|Autosomal dominant inheritance, Sporadic
[RCV000626481](https://www.ncbi.nlm.nih.gov/clinvar/RCV000626481/)|Autosomal dominant inheritance, Sporadic
[RCV000758715](https://www.ncbi.nlm.nih.gov/clinvar/RCV000758715/)|Autosomal dominant inheritance, Sporadic
[RCV000760175](https://www.ncbi.nlm.nih.gov/clinvar/RCV000760175/)|Autosomal dominant inheritance, Sporadic
[RCV001199967](https://www.ncbi.nlm.nih.gov/clinvar/RCV001199967/)|Autosomal dominant inheritance, Sporadic
[RCV000012580](https://www.ncbi.nlm.nih.gov/clinvar/RCV000012580/)|Autosomal dominant inheritance, X-linked dominant inheritance
[RCV000477948](https://www.ncbi.nlm.nih.gov/clinvar/RCV000477948/)|Autosomal dominant inheritance, X-linked inheritance
[RCV000020022](https://www.ncbi.nlm.nih.gov/clinvar/RCV000020022/)|Autosomal recessive inheritance, Autosomal unknown
[RCV001264819](https://www.ncbi.nlm.nih.gov/clinvar/RCV001264819/)|Autosomal recessive inheritance, Unknown mechanism
[RCV000853199](https://www.ncbi.nlm.nih.gov/clinvar/RCV000853199/)|Autosomal recessive inheritance, X-linked recessive inheritance
[RCV000029316](https://www.ncbi.nlm.nih.gov/clinvar/RCV000029316/)|Autosomal recessive inheritance, autosomal unknown
[RCV000029365](https://www.ncbi.nlm.nih.gov/clinvar/RCV000029365/)|Autosomal recessive inheritance, autosomal unknown
[RCV000029370](https://www.ncbi.nlm.nih.gov/clinvar/RCV000029370/)|Autosomal recessive inheritance, autosomal unknown
[RCV000030177](https://www.ncbi.nlm.nih.gov/clinvar/RCV000030177/)|Autosomal recessive inheritance, autosomal unknown
[RCV000149480](https://www.ncbi.nlm.nih.gov/clinvar/RCV000149480/)|Autosomal unknown, Sporadic
[RCV000012590](https://www.ncbi.nlm.nih.gov/clinvar/RCV000012590/)|Sporadic, X-linked inheritance
[RCV000056321](https://www.ncbi.nlm.nih.gov/clinvar/RCV000056321/)|Sporadic, X-linked inheritance
[RCV000012601](https://www.ncbi.nlm.nih.gov/clinvar/RCV000012601/)|X-linked dominant inheritance, X-linked inheritance
[RCV000170103](https://www.ncbi.nlm.nih.gov/clinvar/RCV000170103/)|X-linked dominant inheritance, X-linked inheritance
[RCV000256179](https://www.ncbi.nlm.nih.gov/clinvar/RCV000256179/)|X-linked dominant inheritance, X-linked inheritance
[RCV000714397](https://www.ncbi.nlm.nih.gov/clinvar/RCV000714397/)|X-linked dominant inheritance, X-linked inheritance
[RCV000758011](https://www.ncbi.nlm.nih.gov/clinvar/RCV000758011/)|X-linked dominant inheritance, X-linked inheritance
[RCV000011232](https://www.ncbi.nlm.nih.gov/clinvar/RCV000011232/)|X-linked inheritance, X-linked recessive inheritance
[RCV000011233](https://www.ncbi.nlm.nih.gov/clinvar/RCV000011233/)|X-linked inheritance, X-linked recessive inheritance
[RCV000011237](https://www.ncbi.nlm.nih.gov/clinvar/RCV000011237/)|X-linked inheritance, X-linked recessive inheritance
[RCV000030055](https://www.ncbi.nlm.nih.gov/clinvar/RCV000030055/)|X-linked inheritance, X-linked recessive inheritance
[RCV000177016](https://www.ncbi.nlm.nih.gov/clinvar/RCV000177016/)|X-linked inheritance, X-linked recessive inheritance
[RCV000179363](https://www.ncbi.nlm.nih.gov/clinvar/RCV000179363/)|X-linked inheritance, X-linked recessive inheritance
[RCV000180471](https://www.ncbi.nlm.nih.gov/clinvar/RCV000180471/)|X-linked inheritance, X-linked recessive inheritance
[RCV000180473](https://www.ncbi.nlm.nih.gov/clinvar/RCV000180473/)|X-linked inheritance, X-linked recessive inheritance
[RCV000180545](https://www.ncbi.nlm.nih.gov/clinvar/RCV000180545/)|X-linked inheritance, X-linked recessive inheritance
[RCV000223722](https://www.ncbi.nlm.nih.gov/clinvar/RCV000223722/)|X-linked inheritance, X-linked recessive inheritance
[RCV000282708](https://www.ncbi.nlm.nih.gov/clinvar/RCV000282708/)|X-linked inheritance, X-linked recessive inheritance

## Records with multiple allele origin values
Allele origins|Count
:--|:--
germline, unknown|20686
germline, not provided|2644
de novo, germline|769
germline, inherited|766
germline, maternal|726
germline, not applicable|708
germline, not provided, unknown|595
germline, paternal|569
not applicable, unknown|281
inherited, unknown|277
not provided, unknown|263
germline, maternal, unknown|224
germline, inherited, unknown|224
de novo, unknown|189
de novo, germline, unknown|187
germline, somatic|182
germline, paternal, unknown|171
maternal, unknown|151
maternal, not provided|150
germline, not applicable, unknown|131
paternal, unknown|125
not provided, paternal|105
inherited, maternal|68
maternal, paternal|65
de novo, not provided|62
inherited, paternal|51
somatic, unknown|44
maternal, not provided, paternal|36
inherited, not applicable|35
germline, maternal, paternal, unknown|30
biparental, germline|29
de novo, not applicable|28
de novo, maternal|28
germline, inherited, not provided, unknown|27
germline, maternal, paternal|23
germline, somatic, unknown|20
germline, inherited, not provided|19
germline, maternal, not provided, unknown|19
germline, inherited, paternal|18
de novo, paternal|15
de novo, inherited|15
de novo, germline, maternal, unknown|15
germline, inherited, paternal, unknown|14
inherited, not provided|13
not applicable, somatic|12
maternal, paternal, unknown|12
inherited, maternal, paternal|12
maternal, not applicable|11
de novo, maternal, not provided|11
germline, inherited, maternal|11
de novo, maternal, not provided, paternal|10
de novo, germline, not applicable|10
germline, not provided, paternal, unknown|10
de novo, germline, not provided|10
biparental, germline, unknown|9
germline, not provided, paternal|9
de novo, not provided, paternal|8
de novo, germline, maternal|8
germline, inherited, maternal, unknown|8
de novo, germline, not provided, unknown|8
germline, inherited, not applicable|7
de novo, germline, paternal, unknown|7
inherited, paternal, unknown|7
not applicable, paternal|7
germline, not applicable, not provided, unknown|7
germline, not provided, somatic, unknown|7
inherited, not provided, unknown|6
de novo, germline, inherited, unknown|6
biparental, germline, inherited, unknown|6
germline, maternal, not provided|6
not provided, somatic|6
germline, inherited, maternal, paternal, unknown|6
somatic, tested-inconclusive, unknown|6
biparental, unknown|5
germline, inherited, maternal, not provided, unknown|5
de novo, inherited, unknown|5
not provided, tested-inconclusive|4
germline, not applicable, somatic|4
de novo, germline, somatic|4
germline, tested-inconclusive|4
germline, maternal, not applicable|4
de novo, somatic|3
germline, inherited, not provided, paternal, unknown|3
de novo, germline, paternal|3
de novo, germline, inherited, maternal, unknown|3
somatic, tested-inconclusive|3
de novo, maternal, paternal|2
inherited, not applicable, unknown|2
inherited, not provided, paternal|2
germline, inherited, maternal, paternal|2
biparental, maternal|2
biparental, germline, inherited|2
not applicable, not provided|2
germline, not provided, somatic|2
inherited, maternal, unknown|2
germline, maternal, not provided, paternal, unknown|2
biparental, inherited|2
de novo, germline, inherited|2
germline, inherited, not applicable, unknown|2
biparental, inherited, not applicable|2
maternal, uniparental|2
maternal, somatic|2
germline, maternal, not applicable, unknown|2
germline, not applicable, somatic, unknown|2
de novo, germline, maternal, paternal, unknown|2
germline, not applicable, paternal, unknown|2
germline, not applicable, not provided|2
germline, somatic, tested-inconclusive, unknown|2
biparental, maternal, not provided, paternal|1
biparental, not provided|1
maternal, not provided, tested-inconclusive|1
biparental, germline, not provided, unknown|1
de novo, paternal, unknown|1
de novo, germline, inherited, paternal, unknown|1
inherited, maternal, paternal, unknown|1
de novo, tested-inconclusive|1
germline, maternal, not provided, paternal|1
biparental, germline, inherited, maternal, paternal, unknown|1
not provided, somatic, unknown|1
maternal, not provided, unknown|1
biparental, germline, maternal|1
inherited, maternal, not provided|1
inherited, tested-inconclusive|1
de novo, germline, tested-inconclusive|1
de novo, maternal, paternal, unknown|1
de novo, germline, not applicable, unknown|1
biparental, paternal, unknown|1
maternal, not applicable, unknown|1
de novo, maternal, not applicable|1
de novo, maternal, unknown|1
paternal, somatic|1
germline, uniparental|1
biparental, not applicable|1
de novo, germline, maternal, not provided|1
de novo, not provided, somatic, unknown|1
germline, inherited, somatic|1
biparental, germline, not provided|1
germline, inherited, maternal, not applicable|1
germline, inherited, not applicable, paternal|1
biparental, germline, maternal, paternal, unknown|1
germline, not applicable, not provided, somatic, unknown|1
germline, inherited, somatic, unknown|1
germline, somatic, tested-inconclusive|1
germline, maternal, somatic|1
inherited, not applicable, paternal|1
de novo, paternal, somatic|1

## Records with inconsistent mode of inheritance and allele origin values
RCV|Modes of inheritance|Allele origins
:--|:--|:--
[RCV000032907](https://www.ncbi.nlm.nih.gov/clinvar/RCV000032907/)|Autosomal dominant inheritance|de novo, germline, somatic
[RCV000031343](https://www.ncbi.nlm.nih.gov/clinvar/RCV000031343/)|Autosomal dominant inheritance|germline, inherited, somatic, unknown
[RCV000240958](https://www.ncbi.nlm.nih.gov/clinvar/RCV000240958/)|Autosomal dominant inheritance|germline, maternal, somatic
[RCV000019229](https://www.ncbi.nlm.nih.gov/clinvar/RCV000019229/)|Autosomal dominant inheritance|germline, not applicable, not provided, somatic, unknown
[RCV000003925](https://www.ncbi.nlm.nih.gov/clinvar/RCV000003925/)|Autosomal dominant inheritance|germline, not applicable, somatic
[RCV000019263](https://www.ncbi.nlm.nih.gov/clinvar/RCV000019263/)|Autosomal dominant inheritance|germline, not applicable, somatic, unknown
[RCV000009905](https://www.ncbi.nlm.nih.gov/clinvar/RCV000009905/)|Autosomal dominant inheritance|germline, not provided, somatic, unknown
[RCV000009907](https://www.ncbi.nlm.nih.gov/clinvar/RCV000009907/)|Autosomal dominant inheritance|germline, not provided, somatic, unknown
[RCV000019243](https://www.ncbi.nlm.nih.gov/clinvar/RCV000019243/)|Autosomal dominant inheritance|germline, not provided, somatic, unknown
[RCV000111891](https://www.ncbi.nlm.nih.gov/clinvar/RCV000111891/)|Autosomal dominant inheritance|germline, not provided, somatic, unknown
[RCV000112410](https://www.ncbi.nlm.nih.gov/clinvar/RCV000112410/)|Autosomal dominant inheritance|germline, not provided, somatic, unknown
[RCV000113532](https://www.ncbi.nlm.nih.gov/clinvar/RCV000113532/)|Autosomal dominant inheritance|germline, not provided, somatic, unknown
[RCV000000845](https://www.ncbi.nlm.nih.gov/clinvar/RCV000000845/)|Autosomal dominant inheritance|germline, somatic
[RCV000024242](https://www.ncbi.nlm.nih.gov/clinvar/RCV000024242/)|Autosomal dominant inheritance|germline, somatic
[RCV000031018](https://www.ncbi.nlm.nih.gov/clinvar/RCV000031018/)|Autosomal dominant inheritance|germline, somatic
[RCV000074359](https://www.ncbi.nlm.nih.gov/clinvar/RCV000074359/)|Autosomal dominant inheritance|germline, somatic
[RCV000075300](https://www.ncbi.nlm.nih.gov/clinvar/RCV000075300/)|Autosomal dominant inheritance|germline, somatic
[RCV000076272](https://www.ncbi.nlm.nih.gov/clinvar/RCV000076272/)|Autosomal dominant inheritance|germline, somatic
[RCV000077281](https://www.ncbi.nlm.nih.gov/clinvar/RCV000077281/)|Autosomal dominant inheritance|germline, somatic
[RCV000111553](https://www.ncbi.nlm.nih.gov/clinvar/RCV000111553/)|Autosomal dominant inheritance|germline, somatic
[RCV000114697](https://www.ncbi.nlm.nih.gov/clinvar/RCV000114697/)|Autosomal dominant inheritance|germline, somatic
[RCV000114982](https://www.ncbi.nlm.nih.gov/clinvar/RCV000114982/)|Autosomal dominant inheritance|germline, somatic
[RCV000114985](https://www.ncbi.nlm.nih.gov/clinvar/RCV000114985/)|Autosomal dominant inheritance|germline, somatic
[RCV000114988](https://www.ncbi.nlm.nih.gov/clinvar/RCV000114988/)|Autosomal dominant inheritance|germline, somatic
[RCV000205517](https://www.ncbi.nlm.nih.gov/clinvar/RCV000205517/)|Autosomal dominant inheritance|germline, somatic
[RCV000237153](https://www.ncbi.nlm.nih.gov/clinvar/RCV000237153/)|Autosomal dominant inheritance|germline, somatic
[RCV000237481](https://www.ncbi.nlm.nih.gov/clinvar/RCV000237481/)|Autosomal dominant inheritance|germline, somatic
[RCV000237597](https://www.ncbi.nlm.nih.gov/clinvar/RCV000237597/)|Autosomal dominant inheritance|germline, somatic
[RCV000237924](https://www.ncbi.nlm.nih.gov/clinvar/RCV000237924/)|Autosomal dominant inheritance|germline, somatic
[RCV000238117](https://www.ncbi.nlm.nih.gov/clinvar/RCV000238117/)|Autosomal dominant inheritance|germline, somatic
[RCV000238228](https://www.ncbi.nlm.nih.gov/clinvar/RCV000238228/)|Autosomal dominant inheritance|germline, somatic
[RCV000609972](https://www.ncbi.nlm.nih.gov/clinvar/RCV000609972/)|Autosomal dominant inheritance|germline, somatic
[RCV000787352](https://www.ncbi.nlm.nih.gov/clinvar/RCV000787352/)|Autosomal dominant inheritance|germline, somatic
[RCV000003878](https://www.ncbi.nlm.nih.gov/clinvar/RCV000003878/)|Autosomal dominant inheritance|germline, somatic, unknown
[RCV000031535](https://www.ncbi.nlm.nih.gov/clinvar/RCV000031535/)|Autosomal dominant inheritance|germline, somatic, unknown
[RCV000077518](https://www.ncbi.nlm.nih.gov/clinvar/RCV000077518/)|Autosomal dominant inheritance|germline, somatic, unknown
[RCV000111758](https://www.ncbi.nlm.nih.gov/clinvar/RCV000111758/)|Autosomal dominant inheritance|germline, somatic, unknown
[RCV000148749](https://www.ncbi.nlm.nih.gov/clinvar/RCV000148749/)|Autosomal dominant inheritance|germline, somatic, unknown
[RCV000257639](https://www.ncbi.nlm.nih.gov/clinvar/RCV000257639/)|Autosomal dominant inheritance|germline, somatic, unknown
[RCV000850247](https://www.ncbi.nlm.nih.gov/clinvar/RCV000850247/)|Autosomal dominant inheritance|maternal, somatic
[RCV000210355](https://www.ncbi.nlm.nih.gov/clinvar/RCV000210355/)|Autosomal dominant inheritance|somatic
[RCV000236033](https://www.ncbi.nlm.nih.gov/clinvar/RCV000236033/)|Autosomal dominant inheritance|somatic
[RCV000560194](https://www.ncbi.nlm.nih.gov/clinvar/RCV000560194/)|Autosomal dominant inheritance|somatic
[RCV000590930](https://www.ncbi.nlm.nih.gov/clinvar/RCV000590930/)|Autosomal dominant inheritance|somatic
[RCV000590964](https://www.ncbi.nlm.nih.gov/clinvar/RCV000590964/)|Autosomal dominant inheritance|somatic
[RCV000664310](https://www.ncbi.nlm.nih.gov/clinvar/RCV000664310/)|Autosomal dominant inheritance|somatic
[RCV000722144](https://www.ncbi.nlm.nih.gov/clinvar/RCV000722144/)|Autosomal dominant inheritance|somatic
[RCV000754837](https://www.ncbi.nlm.nih.gov/clinvar/RCV000754837/)|Autosomal dominant inheritance|somatic
[RCV000853399](https://www.ncbi.nlm.nih.gov/clinvar/RCV000853399/)|Autosomal dominant inheritance|somatic
[RCV000991329](https://www.ncbi.nlm.nih.gov/clinvar/RCV000991329/)|Autosomal dominant inheritance|somatic
[RCV000993765](https://www.ncbi.nlm.nih.gov/clinvar/RCV000993765/)|Autosomal dominant inheritance|somatic
[RCV000993766](https://www.ncbi.nlm.nih.gov/clinvar/RCV000993766/)|Autosomal dominant inheritance|somatic
[RCV001172316](https://www.ncbi.nlm.nih.gov/clinvar/RCV001172316/)|Autosomal dominant inheritance|somatic
[RCV001250663](https://www.ncbi.nlm.nih.gov/clinvar/RCV001250663/)|Autosomal dominant inheritance|somatic
[RCV001270434](https://www.ncbi.nlm.nih.gov/clinvar/RCV001270434/)|Autosomal dominant inheritance|somatic
[RCV001270435](https://www.ncbi.nlm.nih.gov/clinvar/RCV001270435/)|Autosomal dominant inheritance|somatic
[RCV001270447](https://www.ncbi.nlm.nih.gov/clinvar/RCV001270447/)|Autosomal dominant inheritance|somatic
[RCV001281670](https://www.ncbi.nlm.nih.gov/clinvar/RCV001281670/)|Autosomal dominant inheritance|somatic
[RCV000680026](https://www.ncbi.nlm.nih.gov/clinvar/RCV000680026/)|Autosomal dominant inheritance|somatic, unknown
[RCV000236291](https://www.ncbi.nlm.nih.gov/clinvar/RCV000236291/)|Autosomal recessive inheritance|germline, somatic
[RCV000223734](https://www.ncbi.nlm.nih.gov/clinvar/RCV000223734/)|Autosomal recessive inheritance|somatic
[RCV000735435](https://www.ncbi.nlm.nih.gov/clinvar/RCV000735435/)|Autosomal recessive inheritance|somatic
[RCV000758079](https://www.ncbi.nlm.nih.gov/clinvar/RCV000758079/)|Autosomal recessive inheritance|somatic
[RCV000855541](https://www.ncbi.nlm.nih.gov/clinvar/RCV000855541/)|Autosomal recessive inheritance|somatic
[RCV001250665](https://www.ncbi.nlm.nih.gov/clinvar/RCV001250665/)|Autosomal recessive inheritance|somatic
[RCV001250666](https://www.ncbi.nlm.nih.gov/clinvar/RCV001250666/)|Autosomal recessive inheritance|somatic
[RCV001250667](https://www.ncbi.nlm.nih.gov/clinvar/RCV001250667/)|Autosomal recessive inheritance|somatic
[RCV000495738](https://www.ncbi.nlm.nih.gov/clinvar/RCV000495738/)|Mitochondrial inheritance|germline, somatic
[RCV000505667](https://www.ncbi.nlm.nih.gov/clinvar/RCV000505667/)|Mitochondrial inheritance|somatic
[RCV000708565](https://www.ncbi.nlm.nih.gov/clinvar/RCV000708565/)|Somatic mutation|de novo
[RCV000754629](https://www.ncbi.nlm.nih.gov/clinvar/RCV000754629/)|Somatic mutation|de novo
[RCV001034608](https://www.ncbi.nlm.nih.gov/clinvar/RCV001034608/)|Somatic mutation|de novo
[RCV001254923](https://www.ncbi.nlm.nih.gov/clinvar/RCV001254923/)|Somatic mutation|de novo
[RCV000114677](https://www.ncbi.nlm.nih.gov/clinvar/RCV000114677/)|Somatic mutation|de novo, germline, somatic
[RCV000220945](https://www.ncbi.nlm.nih.gov/clinvar/RCV000220945/)|Somatic mutation|de novo, somatic
[RCV000007884](https://www.ncbi.nlm.nih.gov/clinvar/RCV000007884/)|Somatic mutation|germline, somatic
[RCV000014173](https://www.ncbi.nlm.nih.gov/clinvar/RCV000014173/)|Somatic mutation|germline, somatic
[RCV000014936](https://www.ncbi.nlm.nih.gov/clinvar/RCV000014936/)|Somatic mutation|germline, somatic
[RCV000014937](https://www.ncbi.nlm.nih.gov/clinvar/RCV000014937/)|Somatic mutation|germline, somatic
[RCV000014939](https://www.ncbi.nlm.nih.gov/clinvar/RCV000014939/)|Somatic mutation|germline, somatic
[RCV000014978](https://www.ncbi.nlm.nih.gov/clinvar/RCV000014978/)|Somatic mutation|germline, somatic
[RCV000015769](https://www.ncbi.nlm.nih.gov/clinvar/RCV000015769/)|Somatic mutation|germline, somatic
[RCV000021873](https://www.ncbi.nlm.nih.gov/clinvar/RCV000021873/)|Somatic mutation|germline, somatic
[RCV000114391](https://www.ncbi.nlm.nih.gov/clinvar/RCV000114391/)|Somatic mutation|germline, somatic
[RCV000114716](https://www.ncbi.nlm.nih.gov/clinvar/RCV000114716/)|Somatic mutation|germline, somatic
[RCV000114729](https://www.ncbi.nlm.nih.gov/clinvar/RCV000114729/)|Somatic mutation|germline, somatic
[RCV000114733](https://www.ncbi.nlm.nih.gov/clinvar/RCV000114733/)|Somatic mutation|germline, somatic
[RCV000154233](https://www.ncbi.nlm.nih.gov/clinvar/RCV000154233/)|Somatic mutation|germline, somatic
[RCV000211848](https://www.ncbi.nlm.nih.gov/clinvar/RCV000211848/)|Somatic mutation|germline, somatic
[RCV000417859](https://www.ncbi.nlm.nih.gov/clinvar/RCV000417859/)|Somatic mutation|germline, somatic
[RCV000419670](https://www.ncbi.nlm.nih.gov/clinvar/RCV000419670/)|Somatic mutation|germline, somatic
[RCV000420800](https://www.ncbi.nlm.nih.gov/clinvar/RCV000420800/)|Somatic mutation|germline, somatic
[RCV000429467](https://www.ncbi.nlm.nih.gov/clinvar/RCV000429467/)|Somatic mutation|germline, somatic
[RCV000431704](https://www.ncbi.nlm.nih.gov/clinvar/RCV000431704/)|Somatic mutation|germline, somatic
[RCV000432558](https://www.ncbi.nlm.nih.gov/clinvar/RCV000432558/)|Somatic mutation|germline, somatic
[RCV000433543](https://www.ncbi.nlm.nih.gov/clinvar/RCV000433543/)|Somatic mutation|germline, somatic
[RCV000434992](https://www.ncbi.nlm.nih.gov/clinvar/RCV000434992/)|Somatic mutation|germline, somatic
[RCV000435642](https://www.ncbi.nlm.nih.gov/clinvar/RCV000435642/)|Somatic mutation|germline, somatic
[RCV000436995](https://www.ncbi.nlm.nih.gov/clinvar/RCV000436995/)|Somatic mutation|germline, somatic
[RCV000438560](https://www.ncbi.nlm.nih.gov/clinvar/RCV000438560/)|Somatic mutation|germline, somatic
[RCV000442350](https://www.ncbi.nlm.nih.gov/clinvar/RCV000442350/)|Somatic mutation|germline, somatic
[RCV000442533](https://www.ncbi.nlm.nih.gov/clinvar/RCV000442533/)|Somatic mutation|germline, somatic
[RCV000589007](https://www.ncbi.nlm.nih.gov/clinvar/RCV000589007/)|Somatic mutation|germline, somatic
[RCV000007871](https://www.ncbi.nlm.nih.gov/clinvar/RCV000007871/)|Somatic mutation|germline, somatic, unknown
[RCV000013951](https://www.ncbi.nlm.nih.gov/clinvar/RCV000013951/)|Somatic mutation|germline, somatic, unknown
[RCV000014924](https://www.ncbi.nlm.nih.gov/clinvar/RCV000014924/)|Somatic mutation|germline, somatic, unknown
[RCV000014941](https://www.ncbi.nlm.nih.gov/clinvar/RCV000014941/)|Somatic mutation|germline, somatic, unknown
[RCV000175096](https://www.ncbi.nlm.nih.gov/clinvar/RCV000175096/)|Somatic mutation|germline, somatic, unknown
[RCV000206210](https://www.ncbi.nlm.nih.gov/clinvar/RCV000206210/)|Somatic mutation|germline, somatic, unknown
[RCV000984546](https://www.ncbi.nlm.nih.gov/clinvar/RCV000984546/)|Somatic mutation|not applicable
[RCV000454367](https://www.ncbi.nlm.nih.gov/clinvar/RCV000454367/)|Somatic mutation|not applicable, somatic
[RCV000454368](https://www.ncbi.nlm.nih.gov/clinvar/RCV000454368/)|Somatic mutation|not applicable, somatic
[RCV000454369](https://www.ncbi.nlm.nih.gov/clinvar/RCV000454369/)|Somatic mutation|not applicable, somatic
[RCV000454371](https://www.ncbi.nlm.nih.gov/clinvar/RCV000454371/)|Somatic mutation|not applicable, somatic
[RCV000454372](https://www.ncbi.nlm.nih.gov/clinvar/RCV000454372/)|Somatic mutation|not applicable, somatic
[RCV000454373](https://www.ncbi.nlm.nih.gov/clinvar/RCV000454373/)|Somatic mutation|not applicable, somatic
[RCV000598801](https://www.ncbi.nlm.nih.gov/clinvar/RCV000598801/)|Somatic mutation|not applicable, somatic
[RCV000505630](https://www.ncbi.nlm.nih.gov/clinvar/RCV000505630/)|Somatic mutation|paternal
[RCV000173889](https://www.ncbi.nlm.nih.gov/clinvar/RCV000173889/)|Somatic mutation|somatic, unknown
[RCV000421625](https://www.ncbi.nlm.nih.gov/clinvar/RCV000421625/)|Somatic mutation|somatic, unknown
[RCV000421755](https://www.ncbi.nlm.nih.gov/clinvar/RCV000421755/)|Somatic mutation|somatic, unknown
[RCV000423448](https://www.ncbi.nlm.nih.gov/clinvar/RCV000423448/)|Somatic mutation|somatic, unknown
[RCV000424592](https://www.ncbi.nlm.nih.gov/clinvar/RCV000424592/)|Somatic mutation|somatic, unknown
[RCV000427081](https://www.ncbi.nlm.nih.gov/clinvar/RCV000427081/)|Somatic mutation|somatic, unknown
[RCV000427260](https://www.ncbi.nlm.nih.gov/clinvar/RCV000427260/)|Somatic mutation|somatic, unknown
[RCV000431156](https://www.ncbi.nlm.nih.gov/clinvar/RCV000431156/)|Somatic mutation|somatic, unknown
[RCV000436831](https://www.ncbi.nlm.nih.gov/clinvar/RCV000436831/)|Somatic mutation|somatic, unknown
[RCV000442220](https://www.ncbi.nlm.nih.gov/clinvar/RCV000442220/)|Somatic mutation|somatic, unknown
[RCV001263488](https://www.ncbi.nlm.nih.gov/clinvar/RCV001263488/)|Somatic mutation|unknown
[RCV001281344](https://www.ncbi.nlm.nih.gov/clinvar/RCV001281344/)|Somatic mutation|unknown
[RCV000454370](https://www.ncbi.nlm.nih.gov/clinvar/RCV000454370/)|Sporadic|not applicable, somatic
[RCV000515554](https://www.ncbi.nlm.nih.gov/clinvar/RCV000515554/)|Sporadic|somatic
[RCV001252644](https://www.ncbi.nlm.nih.gov/clinvar/RCV001252644/)|X-linked dominant inheritance|paternal, somatic
[RCV000145521](https://www.ncbi.nlm.nih.gov/clinvar/RCV000145521/)|X-linked inheritance|germline, somatic, unknown
[RCV000680058](https://www.ncbi.nlm.nih.gov/clinvar/RCV000680058/)|X-linked inheritance|somatic
[RCV000680061](https://www.ncbi.nlm.nih.gov/clinvar/RCV000680061/)|X-linked inheritance|somatic
[RCV001250664](https://www.ncbi.nlm.nih.gov/clinvar/RCV001250664/)|X-linked inheritance|somatic
[RCV000785880](https://www.ncbi.nlm.nih.gov/clinvar/RCV000785880/)|X-linked recessive inheritance|somatic
[RCV000785881](https://www.ncbi.nlm.nih.gov/clinvar/RCV000785881/)|X-linked recessive inheritance|somatic
[RCV001270620](https://www.ncbi.nlm.nih.gov/clinvar/RCV001270620/)|X-linked recessive inheritance|somatic

redpajama_set_name: RedPajamaGithub


text:
package com.github.meteoorkip.solver.library;

/**
 * An exception thrown when something goes wrong in one of the libraries.
 */
public class LibraryException extends RuntimeException {

    /**
     * Creates the exception with the given cause.
     *
     * @param cause The given cause.
     */
    public LibraryException(Throwable cause) {
        super(cause);
    }

    /**
     * Creates the exception with the formatted message using the specified format {@link String} and arguments.
     *
     * @param message The format {@link String}.
     * @param args    The given arguments.
     */
    public LibraryException(String message, Object... args) {
        super(String.format(message, args));
    }
}


text:
import numpy as np
import scipy.io
import pandas as pd
import fnmatch
import os
import matplotlib.pyplot as plt
import glob
import re
import pdb
import sys
import shutil
#find onset files matching .csv and return matlab cell array

def cleanUp(subject):
    for file in glob.glob('/data/modMap/subjects/%s/%s/rsaRemap*_responses.csv' %(subject,day)):
        os.remove(file)
    for file in glob.glob('/data/modMap/subjects/%s/%s/*practiceOnsets*.csv' %(subject,day)):
        os.remove(file)

def copyOnsets(subject):
    for file in glob.glob('/home/beukema2/Dropbox/modmap/MRI/%s/rsaRemap_%s_Day%s_Session*_responses.csv' %(subject, subject, which_day[day])):
        shutil.copy(file, '/data/modMap/subjects/%s/%s' %(subject, day))
    for file in glob.glob('/home/beukema2/Dropbox/modmap/MRI/%s/%s_practiceOnsets_Day%s_session*.csv' %(subject, subject, which_day[day])):
        shutil.copy(file, '/data/modMap/subjects/%s/%s' %(subject, day))

def genOrderings(subjectDir):
    summary_files = []
    mapping_files = []
    for file in os.listdir(subjectDir):
        if fnmatch.fnmatch(file, '*rsaRemap*responses*.csv'):
            summary_files.append(os.path.realpath(os.path.join(subjectDir,file)))
        if fnmatch.fnmatch(file, '*_practiceOnsets_Day*.csv'):
            mapping_files.append(os.path.realpath(os.path.join(subjectDir,file)))
    cue_reordering = pd.DataFrame(columns = ['1','2', '3', '4', '5', '6', '7', '8'])
    finger_reordering = pd.DataFrame(columns = ['1','2', '3', '4', '5', '6', '7', '8'])

    for file in summary_files:
        (prefix, sep, suffix) = file.rpartition('.')
        base=os.path.basename(file)

        df = pd.read_csv(file)
        df['keysPressed'].replace(to_replace='[^0-9]', value='', inplace=True, regex=True)
        df['correctResp'].replace(to_replace='[^0-9]', value='', inplace=True, regex=True)
        df['onsetTime'] = df['onsetTime'].apply(int)
        df['onsetTime'] = df['onsetTime']/2 # to convert to TRs for spm
        df['chunk'] = df.apply(lambda x : x['chunkID'] if (x['Error'] == 0) else 'NaN', axis=1)
        df['fingers'] = df.apply(lambda x : x['correctResp'] if (x['Error'] == 0) else 'NaN', axis=1)
        df['firstfinger'] = [item[0] for item in df['fingers']]
        #Generate the onsets for each different chunk
        new_onsets = np.empty(df.shape[1]+1, dtype=object)
        new_onsets[0] = np.array(df[df['chunk'] == 'chunk_R1']['onsetTime'][:,np.newaxis])
        new_onsets[1] = np.array(df[df['chunk'] == 'chunk_R2']['onsetTime'][:,np.newaxis])
        new_onsets[2] = np.array(df[df['chunk'] == 'chunk_R3']['onsetTime'][:,np.newaxis])
        new_onsets[3] = np.array(df[df['chunk'] == 'chunk_R4']['onsetTime'][:,np.newaxis])
        new_onsets[4] = np.array(df[df['chunk'] == 'chunk_C1']['onsetTime'][:,np.newaxis])
        new_onsets[5] = np.array(df[df['chunk'] == 'chunk_C2']['onsetTime'][:,np.newaxis])
        new_onsets[6] = np.array(df[df['chunk'] == 'chunk_C3']['onsetTime'][:,np.newaxis])
        new_onsets[7] = np.array(df[df['chunk'] == 'chunk_C4']['onsetTime'][:,np.newaxis])

        #Get the cue reordering for this run
        session = base[26:-14]
        print session

        mapping_df = df.drop(['onsetTime', 'correctResp','keysPressed', 'chunkID', 'responseTimes', 'Error', 'fingers'], axis=1)
        mapping_df = mapping_df.drop_duplicates()
        mapping_df = mapping_df[mapping_df['chunk'].str.contains("chunk_C")].reset_index()
        chunk_to_row = {'chunk_C1': 5, 'chunk_C2': 6,'chunk_C3': 7,'chunk_C4': 8}
        mapping_df['row_num'] = mapping_df['chunk'].map(chunk_to_row)
        mapping_df.sort_values(by=['row_num'],inplace=True)
        #mapping_df['firstfinger'] = mapping_df['firstfinger'] + 4
        mapping_df['firstfinger'] = pd.to_numeric(mapping_df.firstfinger)
        mapping_df['firstfinger'] = mapping_df['firstfinger'] + 3
        cue_reordering.loc[:,session] = mapping_df['firstfinger'].values

        #Get the finger reordering for this run
        temp_file = mapping_files[0]
        mapping_file =  temp_file[0:-5] + base[26] + '.csv'
        df_firstcue = pd.read_csv(mapping_file)
        di = {'image_folder/stim_2.png': "A", 'image_folder/stim_3.png': "B",'image_folder/stim_4.png': "C",'image_folder/stim_5.png': "D"}
        df_firstcue = df_firstcue.replace({"img_id": di})
        df_firstcue.cor_ans = df_firstcue.cor_ans.astype(str)
        my_dict = dict(zip(df_firstcue.cor_ans,df_firstcue.img_id))
        df = df.replace({"firstfinger":my_dict})
        mapping_df = df.drop(['onsetTime', 'correctResp','keysPressed', 'chunkID', 'responseTimes', 'Error', 'fingers'], axis=1)
        mapping_df = mapping_df.drop_duplicates()
        mapping_df = mapping_df[mapping_df['chunk'].str.contains("chunk_R")].reset_index()
        chunk_to_row = {'chunk_R1': 1, 'chunk_R2': 2,'chunk_R3': 3,'chunk_R4': 4}
        cue_to_row = {'A': 1, 'B': 2,'C': 3,'D': 4}
        mapping_df['row_num'] = mapping_df['chunk'].map(chunk_to_row)
        mapping_df['cue_to_row'] = mapping_df['firstfinger'].map(cue_to_row)
        mapping_df.sort_values(by=['row_num'],inplace=True)
        finger_reordering.loc[:,session] = mapping_df['cue_to_row'].values
        print finger_reordering
    finger_fn = subjectDir + '/finger_reordering_'+day+'.csv'
    cue_fn = subjectDir + '/cue_reordering_'+day+'.csv'
    finger_reordering.to_csv(finger_fn,sep='\t', index=False, header=False)
    cue_reordering.to_csv(cue_fn,sep='\t', index=False, header=False)

subject = sys.argv[1]
day = sys.argv[2]
which_day = {'Pre':'1', 'Post':'2'}
copyOnsets(subject)

for root, dirs, files in os.walk('/data/modMap/subjects/%s/%s' % (subject,day)):
    genOrderings(root)

#Housekeeping
cleanUp(subject)


text:
#pragma once
#include <aws/connect/Connect_EXPORTS.h>
#include <aws/connect/ConnectRequest.h>
#include <aws/core/utils/memory/stl/AWSString.h>
#include <aws/core/utils/memory/stl/AWSVector.h>
#include <aws/connect/model/MonitorCapability.h>
#include <utility>
#include <aws/core/utils/UUID.h>

namespace Aws
{
namespace Connect
{
namespace Model
{

  /**
   */
  class AWS_CONNECT_API MonitorContactRequest : public ConnectRequest
  {
  public:
    MonitorContactRequest();

    // Service request name is the Operation name which will send this request out,
    // each operation should has unique request name, so that we can get operation's name from this request.
    // Note: this is not true for response, multiple operations may have the same response name,
    // so we can not get operation's name from response.
    inline virtual const char* GetServiceRequestName() const override { return "MonitorContact"; }

    Aws::String SerializePayload() const override;

    /**
     *
The identifier of the Amazon Connect instance. You can find the instanceId in
     * the ARN of the instance.

     */
    inline const Aws::String& GetInstanceId() const{ return m_instanceId; }

    /**
     *
The identifier of the Amazon Connect instance. You can find the instanceId in
     * the ARN of the instance.

     */
    inline bool InstanceIdHasBeenSet() const { return m_instanceIdHasBeenSet; }

    /**
     *
The identifier of the Amazon Connect instance. You can find the instanceId in
     * the ARN of the instance.

     */
    inline void SetInstanceId(const Aws::String& value) { m_instanceIdHasBeenSet = true; m_instanceId = value; }

    /**
     *
The identifier of the Amazon Connect instance. You can find the instanceId in
     * the ARN of the instance.

     */
    inline void SetInstanceId(Aws::String&& value) { m_instanceIdHasBeenSet = true; m_instanceId = std::move(value); }

    /**
     *
The identifier of the Amazon Connect instance. You can find the instanceId in
     * the ARN of the instance.

     */
    inline void SetInstanceId(const char* value) { m_instanceIdHasBeenSet = true; m_instanceId.assign(value); }

    /**
     *
The identifier of the Amazon Connect instance. You can find the instanceId in
     * the ARN of the instance.

     */
    inline MonitorContactRequest& WithInstanceId(const Aws::String& value) { SetInstanceId(value); return *this;}

    /**
     *
The identifier of the Amazon Connect instance. You can find the instanceId in
     * the ARN of the instance.

     */
    inline MonitorContactRequest& WithInstanceId(Aws::String&& value) { SetInstanceId(std::move(value)); return *this;}

    /**
     *
The identifier of the Amazon Connect instance. You can find the instanceId in
     * the ARN of the instance.

     */
    inline MonitorContactRequest& WithInstanceId(const char* value) { SetInstanceId(value); return *this;}

    /**
     *
The identifier of the contact.

     */
    inline const Aws::String& GetContactId() const{ return m_contactId; }

    /**
     *
The identifier of the contact.

     */
    inline bool ContactIdHasBeenSet() const { return m_contactIdHasBeenSet; }

    /**
     *
The identifier of the contact.

     */
    inline void SetContactId(const Aws::String& value) { m_contactIdHasBeenSet = true; m_contactId = value; }

    /**
     *
The identifier of the contact.

     */
    inline void SetContactId(Aws::String&& value) { m_contactIdHasBeenSet = true; m_contactId = std::move(value); }

    /**
     *
The identifier of the contact.

     */
    inline void SetContactId(const char* value) { m_contactIdHasBeenSet = true; m_contactId.assign(value); }

    /**
     *
The identifier of the contact.

     */
    inline MonitorContactRequest& WithContactId(const Aws::String& value) { SetContactId(value); return *this;}

    /**
     *
The identifier of the contact.

     */
    inline MonitorContactRequest& WithContactId(Aws::String&& value) { SetContactId(std::move(value)); return *this;}

    /**
     *
The identifier of the contact.

     */
    inline MonitorContactRequest& WithContactId(const char* value) { SetContactId(value); return *this;}

    /**
     *
The identifier of the user account.

     */
    inline const Aws::String& GetUserId() const{ return m_userId; }

    /**
     *
The identifier of the user account.

     */
    inline bool UserIdHasBeenSet() const { return m_userIdHasBeenSet; }

    /**
     *
The identifier of the user account.

     */
    inline void SetUserId(const Aws::String& value) { m_userIdHasBeenSet = true; m_userId = value; }

    /**
     *
The identifier of the user account.

     */
    inline void SetUserId(Aws::String&& value) { m_userIdHasBeenSet = true; m_userId = std::move(value); }

    /**
     *
The identifier of the user account.

     */
    inline void SetUserId(const char* value) { m_userIdHasBeenSet = true; m_userId.assign(value); }

    /**
     *
The identifier of the user account.

     */
    inline MonitorContactRequest& WithUserId(const Aws::String& value) { SetUserId(value); return *this;}

    /**
     *
The identifier of the user account.

     */
    inline MonitorContactRequest& WithUserId(Aws::String&& value) { SetUserId(std::move(value)); return *this;}

    /**
     *
The identifier of the user account.

     */
    inline MonitorContactRequest& WithUserId(const char* value) { SetUserId(value); return *this;}

    /**
     *
Specify which monitoring actions the user is allowed to take. For example,
     * whether the user is allowed to escalate from silent monitoring to barge.

     */
    inline const Aws::Vector<MonitorCapability>& GetAllowedMonitorCapabilities() const{ return m_allowedMonitorCapabilities; }

    /**
     *
Specify which monitoring actions the user is allowed to take. For example,
     * whether the user is allowed to escalate from silent monitoring to barge.

     */
    inline bool AllowedMonitorCapabilitiesHasBeenSet() const { return m_allowedMonitorCapabilitiesHasBeenSet; }

    /**
     *
Specify which monitoring actions the user is allowed to take. For example,
     * whether the user is allowed to escalate from silent monitoring to barge.

     */
    inline void SetAllowedMonitorCapabilities(const Aws::Vector<MonitorCapability>& value) { m_allowedMonitorCapabilitiesHasBeenSet = true; m_allowedMonitorCapabilities = value; }

    /**
     *
Specify which monitoring actions the user is allowed to take. For example,
     * whether the user is allowed to escalate from silent monitoring to barge.

     */
    inline void SetAllowedMonitorCapabilities(Aws::Vector<MonitorCapability>&& value) { m_allowedMonitorCapabilitiesHasBeenSet = true; m_allowedMonitorCapabilities = std::move(value); }

    /**
     *
Specify which monitoring actions the user is allowed to take. For example,
     * whether the user is allowed to escalate from silent monitoring to barge.

     */
    inline MonitorContactRequest& WithAllowedMonitorCapabilities(const Aws::Vector<MonitorCapability>& value) { SetAllowedMonitorCapabilities(value); return *this;}

    /**
     *
Specify which monitoring actions the user is allowed to take. For example,
     * whether the user is allowed to escalate from silent monitoring to barge.

     */
    inline MonitorContactRequest& WithAllowedMonitorCapabilities(Aws::Vector<MonitorCapability>&& value) { SetAllowedMonitorCapabilities(std::move(value)); return *this;}

    /**
     *
Specify which monitoring actions the user is allowed to take. For example,
     * whether the user is allowed to escalate from silent monitoring to barge.

     */
    inline MonitorContactRequest& AddAllowedMonitorCapabilities(const MonitorCapability& value) { m_allowedMonitorCapabilitiesHasBeenSet = true; m_allowedMonitorCapabilities.push_back(value); return *this; }

    /**
     *
Specify which monitoring actions the user is allowed to take. For example,
     * whether the user is allowed to escalate from silent monitoring to barge.

     */
    inline MonitorContactRequest& AddAllowedMonitorCapabilities(MonitorCapability&& value) { m_allowedMonitorCapabilitiesHasBeenSet = true; m_allowedMonitorCapabilities.push_back(std::move(value)); return *this; }

    /**
     *
A unique, case-sensitive identifier that you provide to ensure the
     * idempotency of the request. If not provided, the Amazon Web Services SDK
     * populates this field. For more information about idempotency, see Making
     * retries safe with idempotent APIs.

     */
    inline const Aws::String& GetClientToken() const{ return m_clientToken; }

    /**
     *
A unique, case-sensitive identifier that you provide to ensure the
     * idempotency of the request. If not provided, the Amazon Web Services SDK
     * populates this field. For more information about idempotency, see Making
     * retries safe with idempotent APIs.

     */
    inline bool ClientTokenHasBeenSet() const { return m_clientTokenHasBeenSet; }

    /**
     *
A unique, case-sensitive identifier that you provide to ensure the
     * idempotency of the request. If not provided, the Amazon Web Services SDK
     * populates this field. For more information about idempotency, see Making
     * retries safe with idempotent APIs.

     */
    inline void SetClientToken(const Aws::String& value) { m_clientTokenHasBeenSet = true; m_clientToken = value; }

    /**
     *
A unique, case-sensitive identifier that you provide to ensure the
     * idempotency of the request. If not provided, the Amazon Web Services SDK
     * populates this field. For more information about idempotency, see Making
     * retries safe with idempotent APIs.

     */
    inline void SetClientToken(Aws::String&& value) { m_clientTokenHasBeenSet = true; m_clientToken = std::move(value); }

    /**
     *
A unique, case-sensitive identifier that you provide to ensure the
     * idempotency of the request. If not provided, the Amazon Web Services SDK
     * populates this field. For more information about idempotency, see Making
     * retries safe with idempotent APIs.

     */
    inline void SetClientToken(const char* value) { m_clientTokenHasBeenSet = true; m_clientToken.assign(value); }

    /**
     *
A unique, case-sensitive identifier that you provide to ensure the
     * idempotency of the request. If not provided, the Amazon Web Services SDK
     * populates this field. For more information about idempotency, see Making
     * retries safe with idempotent APIs.

     */
    inline MonitorContactRequest& WithClientToken(const Aws::String& value) { SetClientToken(value); return *this;}

    /**
     *
A unique, case-sensitive identifier that you provide to ensure the
     * idempotency of the request. If not provided, the Amazon Web Services SDK
     * populates this field. For more information about idempotency, see Making
     * retries safe with idempotent APIs.

     */
    inline MonitorContactRequest& WithClientToken(Aws::String&& value) { SetClientToken(std::move(value)); return *this;}

    /**
     *
A unique, case-sensitive identifier that you provide to ensure the
     * idempotency of the request. If not provided, the Amazon Web Services SDK
     * populates this field. For more information about idempotency, see Making
     * retries safe with idempotent APIs.

     */
    inline MonitorContactRequest& WithClientToken(const char* value) { SetClientToken(value); return *this;}

  private:

    Aws::String m_instanceId;
    bool m_instanceIdHasBeenSet = false;

    Aws::String m_contactId;
    bool m_contactIdHasBeenSet = false;

    Aws::String m_userId;
    bool m_userIdHasBeenSet = false;

    Aws::Vector<MonitorCapability> m_allowedMonitorCapabilities;
    bool m_allowedMonitorCapabilitiesHasBeenSet = false;

    Aws::String m_clientToken;
    bool m_clientTokenHasBeenSet = false;
  };

} // namespace Model
} // namespace Connect
} // namespace Aws


text:
#ifndef SCALAR_INT_H
#define SCALAR_INT_H

void            init_example_scalar(void);

#endif                          /* SCALAR_INT_H */


text:
/*
 * TABLE: Event
 */

CREATE TABLE Event(
    Event_ID             int               IDENTITY(100,1),
    Title                nvarchar(250)     NULL,
    Description          nvarchar(4000)    NULL,
    Start_Date           datetime2(0)      NOT NULL,
    End_Date             datetime2(0)      NULL,
    Location_ID          int               NULL,
    Registration_URI     varchar(2000)     NULL,
    Created_Date         datetime2(7)      DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)      NULL,
    Last_Updated_Date    datetime2(7)      DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)      NULL,
    CONSTRAINT pk_Event__Event_ID PRIMARY KEY CLUSTERED (Event_ID)
)
go

IF OBJECT_ID('Event') IS NOT NULL
    PRINT '<<< CREATED TABLE Event >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Event >>>'
go

/*
 * TABLE: Event_Group
 */

CREATE TABLE Event_Group(
    Event_Group_ID       int             IDENTITY(100,1),
    Event_ID             int             NOT NULL,
    Group_ID             int             NOT NULL,
    Created_Date         datetime2(7)    DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)    NULL,
    Last_Updated_Date    datetime2(7)    DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)    NULL,
    CONSTRAINT pk_Event_Group__Event_Group_ID PRIMARY KEY CLUSTERED (Event_Group_ID)
)
go

IF OBJECT_ID('Event_Group') IS NOT NULL
    PRINT '<<< CREATED TABLE Event_Group >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Event_Group >>>'
go

/*
 * TABLE: Event_Person
 */

CREATE TABLE Event_Person(
    Event_Person_ID      int             IDENTITY(100,1),
    Event_ID             int             NOT NULL,
    Person_ID            int             NOT NULL,
    Created_Date         datetime2(7)    DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)    NULL,
    Last_Updated_Date    datetime2(7)    DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)    NULL,
    CONSTRAINT pk_Event_Person__Event_Persion_ID PRIMARY KEY CLUSTERED (Event_Person_ID)
)
go

IF OBJECT_ID('Event_Person') IS NOT NULL
    PRINT '<<< CREATED TABLE Event_Person >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Event_Person >>>'
go

/*
 * TABLE: Event_Session
 */

CREATE TABLE Event_Session(
    Event_Session_ID     int             IDENTITY(100,1),
    Event_ID             int             NOT NULL,
    Session_ID           int             NOT NULL,
    Created_Date         datetime2(7)    DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)    NULL,
    Last_Updated_Date    datetime2(7)    DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)    NULL,
    CONSTRAINT pk_Event_Session__Event_Session_ID PRIMARY KEY CLUSTERED (Event_Session_ID)
)
go

IF OBJECT_ID('Event_Session') IS NOT NULL
    PRINT '<<< CREATED TABLE Event_Session >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Event_Session >>>'
go

/*
 * TABLE: Event_Sponsor
 */

CREATE TABLE Event_Sponsor(
    Event_Sponsor_ID     int             IDENTITY(100,1),
    Event_ID             int             NOT NULL,
    Sponsor_ID           int             NOT NULL,
    Created_Date         datetime2(7)    DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)    NULL,
    Last_Updated_Date    datetime2(7)    DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)    NULL,
    CONSTRAINT pk_Event_Sponsor__Event_Sponsor_ID PRIMARY KEY CLUSTERED (Event_Sponsor_ID)
)
go

IF OBJECT_ID('Event_Sponsor') IS NOT NULL
    PRINT '<<< CREATED TABLE Event_Sponsor >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Event_Sponsor >>>'
go

/*
 * TABLE: Giveaway
 */

CREATE TABLE Giveaway(
    Giveaway_ID          int               IDENTITY(100,1),
    Giveaway_Name        nvarchar(100)     NOT NULL,
    Description          nvarchar(4000)    NULL,
    Event_ID             int               NULL,
    Sponsor_ID           int               NULL,
    Person_ID            int               NULL,
    Created_Date         datetime2(7)      DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)      NULL,
    Last_Updated_Date    datetime2(7)      DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)      NULL,
    CONSTRAINT pk_Giveaway__Giveaway_ID PRIMARY KEY CLUSTERED (Giveaway_ID)
)
go

IF OBJECT_ID('Giveaway') IS NOT NULL
    PRINT '<<< CREATED TABLE Giveaway >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Giveaway >>>'
go

/*
 * TABLE: User_Group
 */

CREATE TABLE User_Group(
    Group_ID             int              IDENTITY(100,1),
    Group_Name           nvarchar(100)    NOT NULL,
    Group_Description    varchar(250)     NULL,
    Created_Date         datetime2(7)     DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)     NULL,
    Last_Updated_Date    datetime2(7)     DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)     NULL,
    CONSTRAINT pk_Group__Group_ID PRIMARY KEY CLUSTERED (Group_ID)
)
go

IF OBJECT_ID('User_Group') IS NOT NULL
    PRINT '<<< CREATED TABLE User_Group >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE User_Group >>>'
go

/*
 * TABLE: Group_Person
 */

CREATE TABLE Group_Person(
    Group_Person_ID      int             IDENTITY(100,1),
    Group_ID             int             NOT NULL,
    Person_ID            int             NOT NULL,
    Created_Date         datetime2(7)    DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)    NULL,
    Last_Updated_Date    datetime2(7)    DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)    NULL,
    CONSTRAINT pk_Group_Person__Group_Person_ID PRIMARY KEY CLUSTERED (Group_Person_ID)
)
go

IF OBJECT_ID('Group_Person') IS NOT NULL
    PRINT '<<< CREATED TABLE Group_Person >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Group_Person >>>'
go

/*
 * TABLE: Location
 */

CREATE TABLE Location(
    Location_ID          int              IDENTITY(100,1),
    Location_Name        nvarchar(100)    NOT NULL,
    Location_URI         varchar(2000)    NULL,
    Street_1             varchar(75)      NULL,
    Street_2             varchar(75)      NULL,
    City                 varchar(50)      NULL,
    State                varchar(50)      NULL,
    Zip_Code             varchar(10)      NULL,
    Map_URI              varchar(2000)    NULL,
    Latitude             numeric(9, 6)    NULL,
    Longitude            numeric(9, 6)    NULL,
    Created_Date         datetime2(7)     DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)     NULL,
    Last_Updated_Date    datetime2(7)     DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)     NULL,
    CONSTRAINT pk_Location__Location_ID PRIMARY KEY CLUSTERED (Location_ID)
)
go

IF OBJECT_ID('Location') IS NOT NULL
    PRINT '<<< CREATED TABLE Location >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Location >>>'
go

/*
 * TABLE: Person
 */

CREATE TABLE Person(
    Person_ID            int               IDENTITY(100,1),
    First_Name           nvarchar(50)      NOT NULL,
    Last_Name            nvarchar(50)      NOT NULL,
    EMail                varchar(320)      NULL,
    Member_URI           varchar(2000)     NULL,
    Twitter_Name         varchar(50)       NULL,
    Linkedin_URI         varchar(2000)     NULL,
    Bio                  nvarchar(4000)    NULL,
    Photo_URI            varchar(2000)     NULL,
    Zip                  varchar(10)       NULL,
    Created_Date         datetime2(7)      DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)      NULL,
    Last_Updated_Date    datetime2(7)      DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)      NULL,
    CONSTRAINT pk_Person__Person_ID PRIMARY KEY CLUSTERED (Person_ID)
)
go

IF OBJECT_ID('Person') IS NOT NULL
    PRINT '<<< CREATED TABLE Person >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Person >>>'
go

/*
 * TABLE: Session
 */

CREATE TABLE Session(
    Session_ID           int               IDENTITY(100,1),
    Title                nvarchar(100)     NOT NULL,
    Abstract             nvarchar(4000)    NULL,
    Session_Type_ID      int               NOT NULL,
    Created_Date         datetime2(7)      DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)      NULL,
    Last_Updated_Date    datetime2(7)      DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)      NULL,
    CONSTRAINT pk_Session__Session_ID PRIMARY KEY CLUSTERED (Session_ID)
)
go

IF OBJECT_ID('Session') IS NOT NULL
    PRINT '<<< CREATED TABLE Session >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Session >>>'
go

/*
 * TABLE: Session_Person
 */

CREATE TABLE Session_Person(
    Session_Person_ID    int             IDENTITY(100,1),
    Session_ID           int             NOT NULL,
    Person_ID            int             NOT NULL,
    Created_Date         datetime2(7)    DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)    NULL,
    Last_Updated_Date    datetime2(7)    DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)    NULL,
    CONSTRAINT pk_Session_Person__Session_Person_ID PRIMARY KEY CLUSTERED (Session_Person_ID)
)
go

IF OBJECT_ID('Session_Person') IS NOT NULL
    PRINT '<<< CREATED TABLE Session_Person >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Session_Person >>>'
go

/*
 * TABLE: Session_Type
 */

CREATE TABLE Session_Type(
    Session_Type_ID      int              IDENTITY(100,1),
    Session_Type_Name    nvarchar(100)    NOT NULL,
    Description          varchar(250)     NULL,
    Created_Date         datetime2(7)     DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)     NULL,
    Last_Updated_Date    datetime2(7)     DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)     NULL,
    CONSTRAINT pk_Session_Type__Session_Type_ID PRIMARY KEY CLUSTERED (Session_Type_ID)
)
go

IF OBJECT_ID('Session_Type') IS NOT NULL
    PRINT '<<< CREATED TABLE Session_Type >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Session_Type >>>'
go

/*
 * TABLE: Sponsor
 */

CREATE TABLE Sponsor(
    Sponsor_ID           int              IDENTITY(100,1),
    Sponsor_Name         nvarchar(100)    NOT NULL,
    Sponsor_URI          varchar(2000)    NULL,
    Image_URI            varchar(2000)    NULL,
    Created_Date         datetime2(7)     DEFAULT SYSDATETIME() NULL,
    Created_User         nvarchar(50)     NULL,
    Last_Updated_Date    datetime2(7)     DEFAULT SYSDATETIME() NOT NULL,
    Last_Updated_User    nvarchar(50)     NULL,
    CONSTRAINT pk_Sponsor__Sponsor_ID PRIMARY KEY CLUSTERED (Sponsor_ID)
)
go

IF OBJECT_ID('Sponsor') IS NOT NULL
    PRINT '<<< CREATED TABLE Sponsor >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Sponsor >>>'
go

/*
 * INDEX: ak_Event_Group__Event_ID_Group_ID
 */

CREATE UNIQUE INDEX ak_Event_Group__Event_ID_Group_ID ON Event_Group(Event_ID, Group_ID)
go
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id=OBJECT_ID('Event_Group') AND name='ak_Event_Group__Event_ID_Group_ID')
    PRINT '<<< CREATED INDEX Event_Group.ak_Event_Group__Event_ID_Group_ID >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Event_Group.ak_Event_Group__Event_ID_Group_ID >>>'
go

/*
 * INDEX: ak_Event_Person__Event_ID_Person_ID
 */

CREATE UNIQUE INDEX ak_Event_Person__Event_ID_Person_ID ON Event_Person(Event_ID, Person_ID)
go
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id=OBJECT_ID('Event_Person') AND name='ak_Event_Person__Event_ID_Person_ID')
    PRINT '<<< CREATED INDEX Event_Person.ak_Event_Person__Event_ID_Person_ID >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Event_Person.ak_Event_Person__Event_ID_Person_ID >>>'
go

/*
 * INDEX: ak_Event_Session__Event_ID_Session_ID
 */

CREATE UNIQUE INDEX ak_Event_Session__Event_ID_Session_ID ON Event_Session(Event_ID, Session_ID)
go
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id=OBJECT_ID('Event_Session') AND name='ak_Event_Session__Event_ID_Session_ID')
    PRINT '<<< CREATED INDEX Event_Session.ak_Event_Session__Event_ID_Session_ID >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Event_Session.ak_Event_Session__Event_ID_Session_ID >>>'
go

/*
 * INDEX: ak_Event_Sponsor__Event_ID_Sponsor_ID
 */

CREATE UNIQUE INDEX ak_Event_Sponsor__Event_ID_Sponsor_ID ON Event_Sponsor(Event_ID, Sponsor_ID)
go
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id=OBJECT_ID('Event_Sponsor') AND name='ak_Event_Sponsor__Event_ID_Sponsor_ID')
    PRINT '<<< CREATED INDEX Event_Sponsor.ak_Event_Sponsor__Event_ID_Sponsor_ID >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Event_Sponsor.ak_Event_Sponsor__Event_ID_Sponsor_ID >>>'
go

/*
 * INDEX: ak_Group__Group_Name
 */

CREATE UNIQUE INDEX ak_Group__Group_Name ON User_Group(Group_Name)
go
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id=OBJECT_ID('User_Group') AND name='ak_Group__Group_Name')
    PRINT '<<< CREATED INDEX User_Group.ak_Group__Group_Name >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX User_Group.ak_Group__Group_Name >>>'
go

/*
 * INDEX: ak_Group_Person__Group_ID_Person_ID
 */

CREATE UNIQUE INDEX ak_Group_Person__Group_ID_Person_ID ON Group_Person(Group_ID, Person_ID)
go
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id=OBJECT_ID('Group_Person') AND name='ak_Group_Person__Group_ID_Person_ID')
    PRINT '<<< CREATED INDEX Group_Person.ak_Group_Person__Group_ID_Person_ID >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Group_Person.ak_Group_Person__Group_ID_Person_ID >>>'
go

/*
 * INDEX: ak_Session_Person__Session_ID_Person_ID
 */

CREATE UNIQUE INDEX ak_Session_Person__Session_ID_Person_ID ON Session_Person(Session_ID, Person_ID)
go
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id=OBJECT_ID('Session_Person') AND name='ak_Session_Person__Session_ID_Person_ID')
    PRINT '<<< CREATED INDEX Session_Person.ak_Session_Person__Session_ID_Person_ID >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Session_Person.ak_Session_Person__Session_ID_Person_ID >>>'
go

/*
 * INDEX: ak_Session_Type__Session_Type_Name
 */

CREATE UNIQUE INDEX ak_Session_Type__Session_Type_Name ON Session_Type(Session_Type_Name)
go
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id=OBJECT_ID('Session_Type') AND name='ak_Session_Type__Session_Type_Name')
    PRINT '<<< CREATED INDEX Session_Type.ak_Session_Type__Session_Type_Name >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Session_Type.ak_Session_Type__Session_Type_Name >>>'
go

/*
 * INDEX: ak_Sponsor__Sponsor_Name
 */

CREATE UNIQUE INDEX ak_Sponsor__Sponsor_Name ON Sponsor(Sponsor_Name)
go
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id=OBJECT_ID('Sponsor') AND name='ak_Sponsor__Sponsor_Name')
    PRINT '<<< CREATED INDEX Sponsor.ak_Sponsor__Sponsor_Name >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Sponsor.ak_Sponsor__Sponsor_Name >>>'
go

/*
 * TABLE: Event
 */

ALTER TABLE Event ADD CONSTRAINT fk_Event_Location_ID__Location_Location_ID
    FOREIGN KEY (Location_ID)
    REFERENCES Location(Location_ID)
go

/*
 * TABLE: Event_Group
 */

ALTER TABLE Event_Group ADD CONSTRAINT fk_Event_Group_Group_ID__User_Group_Group_ID
    FOREIGN KEY (Group_ID)
    REFERENCES [User_Group](Group_ID)
go

ALTER TABLE Event_Group ADD CONSTRAINT fk_Event_Group_Group_ID__Event_Event_ID
    FOREIGN KEY (Event_ID)
    REFERENCES Event(Event_ID)
go

/*
 * TABLE: Event_Person
 */

ALTER TABLE Event_Person ADD CONSTRAINT fk_Event_Person_Person_ID__Person_Person_ID
    FOREIGN KEY (Person_ID)
    REFERENCES Person(Person_ID)
go

ALTER TABLE Event_Person ADD CONSTRAINT fk_Event_Person_Event_ID_Person_Person_ID
    FOREIGN KEY (Event_ID)
    REFERENCES Event(Event_ID)
go

/*
 * TABLE: Event_Session
 */

ALTER TABLE Event_Session ADD CONSTRAINT fk_Event_Session_Session_ID__Session_Session_ID
    FOREIGN KEY (Session_ID)
    REFERENCES Session(Session_ID)
go

ALTER TABLE Event_Session ADD CONSTRAINT fk_Event_Session_Event_ID__Event_Event_ID
    FOREIGN KEY (Event_ID)
    REFERENCES Event(Event_ID)
go

/*
 * TABLE: Event_Sponsor
 */

ALTER TABLE Event_Sponsor ADD CONSTRAINT fk_Event_Sponsor_Sponsor_ID__Sponsor_Sponsor_ID
    FOREIGN KEY (Sponsor_ID)
    REFERENCES Sponsor(Sponsor_ID)
go

ALTER TABLE Event_Sponsor ADD CONSTRAINT fk_Event_Sponsor_Event_ID__Event_Event_ID
    FOREIGN KEY (Event_ID)
    REFERENCES Event(Event_ID)
go

/*
 * TABLE: Giveaway
 */

ALTER TABLE Giveaway ADD CONSTRAINT fk_Giveaway_Sponsor_ID__Sponsor_Sponsor_ID
    FOREIGN KEY (Sponsor_ID)
    REFERENCES Sponsor(Sponsor_ID)
go

ALTER TABLE Giveaway ADD CONSTRAINT fk_Giveaway_Person_ID__Person_ID
    FOREIGN KEY (Person_ID)
    REFERENCES Person(Person_ID)
go

ALTER TABLE Giveaway ADD CONSTRAINT fk_Giveaway_Event_ID__Event_Event_ID
    FOREIGN KEY (Event_ID)
    REFERENCES Event(Event_ID)
go

/*
 * TABLE: Group_Person
 */

ALTER TABLE Group_Person ADD CONSTRAINT fk_Group_Person_Person_ID__Person_Person_ID
    FOREIGN KEY (Person_ID)
    REFERENCES Person(Person_ID)
go

ALTER TABLE Group_Person ADD CONSTRAINT fk_Group_Person_Group_ID__User_Group_Group_ID
    FOREIGN KEY (Group_ID)
    REFERENCES User_Group(Group_ID)
go

/*
 * TABLE: Session
 */

ALTER TABLE Session ADD CONSTRAINT fk_SessionSession_Type_ID__Session_Type_Session_Type_ID
    FOREIGN KEY (Session_Type_ID)
    REFERENCES Session_Type(Session_Type_ID)
go

/*
 * TABLE: Session_Person
 */

ALTER TABLE Session_Person ADD CONSTRAINT fk_Session_Person_Person_ID__Person_Person_ID
    FOREIGN KEY (Person_ID)
    REFERENCES Person(Person_ID)
go

ALTER TABLE Session_Person ADD CONSTRAINT fk_Session_Person_Session_ID__Session_Session_ID
    FOREIGN KEY (Session_ID)
    REFERENCES Session(Session_ID)
go