| 183 | |
| 184 | # KEEP in oss/ |
| 185 | class DeploymentDB(Base): |
| 186 | __tablename__ = "deployments" |
| 187 | |
| 188 | id = Column( |
| 189 | UUID(as_uuid=True), |
| 190 | primary_key=True, |
| 191 | default=uuid.uuid7, |
| 192 | unique=True, |
| 193 | nullable=False, |
| 194 | ) |
| 195 | app_id = Column(UUID(as_uuid=True), ForeignKey("app_db.id", ondelete="CASCADE")) |
| 196 | project_id = Column( |
| 197 | UUID(as_uuid=True), ForeignKey("projects.id", ondelete="CASCADE") |
| 198 | ) |
| 199 | uri = Column(String) |
| 200 | created_at = Column( |
| 201 | DateTime(timezone=True), default=lambda: datetime.now(timezone.utc) |
| 202 | ) |
| 203 | updated_at = Column( |
| 204 | DateTime(timezone=True), default=lambda: datetime.now(timezone.utc) |
| 205 | ) |
| 206 | |
| 207 | project = relationship("oss.src.models.db_models.ProjectDB") |
| 208 | app = relationship("AppDB", back_populates="deployment") |
| 209 | |
| 210 | |
| 211 | # KEEP in oss/ |