dbschema.txt

CREATE TABLE main.posts (
    id text PRIMARY KEY,
    geolocation frozen<tuple<double, double>>,
    multimediaurl list<text>,
    textcontent text,
    timestamp timestamp,
    lastupdatetimestamp timestamp,

    userid text,
    username text,
    profilephoto text,
    language text,

    classifier int,
    isclassified boolean,
    class text,

    translator int,
    istranslated boolean,
    translatedtextcontent text
)

CREATE TABLE main.requests (
    id text PRIMARY KEY,
    umbrellatype text,
    item text,
    quantity int,
    
    postid text,
    geolocation frozen<tuple<double, double>>,
    translatedtextcontent text,
    timestamp timestamp,
    postclass text,
    
    userid text,
    username text,
    profilephoto text,
    
    matcherid int,
    ismatched boolean
)


CREATE TABLE main.donations (
    id text PRIMARY KEY,
    umbrellatype text,
    item text,
    quantity int,

    postid text,
    geolocation frozen<tuple<double, double>>,
    translatedtextcontent text,
    timestamp timestamp,
    postclass text,

    userid text,
    username text,
    profilephoto text,

    matcherid int,
    ismatched boolean
);

CREATE TABLE main.MATCHES(
    requestID text,
    donationID text,
    matcherID int,
    matchtime timestamp,
    requesterAck boolean,
    donorAck boolean,
    PRIMARY KEY ((requestID,donationID))
);

CREATE TABLE IF NOT EXISTS main.USERS
(
    id text PRIMARY KEY,
    name text,
    phoneNumber text,
    address text,
    dateofbirth text,
    email text,
    gender text,
    maskednumber text,
    password text,
    phone text,
    profileimage text,
    username text,
    language text
);

CREATE TABLE main.INSTANCES(
    id int PRIMARY KEY,
    type text,
    userid text,
    name text,
    phoneNumber text,
    address text
)