{
  "tables": {
    "asset_libraries": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "project_id",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(255)",
          "unique": false
        },
        {
          "index": true,
          "name": "kind",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "asset_count",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "total_size",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "metadata",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "kind"
          ],
          "name": "ix_asset_libraries_kind",
          "unique": false
        },
        {
          "columns": [
            "project_id"
          ],
          "name": "ix_asset_libraries_project_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "asset_tags": {
      "columns": [
        {
          "index": false,
          "name": "asset_id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "tag_id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [],
      "primary_key": [
        "asset_id",
        "tag_id"
      ]
    },
    "assets": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "project_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "asset_library_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(500)",
          "unique": false
        },
        {
          "index": true,
          "name": "file_type",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "file_size",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "file_url",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(1000)",
          "unique": false
        },
        {
          "index": false,
          "name": "thumbnail_url",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(1000)",
          "unique": false
        },
        {
          "index": false,
          "name": "duration",
          "nullable": true,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "width",
          "nullable": true,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "height",
          "nullable": true,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "fps",
          "nullable": true,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "codec",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(50)",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": true,
          "name": "classification_status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "classification_result",
          "nullable": true,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "quality_score",
          "nullable": true,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "uploaded_by_user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "file_hash",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(64)",
          "unique": false
        },
        {
          "index": false,
          "name": "metadata",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": true,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "asset_library_id"
          ],
          "name": "ix_assets_asset_library_id",
          "unique": false
        },
        {
          "columns": [
            "classification_status"
          ],
          "name": "ix_assets_classification_status",
          "unique": false
        },
        {
          "columns": [
            "created_at"
          ],
          "name": "ix_assets_created_at",
          "unique": false
        },
        {
          "columns": [
            "file_hash"
          ],
          "name": "ix_assets_file_hash",
          "unique": false
        },
        {
          "columns": [
            "file_type"
          ],
          "name": "ix_assets_file_type",
          "unique": false
        },
        {
          "columns": [
            "project_id"
          ],
          "name": "ix_assets_project_id",
          "unique": false
        },
        {
          "columns": [
            "status"
          ],
          "name": "ix_assets_status",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "billing_records": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "plan_name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(50)",
          "unique": false
        },
        {
          "index": false,
          "name": "amount",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "billing_cycle",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "payment_method",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(50)",
          "unique": false
        },
        {
          "index": false,
          "name": "payment_id",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "invoice_url",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(500)",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "paid_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "user_id"
          ],
          "name": "ix_billing_records_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "classification_jobs": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "project_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "asset_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "classification",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(50)",
          "unique": false
        },
        {
          "index": false,
          "name": "confidence",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "error_message",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "asset_id"
          ],
          "name": "ix_classification_jobs_asset_id",
          "unique": false
        },
        {
          "columns": [
            "project_id"
          ],
          "name": "ix_classification_jobs_project_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "duplication_records": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "filename",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(500)",
          "unique": false
        },
        {
          "index": false,
          "name": "file_size",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "storage_key",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(500)",
          "unique": false
        },
        {
          "index": false,
          "name": "duration_seconds",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "duplicate_rate",
          "nullable": true,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "duplicate_count",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "video_fingerprint",
          "nullable": true,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "error_message",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "status"
          ],
          "name": "ix_duplication_records_status",
          "unique": false
        },
        {
          "columns": [
            "user_id"
          ],
          "name": "ix_duplication_records_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "duplication_segments": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "record_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "source_start",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "source_end",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "matched_video_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "matched_video_name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(500)",
          "unique": false
        },
        {
          "index": false,
          "name": "matched_start",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "matched_end",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "similarity",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "record_id"
          ],
          "name": "ix_duplication_segments_record_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "edit_plan_clips": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "plan_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "clip_type",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "order",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": true,
          "name": "template_clip_config_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "asset_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "text_content",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "start_time",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "duration",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "transition_effect",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "config",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "asset_id"
          ],
          "name": "ix_edit_plan_clips_asset_id",
          "unique": false
        },
        {
          "columns": [
            "clip_type"
          ],
          "name": "ix_edit_plan_clips_clip_type",
          "unique": false
        },
        {
          "columns": [
            "plan_id"
          ],
          "name": "ix_edit_plan_clips_plan_id",
          "unique": false
        },
        {
          "columns": [
            "status"
          ],
          "name": "ix_edit_plan_clips_status",
          "unique": false
        },
        {
          "columns": [
            "template_clip_config_id"
          ],
          "name": "ix_edit_plan_clips_template_clip_config_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "edit_plans": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "template_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(200)",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "total_duration",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "config",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": true,
          "name": "source_edit_plan_id",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "project_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "created_by_user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "created_by_user_id"
          ],
          "name": "ix_edit_plans_created_by_user_id",
          "unique": false
        },
        {
          "columns": [
            "project_id"
          ],
          "name": "ix_edit_plans_project_id",
          "unique": false
        },
        {
          "columns": [
            "source_edit_plan_id"
          ],
          "name": "ix_edit_plans_source_edit_plan_id",
          "unique": false
        },
        {
          "columns": [
            "status"
          ],
          "name": "ix_edit_plans_status",
          "unique": false
        },
        {
          "columns": [
            "template_id"
          ],
          "name": "ix_edit_plans_template_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "edit_templates": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(120)",
          "unique": false
        },
        {
          "index": false,
          "name": "description",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": true,
          "name": "template_type",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(50)",
          "unique": false
        },
        {
          "index": false,
          "name": "config",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "preview_url",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(1000)",
          "unique": false
        },
        {
          "index": true,
          "name": "sort_weight",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "sort_weight"
          ],
          "name": "ix_edit_templates_sort_weight",
          "unique": false
        },
        {
          "columns": [
            "status"
          ],
          "name": "ix_edit_templates_status",
          "unique": false
        },
        {
          "columns": [
            "template_type"
          ],
          "name": "ix_edit_templates_template_type",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "generated_videos": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "project_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "generation_task_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(255)",
          "unique": false
        },
        {
          "index": false,
          "name": "file_url",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(1000)",
          "unique": false
        },
        {
          "index": false,
          "name": "file_size",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "duration",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "thumbnail_url",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(1000)",
          "unique": false
        },
        {
          "index": false,
          "name": "width",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "height",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "fps",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": true,
          "name": "review_status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "generation_params",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "generated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "video_fingerprint",
          "nullable": true,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "is_duplicate",
          "nullable": false,
          "primary_key": false,
          "type": "BOOLEAN",
          "unique": false
        },
        {
          "index": false,
          "name": "duplicate_of",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "generation_task_id"
          ],
          "name": "ix_generated_videos_generation_task_id",
          "unique": false
        },
        {
          "columns": [
            "project_id"
          ],
          "name": "ix_generated_videos_project_id",
          "unique": false
        },
        {
          "columns": [
            "review_status"
          ],
          "name": "ix_generated_videos_review_status",
          "unique": false
        },
        {
          "columns": [
            "status"
          ],
          "name": "ix_generated_videos_status",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "generation_tasks": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "project_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "strategy_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "asset_library_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "voice_library_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "template_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "asset_ids",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "title_ids",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "voice_ids",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": true,
          "name": "editing_mode",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "progress",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "result_count",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "error_message",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "started_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "completed_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": true,
          "name": "created_by_user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "source_edit_plan_id",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "asset_select_mode",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": true,
          "name": "batch_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "is_preview",
          "nullable": false,
          "primary_key": false,
          "type": "BOOLEAN",
          "unique": false
        },
        {
          "index": true,
          "name": "source_task_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "output_width",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "output_height",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "cover_url",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(1000)",
          "unique": false
        },
        {
          "index": false,
          "name": "custom_title",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(500)",
          "unique": false
        },
        {
          "index": false,
          "name": "metadata",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "asset_library_id"
          ],
          "name": "ix_generation_tasks_asset_library_id",
          "unique": false
        },
        {
          "columns": [
            "batch_id"
          ],
          "name": "ix_generation_tasks_batch_id",
          "unique": false
        },
        {
          "columns": [
            "created_by_user_id"
          ],
          "name": "ix_generation_tasks_created_by_user_id",
          "unique": false
        },
        {
          "columns": [
            "editing_mode"
          ],
          "name": "ix_generation_tasks_editing_mode",
          "unique": false
        },
        {
          "columns": [
            "project_id"
          ],
          "name": "ix_generation_tasks_project_id",
          "unique": false
        },
        {
          "columns": [
            "source_edit_plan_id"
          ],
          "name": "ix_generation_tasks_source_edit_plan_id",
          "unique": false
        },
        {
          "columns": [
            "source_task_id"
          ],
          "name": "ix_generation_tasks_source_task_id",
          "unique": false
        },
        {
          "columns": [
            "status"
          ],
          "name": "ix_generation_tasks_status",
          "unique": false
        },
        {
          "columns": [
            "template_id"
          ],
          "name": "ix_generation_tasks_template_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "ingest_jobs": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "project_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "library_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "storage_key",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(255)",
          "unique": false
        },
        {
          "index": false,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "error_message",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "result_asset_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "file_hash",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(64)",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "file_hash"
          ],
          "name": "ix_ingest_jobs_file_hash",
          "unique": false
        },
        {
          "columns": [
            "library_id"
          ],
          "name": "ix_ingest_jobs_library_id",
          "unique": false
        },
        {
          "columns": [
            "project_id"
          ],
          "name": "ix_ingest_jobs_project_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "jobs": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "project_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "job_type",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(30)",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "progress",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "current_stage",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(200)",
          "unique": false
        },
        {
          "index": false,
          "name": "payload",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "result",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "error_message",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "retry_count",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "max_retries",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "celery_task_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": true,
          "name": "source_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "created_by_user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "started_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "completed_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "created_by_user_id"
          ],
          "name": "ix_jobs_created_by_user_id",
          "unique": false
        },
        {
          "columns": [
            "job_type"
          ],
          "name": "ix_jobs_job_type",
          "unique": false
        },
        {
          "columns": [
            "project_id"
          ],
          "name": "ix_jobs_project_id",
          "unique": false
        },
        {
          "columns": [
            "source_id"
          ],
          "name": "ix_jobs_source_id",
          "unique": false
        },
        {
          "columns": [
            "status"
          ],
          "name": "ix_jobs_status",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "projects": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "owner_user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "description",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "shared_users",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "metadata",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "owner_user_id"
          ],
          "name": "ix_projects_owner_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "recipe_items": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "recipe_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "item_type",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "item_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "position",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "metadata",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "recipe_id"
          ],
          "name": "ix_recipe_items_recipe_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "recipes": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(200)",
          "unique": false
        },
        {
          "index": false,
          "name": "description",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "template_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "generation_params",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "is_active",
          "nullable": false,
          "primary_key": false,
          "type": "BOOLEAN",
          "unique": false
        },
        {
          "index": false,
          "name": "metadata",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "user_id"
          ],
          "name": "ix_recipes_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "tags": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "user_id"
          ],
          "name": "ix_tags_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "template_categories": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "user_id"
          ],
          "name": "ix_template_categories_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "template_clip_configs": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "template_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(32)",
          "unique": false
        },
        {
          "index": true,
          "name": "clip_type",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "order",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "min_duration",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "max_duration",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "text_template",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "material_requirements",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "transition_effect",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "config",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "clip_type"
          ],
          "name": "ix_template_clip_configs_clip_type",
          "unique": false
        },
        {
          "columns": [
            "template_id"
          ],
          "name": "ix_template_clip_configs_template_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "template_segments": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "template_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "segment_order",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "duration_min",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "duration_max",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "material_type",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "template_id"
          ],
          "name": "ix_template_segments_template_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "templates": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(200)",
          "unique": false
        },
        {
          "index": true,
          "name": "mode",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(30)",
          "unique": false
        },
        {
          "index": false,
          "name": "category",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "tags",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "title_config",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "subtitle_config",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "bgm_config",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "estimated_duration",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "is_active",
          "nullable": false,
          "primary_key": false,
          "type": "BOOLEAN",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "mode"
          ],
          "name": "ix_templates_mode",
          "unique": false
        },
        {
          "columns": [
            "user_id"
          ],
          "name": "ix_templates_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "title_libraries": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(255)",
          "unique": false
        },
        {
          "index": false,
          "name": "description",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": true,
          "name": "category",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(50)",
          "unique": false
        },
        {
          "index": false,
          "name": "text",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(500)",
          "unique": false
        },
        {
          "index": false,
          "name": "tags",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "usage_count",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": true,
          "name": "is_active",
          "nullable": false,
          "primary_key": false,
          "type": "BOOLEAN",
          "unique": false
        },
        {
          "index": false,
          "name": "metadata",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "category"
          ],
          "name": "ix_title_libraries_category",
          "unique": false
        },
        {
          "columns": [
            "is_active"
          ],
          "name": "ix_title_libraries_is_active",
          "unique": false
        },
        {
          "columns": [
            "user_id"
          ],
          "name": "ix_title_libraries_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "tts_jobs": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "input_text",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "voice_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "voice_model",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "project_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "voice_clone_profile_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "output_audio_url",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "output_audio_key",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(500)",
          "unique": false
        },
        {
          "index": false,
          "name": "duration",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "file_size",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "sample_rate",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "format",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "error_message",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "retry_count",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "max_retries",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "metadata",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "started_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "completed_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "status"
          ],
          "name": "ix_tts_jobs_status",
          "unique": false
        },
        {
          "columns": [
            "user_id"
          ],
          "name": "ix_tts_jobs_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "users": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "email",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(255)",
          "unique": true
        },
        {
          "index": true,
          "name": "username",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": true
        },
        {
          "index": false,
          "name": "display_name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(255)",
          "unique": false
        },
        {
          "index": false,
          "name": "password_hash",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(255)",
          "unique": false
        },
        {
          "index": false,
          "name": "email_verified",
          "nullable": false,
          "primary_key": false,
          "type": "BOOLEAN",
          "unique": false
        },
        {
          "index": false,
          "name": "email_verification_token",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(255)",
          "unique": false
        },
        {
          "index": false,
          "name": "password_reset_token",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(255)",
          "unique": false
        },
        {
          "index": false,
          "name": "password_reset_expires_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "last_login_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "last_login_ip",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(50)",
          "unique": false
        },
        {
          "index": false,
          "name": "subscription_plan",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "subscription_status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "subscription_expires_at",
          "nullable": true,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "max_projects",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "max_storage_gb",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "used_storage_gb",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "is_admin",
          "nullable": false,
          "primary_key": false,
          "type": "BOOLEAN",
          "unique": false
        },
        {
          "index": true,
          "name": "wechat_openid",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(128)",
          "unique": true
        },
        {
          "index": true,
          "name": "wechat_unionid",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(128)",
          "unique": true
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "email"
          ],
          "name": "ix_users_email",
          "unique": true
        },
        {
          "columns": [
            "username"
          ],
          "name": "ix_users_username",
          "unique": true
        },
        {
          "columns": [
            "wechat_openid"
          ],
          "name": "ix_users_wechat_openid",
          "unique": true
        },
        {
          "columns": [
            "wechat_unionid"
          ],
          "name": "ix_users_wechat_unionid",
          "unique": true
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "voice_clone_profiles": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "description",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "source_audio_url",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "voice_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "voice_model",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "language",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "gender",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "error_message",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "retry_count",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "max_retries",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": false,
          "name": "metadata",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "status"
          ],
          "name": "ix_voice_clone_profiles_status",
          "unique": false
        },
        {
          "columns": [
            "user_id"
          ],
          "name": "ix_voice_clone_profiles_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    },
    "voice_libraries": {
      "columns": [
        {
          "index": false,
          "name": "id",
          "nullable": false,
          "primary_key": true,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "user_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": true,
          "name": "project_id",
          "nullable": true,
          "primary_key": false,
          "type": "VARCHAR(36)",
          "unique": false
        },
        {
          "index": false,
          "name": "name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(255)",
          "unique": false
        },
        {
          "index": false,
          "name": "text",
          "nullable": false,
          "primary_key": false,
          "type": "TEXT",
          "unique": false
        },
        {
          "index": false,
          "name": "voice_provider",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(50)",
          "unique": false
        },
        {
          "index": false,
          "name": "voice_id",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "voice_name",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(100)",
          "unique": false
        },
        {
          "index": false,
          "name": "audio_url",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(1000)",
          "unique": false
        },
        {
          "index": false,
          "name": "duration",
          "nullable": false,
          "primary_key": false,
          "type": "FLOAT",
          "unique": false
        },
        {
          "index": false,
          "name": "file_size",
          "nullable": false,
          "primary_key": false,
          "type": "INTEGER",
          "unique": false
        },
        {
          "index": true,
          "name": "status",
          "nullable": false,
          "primary_key": false,
          "type": "VARCHAR(20)",
          "unique": false
        },
        {
          "index": false,
          "name": "tags",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "metadata",
          "nullable": false,
          "primary_key": false,
          "type": "JSON",
          "unique": false
        },
        {
          "index": false,
          "name": "created_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        },
        {
          "index": false,
          "name": "updated_at",
          "nullable": false,
          "primary_key": false,
          "type": "DATETIME",
          "unique": false
        }
      ],
      "indexes": [
        {
          "columns": [
            "project_id"
          ],
          "name": "ix_voice_libraries_project_id",
          "unique": false
        },
        {
          "columns": [
            "status"
          ],
          "name": "ix_voice_libraries_status",
          "unique": false
        },
        {
          "columns": [
            "user_id"
          ],
          "name": "ix_voice_libraries_user_id",
          "unique": false
        }
      ],
      "primary_key": [
        "id"
      ]
    }
  }
}
