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