TBZ

Tables (44)

Copy Of Copy Of Untitled53 (post_comment_report)

  • Key (comment_report_id) — long — Primary key — NOT NULL
  • Key (post_comment_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (user_id) — long
  • Field2 (reason) — varchar
  • Field3 (created_at) — date

Copy Of Untitled (post_comment_like)

  • Key (post_like_id) — long — Primary key — NOT NULL
  • Key (post_comment_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (user_id) — long
  • Field2 (created_at) — date

Copy Of Untitled2 (post_tag)

  • Key (tag_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (feed_post_id) — long — Foreign key → Untitled5.Key — NOT NULL

Copy Of Untitled5 (post_bookmark)

  • Key (post_bookmark_id) — long — Primary key — NOT NULL
  • Key (feed_post_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (user_id) — long
  • Field3 (created_at) — date

Copy Of Untitled52 (video_report)

  • Key (video_report_id) — long — Primary key — NOT NULL
  • id (vidoe_id) — long — Foreign key → feed_video.id — NOT NULL
  • Field (user_id) — long
  • Field2 (reason) — varchar
  • Field3 (created_at) — date

Copy Of Untitled53 (video_comment_report)

  • Key (comment_report_id) — long — Primary key — NOT NULL
  • Key (video_comment_id) — long — Foreign key → Copy Of Untitled54.Key — NOT NULL
  • Field (user_id) — long
  • Field2 (reason) — varchar
  • Field3 (created_at) — date

Copy Of Untitled54 (video_comment)

  • Key (video_comment_id) — long — Primary key — NOT NULL
  • id (vidoe_id) — long — Foreign key → feed_video.id — NOT NULL
  • Field2 (path) — long
  • Field3 (user_id) — long
  • Field4 (content) — varchar
  • Field5 (created_at) — date
  • Field (updated_at) — date
  • Field (is_enable) — enum

Copy Of Untitled55 (video_comment_like)

  • Key (video_like_id) — long — Primary key — NOT NULL
  • Key (video_comment_id) — long — Foreign key → Copy Of Untitled54.Key — NOT NULL
  • Field (user_id) — long
  • Field2 (created_at) — date

Copy Of Untitled56 (post_view_count)

  • Key (view_count_id) — long — Primary key — NOT NULL
  • Key (feed_post_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (user_id) — long
  • Field2 (created_at) — date

Untitled (challenge_banner_new)

  • Key (challenge_banner_new_id) — long — Primary key — NOT NULL
  • Key (challenge_banner_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field (seq) — int
  • Field2 (created_at) — date
  • Field3 (updated_at) — date

Untitled (challenge_banner)

  • Key (challenge_banner_id) — long — Primary key — NOT NULL
  • Key (challenge_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field (banner_start) — date
  • Field2 (banner_end) — date
  • Field3 (state) — varchar
  • Field4 (banner_video_link) — varchar
  • Field5 (admin_id) — long
  • Field (created_at) — date
  • Field2 (updated_at) — date
  • Field3 (is_enable) — enum

Untitled (travel_record)

  • Key (travel_record_id) — long — Primary key — NOT NULL
  • id (vidoe_id) — long — Foreign key → feed_video.id — NOT NULL
  • Key (feed_post_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (user_id) — long
  • Field2 (created_at) — date

Untitled (passport)

  • Key (passport_id) — long — Primary key — NOT NULL
  • Key (passport_uid) — varchar — Primary key — NOT NULL
  • Key (passport_grade_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key2 (user_id) — long — NOT NULL
  • Field (travel_count) — int
  • Field2 (visit_city_count) — int
  • Field3 (rating) — int
  • Field4 (created_at) — date
  • Field (updated_at) — date

Untitled (ranking_event)

  • Key (ranking_event_id) — long — Primary key — NOT NULL
  • Field (ranking_event_state) — varchar
  • Field2 (ranking_event_title) — varchar
  • Field3 (ranking_event_start) — date
  • Field4 (ranking_event_end) — date
  • Field5 (prize_money) — long
  • Field (admin_id) — long
  • Field2 (icon_image_link) — varchar
  • Field3 (created_at) — date
  • Field (updated_at) — date

Untitled (user_ranking)

  • Key (user_ranking_id) — long — Primary key — NOT NULL
  • Key (ranking_event_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field (user_id) — long
  • Field2 (country) — varchar
  • Field3 (city_id) — long
  • Field4 (hotel_id) — long
  • Field5 (ex_ranking) — int
  • Field (now_ranking) — int
  • Field (occupation_date) — date
  • Field (ranking_point) — long
  • Field (updated_at) — date

Untitled (alarm)

  • Key (alarm_id) — long — Primary key — NOT NULL
  • Key (event_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Key (feed_post_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • id (vidoe_id) — long — Foreign key → feed_video.id — NOT NULL
  • Field4 (category) — varchar
  • Field (user_id) — long
  • Field (rservation_id) — long
  • Field2 (alarm_title) — varchar
  • Field3 (alarm_content) — varchar
  • Field (view_check) — enum
  • Field (created_at) — date
  • Field2 (updated_at) — date
  • Field (is_enable) — enum

Untitled (post_like)

  • Key (post_like_id) — long — Primary key — NOT NULL
  • Key (feed_post_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (user_id) — long
  • Field2 (created_at) — date

Untitled (tag)

  • Key (tag_id) — long — Primary key — NOT NULL
  • Field (content) — varchar

Untitled (video_tag)

  • Key (tag_id) — long — Foreign key → Untitled.Key — NOT NULL
  • id (vidoe_id) — long — Foreign key → feed_video.id — NOT NULL

Untitled (challenge_tag_banner)

  • Key (challenge_tag_banner_id) — long — Primary key — NOT NULL
  • Key (challenge_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field (challenge_tag_banner_image_url) — varchar
  • Field (challenge_tag_banner_seq) — int

Untitled (video_ignore)

  • Key (video_ignore_id) — Primary key — NOT NULL
  • Field (video_id)
  • Field2 (user_id)
  • Field (created_at)

Untitled (user_video_ignore)

  • Key (user_video_ignore_id) — long — Primary key — NOT NULL
  • Field (ignore_user_id) — long
  • Field2 (user_id) — long
  • Field3 (created_at) — datetime

Untitled (challenge_detail_view)

  • Key (challenge_detail_view_id) — long — Primary key — NOT NULL
  • Key (challenge_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (event_id) — long — Foreign key → Untitled5.Key — NOT NULL

Untitled (challenge_join)

  • Key (challenge_join_id) — long — Primary key — NOT NULL
  • Key (challenge_id) — long — Foreign key → Untitled.Key — NOT NULL
  • id (vidoe_id) — long — Foreign key → feed_video.id — NOT NULL
  • Field (is_private) — enum
  • Field2 (created_at) — date

Untitled (challenge_tag)

  • Key (challenge_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (tag_id) — long — Foreign key → Untitled.Key — NOT NULL

Untitled (challenge)

  • Key (challenge_id) — long — Primary key — NOT NULL
  • Key (category_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field (challenge_title) — varchar
  • Field2 (challenge_description) — varchar
  • Field3 (challenge_start) — date
  • Field4 (challenge_end) — date
  • Field5 (challenge_image_link) — varchar
  • Field6 (is_view) — enum
  • Field7 (is_new) — enum
  • Field (use_banner) — enum
  • Field (admin_id) — long
  • Field (state) — varchar
  • Field (challenge_seq) — int
  • Field (challenge_sound) — varchar
  • Field (created_at) — date
  • Field (updated_at) — date
  • Field (is_enable) — enum

Untitled (category)

  • Key (category_id) — long — Primary key — NOT NULL
  • Field (category_title) — varchar
  • Field2 (category_seq) — int
  • Field (category_type) — varchar
  • Field3 (created_at) — date
  • Field (updated_at) — date
  • Field (is_enable) — enum

Untitled (passport_grade)

  • Key (passport_grade_id) — long — Primary key — NOT NULL
  • Field (passport_grade_title) — varchar
  • Field2 (condition) — int
  • Field4 (updated_at) — date

Untitled (user_badge)

  • Key (user_badge_id) — long — Primary key — NOT NULL
  • Field (user_id) — long
  • Field2 (badge_id) — long
  • Field3 (created_date) — date

Untitled (user_info)

  • Key (user_info_id) — long — Primary key — NOT NULL
  • Field (user_id) — long
  • Field3 (profile) — varchar
  • Field4 (nickname) — varchar
  • Field5 (introduction) — varchar
  • Field6 (name_ko) — varchar
  • Field (name_en) — varchar
  • Field (birth) — date
  • Field (nationality) — varchar
  • Field (phone) — varchar
  • Field (email_consent) — enum
  • Field (sms_consent) — enum
  • Field2 (alarm_yn) — enum
  • Field (reservation_push) — enum
  • Field2 (trip_cash_push) — enum
  • Field3 (activity_push) — enum
  • Field (event_push) — enum
  • Field (friend_push) — enum
  • Field (updated_at) — date

Untitled5 (feed_post)

  • Key (feed_post_id) — long — Primary key — NOT NULL
  • Key (category_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field2 (user_id) — long
  • Field3 (country) — varchar
  • Field4 (city_id) — long
  • Field5 (hotel_id) — long
  • Field6 (upload_os) — varchar
  • Field7 (created_at) — date
  • Field8 (updated_at) — date
  • Field9 (is_enable) — enum

Untitled5 (post_img)

  • Key (id) — long — Primary key — NOT NULL
  • Key (feed_post_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (image_link) — varchar
  • Field2 (seq) — int
  • Field3 (created_at) — date
  • Field (updated_at) — date
  • Field (is_enable) — enum

Untitled5 (follow)

  • Key (id) — long — Primary key — NOT NULL
  • Field (following) — long
  • Field2 (follower) — long
  • Field (created_at) — date

Untitled5 (post_report)

  • Key (post_report_id) — long — Primary key — NOT NULL
  • Key (feed_post_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (user_id) — long
  • Field2 (reason) — varchar
  • Field3 (created_at) — date

Untitled5 (video_bookmark)

  • Key (video_bookmark_id) — long — Primary key — NOT NULL
  • id (vidoe_id) — long — Foreign key → feed_video.id — NOT NULL
  • Field (user_id) — long
  • Field3 (created_at) — date

Untitled5 (video_like)

  • Key (video_like_id) — long — Primary key — NOT NULL
  • id (vidoe_id) — long — Foreign key → feed_video.id — NOT NULL
  • Field (user_id) — long
  • Field2 (created_at) — date

Untitled5 (post_comment)

  • Key (post_comment_id) — long — Primary key — NOT NULL
  • Key (feed_post_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field2 (path) — long
  • Field3 (user_id) — long
  • Field4 (content) — varchar
  • Field5 (created_at) — date
  • Field (updated_at) — date
  • Field (is_enable) — enum

Untitled5 (video_view_count)

  • Key (view_count_id) — long — Primary key — NOT NULL
  • id (vidoe_id) — long — Foreign key → feed_video.id — NOT NULL
  • Field (user_id) — long
  • Field2 (created_at) — date

Untitled5 (event)

  • Key (event_id) — long — Primary key — NOT NULL
  • Field (event_title) — varchar
  • Field2 (event_start) — date
  • Field3 (event_end) — date
  • Field4 (event_state) — varchar
  • Field5 (event_image_link) — varchar
  • Field (event_description) — varchar
  • Field (button_view) — enum
  • Field (admin_id) — long
  • Field (first_alarm) — date
  • Field (created_at) — date
  • Field2 (updated_at) — date
  • Field3 (is_enable) — enum

Untitled5 (button)

  • Key (button_id) — long — Primary key — NOT NULL
  • Key (event_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (button_title) — varchar
  • Field2 (url) — varchar

Untitled5 (event_alarm)

  • Key (alarm_id) — long — Primary key — NOT NULL
  • Key (event_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (created_at) — date

Untitled5 (popup)

  • Key (popup_id) — long — Primary key — NOT NULL
  • Key (event_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (popup_start) — date
  • Field2 (popup_end) — date
  • Field3 (popup_state) — varchar
  • Field (popup_image_link) — varchar
  • Field4 (admin_id) — long
  • Field (seq) — int
  • Field (is_view) — enum
  • Field (created_at) — date
  • Field (updated_at) — date
  • Field (is_enable) — enum

Untitled5 (popup_click)

  • Key (popup_click_id) — long — Primary key — NOT NULL
  • Key (popup_id) — long — Foreign key → Untitled5.Key — NOT NULL
  • Field (user_id) — long
  • Field2 (created_at) — date

feed_video (video)

  • id (vidoe_id) — long — Primary key — NOT NULL
  • user_id — long
  • Field2 (country) — varchar
  • Field3 (city_id) — long
  • Field4 (hotel_id) — long
  • Field5 (type) — varchar
  • Field (upload_os) — varchar
  • Field2 (content) — varchar
  • Field3 (video_link) — varchar
  • Field4 (video_length) — time
  • Field6 (is_ignore) — enum
  • Field7 (is_public) — enum
  • Field8 (created_at) — date
  • Field (updated_at) — date
  • Field2 (is_enable) — enum