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)