ddl.aql

//Datatypes

create type EmploymentType as {
    organization: string,
    start_date: date,
    end_date: date?
}

create type GleambookUserType as {
    id: int64,
    alias: string,
    name: string,
    user_since: datetime,
    friend_ids: {{ int64 }},
    employment: [EmploymentType]
}

create type GleambookMessageType as {
    message_id: int64,
    author_id: int64,
    in_response_to: int64?,
    sender_location: point,
    send_time: datetime,
    message: string
}

create type ChirpUserType as {
    screen_name: string,
    lang: string,
    friends_count: int32,
    statuses_count: int32,
    name: string,
    followers_count: int32
}

create type ChirpMessageType as {
    chirpid: int64,    
    user: ChirpUserType,
    sender_location: point,
    send_time: datetime,
    referred_topics: {{ string }},
    message_text: string
}


//Datasets

create dataset ChirpMessages(ChirpMessageType)
primary key chirpid;

create dataset GleambookUsers(GleambookUserType)
primary key id;    

create dataset GleambookMessages(GleambookMessageType)
primary key message_id;


//Secondary Indices

create index usrSinceIx on GleambookUsers(user_since);
create index authorIdIx on GleambookMessages(author_id);
create index sndTimeIx on ChirpMessages(send_time);
create index sendLocIx on ChirpMessages(sender_location) type rtree;
create index msgNGramIdx on ChirpMessages(message_text) type ngram(2);