PRINTFILM: AI short-video marketing and AI short-drama creation platform
from datetime import datetime
from enum import StrEnum
from sqlalchemy import JSON, Boolean, DateTime, Float, ForeignKey, Integer, String, Text, func
from sqlalchemy.orm import Mapped, mapped_column, relationship
from app.database import Base
class ProjectStatus(StrEnum):
DRAFT = "DRAFT"
SCRIPTING = "SCRIPTING"
SCRIPT_READY = "SCRIPT_READY"
IMAGING = "IMAGING"
IMAGE_READY = "IMAGE_READY"
VIDEOING = "VIDEOING"
VIDEO_READY = "VIDEO_READY"
AUDIOING = "AUDIOING"
COMPOSING = "COMPOSING"
AUDITING = "AUDITING"
DONE = "DONE"
REJECTED = "REJECTED"
FAILED = "FAILED"
CANCELLED = "CANCELLED"
class ShotStatus(StrEnum):
PENDING = "PENDING"
IMAGE_READY = "IMAGE_READY"
VIDEO_READY = "VIDEO_READY"
AUDIO_READY = "AUDIO_READY"
FAILED = "FAILED"
class User(Base):
__tablename__ = "users"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
email: Mapped[str] = mapped_column(String(255), unique=True, index=True)
nickname: Mapped[str] = mapped_column(String(64), default="创作者")
hashed_password: Mapped[str] = mapped_column(String(255))
# Legacy field; prefer balance_fen for billing
quota_left: Mapped[int] = mapped_column(Integer, default=5)
balance_fen: Mapped[int] = mapped_column(Integer, default=0)
frozen_fen: Mapped[int] = mapped_column(Integer, default=0)
plan: Mapped[str] = mapped_column(String(32), default="free")
# user | admin
role: Mapped[str] = mapped_column(String(16), default="user")
avatar_url: Mapped[str] = mapped_column(String(512), default="")
# 联系手机,仅记录,不走短信验证
phone: Mapped[str] = mapped_column(String(32), default="")
# 用户消费里程碑告警:上次已提醒的累计扣费档位(分)
billing_alert_last_milestone_fen: Mapped[int] = mapped_column(Integer, default=0)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
projects: Mapped[list["Project"]] = relationship(back_populates="owner")
class BillingAlertNotification(Base):
"""待展示的用户额度告警(弹窗)。"""
__tablename__ = "billing_alert_notifications"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
user_id: Mapped[int] = mapped_column(Integer, index=True)
kind: Mapped[str] = mapped_column(String(32), default="user_milestone")
title: Mapped[str] = mapped_column(String(128), default="")
message: Mapped[str] = mapped_column(Text, default="")
milestone_fen: Mapped[int] = mapped_column(Integer, default=0)
acknowledged: Mapped[bool] = mapped_column(Boolean, default=False)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
class Template(Base):
__tablename__ = "templates"
id: Mapped[str] = mapped_column(String(64), primary_key=True)
name: Mapped[str] = mapped_column(String(128))
description: Mapped[str] = mapped_column(Text, default="")
category: Mapped[list] = mapped_column(JSON, default=list)
preview_cover: Mapped[str] = mapped_column(String(512), default="")
style_prefix: Mapped[str] = mapped_column(Text)
negative_prompt: Mapped[str] = mapped_column(Text, default="")
default_ratio: Mapped[str] = mapped_column(String(16), default="16:9")
shot_duration_min: Mapped[int] = mapped_column(Integer, default=3)
shot_duration_max: Mapped[int] = mapped_column(Integer, default=8)
llm_system_addon: Mapped[str] = mapped_column(Text, default="")
seedream_config: Mapped[dict] = mapped_column(JSON, default=dict)
seedance_config: Mapped[dict] = mapped_column(JSON, default=dict)
audio_config: Mapped[dict] = mapped_column(JSON, default=dict)
subtitle_config: Mapped[dict] = mapped_column(JSON, default=dict)
sort_order: Mapped[int] = mapped_column(Integer, default=0)
is_active: Mapped[bool] = mapped_column(Boolean, default=True)
is_premium: Mapped[bool] = mapped_column(Boolean, default=False)
class Project(Base):
__tablename__ = "projects"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
user_id: Mapped[int] = mapped_column(ForeignKey("users.id"), index=True)
template_id: Mapped[str] = mapped_column(ForeignKey("templates.id"), index=True)
title: Mapped[str] = mapped_column(String(200), default="未命名作品")
source_type: Mapped[str] = mapped_column(String(16), default="theme") # theme | script
source_text: Mapped[str] = mapped_column(Text)
status: Mapped[str] = mapped_column(String(32), default=ProjectStatus.DRAFT)
progress: Mapped[int] = mapped_column(Integer, default=0)
error_msg: Mapped[str | None] = mapped_column(Text, nullable=True)
cover_url: Mapped[str | None] = mapped_column(String(1024), nullable=True)
final_video_url: Mapped[str | None] = mapped_column(String(1024), nullable=True)
resolution_mode: Mapped[str] = mapped_column(String(16), default="preview") # preview | hd
# full = 图→视频→配音→合成;image_text = 静图+叠字+配音+Ken Burns(跳过 AI 视频)
# 由用户选择,不由模板锁定
pipeline_mode: Mapped[str] = mapped_column(String(32), default="full")
# Agent 会话归属和目标时长;历史向导项目保持空会话标识。
creation_session_id: Mapped[int | None] = mapped_column(Integer, nullable=True, index=True)
target_duration_sec: Mapped[int] = mapped_column(Integer, default=60)
# 输出画幅,如 16:9 / 9:16;空则回退模板 default_ratio
output_ratio: Mapped[str] = mapped_column(String(16), default="")
# 配音预设 id;空则用模板默认
voice_id: Mapped[str] = mapped_column(String(128), default="")
# Canonical cast/look description for Seedream consistency across shots
character_bible: Mapped[str] = mapped_column(Text, default="")
# Project-level BGM mood lock (same across shots)
bgm_lock: Mapped[str] = mapped_column(Text, default="")
# 科普成片字幕预设:standard | large | split
subtitle_preset: Mapped[str] = mapped_column(String(32), default="")
# User overrides from studio (optional)
style_prompt: Mapped[str] = mapped_column(Text, default="")
character_prompt: Mapped[str] = mapped_column(Text, default="")
extra_prompt: Mapped[str] = mapped_column(Text, default="")
# 科普图/视频模型;空则走后台 TokenFree 默认
image_model: Mapped[str] = mapped_column(String(64), default="")
video_model: Mapped[str] = mapped_column(String(64), default="")
image_resolution: Mapped[str] = mapped_column(String(16), default="")
video_resolution: Mapped[str] = mapped_column(String(16), default="")
ref_image_url: Mapped[str | None] = mapped_column(String(1024), nullable=True)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
updated_at: Mapped[datetime] = mapped_column(
DateTime(timezone=True), server_default=func.now(), onupdate=func.now()
)
owner: Mapped["User"] = relationship(back_populates="projects")
template: Mapped["Template"] = relationship()
shots: Mapped[list["Shot"]] = relationship(
back_populates="project",
cascade="all, delete-orphan",
order_by="Shot.shot_no",
)
jobs: Mapped[list["PipelineJob"]] = relationship(back_populates="project", cascade="all, delete-orphan")
class Shot(Base):
__tablename__ = "shots"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
project_id: Mapped[int] = mapped_column(ForeignKey("projects.id"), index=True)
shot_no: Mapped[int] = mapped_column(Integer)
duration: Mapped[float] = mapped_column(Float, default=4.0)
narration: Mapped[str] = mapped_column(Text, default="") # TTS 旁白
overlay_title: Mapped[str] = mapped_column(String(128), default="") # 图文顶部大标题
overlay_subtitle: Mapped[str] = mapped_column(String(256), default="") # 图文顶部副标题(叠字)
img_prompt: Mapped[str] = mapped_column(Text, default="")
video_prompt: Mapped[str] = mapped_column(Text, default="")
# Manju-style timed segment script (@duration + production cues)
segment_script: Mapped[str] = mapped_column(Text, default="")
camera: Mapped[str] = mapped_column(String(64), default="slow pan")
bgm_mood: Mapped[str] = mapped_column(String(64), default="neutral")
image_url: Mapped[str | None] = mapped_column(String(1024), nullable=True)
image_ark_url: Mapped[str | None] = mapped_column(String(1024), nullable=True)
video_url: Mapped[str | None] = mapped_column(String(1024), nullable=True)
last_frame_url: Mapped[str | None] = mapped_column(String(1024), nullable=True)
audio_url: Mapped[str | None] = mapped_column(String(1024), nullable=True)
# 跳过 AI 视频的原因(privacy=真人隐私拦截,静图合成);NULL 表示正常出视频
video_skip_reason: Mapped[str | None] = mapped_column(String(32), nullable=True)
status: Mapped[str] = mapped_column(String(32), default=ShotStatus.PENDING)
version: Mapped[int] = mapped_column(Integer, default=1)
project: Mapped["Project"] = relationship(back_populates="shots")
class PipelineJob(Base):
__tablename__ = "pipeline_jobs"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
project_id: Mapped[int] = mapped_column(ForeignKey("projects.id"), index=True)
stage: Mapped[str] = mapped_column(String(32))
progress: Mapped[int] = mapped_column(Integer, default=0)
error_code: Mapped[str | None] = mapped_column(String(64), nullable=True)
error_msg: Mapped[str | None] = mapped_column(Text, nullable=True)
retry_count: Mapped[int] = mapped_column(Integer, default=0)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
project: Mapped["Project"] = relationship(back_populates="jobs")
class Work(Base):
__tablename__ = "works"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
project_id: Mapped[int] = mapped_column(ForeignKey("projects.id"), unique=True)
user_id: Mapped[int] = mapped_column(ForeignKey("users.id"), index=True)
title: Mapped[str] = mapped_column(String(200))
cover_url: Mapped[str | None] = mapped_column(String(1024), nullable=True)
video_url: Mapped[str] = mapped_column(String(1024))
visibility: Mapped[str] = mapped_column(String(16), default="public")
audit_status: Mapped[str] = mapped_column(String(16), default="passed")
published_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
class UsageEvent(Base):
"""One upstream model/TTS call for token billing."""
__tablename__ = "usage_events"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
user_id: Mapped[int] = mapped_column(ForeignKey("users.id"), index=True)
billing_payer_user_id: Mapped[int | None] = mapped_column(ForeignKey("users.id"), nullable=True, index=True)
team_id: Mapped[int | None] = mapped_column(ForeignKey("teams.id"), nullable=True, index=True)
project_id: Mapped[int | None] = mapped_column(
ForeignKey("projects.id", ondelete="SET NULL"), nullable=True, index=True
)
# Drama module billing ref (mutually exclusive with kepu project_id when set)
drama_project_id: Mapped[int | None] = mapped_column(Integer, nullable=True, index=True)
task_run_id: Mapped[int | None] = mapped_column(Integer, nullable=True, index=True)
domain: Mapped[str | None] = mapped_column(String(32), nullable=True, index=True)
capability: Mapped[str | None] = mapped_column(String(16), nullable=True, index=True)
shot_id: Mapped[int | None] = mapped_column(Integer, nullable=True)
provider: Mapped[str] = mapped_column(String(32), default="ark")
billing_key: Mapped[str] = mapped_column(String(64), index=True)
model: Mapped[str] = mapped_column(String(128), default="")
prompt_tokens: Mapped[int] = mapped_column(Integer, default=0)
completion_tokens: Mapped[int] = mapped_column(Integer, default=0)
total_tokens: Mapped[int] = mapped_column(Integer, default=0)
cost_fen: Mapped[int] = mapped_column(Integer, default=0)
charge_fen: Mapped[int] = mapped_column(Integer, default=0)
estimated: Mapped[bool] = mapped_column(Boolean, default=False)
settled: Mapped[bool] = mapped_column(Boolean, default=False)
raw_usage_json: Mapped[str | None] = mapped_column(Text, nullable=True)
billing_detail: Mapped[dict | None] = mapped_column(JSON, nullable=True)
delivery_key: Mapped[str | None] = mapped_column(String(192), nullable=True, unique=True)
cost_status: Mapped[str | None] = mapped_column(String(16), nullable=True)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
class WalletLedger(Base):
__tablename__ = "wallet_ledger"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
user_id: Mapped[int] = mapped_column(ForeignKey("users.id"), index=True)
delta_fen: Mapped[int] = mapped_column(Integer)
balance_after: Mapped[int] = mapped_column(Integer, default=0)
kind: Mapped[str] = mapped_column(String(32)) # topup|grant|freeze|unfreeze|settle|refund
ref_type: Mapped[str] = mapped_column(String(32), default="")
ref_id: Mapped[str] = mapped_column(String(64), default="")
note: Mapped[str] = mapped_column(String(255), default="")
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
class Order(Base):
__tablename__ = "orders"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
out_trade_no: Mapped[str] = mapped_column(String(64), unique=True, index=True)
user_id: Mapped[int] = mapped_column(ForeignKey("users.id"), index=True)
team_id: Mapped[int | None] = mapped_column(ForeignKey("teams.id"), nullable=True, index=True)
sku_id: Mapped[str] = mapped_column(String(64))
amount_fen: Mapped[int] = mapped_column(Integer)
credit_fen: Mapped[int] = mapped_column(Integer)
pay_type: Mapped[str] = mapped_column(String(16)) # alipay | wxpay
status: Mapped[str] = mapped_column(String(16), default="pending") # pending|paid|closed
trade_no: Mapped[str | None] = mapped_column(String(128), nullable=True)
paid_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True), nullable=True)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
class ToolRun(Base):
"""独立创作工具一次生成记录,供个人中心回看。"""
__tablename__ = "tool_runs"
id: Mapped[int] = mapped_column(Integer, primary_key=True)
user_id: Mapped[int] = mapped_column(ForeignKey("users.id", ondelete="CASCADE"), index=True)
tool_id: Mapped[str] = mapped_column(String(16), index=True)
kind: Mapped[str] = mapped_column(String(16), default="image")
status: Mapped[str] = mapped_column(String(16), default="succeeded", index=True)
prompt: Mapped[str] = mapped_column(Text, default="")
preview_url: Mapped[str | None] = mapped_column(String(1024), nullable=True)
urls: Mapped[list | None] = mapped_column(JSON, nullable=True)
task_id: Mapped[str | None] = mapped_column(String(128), nullable=True, index=True)
params: Mapped[dict | None] = mapped_column(JSON, nullable=True)
error: Mapped[str | None] = mapped_column(String(512), nullable=True)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
updated_at: Mapped[datetime] = mapped_column(
DateTime(timezone=True), server_default=func.now(), onupdate=func.now()
)