schema.py 1.0 KB

1234567891011121314151617181920212223242526
  1. from sqlalchemy import Column, String, DateTime, Text, JSON, Integer
  2. from datetime import datetime
  3. from app.core.database import Base
  4. class VasSchema(Base):
  5. __tablename__ = "vas_schema"
  6. __ddl__ = """
  7. CREATE TABLE IF NOT EXISTS `vas_schema` (
  8. `id` INT NOT NULL AUTO_INCREMENT,
  9. `name` VARCHAR(255) NOT NULL,
  10. `description` TEXT NULL,
  11. `schema_json` JSON NOT NULL,
  12. `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  13. `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  14. PRIMARY KEY (`id`)
  15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='表单数据结构定义表';
  16. """
  17. id = Column(Integer, primary_key=True, autoincrement=True)
  18. name = Column(String(255), nullable=False)
  19. description = Column(Text)
  20. schema_json = Column(JSON, nullable=False)
  21. created_at = Column(DateTime, default=datetime.utcnow)
  22. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)