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