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