| 123456789101112131415161718192021222324252627282930313233343536373839404142 |
- # 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)
|