tts_project

Tables (9)

language (언어관리)

  • lang_id (언어id) — int — Primary key — NOT NULL
  • language (언어명) — varchar

project_main (프로젝트 main)

  • project_id (project_key) — int — Primary key — NOT NULL
  • user_id (user_key) — int — Foreign key → user.user_id — NOT NULL
  • project_name (프로젝트명) — varchar
  • reg_dt (등록일시) — datetime
  • edit_dt (수정일시) — datetime

user (유저테이블)

  • user_id (user_key) — int — Primary key — NOT NULL
  • account (user id) — varchar
  • passwd (패스워드) — varchar

user_bg_file (유저배경파일테이블)

  • bg_file_id (bg_file_key) — int — Primary key — NOT NULL
  • user_id (user_key) — int — Foreign key → user.user_id — NOT NULL
  • file_name (파일명) — varchar
  • file_path (파일 경로) — varchar

user_face_file (유저얼굴파일테이블)

  • face_file_id (face_file_key) — int — Primary key — NOT NULL
  • user_id (user_key) — int — Foreign key → user.user_id — NOT NULL
  • file_name (파일명) — varchar
  • file_path (파일 경로) — varchar

user_voice_file (유저음성파일테이블)

  • voice_file_id (voice_file_key) — int — Primary key — NOT NULL
  • user_id (user_key) — int — Foreign key → user.user_id — NOT NULL
  • file_name (파일명) — varchar
  • file_path (파일 경로) — varchar

workcspace_background (워크스페이스_배경)

  • bgd_id (bgd_key) — int — Primary key — NOT NULL
  • script_id (script_key) — int — Foreign key → workspace_script.script_id — NOT NULL
  • bg_file_id (bg_file_key) — int — Foreign key → user_bg_file.bg_file_id — NOT NULL
  • face_video_path (스크립트 얼굴영상 경로) — varchar

workspace (워크스페이스)

  • workspace_id (workspace_key) — int — Primary key — NOT NULL
  • project_id (project_key) — int — Foreign key → project_main.project_id — NOT NULL
  • lang_id (언어id) — int — Foreign key → language.lang_id — NOT NULL
  • face_file_id (face_file_key) — int — Foreign key → user_face_file.face_file_id — NOT NULL
  • voice_file_id (voice_file_key) — int — Foreign key → user_voice_file.voice_file_id — NOT NULL
  • face_position (영상의 얼굴 위치) — int
  • vid_progress (영상합성진행도) — int
  • stage (워크스페이스진행단계) — varchar
  • edit_dt (수정일시) — datetime
  • video_path (완성영상경로) — varchar
  • video_st_ed (영상합성시작시간) — datetime
  • video_ed_dt (영상완성종료시간) — datetime

workspace_script (워크스페이스_자막)

  • script_id (script_key) — int — Primary key — NOT NULL
  • workspace_id (workspace_key) — int — Foreign key → workspace.workspace_id — NOT NULL
  • script_seq (스크립트순서) — int
  • script (스크립트) — varchar
  • script_voice_path (스크립트 음성경로) — varchar