agency.py 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. # app/models/agency.py
  2. from datetime import datetime
  3. from sqlalchemy import Column, String, Integer, SmallInteger, DateTime, Text
  4. from app.core.database import Base
  5. class VasAgency(Base):
  6. __tablename__ = "vas_agency"
  7. __ddl__ = """
  8. CREATE TABLE IF NOT EXISTS `vas_agency` (
  9. `id` VARCHAR(64) NOT NULL,
  10. `name` VARCHAR(128) NOT NULL,
  11. `contact_name` VARCHAR(64) NULL,
  12. `contact_phone` VARCHAR(32) NULL,
  13. `owner_id` VARCHAR(128) NOT NULL COMMENT '中介对接拓展人 (独享40%提成)',
  14. `min_floor_price` INT NOT NULL DEFAULT 0 COMMENT '协议底价(分)',
  15. `status` SMALLINT NOT NULL DEFAULT 1 COMMENT '1:合作中, 0:停用',
  16. `notes` TEXT NULL,
  17. `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
  18. `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  19. PRIMARY KEY (`id`),
  20. UNIQUE KEY `uk_vas_agency_name` (`name`),
  21. INDEX `idx_vas_agency_owner` (`owner_id`)
  22. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='合作中介机构表';
  23. """
  24. id = Column(String(64), primary_key=True)
  25. name = Column(String(128), nullable=False, unique=True, index=True)
  26. contact_name = Column(String(64), nullable=True)
  27. contact_phone = Column(String(32), nullable=True)
  28. # 该中介归属的专属拓展/维系人 (40%销售提成归其个人)
  29. owner_id = Column(String(128), nullable=False, index=True)
  30. # 该中介默认协议最低底价 (分),若为0则沿用产品默认底价
  31. min_floor_price = Column(Integer, default=0, nullable=False)
  32. status = Column(SmallInteger, default=1, nullable=False) # 1:合作中, 0:终止合作
  33. notes = Column(Text, nullable=True)
  34. created_at = Column(DateTime, default=datetime.utcnow)
  35. updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)