jellypins-dynamodb

Tables (13)

tb_comment (Untitled9)

  • Comment No (comment_no) — Number — Primary key — NOT NULL
  • Pin No (pin_no) — Number — Foreign key → tb_pin.Pin No — NOT NULL
  • User ID (user_id) — String — Foreign key → tb_user.User ID — NOT NULL
  • User Name (user_name) — String
  • Type No (type_no) — Number
  • Image Count (image_cnt) — Number
  • Images (images) — String List
  • Text (text) — String
  • Comment Count (comment_cnt) — Number
  • Hash Tags (hash_tags) — String List
  • Like Count (like_cnt) — Number
  • Create Datetime (create_datetime) — String
  • Check Datetime (check_datetime) — String
  • Update Datetime (update_datetime) — String

tb_comment_sub (CopyOfUntitled9)

  • Comment No (comment_no) — Number — Primary key — NOT NULL
  • Parent No (parent_no) — Number — Foreign key → tb_comment.Comment No — NOT NULL
  • User ID (id) — String — Foreign key → tb_comment.User ID — NOT NULL
  • User Name (user_name) — String
  • Type No (type_no) — Number
  • Image Count (image_cnt) — Number
  • Images (images) — String List
  • Text (text) — String
  • Comment Count (comment_cnt) — Number
  • Hash Tags (hash_tags) — String List
  • Like Count (like_cnt) — Number
  • Create Datetime (create_datetime) — String
  • Check Datetime (check_datetime) — String
  • Update Datetime (update_datetime) — String

tb_follow (CopyOfUntitled)

  • Follower ID (follower_id) — String — Primary key — NOT NULL
  • User ID (id) — String — Foreign key → tb_user.User ID — NOT NULL
  • Create Datetime (create_datetime) — String

tb_pin (CopyOfUntitled2)

  • Pin No (no) — Number — Primary key — NOT NULL
  • Place ID (place_id2) — String — Foreign key → tb_place_pin.Place ID — NOT NULL
  • User ID (user_id) — String — Foreign key → tb_user.User ID — NOT NULL
  • Hash Tags (hash_tags) — String List
  • Filter (filter) — String
  • Country No (country_no) — Number
  • Type No (type_no) — Number
  • Group No (group_no) — Number
  • My Group Count (my_group_cnt) — Number
  • Pin Count (pin_cnt) — Number
  • Rating (rating) — Number
  • View Count (view_cnt) — Number
  • Comment Count (comment_cnt) — Number
  • Like Count (like_cnt) — Number
  • Bookmark Count (bookmark_cnt) — Number
  • Title (title) — String
  • Text (texta) — String
  • Image (images) — List
  • Latitude (lat) — Number
  • Longitude (lon) — Number
  • Address (address) — String
  • Place Name (place_name) — String
  • Public (public) — Boolean
  • Trip Public (trip_public) — Boolean
  • Group Main (group_main) — Boolean
  • My Group Main (my_group_main) — Boolean
  • Create Datetime (create_datetime) — String
  • Check Datetime (check_datetime) — String
  • Update Datetime (update_datetime) — String
  • Table Name (table_name) — String

tb_pin_bookmark (CopyOfUntitled22)

  • User ID (id) — String — Foreign key → tb_user.User ID — NOT NULL
  • Pin No (no) — String — Foreign key → tb_pin.Pin No — NOT NULL
  • CreateDatetime (create_datetime) — String

tb_pin_like (Untitled2)

  • User ID (id) — String — Foreign key → tb_user.User ID — NOT NULL
  • Pin No (no) — String — Foreign key → tb_pin.Pin No — NOT NULL
  • CreateDatetime (create_datetime) — String

tb_place_pin (Untitled3)

  • Place ID (place_id) — String — Primary key — NOT NULL
  • Pin No (no) — String — Foreign key → tb_pin.Pin No — NOT NULL
  • Country No (country_no) — Number
  • Count (count) — Number
  • Create Datetime (create_datetime) — String
  • Update Datetime (update_datetime) — String

tb_rating (Untitled6)

  • Trip No (trip_no) — Number — Foreign key → tb_trip.Trip No — NOT NULL
  • User ID (user_id) — String — Foreign key → tb_pin.User ID — NOT NULL
  • Title (title) — String
  • Text (text) — String
  • Value (value) — Number
  • Create Datetime (create_datetime) — String
  • Update Datetime (update_datetime) — String

tb_save (Untitled7)

  • Trip No (trip_no) — Number — Foreign key → tb_trip.Trip No — NOT NULL
  • User ID (user_id) — String — Foreign key → tb_pin.User ID — NOT NULL
  • Point (point) — Number
  • Create Datetime (create_datetime) — String

tb_trip (Untitled4)

  • Trip No (trip_no) — Number — Primary key — NOT NULL
  • User ID (user_id) — String — Foreign key → tb_user.User ID — NOT NULL
  • Place ID (place_id) — String — Foreign key → tbl_place_trip.Place ID — NOT NULL
  • Country No (country_no) — Number
  • Filter (filter) — String
  • Type No (type_no) — Number
  • Group No (group_no) — Number
  • Next No (next_no) — Number
  • Prev No (prev_no) — Number
  • Rating (rating) — Number
  • Rating count (rating_cnt) — Number
  • Tripins (tripins) — List
  • Tripin count (tripin_cnt) — Number
  • View count (view_cnt) — Number
  • Comment count (comment_cnt) — Number
  • Like count (like_cnt) — Number
  • Bookmark count (bookmark_cnt) — Number
  • Save count (save_cnt) — Number
  • Traveling count (traveling_cnt) — Number
  • Title (title) — Number
  • Image (image) — Number
  • Hash Tags (hash_tags) — String List
  • Latitude (lat) — Number
  • Longitude (lon) — Number
  • Address (address) — String
  • Place Name (place_name) — String
  • Language (language) — String
  • Public (public) — Boolean
  • Cash (cash) — Number
  • Point (point) — Number
  • Level (level) — Number
  • Create Datetime (create_datetime) — String
  • Check Datetime (check_datetime) — String
  • Update Datetime (update_datetime) — String
  • Table Name (table_name) — String

tb_trip_like (Untitled8)

  • Trip No (trip_no) — Number — Foreign key → tb_trip.Trip No — NOT NULL
  • User ID (id) — String — Foreign key → tb_user.User ID — NOT NULL
  • Create Datetime (create_datetime) — String

tb_user (Untitled)

  • User ID (id) — String — Primary key — NOT NULL
  • Name (name) — String
  • Country No (country_no) — Number
  • Table Name (table_name) — Number
  • Verified (verified) — Boolean
  • First Name (first_name) — String
  • Last Name (last_name) — String
  • ProfileImg (profile_img) — String
  • Message Token (msg_token) — String
  • Type No (type_no) — Number
  • Group No (group_no) — Number
  • Create Datetime (create_datetime) — String
  • Check Datetime (check_datetime) — String
  • Update Datetime (update_datetime) — String

tbl_place_trip (Untitled5)

  • Place ID (place_id) — String — Primary key — NOT NULL
  • Trip No (trip_no) — String — Foreign key → tb_trip.Trip No — NOT NULL
  • Country No (country_no) — Number
  • Count (count) — Number
  • Create Datetime (create_datetime) — String
  • Update Datetime (update_datetime) — String