ekyc

Electronic KYC process with uploading ID document using OAuth 2.1 (experimental)
Log | Files | Refs | README | LICENSE

20240619101025_create_iddocument.ts (1078B)

      1 import {
      2   AbstractMigration,
      3   ClientPostgreSQL,
      4   Info,
      5 } from "https://deno.land/x/nessie@2.0.11/mod.ts";
      6 
      7 export default class extends AbstractMigration<ClientPostgreSQL> {
      8   /** Runs on migrate */
      9   async up(_info: Info): Promise<void> {
     10     await this.client.queryArray`create table "id_document" (
     11             "uuid" uuid not null,
     12             "firstName" varchar null,
     13             "lastName" varchar null,
     14             "birthDate" timestamp null,
     15             "sex" varchar null,
     16             "nationality" varchar null,
     17             "country" varchar null,
     18             "state" varchar not null,
     19             "back" varchar null,
     20             "front" varchar null,
     21             "faceLeft" varchar null,
     22             "faceFront" varchar null,
     23             "faceRight" varchar null,
     24             "admin" uuid null,
     25             "version" int4 not null default 0,
     26             constraint id_document_pk primary key("uuid")
     27         );`;
     28   }
     29 
     30   /** Runs on rollback */
     31   async down(_info: Info): Promise<void> {
     32     await this.client.queryArray`drop table "id_document" cascade;`;
     33   }
     34 }