company_videos

0 rows


Description

自社動画一覧

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
company_video_department_association.video_id company_video_department_association_video_foreignR
company_video_watching_histories.company_video_id company_video_watching_histories_company_video_foreignC

自社動画ID
organization_id VARCHAR 100 null
organizations.id company_videos_organization_foreignR

OrganizationID
stream_id VARCHAR 255 null

ストリームID
thumbnail VARCHAR 255 √ null

サムネイル
title VARCHAR 255 null

タイトル
description VARCHAR 255 null

説明
status VARCHAR 255 null
company_video_status.status company_videos_company_video_status_foreignR

ステータス
scope VARCHAR 255 null
company_video_scope.scope company_videos_company_video_scope_foreignR

スコープ
view_count INT 10 0

視聴回数
duration DOUBLE 22 null

動画の長さs
published_at BIGINT 19 null

公開日時(unixTimes)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
company_videos_company_video_scope_foreign Performance Asc scope
company_videos_company_video_status_foreign Performance Asc status
company_videos_organization_foreign Performance Asc organization_id

Relationships

Close relationships within degrees of separation