reventures

Tables (7)

Fund (투자조합)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • costPerShare (Field2) — Long
  • totalShare (Field3) — Long
  • minimumShare (Field4) — Long
  • totalMember (Field5) — Long
  • startDate (Field6) — LocalDate
  • payDate (Field7) — LocalDate
  • recommenderName (Field8) — String?
  • groupName (Field9) — String?
  • status (Field10) — FundStatus
  • isFunding (Field11) — Boolean
  • remainingCost (Field12) — Long
  • remainingStocks (Field13) — Long
  • currentMember (Field14) — Long
  • finalDate (Field15) — LocalDate?
  • returnRate (Field16) — Long?

FundGroup (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • fundId (Field)
  • groupId (Field2) — Long

LP (조합원)

  • id (Key) — Long — Primary key — NOT NULL
  • fundId (Key2) — Long — Foreign key → Fund.id — NOT NULL
  • userId (Key3) — Long — Foreign key → User.id — NOT NULL
  • stockCounts (Field3) — Long
  • cost (Field4) — Long
  • depositAt (Field5) — LocalDateTime?

LpDocument (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • id (Key2) — Long — Foreign key → LP.id — NOT NULL
  • fundId (Key22) — Long — Foreign key → LP.fundId — NOT NULL
  • userId (Key3) — Long — Foreign key → LP.userId — NOT NULL

Notification (알림)

  • id (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → User.id — NOT NULL
  • content (Field2) — String
  • title (Field3) — String
  • checsk (Field) — Boolean

User (사용자)

  • id (Key) — Long — Primary key — NOT NULL
  • stringId (Field) — String
  • password (Field3) — String
  • lastLoggedln (Field2) — LocalDateTime

UserInfo (사용자정보)

  • id (PK) — Long — Primary key — NOT NULL
  • userId (FK) — Long — Foreign key → User.id — NOT NULL
  • name (Field) — String
  • phone (Field2) — String
  • email (Field3) — String
  • recommender (Field5) — String?
  • workplace (Field6) — String?
  • businessCard (Field7) — String?