| 1234567891011121314151617181920212223242526 |
- from sqlalchemy import Column, String, DateTime, Text, JSON, Integer
- from datetime import datetime
- from app.core.database import Base
- class VasSchema(Base):
- __tablename__ = "vas_schema"
- __ddl__ = """
- CREATE TABLE IF NOT EXISTS `vas_schema` (
- `id` INT NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) NOT NULL,
- `description` TEXT NULL,
- `schema_json` JSON NOT NULL,
- `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='表单数据结构定义表';
- """
- id = Column(Integer, primary_key=True, autoincrement=True)
- name = Column(String(255), nullable=False)
- description = Column(Text)
- schema_json = Column(JSON, nullable=False)
- created_at = Column(DateTime, default=datetime.utcnow)
- updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)
|