[METERING] Create User Schema in DB

[tchardin]

• [x] Create a new table for user accounts, the user object should look like:

  {
  "id": "UUID",
  "email": "joe@company.com",
  "integrations": [
  {
  "id": "UUID",
  "user_id": "UUID",
  "name": "My awesome integration",
  "allow_list": ["company.com", "bucket.company.com"],
  "status": "active",
  "client_key": "jjdwekjdkwe"
  }
  ],
  "usage": [{
      "integration_id": "UUID",
  "date": "datestring",
  "requests": 100,
  "bandwidth": 300,
  }]
  }

• [x] Make sure the db has public endpoint with auth credentials for Subvisual
• [x] Use staging environment

[tchardin]

Subvisual have DB access and the schema but facing issues connecting.

[guanzo]

Gah. We either need to whitelist their IP or give them SSH tunnel access through our bastion host. Waiting for their response.

[guanzo]

Done!