# app/models/agency.py from datetime import datetime from sqlalchemy import Column, String, Integer, SmallInteger, DateTime, Text from app.core.database import Base class VasAgency(Base): __tablename__ = "vas_agency" __ddl__ = """ CREATE TABLE IF NOT EXISTS `vas_agency` ( `id` VARCHAR(64) NOT NULL, `name` VARCHAR(128) NOT NULL, `contact_name` VARCHAR(64) NULL, `contact_phone` VARCHAR(32) NULL, `owner_id` VARCHAR(128) NOT NULL COMMENT '中介对接拓展人 (独享40%提成)', `min_floor_price` INT NOT NULL DEFAULT 0 COMMENT '协议底价(分)', `status` SMALLINT NOT NULL DEFAULT 1 COMMENT '1:合作中, 0:停用', `notes` TEXT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `uk_vas_agency_name` (`name`), INDEX `idx_vas_agency_owner` (`owner_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='合作中介机构表'; """ id = Column(String(64), primary_key=True) name = Column(String(128), nullable=False, unique=True, index=True) contact_name = Column(String(64), nullable=True) contact_phone = Column(String(32), nullable=True) # 该中介归属的专属拓展/维系人 (40%销售提成归其个人) owner_id = Column(String(128), nullable=False, index=True) # 该中介默认协议最低底价 (分),若为0则沿用产品默认底价 min_floor_price = Column(Integer, default=0, nullable=False) status = Column(SmallInteger, default=1, nullable=False) # 1:合作中, 0:终止合作 notes = Column(Text, nullable=True) created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)