Open Stack 2.0 Data Model

[urbantech]

1. Corporations

• Corporation
  • id: UUID (Primary Key)
  • legalName: String (Required)
  • doingBusinessAsName: String (Optional)
  • website: String (Optional)

---

2. Compensation

• CompensationBenchmark
  • id: UUID (Primary Key)
  • corporationId: UUID (Foreign Key, Required)
  • benchmarks_version_datetime: DateTime (Required)
  • compensation_type: Enum (Required) - (e.g., SALARY, EQUITY_AS_FULLY_DILUTED_PERCENT)
  • industry: String (Optional)
  • percentile: Enum (Required) - (e.g., P25, P50, P75)
  • post_money_valuation_bucket: String (Optional)
  • geo_adjustment_location: String (Optional)
  • job_area: String (Optional)
  • job_specialization: String (Optional)
  • job_level: String (Optional)

---

3. Issuers

• Issuer
  • id: UUID (Primary Key)
  • legalName: String (Required)
  • doingBusinessAsName: String (Optional)
  • website: String (Optional)
  • dateOfIncorporation: Date (Required)
  • countryOfIncorporation: String (Required)
  • stateOfIncorporation: String (Optional)
  • employerIdentificationNumber: String (Optional)
  • address: JSON (storing line1, city, countrySubdivision, country, postalCode) (Optional)
  • primaryContactId: UUID (Foreign Key, Optional)
  • certificateOfIncorporationId: UUID (Foreign Key, Optional)

---

4. Certificates

• Certificate
  • id: UUID (Primary Key)
  • issuerId: UUID (Foreign Key, Required)
  • stakeholderId: UUID (Foreign Key, Required)
  • shareClassId: UUID (Foreign Key, Required)
  • issueDate: Date (Required)
  • quantity: Decimal (Required)
  • pricePerShare: Decimal (Required)
  • lastModifiedDatetime: DateTime (Optional)
  • canceledDate: Date (Optional)
  • terminationDate: Date (Optional)

---

5. Convertible Notes

• ConvertibleNote
  • id: UUID (Primary Key)
  • issuerId: UUID (Foreign Key, Required)
  • stakeholderId: UUID (Foreign Key, Required)
  • securityLabel: String (Required)
  • issueDatetime: DateTime (Required)
  • conversionDatetime: DateTime (Optional)
  • canceledDatetime: DateTime (Optional)
  • cashPaid: Decimal (Required)
  • maturityDatetime: DateTime (Required)
  • interest: Decimal (Required)
  • noteBlockId: UUID (Foreign Key, Optional)
  • interestAccrualPeriod: String (Optional)
  • interestRate: Decimal (Required)
  • interestCompoundingPeriod: String (Optional)
  • dayCountBasis: String (Optional)
  • priceCap: Decimal (Optional)
  • discountPercentage: Decimal (Optional)
  • changeInControlPercent: Decimal (Optional)
  • conversionTrigger: Decimal (Optional)
  • canceledQuantity: Decimal (Optional)

---

6. Stakeholders

• Stakeholder
  • id: UUID (Primary Key)
  • issuerId: UUID (Foreign Key, Required)
  • fullName: String (Required)
  • email: String (Required)
  • relationship: String (Required)
  • employeeId: String (Optional)
  • role: String (Optional)
  • StakeholderRelationshipType: Enum (Required) - (e.g., Founder, Investor)
  • ContactInfo: JSON (Optional)
    • Email: String (Optional)
    • Phone: String (Optional)
    • Address: String (Optional)
    • TaxID: String (Optional)
    • EmailType: Enum (Optional) - (e.g., Work, Personal)
    • PhoneType: Enum (Optional) - (e.g., Mobile, Landline)
    • AddressType: Enum (Optional) - (e.g., Home, Office)

---

7. Vesting Schedules

• VestingScheduleTemplate

  • id: UUID (Primary Key)
  • issuerId: UUID (Foreign Key, Required)
  • name: String (Required)
  • description: String (Optional)
  • vestingScheduleType: String (Optional)
  • startDate: Date (Required)
  • endDate: Date (Optional)

• EquityPlan

  • planId: UUID (Primary Key)
  • issuerId: UUID (Foreign Key, Required)
  • planName: String (Required)
  • description: String (Optional)
  • startDate: Date (Required)
  • endDate: Date (Optional)
  • allocation: Decimal (Required)
  • participants: Array of UUID (stakeholderId) (Optional)
  • vestingTerms: JSON (Optional)
    • vestingStartDate: Date (Optional)
    • vestingEndDate: Date (Optional)
    • vestingSchedule: String (Optional)
  • planType: Enum (Required) - (e.g., Stock Option Plan, Restricted Stock Plan)
  • allocationType: Enum (Optional) - (e.g., Fixed, Performance-Based)
  • planAdministrator: String (Optional)

---

8. Capitalization Tables

• CapitalizationTable
  • id: UUID (Primary Key)
  • issuerId: UUID (Foreign Key, Required)
  • asOfDate: Date (Required)
  • fullyDilutedShares: Decimal (Required)
  • outstandingShares: Decimal (Required)
  • cashRaised: Decimal (Required)
  • shareClassSummaries: JSON (including shareClassId, outstandingShares, fullyDilutedShares, cashRaised) (Optional)
  • optionPoolSummaries: JSON (including optionPoolId, shareClassId, fullyDilutedShares, outstandingEquityAwardDerivatives) (Optional)
  • warrantBlockSummaries: JSON (including warrantBlockId, shareClassId, fullyDilutedShares, outstandingWarrants) (Optional)
  • noteBlockSummaries: JSON (including noteBlockId, principal, interest, outstanding_debt) (Optional)

---

9. Portfolios

• Portfolio

  • portfolioId: UUID (Primary Key)
  • legalName: String (Required)
  • createTime: DateTime (Required)

• PortfolioIssuer

  • id: UUID (Primary Key)
  • portfolioId: UUID (Foreign Key, Required)
  • issuerId: UUID (Foreign Key, Required)
  • fairMarketValue: Decimal (Required)

---

10. Funds

• Fund

  • id: UUID (Primary Key)
  • firmId: UUID (Foreign Key, Required)
  • name: String (Required)

• FundInvestmentDocument

  • documentId: UUID (Primary Key)
  • fundId: UUID (Foreign Key, Required)
  • firmId: UUID (Foreign Key, Required)
  • documentName: String (Required)
  • effectiveDate: Date (Required)
  • sharedDate: Date (Optional)

---

11. Warrants

• Warrant
  • id: UUID (Primary Key)
  • firmId: UUID (Foreign Key, Required)
  • fundId: UUID (Foreign Key, Required)
  • companyId: UUID (Foreign Key, Required)
  • stakeholderId: UUID (Foreign Key, Required)
  • shareClassId: UUID (Foreign Key, Required)
  • issueDate: Date (Required)
  • quantity: Decimal (Required)
  • pricePerShare: Decimal (Required)
  • canceledDate: Date (Optional)
  • terminationDate: Date (Optional)

---

12. Option Grants

• OptionGrant
  • id: UUID (Primary Key)
  • issuerId: UUID (Foreign Key, Required)
  • stakeholderId: UUID (Foreign Key, Required)
  • equityIncentivePlanName: String (Optional)
  • issueDate: Date (Required)
  • vestingStartDate: Date (Required)
  • boardApprovalDate: Date (Optional)
  • stakeholderAcceptanceDate: Date (Optional)
  • grantExpirationDate: Date (Optional)
  • isoNsoSplit: Boolean (Optional)
  • stockOptionType: String (Optional)
  • quantity: Decimal (Required)
  • outstandingQuantity: Decimal (Required)
  • vestedQuantity: Decimal (Required)
  • exercisedQuantity: Decimal (Optional)
  • exercisePrice: Decimal (Required)
  • vestingScheduleId: UUID (Foreign Key,

Required)

---

13. Restricted Stock Awards

• RestrictedStockAward
  • id: UUID (Primary Key)
  • issuerId: UUID (Foreign Key, Required)
  • stakeholderId: UUID (Foreign Key, Required)
  • equityIncentivePlanName: String (Optional)
  • shareClassName: String (Optional)
  • issueDate: Date (Required)
  • vestingStartDate: Date (Required)
  • boardApprovalDate: Date (Optional)
  • stakeholderAcceptanceDate: Date (Optional)
  • canceledDate: Date (Optional)
  • quantity: Decimal (Required)
  • vestedQuantity: Decimal (Optional)
  • vestingEvents: JSON (including vestDate, quantity, performanceCondition) (Optional)
  • vestingScheduleId: UUID (Foreign Key, Required)

---

14. SPV (Special Purpose Vehicle)

• SPV

  • SPVID: UUID (Primary Key)
  • Name: String (Required)
  • Purpose: String (Required)
  • CreationDate: Date (Required)
  • Status: Enum (Required) - (e.g., Active, Inactive)
  • ParentCompanyID: UUID (Foreign Key, Required)
  • ComplianceStatus: Enum (Required) - (e.g., Compliant, Non-Compliant)
  • ClosureStatus: Enum (Optional) - (e.g., Initiated, Disbursed, CounterSigned, Approved)
  • Disbursements: Array of UUID (disbursementId) (Optional)
  • FundDealAdjustments: Array of UUID (adjustmentId) (Optional)

• Investment

  • InvestmentID: UUID (Primary Key)
  • SPVID: UUID (Foreign Key, Required)
  • InvestorID: UUID (Foreign Key, Required)
  • Amount: Decimal (Required)
  • Date: Date (Required)
  • OwnershipPercentage: Decimal (Required)
  • CurrentValue: Decimal (Required)

• SPV Financial Report

  • ReportID: UUID (Primary Key)
  • SPVID: UUID (Foreign Key, Required)
  • Type: Enum (Required) - (e.g., Balance Sheet, Income Statement, Cash Flow Statement)
  • Data: JSON (Required)
  • Timestamp: Date (Required)

• Compliance Check

  • CheckID: UUID (Primary Key)
  • SPVID: UUID (Foreign Key, Required)
  • RegulationType: Enum (Required)
  • Status: Enum (Required) - (e.g., Compliant, Non-Compliant)
  • Details: String (Optional)
  • Timestamp: Date (Required)

• SPV Asset

  • AssetID: UUID (Primary Key)
  • SPVID: UUID (Foreign Key, Required)
  • Type: Enum (Required) - (e.g., Real Estate, Financial Instrument)
  • Value: Decimal (Required)
  • Description: String (Required)
  • AcquisitionDate: Date (Required)

• Disbursement

  • DisbursementID: UUID (Primary Key)
  • SPVID: UUID (Foreign Key, Required)
  • Amount: Decimal (Required)
  • Date: Date (Required)
  • Status: Enum (Required) - (e.g., Pending, Completed, Adjusted)

• Adjustment

  • AdjustmentID: UUID (Primary Key)
  • SPVID: UUID (Foreign Key, Required)
  • Amount: Decimal (Required)
  • Date: Date (Required)
  • Description: String (Optional)

---

15. Document Management

• Document

  • DocumentID: UUID (Primary Key)
  • Name: String (Required)
  • Metadata: JSON (Optional)
  • UploadedBy: UUID (Foreign Key, Required)
  • Path: String (Required)
  • Title: String (Required)
  • Content: String (Required)
  • DocumentType: Enum (Required) - (e.g., Legal, Financial)
  • FileType: Enum (Required) - (e.g., PDF, DOCX)
  • Versioning: String (Optional)
  • AccessControl: JSON (Optional)
  • LegalSignificance: String (Optional)

• DocumentEmbedding

  • EmbeddingID: UUID (Primary Key)
  • DocumentID: UUID (Foreign Key, Required)
  • Embedding: Array of Decimal (Required)
  • EmbeddingType: Enum (Required)
  • EmbeddingVersion: String (Optional)
  • CreatedAt: Date (Default: Current Date)
  • UpdatedAt: Date (Default: Current Date)

• DocumentAccess

  • AccessID: UUID (Primary Key)
  • AccessLevel: Enum (Required) - (e.g., Read, Write, Admin)
  • RelatedDocument: UUID (Foreign Key, Required)
  • UserID: UUID (Foreign Key, Required)
  • Permissions: JSON (Optional)

• DocumentRepository

  • RepositoryID: UUID (Primary Key)
  • Documents: Array of UUID (documentId) (Required)
  • RepositoryType: Enum (Required) - (e.g., Legal, Financial)
  • AccessControl: JSON (Optional)

---

16. Activity Tracking

• Activity
  • ActivityID: UUID (Primary Key)
  • ActivityType: Enum (Required) - (e.g., Document Upload, Stakeholder Update)
  • Timestamp: Date (Required)
  • UserInvolved: UUID (Foreign Key, Required)
  • ChangesMade: String (Optional)
  • RelatedObjects: Array of UUID (Optional)

---

17. User Management

• User

  • UserID: UUID (Primary Key)
  • Username: String (Required)
  • Email: String (Required)
  • UserRoles: Array of Enum (Required) - (e.g., Admin, Editor, Viewer)
  • Permissions: JSON (Required)
  • AuditLogs: Array of UUID (activityId) (Optional)
  • AuthenticationMethods: JSON (Optional)

• Notification

  • NotificationID: UUID (Primary Key)
  • NotificationType: Enum (Required) - (e.g., System, User-Generated)
  • Timestamp: Date (Required)
  • RelatedObject: UUID (Foreign Key, Optional)
  • UserInvolved: UUID (Foreign Key, Required)

---

18. Financial Tools

• TaxCalculator

  • CalculationID: UUID (Primary Key)
  • SaleScenario: JSON (Required)
  • ShareClassInvolved: UUID (Foreign Key, Required)
  • SaleAmount: Decimal (Required)
  • TaxRate: Decimal (Required)
  • TaxImplication: JSON (Required)
  • CalculatedTax: Decimal (Required)
  • TaxDueDate: Date (Required)

• EquitySimulator

  • SimulationID: UUID (Primary Key)
  • ScenarioDetails: JSON (Required)
  • EquityChangeType: Enum (Required) - (e.g., Dilution, Conversion)
  • StakeholdersAffected: Array of UUID (stakeholderId) (Required)
  • ProjectedEquityValue: Decimal (Required)
  • PredictedOutcome: JSON (Required)
  • OutcomeDescription: String (Optional)
  • ImpactOnStakeholders: Array of UUID (Optional)

• FinancialReporting

  • ReportID: UUID (Primary Key)
  • Type: Enum (Required) - (e.g., Annual, Quarterly)
  • Data: JSON (Required)
  • TotalRevenue: Decimal (Required)
  • TotalExpenses: Decimal (Required)
  • NetIncome: Decimal (Required)
  • EquitySummary: Array of UUID (shareClassId) (Optional)
  • Timestamp: Date (Required)

---

19. Communication

• Communication
  • CommunicationID: UUID (Primary Key)
  • MessageType: Enum (Required) - (e.g., Email, SMS, System Notification)
  • Sender: UUID (Foreign Key, Required)
  • Recipient: UUID (Foreign Key, Required)
  • Timestamp: Date (Required)
  • Content: String (Required)

---

20. Open Cap Table

• OpenCapTable
  • id: UUID (Primary Key)
  • state: String (Required)
  • createTime: DateTime (Required)
  • completeTime: DateTime (Optional)
  • details: JSON (including id, createTime, metadata) (Optional)

---

This comprehensive data model integrates all the functionalities from Open Cap Stack 1.5 and 2.0, ensuring that all aspects, including SPVs, certificates, convertible notes, stakeholders, and financial reporting, are fully supported.