Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
11_26_2018 [2018/11/26 21:26] – cynthia.kahn | 11_26_2018 [2018/11/26 21:30] (current) – cynthia.kahn | ||
---|---|---|---|
Line 16: | Line 16: | ||
\\ | \\ | ||
CREATE TABLE users_info( \\ | CREATE TABLE users_info( \\ | ||
- | userID BIGINT, | + | userID BIGINT, |
- | userName TEXT, \\ | + | userName TEXT, |
- | screenName TEXT, \\ | + | screenName TEXT, |
- | userLocation TEXT, \\ | + | userLocation TEXT, |
- | url TEXT, \\ | + | url TEXT, |
- | description TEXT, \\ | + | description TEXT, |
- | translatorType TEXT, \\ | + | translatorType TEXT, |
- | protected TEXT, \\ | + | protected TEXT, |
- | verified TEXT, \\ | + | verified TEXT, |
- | followersCount INTEGER, | + | followersCount INTEGER, |
- | friendsCount INTEGER, | + | friendsCount INTEGER, |
- | listedCount INTEGER, | + | listedCount INTEGER, |
- | favouritesCount INTEGER, | + | favouritesCount INTEGER, |
- | statusesCount INTEGER, | + | statusesCount INTEGER, |
- | userCreated VARCHAR(50), | + | userCreated VARCHAR(50), |
- | | + | |
- | userTimeZone VARCHAR(50), | + | userTimeZone VARCHAR(50), |
- | geoEnabled TEXT, \\ | + | geoEnabled TEXT, |
- | lang TEXT, \\ | + | lang TEXT, |
- | contributorsEnabled TEXT, \\ | + | contributorsEnabled TEXT, |
- | isTranslator TEXT, \\ | + | isTranslator TEXT, |
- | profileBackgroundColor TEXT, \\ | + | profileBackgroundColor TEXT, |
- | profileBackgroundImageURL TEXT, \\ | + | profileBackgroundImageURL TEXT, |
- | profileBackgroundTile TEXT, \\ | + | profileBackgroundTile TEXT, |
- | profileLinkColor TEXT, \\ | + | profileLinkColor TEXT, |
- | profileSidebarBorderColor TEXT, \\ | + | profileSidebarBorderColor TEXT, |
- | profileSidebarFillColor TEXT, \\ | + | profileSidebarFillColor TEXT, |
- | profileTextColor TEXT, \\ | + | profileTextColor TEXT, |
- | profileUseBackgroundImage TEXT, \\ | + | profileUseBackgroundImage TEXT, |
- | profileImageURL TEXT, \\ | + | profileImageURL TEXT, |
- | defaultProfile TEXT, \\ | + | defaultProfile TEXT, |
- | defaultProfileImage TEXT, \\ | + | defaultProfileImage TEXT, |
- | userFollowing TEXT, \\ | + | userFollowing TEXT, |
- | followRequestSent TEXT, \\ | + | followRequestSent TEXT, |
- | notifications TEXT \\ | + | notifications TEXT |
); | ); | ||
+ | \\ | ||
+ | psql cynthiak | ||
+ | \copy users_info FROM '/ | ||
+ | \\ | ||
+ | **//SQL to create table entities_info// | ||
+ | \\ | ||
+ | DROP TABLE IF EXISTS entities_info; | ||
+ | \\ | ||
+ | CREATE TABLE entities_info( \\ | ||
+ | | ||
+ | entitiesURL TEXT, | ||
+ | userMentionsID1 BIGINT, | ||
+ | userMentionsID2 BIGINT, | ||
+ | symbols TEXT, | ||
+ | entitiesMediaID BIGINT, | ||
+ | entitiesMediaIndices TEXT, | ||
+ | entitiesMediaURL TEXT, | ||
+ | entitiesType TEXT, | ||
+ | entitiesSizeSmall TEXT, | ||
+ | entitiesSizeMedium TEXT, | ||
+ | entitiesSizeThumb TEXT, | ||
+ | entitiesSizeLarge TEXT, | ||
+ | extendedEntitiesMediaID BIGINT, | ||
+ | extendedEntitiesMediaIndices TEXT, | ||
+ | extendedEntitiesMediaURL TEXT, | ||
+ | extendedDisplayURL TEXT, | ||
+ | extendedExpandedURL TEXT, | ||
+ | extendedEntitiesType TEXT, | ||
+ | extendedSizeSmall TEXT, | ||
+ | extendedSizeMedium TEXT, | ||
+ | extendedSizeThumb TEXT, | ||
+ | extendedSizeLarge TEXT | ||
+ | ); | ||
+ | \\ | ||
+ | psql cynthiak | ||
+ | \copy entities_info FROM '/ | ||