portfolio account aggregated statistics

[rabbitz]

• Prd & Design

Magickbase/visual-style-guide#36

• Sync account between frontend and backend

ckb-js/kuai#464 (comment)

• Wallet connect

Magickbase/neuron-public-issues#144

• verify signature

https://github.com/ckb-js/lumos/blob/develop/packages/hd/src/key.ts#L27-L30

---

• portfolio account connect #447
• portfolio sync addresses #448
• portfolio transactions #449

[rabbitz]

User sign in

1. route definition

• Url: /api/v2/portfolio/sessions
• Method: POST

2. request definition

address [string]
message [string]
signature [string]
pub_key [string]

3. response definition

jwt [string]

Update user name

1. route definition

• Url: /api/v2/portfolio/user
• Method: PUT
• Response: -

2. request definition

name [string]

User portfolio statistics

1. route definition

• Url: /api/v2/portfolio/statistics
• Method: GET

2. request definition

address [string] # latest_address_in_frontend

3. response definition

capacity [decimal]
deposit_compensation [decimal]
occupied_capacity [decimal]
dao_deposit [decimal]

Sync portfolio addresses

1. route definition

• Url: /api/v2/portfolio/sync_addresses
• Method: POST
• Response: -

2. request definition

addresses [][string]  # addresses_diff_between_frontend_and_backend

---

CREATE TABLE
  `users`(
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT 'user id, primary key',
    `uuid` VARCHAR(36) NOT NULL DEFAULT '' COMMENT 'user uuid',
    `identifier` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'user identifier',
    `nonce` INT unsigned NOT NULL DEFAULT 0 COMMENT 'user nonce',
    `name` VARCHAR(255) DEFAULT '' COMMENT 'user name',
    `create_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created at',
    `update_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'updated at',
    PRIMARY KEY(`id`),
    CONSTRAINT uc_identifier_on_users UNIQUE(`identifier`),
    CONSTRAINT uc_uuid_on_users UNIQUE(`uuid`)
  );

CREATE TABLE
  `portfolios`(
    `user_id` BIGINT NOT NULL DEFAULT 0 COMMENT 'user id',
    `address_id` BIGINT NOT NULL DEFAULT 0 COMMENT 'address id',
    UNIQUE KEY `uc_user_id_address_id_on_portfolios`(`user_id`, `address_id`)
  );

CREATE TABLE
  `portfolio_statistics`(
    `user_id` BIGINT NOT NULL DEFAULT 0,
    `capacity` DECIMAL(30, 0) UNSIGNED NOT NULL DEFAULT 0,
    `occupied_capacity` DECIMAL(30, 0) UNSIGNED NOT NULL DEFAULT 0,
    `dao_deposit` DECIMAL(30, 0) UNSIGNED NOT NULL DEFAULT 0,
    `interest` DECIMAL(30, 0) UNSIGNED NOT NULL DEFAULT 0,
    `unclaimed_compensation` DECIMAL(30, 0) UNSIGNED NOT NULL DEFAULT 0,
    UNIQUE KEY `uc_user_id_address_id_on_portfolios`(`user_id`, `address_id`)
  );