test

Tables (17)

Comments

  • comment_id — VARCHAR(45) — Primary key — NOT NULL
  • text — TINYTEXT — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP
  • region — VARCHAR(20)
  • user_id — VARCHAR(45) — NOT NULL
  • mother_id — VARCHAR(45) — NOT NULL
  • likes — INT — NOT NULL
  • is_updated — TIMESTAMP

Connect

  • source_id — VARCHAR(45) — Primary key — NOT NULL
  • destination_id — VARCHAR(45) — Primary key — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP
  • connect_type — INT — NOT NULL

Follows

  • follower_id — VARCHAR(45) — Primary key — NOT NULL
  • following_id — VARCHAR(45) — Primary key — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP

Hashtags

  • hashtag_id — VARCHAR(45) — Primary key — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP
  • count — INT — NOT NULL
  • hashtag_name — VARCHAR(30) — NOT NULL

IP_addresses

  • user_id — VARCHAR(45) — Primary key — NOT NULL
  • is_created — TIMESTAMP — Primary key — NOT NULL
  • source_ipv4 — VARCHAR(20) — NOT NULL
  • source_ipv6 — VARCHAR(30) — NOT NULL
  • is_updated — TIMESTAMP
  • is_deleted — TIMESTAMP

Likes

  • user_id — VARCHAR(45) — Primary key — NOT NULL
  • destination_id — VARCHAR(45) — Primary key — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP

Logs_network

  • no — INT — Primary key — NOT NULL
  • event_type — INT — NOT NULL
  • level — INT — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • provider_name — VARCHAR(60)
  • destination_id — VARCHAR(45) — NOT NULL
  • source_ipv4 — VARCHAR(20) — NOT NULL
  • source_port — INT — NOT NULL
  • source_ipv6 — VARCHAR(30) — NOT NULL
  • location — VARCHAR(50) — NOT NULL
  • user_id — VARCHAR(45)

Message

  • room_id — INT — Primary key — NOT NULL
  • no — INT — Primary key — NOT NULL
  • text — VARCHAR(256) — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP
  • user_id — VARCHAR(45) — NOT NULL

Message_room

  • room_id — VARCHAR(45) — Primary key — NOT NULL
  • user1_id — VARCHAR(45) — NOT NULL
  • user2_id — VARCHAR(45) — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP
  • is_updated — TIMESTAMP

Photos

  • photo_id — VARCHAR(45) — Primary key — NOT NULL
  • user_id — VARCHAR(45) — NOT NULL
  • latitude — FLOAT — NOT NULL
  • longitude — FLOAT — NOT NULL
  • image_url — VARCHAR(100) — NOT NULL
  • imagefile_size — INT — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP
  • image_caption — VARCHAR(100)
  • region — VARCHAR(20)
  • mother_id — VARCHAR(30) — NOT NULL
  • image_type — VARCHAR(10) — NOT NULL

Posts

  • post_id — VARCHAR(45) — Primary key — NOT NULL
  • content_id — VARCHAR(45) — NOT NULL
  • user_id — VARCHAR(45) — NOT NULL
  • text — VARCHAR(300) — NOT NULL
  • views — INT — NOT NULL
  • post_type — VARCHAR(10) — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP

Saved_posts

  • user_id — VARCHAR(45) — Primary key — NOT NULL
  • groupname — VARCHAR(30) — Primary key — NOT NULL
  • post_id — VARCHAR(45) — NOT NULL
  • group_id — VARCHAR(45) — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP
  • is_updated — TIMESTAMP

Stories

  • story_id — VARCHAR(45) — Primary key — NOT NULL
  • content_id — VARCHAR(45) — NOT NULL
  • data_type — INT — NOT NULL
  • mother_id — VARCHAR(45)
  • user_id — VARCHAR(45) — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP

Story_album

  • album_id — VARCHAR(45) — Primary key — NOT NULL
  • user_id — VARCHAR(45) — NOT NULL
  • photo_id — VARCHAR(45)
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP
  • type — VARCHAR(10) — NOT NULL
  • name — VARCHAR(20)

Tags

  • user_id — VARCHAR(45) — Primary key — NOT NULL
  • destination_id — VARCHAR(45) — Primary key — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP

Users

  • user_id — VARCHAR(45) — Primary key — NOT NULL
  • username — VARCHAR(45) — NOT NULL
  • email — VARCHAR(25)
  • password — VARCHAR(45) — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • profile — TINYTEXT
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP
  • region — varchar(20)
  • user_type — INT — NOT NULL
  • photo_id — VARCHAR(45)
  • followers — INT — NOT NULL
  • followings — INT — NOT NULL
  • posts — INT — NOT NULL
  • website — VARCHAR(45) — NOT NULL
  • is_updated — TIMESTAMP

Videos

  • video_id — VARCHAR(45) — Primary key — NOT NULL
  • user_id — VARCHAR(45) — NOT NULL
  • latitude — FLOAT — NOT NULL
  • longitude — FLOAT — NOT NULL
  • videofile_size — INT — NOT NULL
  • is_created — TIMESTAMP — NOT NULL
  • is_deleted — TIMESTAMP
  • video_caption — TINYTEXT
  • region — VARCHAR(20)
  • length — INT — NOT NULL
  • video_url — VARCHAR(100) — NOT NULL