station & treasury 4

Tables (5)

DaoInfo (dao 기본 정보)

  • nile dao id (Key) — Primary key — NOT NULL
  • dao id (Field13)
  • dao name (Field)
  • dt name (Field4)
  • gt name (Field5)
  • dt ticker (Field6)
  • gt ticker (Field7)
  • dt address (Field11)
  • gt address (Field12)
  • total dt (Field8)
  • total participants (Field9)
  • status (Field10)
  • initial fund (Field15)
  • reward (Field2)

StationInfo (Station 모집 별 활동 내역 집계 정보)

  • reopenId (Key) — Primary key — NOT NULL
  • nile dao id (Key2) — Foreign key → DaoInfo.nile dao id — NOT NULL
  • startAt (Field)
  • endAt (Field2)
  • unit (Field3)
  • min target amount (Field4)
  • total target amount (Field5)
  • min participation amount (Field6)
  • max participation amount (Field7)
  • increment (Field8)
  • total amount (Field9)
  • total participants (Field10)
  • status (Field11)

StationLog (Station 모집 별 참여자 log)

  • tx hash (Key) — Primary key — NOT NULL
  • reopenId (Key2) — Foreign key → StationInfo.reopenId — NOT NULL
  • nile dao id (Key22) — db에서 활용하는 station의 uuid — Foreign key → StationInfo.nile dao id — NOT NULL
  • wallet address (Field)
  • type (Field10)
  • nickname (Field6)
  • profile image (Field7)
  • value (Field11)
  • greeting (Field9) — nullable

TreasuryHistory (Treasury activity 집계 정보)

  • nile dao id (Key) — Foreign key → DaoInfo.nile dao id — NOT NULL
  • unit (Field)
  • balance (Field2)
  • total deposit (Field3)
  • total withdrawal (Field4)

TreasuryLog (Treasury activity 내역 정보)

  • nile dao id (Key) — Foreign key → DaoInfo.nile dao id — NOT NULL
  • unit (Field)
  • flow (Field2)
  • value (Field3)
  • from (Field4)
  • to (Field5)