@startuml

/'
' ****************
' *** Entities ***
' ****************
'/

class AgreementDocument {
  id: Int
  title: Varchar
  description: Text
  pages: Int
  templateId: Varchar
  internalTitle: Varchar
}

class AgreementEnvelope {
  id: Int
  signed: TinyInt
  envelopeId: Varchar
  lastChecked: BigInt
}

class AgreementToSign {
  id: Int
  userId: Int
  documentId: Int
  envelopeId: Int
}

class AllowedEmail {
  id: Int
  email: Varchar
  isPattern: TinyInt
}

class ConsultationRequester {
  id: Int
  status: EnumOf(open, closed, in progress)
  investmentId: Int
  userId: Int
}

class Disclosure {
  id: Int
  value: Text
  slug: TinyText
  investmentId: Int
}

class DocumentCategory {
  id: Int
  name: Varchar
  order: Int
  investmentId: Int
  toggled: TinyInt
  highlighted: TinyInt
}

class Email {
  id: Int
  address: Varchar
  active: TinyInt
}

class Feedback {
  id: Int
  content: LongText
}

class Follower {
  id: Int
  firstname: Varchar
  lastname: Varchar
  country: Varchar
  email: Varchar
}

class Identification {
  id: Int
  sessionId: Varchar
  result: Varchar
  time: Varchar
  phone: Varchar
  email: Varchar
  firstName: Varchar
  lastName: Varchar
  birthdate: Varchar
  birthplace: Varchar
  nationality: Varchar
  gender: Varchar
  street: Varchar
  streetNumber: Varchar
  city: Varchar
  postCode: Varchar
  country: Varchar
  idType: Varchar
  idNumber: Varchar
  idExpiration: Varchar
  idIssueDate: Varchar
  idIssuedBy: Varchar
  idCountry: Varchar
  idFront: Varchar
  idBack: Varchar
  reason: Varchar
  rawDocument: Text
  isActive: TinyInt
  isPending: TinyInt
  userId: Int
}

class Investment {
  id: Int
  name: Int
  description: Text
  details: Text
  state: EnumOf(open, closed, upcoming, pipeline)
  specificationId: Int
  enabled: TinyInt
  allocation: Int
  fundraisedAmount: Int
  hidden: TinyInt
  fundraisingStatus: EnumOf(open, closed)
  feederVehicle: Text
  s3folder: Varchar
  realizedGmm: Float
  realizedIrr: Float
}

class InvestmentAgreement {
  id: Int
  investmentId: Int
  documentInt: Int
}

class InvestmentConsent {
  id: Int
  required: TinyInt
  title: Text
  type: Varchar
  investmentId: Int
}

class InvestmentDocument {
  id: Int
  displayName: Varchar
  fileName: Varchar
  categoryId: Int
  investmentId: Int
  subscribersOnly: TinyInt
}

class InvestmentSpecification {
  id: Int
  assetClass: Varchar
  targetGrossIR: Varchar
  targetSize: Varchar
  targetGrossMM: Varchar
  geographies: Varchar
  minCommitment: Int
  IndustryFocus: Varchar
  description: Text
  capitalCalled: Float
  currency: Varchar
  closingDate: Varchar
  mostRecentClosing: Varchar
  totalIrrRealized: Varchar
  totalMoneyMultipleRealized: Varchar
  totalCapitalDeployed: Varchar
}

class InvestmentsFollower {
  id: Int
  firstname: Varchar
  lastName: Varchar
  country: Varchar
  email: Varchar
  createdAt: DateTime
  investmentState: EnumOf(open, closed, upcoming, pipeline)
  buttonText: TinyText
  investmentId: Int
  userId: Int
}

class InvestorProfile {
  id: Int
  city: Varchar
  country: Varchar
  postalCode: Varchar
  birthDate: Varchar
  taxIdNumber: Varchar
  address: Varchar
  phone: Varchar
  email: Varchar
  fullname: Varchar
  bankLocation: Varchar
  bankName: Varchar
  iban: Varchar
  nationality: Varchar
  passportNationality: Varchar
  passportNumber: Varchar
  swiftCode: Varchar
  taxResidence: Varchar
  investorType: EnumOf(professional, semi-professional)
  otherEmails: Text
  birthCity: Varchar
  birthCountry: Varchar
}

class Item {
  id: String
  order: Int
  label: Varchar
  value: Varchar
  investmentId: Int
}

class Prospect {
  id: Int
  firstname: Varchar
  lastName: Varchar
  country: Varchar
  city: Varchar
  postalCode: Varchar
  birthDate: Varchar
  bankName: Varchar
  iban: Varchar
  token: Varchar
  onboarded: TinyInt
  phone: Varchar
  taxId: Varchar
  taxResidence: Varchar
  address: Varchar
  email: Varchar
  companyName: Varchar
  documentType: Varchar
  documentNationality: Varchar
  documentNumber Varchar
  otherEmails Text
  birthCity: Varchar
  birthCountry: Varchar
  emailSent: TinyInt

}

class ProspectSubscription {
  id: Int
  commitment: Int
  investmentId: Int
  prospectId: Int
  commitmentDate: DateTime
}

class Questionnaire {
  id: Int
  content: LongText
}

class Subscription {
  id: Int
  investmentId: Int
  userId: Int
  confirmed: TinyInt
  commitment: BigInt
  feedbackId: Int
  approvedAt: DateTime
  documentsSigned: TinyInt
  isCompany: TinyInt
  approvedById: Int
  isAllocationRequested: TinyInt
  documentsSignedEmailSent: TinyInt
  investorInformation: Text
  country: Varchar
}

class SubscriptionConsent {
  id: Int
  checkedAt: DateTime
  subscriptionId: Int
  consentId: Int
}

class SubscriptionDocument {
  id: Int
  displayName: Varchar
  fileName: Varchar
  order: Int
  categoryId: Int
  subscriptionId: Int
}

class Tab {
  id: Int
  name: Varchar
  slug: TinyInt
  order: Int
  data: Json
  sections: Text
  investmentId: Int
}

class User {
  id: Int
  firstname: Varchar
  lastname: Varchar
  companyName: Varchar
  password: Varchar
  verified: Int
  emailId: Int
  questionnaireId: Int
  passwordChangeRequestTimestamp: BigInt
  passwordChanged: TinyInt
  investorProfileId: Int
  loginAttempts: TinyInt
  country: Varchar
  roles: Text
  terms: TinyInt
  nda: TinyInt
  note: MediumText
  suitabilityChecked: TinyInt
  isTestUser: TinyInt
  confirmationsSent: TinyInt
  allocationRemaindersSent: TinyInt
  profileCompletedMailSent: TinyInt
  isAccredited: TinyInt
}

/'
 ' ****************************************************************************************
 '/

/'
 ' *****************
 ' *** Relations ***
 ' *****************
 '/


/'
 ' AgreementDocument
 '/


/'
 ' AgreementEnvelope
 '/

AgreementEnvelope "1" *-- "1" User:> uses
AgreementEnvelope "1" *-- "1" Investment:> uses

/'
 ' AgreementToSign
 '/

/'
 ' AllowedEmail
 '/

/'
 ' ConsultationRequester
 '/

ConsultationRequester "1" *-- "1" Investment:> uses
ConsultationRequester "1" *-- "1" User:> uses

/'
 ' Disclosure
 '/

/'
 ' DocumentCategory
 '/

DocumentCategory "1" o-- "1..n" InvestmentDocument:> is composed of
DocumentCategory "1" o-- "1..n" SubscriptionDocument:> is composed of

/'
 ' Email
 '/

/'
 ' Feedback
 '/

/'
 ' Follower
 '/

/'
 ' Identification
 '/

/'
 ' Investment
 '/

Investment "1" o-- "1..n" InvestmentAgreement:> has
Investment "1" *-- "1" Disclosure:> uses
Investment "1" o-- "1..n" DocumentCategory:> is composed of
Investment "1" o-- "1..n" InvestmentConsent:> is composed of
Investment "1" o-- "1..n" InvestmentDocument:> is composed of
Investment "1" *-- "1" InvestmentSpecification:> has (add cascade to be (is composed of))
Investment "1" o-- "1..n" InvestmentDocument:> has
Investment "1" o-- "1..n" InvestmentsFollower:> is composed of
Investment "1" o-- "1..n" Item:> has (add cascade to be (is composed of))
Investment "1" o-- "1..n" ProspectSubscription:> has
Investment "1" o-- "1..n" Subscription:> has
Investment "1" o-- "1..n" Tab:> has (add cascade to be (is composed of))

/'
 ' InvestmentAgreement
 '/

/'
 ' InvestmentConsent
 '/

/'
 ' InvestmentDocument
 '/

/'
 ' InvestorProfile
 '/

/'
 ' Item
 '/

/'
 ' Prospect
 '/

Prospect "1" o-- "1..n" ProspectSubscription:> has (add cascade to be (is composed of))

/'
 ' ProspectSubscription
 '/

/'
 ' Questionnaire
 '/

/'
 ' Subscription
 '/

Subscription "1" o-- "1" Feedback:> is composed of
Subscription "1" o-- "1..n" SubscriptionConsent:> is composed of
Subscription "1" o-- "1..n" SubscriptionDocument:> has

/'
 ' SubscriptionConsent
 '/

/'
 ' SubscriptionDocument
 '/

/'
 ' Tab
 '/

/'
 ' User
 '/

User "1" o-- "1..n" Identification:> has
User "1" o-- "1..n" Subscription:> has

@enduml