Ghost141

Keybase proof

I hereby claim:

• I am ghost141 on github.
• I am ghost_141 (https://keybase.io/ghost_141) on keybase.
• I have a public key ASDXcsFRkg6qBd-7TlvXR6W22b_K6IhgFdZh9EYP45jSbwo

To claim this, I am signing this object:

Ghost141

SELECT
SKIP @firstRowIndex@
FIRST @pageSize@
* 
FROM table(MULTISET(
SELECT
  p.problem_id
, c.component_id 
, ro.room_id
, p.name AS problem_name

Ghost141

CREATE TABLE patient(
    patient_id,
    name,
    birth_date
)

CREATE TABLE user_role_lu ( --1 -> admin, 2 -> district_manager, 3 -> hospital_manager, 4 -> doctor, 5 -> patient
    user_role_id,
    name,
    description

Ghost141

/*
 * Copyright (C) 2014 TopCoder Inc., All Rights Reserved.
 *
 * @version 1.0
 * @author Ghost_141
 */
"use strict";

var async = require('async');
var _ = require('underscore');

Ghost141

exports.getBasicUserProfile = {
    name: 'getBasicUserProfile',
    description: 'getBasicUserProfile',
    inputs: {
        required: ['handle'],
        optional: []
    },
    blockedConnectionTypes: [],
    outputExample: {},
    version: 'v2',