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