MOTIF

Tables (39)

admins

  • admin_seq — INTEGER — Primary key — NOT NULL
  • login_id — VARCHAR(30) — NOT NULL
  • password_hash — VARCHAR(60) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • last_login_dttm — TIMESTAMPTZ
  • reg_dttm — TIMESTAMPTZ — NOT NULL

artist_groups

  • group_seq — INTEGER — Primary key — NOT NULL
  • company_seq — INTEGER — Foreign key → companies.company_seq — NOT NULL
  • group_name — VARCHAR(50) — NOT NULL
  • reg_usr_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_usr_seq — INTEGER — Foreign key → users.user_seq
  • mod_dttm — TIMESTAMPTZ

artists

  • artist_seq — INTEGER — Primary key — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • group_seq — INTEGER — Foreign key → artist_groups.group_seq
  • company_seq — INTEGER — Foreign key → companies.company_seq — NOT NULL
  • motif_bg_image_key — VARCHAR(255)
  • bio — TEXT
  • subscriber_count — INTEGER — NOT NULL
  • reg_usr_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

asset_purchases

  • purchase_seq — BIGINT — Primary key — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • asset_seq — INTEGER — Foreign key → motif_assets.asset_seq — NOT NULL
  • order_seq — BIGINT — Foreign key → orders.order_seq — NOT NULL
  • status — VARCHAR(12) — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

challenge_comment_likes

  • challenge_comment_seq — BIGINT — Foreign key → challenge_comments.challenge_comment_seq — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL

challenge_comments

  • challenge_comment_seq — BIGINT — Primary key — NOT NULL
  • challenge_seq — INTEGER — Foreign key → challenges.challenge_seq — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • parent_comment_seq — BIGINT — Foreign key → challenge_comments.challenge_comment_seq
  • content — TEXT — NOT NULL
  • like_count — INTEGER — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ
  • mod_usr_seq — INTEGER — Foreign key → users.user_seq

challenge_likes

  • challenge_seq — INTEGER — Foreign key → challenges.challenge_seq — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL

challenge_participants

  • challenge_seq — INTEGER — Foreign key → challenges.challenge_seq — NOT NULL
  • artist_seq — INTEGER — Foreign key → artists.artist_seq — NOT NULL
  • participant_mask — INTEGER — NOT NULL
  • bbox_left_top_x — INTEGER — NOT NULL
  • bbox_left_top_y — INTEGER — NOT NULL
  • bbox_right_bottom_x — INTEGER — NOT NULL
  • bbox_right_bottom_y — INTEGER — NOT NULL

challenges

  • challenge_seq — INTEGER — Primary key — NOT NULL
  • artist_seq — INTEGER — Foreign key → artists.artist_seq — NOT NULL
  • song_seq — INTEGER — Foreign key → songs.song_seq — NOT NULL
  • description — TEXT — NOT NULL
  • video_key — VARCHAR(255) — NOT NULL
  • thumbnail_key — VARCHAR(255) — NOT NULL
  • duration_ms — INTEGER — NOT NULL
  • view_count — BIGINT — NOT NULL
  • participant_count — INTEGER — NOT NULL
  • like_count — INTEGER — NOT NULL
  • comment_count — INTEGER — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ
  • is_deleted — BOOLEAN — NOT NULL

companies

  • company_seq — INTEGER — Primary key — NOT NULL
  • company_name — VARCHAR(50) — NOT NULL
  • reg_usr_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_usr_seq — INTEGER — Foreign key → users.user_seq
  • mod_dttm — TIMESTAMPTZ

composite_jobs

  • job_seq — BIGINT — Primary key — NOT NULL
  • job_uuid — UUID — NOT NULL
  • job_type — VARCHAR(10) — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • challenge_seq — INTEGER — Foreign key → challenges.challenge_seq
  • asset_seq — INTEGER — Foreign key → motif_assets.asset_seq
  • edited_challenge_seq — INTEGER — Foreign key → edited_challenges.edited_challenge_seq
  • raw_video_key — VARCHAR(255) — NOT NULL
  • correction_enabled — BOOLEAN — NOT NULL
  • status — VARCHAR(12) — NOT NULL
  • fail_code — VARCHAR(30)
  • result_video_key — VARCHAR(255)
  • result_thumbnail_key — VARCHAR(255)
  • attempt — SMALLINT — NOT NULL
  • processing_ms — INTEGER
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

countries

  • country_seq — INTEGER — Primary key — NOT NULL
  • country_code — CHAR(2) — NOT NULL
  • country_name — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • reg_usr_seq — INTEGER — Foreign key → users.user_seq
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_usr_seq — INTEGER — Foreign key → users.user_seq
  • mod_dttm — TIMESTAMPTZ

device_tokens

  • token_seq — INTEGER — Primary key — NOT NULL
  • user_seq — INTEGER — NOT NULL
  • fcm_token — VARCHAR(255) — NOT NULL
  • platform — VARCHAR(10) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • last_used_dttm — TIMESTAMPTZ
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

edited_challenges

  • edited_challenge_seq — INTEGER — Primary key — NOT NULL
  • challenge_seq — INTEGER — Foreign key → challenges.challenge_seq — NOT NULL
  • participant_mask — INTEGER — NOT NULL
  • video_key — VARCHAR(255) — NOT NULL
  • initial_scene_key — VARCHAR(255) — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

motif_asset_prices

  • asset_price_seq — INTEGER — Primary key — NOT NULL
  • asset_seq — INTEGER — Foreign key → motif_assets.asset_seq — NOT NULL
  • country_seq — INTEGER — Foreign key → countries.country_seq — NOT NULL
  • amount — NUMERIC(10,2) — NOT NULL
  • currency — CHAR(3) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • reg_usr_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_usr_seq — INTEGER — Foreign key → users.user_seq
  • mod_dttm — TIMESTAMPTZ

motif_assets

  • asset_seq — INTEGER — Primary key — NOT NULL
  • artist_seq — INTEGER — Foreign key → artists.artist_seq — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • video_key — VARCHAR(255) — NOT NULL
  • thumbnail_key — VARCHAR(255) — NOT NULL
  • duration_ms — INTEGER — NOT NULL
  • asset_type — VARCHAR(10) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

motif_pass_prices

  • pass_price_seq — INTEGER — Primary key — NOT NULL
  • artist_seq — INTEGER — Foreign key → artists.artist_seq — NOT NULL
  • country_seq — INTEGER — Foreign key → countries.country_seq — NOT NULL
  • duration_months — SMALLINT — NOT NULL
  • amount — NUMERIC(10,2) — NOT NULL
  • currency — CHAR(3) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • reg_usr_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_usr_seq — INTEGER — Foreign key → users.user_seq
  • mod_dttm — TIMESTAMPTZ

motif_passes

  • pass_seq — INTEGER — Primary key — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • artist_seq — INTEGER — Foreign key → artists.artist_seq — NOT NULL
  • order_seq — BIGINT — Foreign key → orders.order_seq — NOT NULL
  • duration_months — SMALLINT — NOT NULL
  • started_dttm — TIMESTAMPTZ — NOT NULL
  • expires_dttm — TIMESTAMPTZ — NOT NULL
  • status — VARCHAR(12) — NOT NULL
  • canceled_dttm — TIMESTAMPTZ
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

motif_results

  • result_seq — BIGINT — Primary key — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • asset_seq — INTEGER — Foreign key → motif_assets.asset_seq — NOT NULL
  • artist_seq — INTEGER — Foreign key → artists.artist_seq — NOT NULL
  • job_seq — BIGINT — Foreign key → composite_jobs.job_seq — NOT NULL
  • video_key — VARCHAR(255) — NOT NULL
  • thumbnail_key — VARCHAR(255) — NOT NULL
  • duration_ms — INTEGER — NOT NULL
  • description — TEXT
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ
  • is_deleted — BOOLEAN — NOT NULL

notice_comment_likes

  • notice_comment_seq — BIGINT — Foreign key → notice_comments.notice_comment_seq — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL

notice_comments

  • notice_comment_seq — BIGINT — Primary key — NOT NULL
  • notice_seq — INTEGER — Foreign key → notices.notice_seq — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • parent_comment_seq — BIGINT — Foreign key → notice_comments.notice_comment_seq
  • content — TEXT — NOT NULL
  • like_count — INTEGER — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ
  • mod_usr_seq — INTEGER — Foreign key → users.user_seq

notice_images

  • notice_image_seq — INTEGER — Primary key — NOT NULL
  • notice_seq — INTEGER — Foreign key → notices.notice_seq — NOT NULL
  • image_key — VARCHAR(255) — NOT NULL
  • display_order — SMALLINT — NOT NULL

notice_likes

  • notice_seq — INTEGER — Foreign key → notices.notice_seq — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL

notices

  • notice_seq — INTEGER — Primary key — NOT NULL
  • artist_seq — INTEGER — Foreign key → artists.artist_seq — NOT NULL
  • content — TEXT — NOT NULL
  • like_count — INTEGER — NOT NULL
  • comment_count — INTEGER — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ
  • is_deleted — BOOLEAN — NOT NULL

oauth_providers

  • provider_seq — INTEGER — Primary key — NOT NULL
  • provider_code — VARCHAR(20) — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL

orders

  • order_seq — BIGINT — Primary key — NOT NULL
  • order_uuid — UUID — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • product_type — VARCHAR(10) — NOT NULL
  • asset_seq — INTEGER — Foreign key → motif_assets.asset_seq
  • artist_seq — INTEGER — Foreign key → artists.artist_seq
  • country_code — CHAR(2) — NOT NULL
  • pass_duration_months — SMALLINT
  • amount — NUMERIC(10,2) — NOT NULL
  • currency — CHAR(3) — NOT NULL
  • status — VARCHAR(12) — NOT NULL
  • payment_provider — VARCHAR(20)
  • payment_key — VARCHAR(200)
  • approved_dttm — TIMESTAMPTZ
  • fail_reason — VARCHAR(200)
  • expires_dttm — TIMESTAMPTZ — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

participation_videos

  • video_seq — BIGINT — Primary key — NOT NULL
  • challenge_seq — INTEGER — Foreign key → challenges.challenge_seq — NOT NULL
  • artist_seq — INTEGER — Foreign key → artists.artist_seq — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • job_seq — BIGINT — Foreign key → composite_jobs.job_seq — NOT NULL
  • description — TEXT — NOT NULL
  • video_key — VARCHAR(255) — NOT NULL
  • thumbnail_key — VARCHAR(255) — NOT NULL
  • duration_ms — INTEGER — NOT NULL
  • visibility — VARCHAR(10) — NOT NULL
  • comment_enabled — BOOLEAN — NOT NULL
  • view_count — BIGINT — NOT NULL
  • like_count — INTEGER — NOT NULL
  • comment_count — INTEGER — NOT NULL
  • has_artist_like — BOOLEAN — NOT NULL
  • has_artist_comment — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ
  • mod_usr_seq — INTEGER — Foreign key → users.user_seq
  • is_deleted — BOOLEAN — NOT NULL

refresh_tokens

  • token_seq — BIGINT — Primary key — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • token_hash — CHAR(64) — NOT NULL
  • expires_dttm — TIMESTAMPTZ — NOT NULL
  • revoked_dttm — TIMESTAMPTZ
  • last_used_dttm — TIMESTAMPTZ
  • reg_dttm — TIMESTAMPTZ — NOT NULL

reports

  • report_seq — BIGINT — Primary key — NOT NULL
  • reporter_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • video_seq — BIGINT — Foreign key → participation_videos.video_seq
  • challenge_comment_seq — BIGINT — Foreign key → challenge_comments.challenge_comment_seq
  • video_comment_seq — BIGINT — Foreign key → video_comments.video_comment_seq
  • notice_comment_seq — BIGINT — Foreign key → notice_comments.notice_comment_seq
  • reason_code — VARCHAR(30) — NOT NULL
  • status — VARCHAR(12) — NOT NULL
  • processed_usr_seq — INTEGER — Foreign key → users.user_seq
  • processed_dttm — TIMESTAMPTZ
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

shop_banners

  • shop_banner_seq — INTEGER — Primary key — NOT NULL
  • image_key — VARCHAR(255) — NOT NULL
  • display_order — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

songs

  • song_seq — INTEGER — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • singer_name — VARCHAR(100) — NOT NULL
  • reg_usr_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL

subscriptions

  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • artist_seq — INTEGER — Foreign key → artists.artist_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL

user_accounts

  • account_seq — INTEGER — Primary key — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • account_status — VARCHAR(12) — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ

user_oauth_accounts

  • oauth_account_seq — INTEGER — Primary key — NOT NULL
  • account_seq — INTEGER — Foreign key → user_accounts.account_seq — NOT NULL
  • provider_seq — INTEGER — Foreign key → oauth_providers.provider_seq — NOT NULL
  • oauth_subject — VARCHAR(255) — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL

users

  • user_seq — INTEGER — Primary key — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_key — VARCHAR(255)
  • rep_motif_result_seq — BIGINT
  • role — VARCHAR(10) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ
  • mod_usr_seq — INTEGER — Foreign key → users.user_seq

video_comment_likes

  • video_comment_seq — BIGINT — Foreign key → video_comments.video_comment_seq — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL

video_comments

  • video_comment_seq — BIGINT — Primary key — NOT NULL
  • video_seq — BIGINT — Foreign key → participation_videos.video_seq — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • parent_comment_seq — BIGINT — Foreign key → video_comments.video_comment_seq
  • content — TEXT — NOT NULL
  • like_count — INTEGER — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL
  • mod_dttm — TIMESTAMPTZ
  • mod_usr_seq — INTEGER — Foreign key → users.user_seq

video_hides

  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • video_seq — BIGINT — Foreign key → participation_videos.video_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL

video_likes

  • video_seq — BIGINT — Foreign key → participation_videos.video_seq — NOT NULL
  • user_seq — INTEGER — Foreign key → users.user_seq — NOT NULL
  • reg_dttm — TIMESTAMPTZ — NOT NULL