risavkarna

SET SCHEMA CHALLENGE3;

DROP TYPE UNKNOWN_TWEET_T;
CREATE TYPE UNKNOWN_TWEET_T AS TABLE 
(	
  "ID" BIGINT NOT NULL,							-- Unique identifier for this Tweet
  "TEXT" nvarchar(800) NOT NULL,            	-- The actual text of the status update
  "TRUNCATED" TINYINT NOT NULL default 0,  		-- (1 = True, 0 = False) Indicates whether the text was truncated, for example, as a result of a retweet exceeding the 140 character Tweet length. Truncated text will end in ellipsis, like this ... 
  "SOURCE" nvarchar(255),                   	-- Utility used to post the Tweet, as an HTML-formatted string. (e.g. 'web')
  "CREATED_AT" DATETIME not null,				-- UTC time when this Tweet was created.

risavkarna

{
    "contributors": null,
    "coordinates": null,
    "in_reply_to_user_id": null,
    "truncated": false,
    "text": "#VerguenzaK los aplaudidores y reidores de la presidentA",
    "entities": {
        "hashtags": [
            {
                "text": "VerguenzaK",