Files
ca/Documentation/api/internal_db_schema.md
2026-10-31 05:36:03 -05:00

53 KiB

schema

import "github.com/effective-security/trustyca/internal/db/schema"

Package schema exposes generated table and column metadata to query builders.

make gen-sql-schema generates schema.gen.go and model/model.gen.go from a recreated local database; typesmap.yaml controls conversions. init warms the column lists of the generated tables, which xdb caches without a lock.

Index

Variables

APIKey provides column definitions for table 'trustyca.apikey'. Primary key: id Indexes:

apikey_key: UNIQUE [key]
apikey_pkey: PRIMARY UNIQUE [id]
idx_apikey_org_project: [org_id,project_id]
var APIKey = struct {
    Table     *xdbschema.TableInfo
    ID        xdbschema.Column // id bigint
    OrgID     xdbschema.Column // org_id bigint
    ProjectID xdbschema.Column // project_id bigint
    Key       xdbschema.Column // key character varying
    Secret    xdbschema.Column // secret character varying
    Label     xdbschema.Column // label character varying
    Scopes    xdbschema.Column // scopes ARRAY
    Metadata  xdbschema.Column // metadata jsonb
    Status    xdbschema.Column // status integer
    CreatedAt xdbschema.Column // created_at timestamp with time zone
    ExpiresAt xdbschema.Column // expires_at timestamp with time zone
    UsedAt    xdbschema.Column // used_at timestamp with time zone
    UsedCount xdbschema.Column // used_count integer
}{
    Table:     &APIKeyTableInfo,
    ID:        xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:     xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: false},
    ProjectID: xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    Key:       xdbschema.Column{Name: "key", Position: 4, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 128},
    Secret:    xdbschema.Column{Name: "secret", Position: 5, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 128},
    Label:     xdbschema.Column{Name: "label", Position: 6, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 260},
    Scopes:    xdbschema.Column{Name: "scopes", Position: 7, Type: "ARRAY", UdtType: "_varchar", Nullable: false},
    Metadata:  xdbschema.Column{Name: "metadata", Position: 8, Type: "jsonb", UdtType: "jsonb", Nullable: true},
    Status:    xdbschema.Column{Name: "status", Position: 9, Type: "integer", UdtType: "int4", Nullable: false},
    CreatedAt: xdbschema.Column{Name: "created_at", Position: 10, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    ExpiresAt: xdbschema.Column{Name: "expires_at", Position: 11, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
    UsedAt:    xdbschema.Column{Name: "used_at", Position: 12, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
    UsedCount: xdbschema.Column{Name: "used_count", Position: 13, Type: "integer", UdtType: "int4", Nullable: false},
}

APIKeyTableInfo provides table info for 'apikey'

var APIKeyTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.apikey",
    Schema:     "trustyca",
    Name:       "apikey",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "project_id", "key", "secret", "label", "scopes", "metadata", "status", "created_at", "expires_at", "used_at", "used_count"},
    Indexes:    []string{"apikey_key", "apikey_pkey", "idx_apikey_org_project"},
    Dialect:    xsql.Postgres,
}

Certificate provides column definitions for table 'trustyca.certificate'. Primary key: id Indexes:

certificate_pkey: PRIMARY UNIQUE [id]
idx_certificate_notafter: [not_after]
idx_certificate_org_id_desc: [id,org_id]
idx_certificate_org_ikid_id_desc: [id,org_id,ikid]
idx_certificate_org_project_id_desc: [org_id,project_id,id]
idx_certificate_org_project_notafter: [project_id,org_id,not_after]
idx_certificate_org_project_status_notafter: [status,org_id,project_id,not_after]
idx_certificate_skid: [skid]
unique_certificate_ikid_serial: UNIQUE [serial_number,ikid]
unique_certificate_sha256: UNIQUE [sha256]
var Certificate = struct {
    Table        *xdbschema.TableInfo
    ID           xdbschema.Column // id bigint
    OrgID        xdbschema.Column // org_id bigint
    ProjectID    xdbschema.Column // project_id bigint
    Skid         xdbschema.Column // skid character varying
    Ikid         xdbschema.Column // ikid character varying
    SerialNumber xdbschema.Column // serial_number character varying
    NotBefore    xdbschema.Column // not_before timestamp with time zone
    NotAfter     xdbschema.Column // not_after timestamp with time zone
    Subject      xdbschema.Column // subject character varying
    Issuer       xdbschema.Column // issuer character varying
    Sha256       xdbschema.Column // sha256 character varying
    Profile      xdbschema.Column // profile character varying
    Label        xdbschema.Column // label character varying
    Locations    xdbschema.Column // locations ARRAY
    Metadata     xdbschema.Column // metadata jsonb
    Pem          xdbschema.Column // pem text
    IssuersPem   xdbschema.Column // issuers_pem text
    Status       xdbschema.Column // status integer
    CreatedAt    xdbschema.Column // created_at timestamp with time zone
}{
    Table:        &CertificateTableInfo,
    ID:           xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:        xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: true},
    ProjectID:    xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    Skid:         xdbschema.Column{Name: "skid", Position: 4, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Ikid:         xdbschema.Column{Name: "ikid", Position: 5, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    SerialNumber: xdbschema.Column{Name: "serial_number", Position: 6, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    NotBefore:    xdbschema.Column{Name: "not_before", Position: 7, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    NotAfter:     xdbschema.Column{Name: "not_after", Position: 8, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    Subject:      xdbschema.Column{Name: "subject", Position: 9, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 260},
    Issuer:       xdbschema.Column{Name: "issuer", Position: 10, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 260},
    Sha256:       xdbschema.Column{Name: "sha256", Position: 11, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Profile:      xdbschema.Column{Name: "profile", Position: 12, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Label:        xdbschema.Column{Name: "label", Position: 13, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 260},
    Locations:    xdbschema.Column{Name: "locations", Position: 14, Type: "ARRAY", UdtType: "_varchar", Nullable: false},
    Metadata:     xdbschema.Column{Name: "metadata", Position: 15, Type: "jsonb", UdtType: "jsonb", Nullable: false},
    Pem:          xdbschema.Column{Name: "pem", Position: 16, Type: "text", UdtType: "text", Nullable: false},
    IssuersPem:   xdbschema.Column{Name: "issuers_pem", Position: 17, Type: "text", UdtType: "text", Nullable: false},
    Status:       xdbschema.Column{Name: "status", Position: 18, Type: "integer", UdtType: "int4", Nullable: false},
    CreatedAt:    xdbschema.Column{Name: "created_at", Position: 19, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
}

CertificateProfile provides column definitions for table 'trustyca.certificate_profile'. Primary key: id Indexes:

certificate_profile_pkey: PRIMARY UNIQUE [id]
idx_certificate_profile_org_issuer: [org_id,issuer_label]
unique_certificate_profile_org_project_label: UNIQUE [org_id,project_id,label]
var CertificateProfile = struct {
    Table       *xdbschema.TableInfo
    ID          xdbschema.Column // id bigint
    OrgID       xdbschema.Column // org_id bigint
    ProjectID   xdbschema.Column // project_id bigint
    Label       xdbschema.Column // label character varying
    IssuerLabel xdbschema.Column // issuer_label character varying
    Status      xdbschema.Column // status integer
    Config      xdbschema.Column // config jsonb
    CreatedAt   xdbschema.Column // created_at timestamp with time zone
    UpdatedAt   xdbschema.Column // updated_at timestamp with time zone
}{
    Table:       &CertificateProfileTableInfo,
    ID:          xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:       xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: true},
    ProjectID:   xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    Label:       xdbschema.Column{Name: "label", Position: 4, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    IssuerLabel: xdbschema.Column{Name: "issuer_label", Position: 5, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Status:      xdbschema.Column{Name: "status", Position: 6, Type: "integer", UdtType: "int4", Nullable: false},
    Config:      xdbschema.Column{Name: "config", Position: 7, Type: "jsonb", UdtType: "jsonb", Nullable: false},
    CreatedAt:   xdbschema.Column{Name: "created_at", Position: 8, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    UpdatedAt:   xdbschema.Column{Name: "updated_at", Position: 9, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
}

CertificateProfileTableInfo provides table info for 'certificate_profile'

var CertificateProfileTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.certificate_profile",
    Schema:     "trustyca",
    Name:       "certificate_profile",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "project_id", "label", "issuer_label", "status", "config", "created_at", "updated_at"},
    Indexes:    []string{"certificate_profile_pkey", "idx_certificate_profile_org_issuer", "unique_certificate_profile_org_project_label"},
    Dialect:    xsql.Postgres,
}

CertificateTableInfo provides table info for 'certificate'

var CertificateTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.certificate",
    Schema:     "trustyca",
    Name:       "certificate",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "project_id", "skid", "ikid", "serial_number", "not_before", "not_after", "subject", "issuer", "sha256", "profile", "label", "locations", "metadata", "pem", "issuers_pem", "status", "created_at"},
    Indexes:    []string{"certificate_pkey", "idx_certificate_notafter", "idx_certificate_org_id_desc", "idx_certificate_org_ikid_id_desc", "idx_certificate_org_project_id_desc", "idx_certificate_org_project_notafter", "idx_certificate_org_project_status_notafter", "idx_certificate_skid", "unique_certificate_ikid_serial", "unique_certificate_sha256"},
    Dialect:    xsql.Postgres,
}

Crl provides column definitions for table 'trustyca.crl'. Primary key: id Indexes:

crl_pkey: PRIMARY UNIQUE [id]
idx_crl_next_update: [next_update]
unique_crl_ikid: UNIQUE [ikid]
var Crl = struct {
    Table      *xdbschema.TableInfo
    ID         xdbschema.Column // id bigint
    OrgID      xdbschema.Column // org_id bigint
    ProjectID  xdbschema.Column // project_id bigint
    IssuerID   xdbschema.Column // issuer_id bigint
    Ikid       xdbschema.Column // ikid character varying
    CrlNumber  xdbschema.Column // crl_number bigint
    ThisUpdate xdbschema.Column // this_update timestamp with time zone
    NextUpdate xdbschema.Column // next_update timestamp with time zone
    Issuer     xdbschema.Column // issuer character varying
    Pem        xdbschema.Column // pem text
    Locations  xdbschema.Column // locations ARRAY
    CreatedAt  xdbschema.Column // created_at timestamp with time zone
}{
    Table:      &CrlTableInfo,
    ID:         xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:      xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: true},
    ProjectID:  xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    IssuerID:   xdbschema.Column{Name: "issuer_id", Position: 4, Type: "bigint", UdtType: "int8", Nullable: false},
    Ikid:       xdbschema.Column{Name: "ikid", Position: 5, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    CrlNumber:  xdbschema.Column{Name: "crl_number", Position: 6, Type: "bigint", UdtType: "int8", Nullable: false},
    ThisUpdate: xdbschema.Column{Name: "this_update", Position: 7, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    NextUpdate: xdbschema.Column{Name: "next_update", Position: 8, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    Issuer:     xdbschema.Column{Name: "issuer", Position: 9, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 260},
    Pem:        xdbschema.Column{Name: "pem", Position: 10, Type: "text", UdtType: "text", Nullable: false},
    Locations:  xdbschema.Column{Name: "locations", Position: 11, Type: "ARRAY", UdtType: "_varchar", Nullable: false},
    CreatedAt:  xdbschema.Column{Name: "created_at", Position: 12, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
}

CrlTableInfo provides table info for 'crl'

var CrlTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.crl",
    Schema:     "trustyca",
    Name:       "crl",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "project_id", "issuer_id", "ikid", "crl_number", "this_update", "next_update", "issuer", "pem", "locations", "created_at"},
    Indexes:    []string{"crl_pkey", "idx_crl_next_update", "unique_crl_ikid"},
    Dialect:    xsql.Postgres,
}

Dialect provides Dialect for trustycadb

var Dialect = xsql.Postgres

Event provides column definitions for table 'trustyca.event'. Primary key: id Indexes:

event_pkey: PRIMARY UNIQUE [id]
idx_event_email: [email]
idx_event_org_created_id_desc: [id,org_id,created_at]
idx_event_org_id: [org_id]
idx_event_org_project_created_id_desc: [org_id,id,project_id,created_at]
idx_event_org_ref_id: [org_id,ref_id]
idx_event_type: [type]
var Event = struct {
    Table       *xdbschema.TableInfo
    ID          xdbschema.Column // id bigint
    OrgID       xdbschema.Column // org_id bigint
    ProjectID   xdbschema.Column // project_id bigint
    Type        xdbschema.Column // type integer
    Title       xdbschema.Column // title character varying
    Description xdbschema.Column // description text
    Metadata    xdbschema.Column // metadata jsonb
    ReferenceID xdbschema.Column // ref_id bigint
    Email       xdbschema.Column // email character varying
    Source      xdbschema.Column // source character varying
    CreatedAt   xdbschema.Column // created_at timestamp with time zone
}{
    Table:       &EventTableInfo,
    ID:          xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:       xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: true},
    ProjectID:   xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    Type:        xdbschema.Column{Name: "type", Position: 4, Type: "integer", UdtType: "int4", Nullable: false},
    Title:       xdbschema.Column{Name: "title", Position: 5, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 256},
    Description: xdbschema.Column{Name: "description", Position: 6, Type: "text", UdtType: "text", Nullable: true},
    Metadata:    xdbschema.Column{Name: "metadata", Position: 7, Type: "jsonb", UdtType: "jsonb", Nullable: false},
    ReferenceID: xdbschema.Column{Name: "ref_id", Position: 8, Type: "bigint", UdtType: "int8", Nullable: true},
    Email:       xdbschema.Column{Name: "email", Position: 9, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 160},
    Source:      xdbschema.Column{Name: "source", Position: 10, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 256},
    CreatedAt:   xdbschema.Column{Name: "created_at", Position: 11, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
}

EventTableInfo provides table info for 'event'

var EventTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.event",
    Schema:     "trustyca",
    Name:       "event",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "project_id", "type", "title", "description", "metadata", "ref_id", "email", "source", "created_at"},
    Indexes:    []string{"event_pkey", "idx_event_email", "idx_event_org_created_id_desc", "idx_event_org_id", "idx_event_org_project_created_id_desc", "idx_event_org_ref_id", "idx_event_type"},
    Dialect:    xsql.Postgres,
}

Invite provides column definitions for table 'trustyca.invite'. Primary key: id Indexes:

idx_invite_email: [email]
idx_invite_org_project: [org_id,project_id]
invite_pkey: PRIMARY UNIQUE [id]
unique_invite_org_project_email: UNIQUE [email,org_id,project_id]
var Invite = struct {
    Table     *xdbschema.TableInfo
    ID        xdbschema.Column // id bigint
    OrgID     xdbschema.Column // org_id bigint
    ProjectID xdbschema.Column // project_id bigint
    InviterID xdbschema.Column // inviter_id bigint
    Email     xdbschema.Column // email character varying
    Role      xdbschema.Column // role integer
    CreatedAt xdbschema.Column // created_at timestamp with time zone
    ExpiresAt xdbschema.Column // expires_at timestamp with time zone
}{
    Table:     &InviteTableInfo,
    ID:        xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:     xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: false},
    ProjectID: xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    InviterID: xdbschema.Column{Name: "inviter_id", Position: 4, Type: "bigint", UdtType: "int8", Nullable: false},
    Email:     xdbschema.Column{Name: "email", Position: 5, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 160},
    Role:      xdbschema.Column{Name: "role", Position: 6, Type: "integer", UdtType: "int4", Nullable: false},
    CreatedAt: xdbschema.Column{Name: "created_at", Position: 7, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    ExpiresAt: xdbschema.Column{Name: "expires_at", Position: 8, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
}

InviteTableInfo provides table info for 'invite'

var InviteTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.invite",
    Schema:     "trustyca",
    Name:       "invite",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "project_id", "inviter_id", "email", "role", "created_at", "expires_at"},
    Indexes:    []string{"idx_invite_email", "idx_invite_org_project", "invite_pkey", "unique_invite_org_project_email"},
    Dialect:    xsql.Postgres,
}

Issuer provides column definitions for table 'trustyca.issuer'. Primary key: id Indexes:

idx_issuer_notafter: [not_after]
idx_issuer_org_project_status: [org_id,project_id,status]
idx_issuer_parent: [parent_id]
issuer_pkey: PRIMARY UNIQUE [id]
unique_issuer_org_project_label: UNIQUE [org_id,project_id,label]
unique_issuer_skid: UNIQUE [skid]
var Issuer = struct {
    Table        *xdbschema.TableInfo
    ID           xdbschema.Column // id bigint
    OrgID        xdbschema.Column // org_id bigint
    ProjectID    xdbschema.Column // project_id bigint
    Label        xdbschema.Column // label character varying
    Type         xdbschema.Column // type integer
    Status       xdbschema.Column // status integer
    ParentID     xdbschema.Column // parent_id bigint
    Skid         xdbschema.Column // skid character varying
    Ikid         xdbschema.Column // ikid character varying
    SerialNumber xdbschema.Column // serial_number character varying
    Subject      xdbschema.Column // subject character varying
    Issuer       xdbschema.Column // issuer character varying
    Sha256       xdbschema.Column // sha256 character varying
    NotBefore    xdbschema.Column // not_before timestamp with time zone
    NotAfter     xdbschema.Column // not_after timestamp with time zone
    Pem          xdbschema.Column // pem text
    ChainPem     xdbschema.Column // chain_pem text
    RootPem      xdbschema.Column // root_pem text
    CsrPem       xdbschema.Column // csr_pem text
    KeyProvider  xdbschema.Column // key_provider character varying
    KeyID        xdbschema.Column // key_id character varying
    KeyProtected xdbschema.Column // key_protected text
    Config       xdbschema.Column // config jsonb
    CrlNumber    xdbschema.Column // crl_number bigint
    CreatedAt    xdbschema.Column // created_at timestamp with time zone
    UpdatedAt    xdbschema.Column // updated_at timestamp with time zone
}{
    Table:        &IssuerTableInfo,
    ID:           xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:        xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: true},
    ProjectID:    xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    Label:        xdbschema.Column{Name: "label", Position: 4, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Type:         xdbschema.Column{Name: "type", Position: 5, Type: "integer", UdtType: "int4", Nullable: false},
    Status:       xdbschema.Column{Name: "status", Position: 6, Type: "integer", UdtType: "int4", Nullable: false},
    ParentID:     xdbschema.Column{Name: "parent_id", Position: 7, Type: "bigint", UdtType: "int8", Nullable: true},
    Skid:         xdbschema.Column{Name: "skid", Position: 8, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Ikid:         xdbschema.Column{Name: "ikid", Position: 9, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    SerialNumber: xdbschema.Column{Name: "serial_number", Position: 10, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Subject:      xdbschema.Column{Name: "subject", Position: 11, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 260},
    Issuer:       xdbschema.Column{Name: "issuer", Position: 12, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 260},
    Sha256:       xdbschema.Column{Name: "sha256", Position: 13, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    NotBefore:    xdbschema.Column{Name: "not_before", Position: 14, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
    NotAfter:     xdbschema.Column{Name: "not_after", Position: 15, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
    Pem:          xdbschema.Column{Name: "pem", Position: 16, Type: "text", UdtType: "text", Nullable: false},
    ChainPem:     xdbschema.Column{Name: "chain_pem", Position: 17, Type: "text", UdtType: "text", Nullable: false},
    RootPem:      xdbschema.Column{Name: "root_pem", Position: 18, Type: "text", UdtType: "text", Nullable: false},
    CsrPem:       xdbschema.Column{Name: "csr_pem", Position: 19, Type: "text", UdtType: "text", Nullable: false},
    KeyProvider:  xdbschema.Column{Name: "key_provider", Position: 20, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    KeyID:        xdbschema.Column{Name: "key_id", Position: 21, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 260},
    KeyProtected: xdbschema.Column{Name: "key_protected", Position: 22, Type: "text", UdtType: "text", Nullable: true},
    Config:       xdbschema.Column{Name: "config", Position: 23, Type: "jsonb", UdtType: "jsonb", Nullable: false},
    CrlNumber:    xdbschema.Column{Name: "crl_number", Position: 24, Type: "bigint", UdtType: "int8", Nullable: false},
    CreatedAt:    xdbschema.Column{Name: "created_at", Position: 25, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    UpdatedAt:    xdbschema.Column{Name: "updated_at", Position: 26, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
}

IssuerTableInfo provides table info for 'issuer'

var IssuerTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.issuer",
    Schema:     "trustyca",
    Name:       "issuer",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "project_id", "label", "type", "status", "parent_id", "skid", "ikid", "serial_number", "subject", "issuer", "sha256", "not_before", "not_after", "pem", "chain_pem", "root_pem", "csr_pem", "key_provider", "key_id", "key_protected", "config", "crl_number", "created_at", "updated_at"},
    Indexes:    []string{"idx_issuer_notafter", "idx_issuer_org_project_status", "idx_issuer_parent", "issuer_pkey", "unique_issuer_org_project_label", "unique_issuer_skid"},
    Dialect:    xsql.Postgres,
}

Login provides column definitions for table 'trustyca.login'. Primary key: id Indexes:

idx_login_email: [email]
idx_login_last_at: [last_at]
login_pkey: PRIMARY UNIQUE [id]
unique_login_provider_email: UNIQUE [provider,email]
var Login = struct {
    Table          *xdbschema.TableInfo
    ID             xdbschema.Column // id bigint
    ExternalID     xdbschema.Column // external_id character varying
    Provider       xdbschema.Column // provider integer
    Email          xdbschema.Column // email character varying
    EmailVerified  xdbschema.Column // email_verified boolean
    Name           xdbschema.Column // name character varying
    AccessToken    xdbschema.Column // access_token text
    RefreshToken   xdbschema.Column // refresh_token text
    TokenExpiresAt xdbschema.Column // token_expires_at timestamp with time zone
    Count          xdbschema.Column // count integer
    LastAt         xdbschema.Column // last_at timestamp with time zone
}{
    Table:          &LoginTableInfo,
    ID:             xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    ExternalID:     xdbschema.Column{Name: "external_id", Position: 2, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Provider:       xdbschema.Column{Name: "provider", Position: 3, Type: "integer", UdtType: "int4", Nullable: false},
    Email:          xdbschema.Column{Name: "email", Position: 4, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 160},
    EmailVerified:  xdbschema.Column{Name: "email_verified", Position: 5, Type: "boolean", UdtType: "bool", Nullable: false},
    Name:           xdbschema.Column{Name: "name", Position: 6, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    AccessToken:    xdbschema.Column{Name: "access_token", Position: 7, Type: "text", UdtType: "text", Nullable: false},
    RefreshToken:   xdbschema.Column{Name: "refresh_token", Position: 8, Type: "text", UdtType: "text", Nullable: false},
    TokenExpiresAt: xdbschema.Column{Name: "token_expires_at", Position: 9, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
    Count:          xdbschema.Column{Name: "count", Position: 10, Type: "integer", UdtType: "int4", Nullable: false},
    LastAt:         xdbschema.Column{Name: "last_at", Position: 11, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
}

LoginTableInfo provides table info for 'login'

var LoginTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.login",
    Schema:     "trustyca",
    Name:       "login",
    PrimaryKey: "id",
    Columns:    []string{"id", "external_id", "provider", "email", "email_verified", "name", "access_token", "refresh_token", "token_expires_at", "count", "last_at"},
    Indexes:    []string{"idx_login_email", "idx_login_last_at", "login_pkey", "unique_login_provider_email"},
    Dialect:    xsql.Postgres,
}

Membership provides column definitions for table 'trustyca.membership'. Primary key: id Indexes:

idx_membership_org_project: [org_id,project_id]
idx_membership_user_id: [user_id]
membership_pkey: PRIMARY UNIQUE [id]
unique_membership_org_project_user: UNIQUE [user_id,org_id,project_id]
var Membership = struct {
    Table     *xdbschema.TableInfo
    ID        xdbschema.Column // id bigint
    OrgID     xdbschema.Column // org_id bigint
    ProjectID xdbschema.Column // project_id bigint
    UserID    xdbschema.Column // user_id bigint
    Role      xdbschema.Column // role integer
    CreatedAt xdbschema.Column // created_at timestamp with time zone
}{
    Table:     &MembershipTableInfo,
    ID:        xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:     xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: false},
    ProjectID: xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    UserID:    xdbschema.Column{Name: "user_id", Position: 4, Type: "bigint", UdtType: "int8", Nullable: false},
    Role:      xdbschema.Column{Name: "role", Position: 5, Type: "integer", UdtType: "int4", Nullable: false},
    CreatedAt: xdbschema.Column{Name: "created_at", Position: 6, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
}

MembershipInfo provides column definitions for table 'trustyca.vw_membership_info'.

var MembershipInfo = struct {
    Table        *xdbschema.TableInfo
    ID           xdbschema.Column // id bigint
    OrgID        xdbschema.Column // org_id bigint
    ProjectID    xdbschema.Column // project_id bigint
    OrgAlias     xdbschema.Column // org_alias character varying
    OrgName      xdbschema.Column // org_name character varying
    OrgStatus    xdbschema.Column // org_status integer
    ProjectAlias xdbschema.Column // project_alias character varying
    ProjectName  xdbschema.Column // project_name character varying
    UserID       xdbschema.Column // user_id bigint
    Email        xdbschema.Column // email character varying
    Name         xdbschema.Column // name character varying
    Role         xdbschema.Column // role integer
    CreatedAt    xdbschema.Column // created_at timestamp with time zone
}{
    Table:        &MembershipInfoTableInfo,
    ID:           xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: true},
    OrgID:        xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: true},
    ProjectID:    xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    OrgAlias:     xdbschema.Column{Name: "org_alias", Position: 4, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 32},
    OrgName:      xdbschema.Column{Name: "org_name", Position: 5, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 64},
    OrgStatus:    xdbschema.Column{Name: "org_status", Position: 6, Type: "integer", UdtType: "int4", Nullable: true},
    ProjectAlias: xdbschema.Column{Name: "project_alias", Position: 7, Type: "character varying", UdtType: "varchar", Nullable: true},
    ProjectName:  xdbschema.Column{Name: "project_name", Position: 8, Type: "character varying", UdtType: "varchar", Nullable: true},
    UserID:       xdbschema.Column{Name: "user_id", Position: 9, Type: "bigint", UdtType: "int8", Nullable: true},
    Email:        xdbschema.Column{Name: "email", Position: 10, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 160},
    Name:         xdbschema.Column{Name: "name", Position: 11, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 64},
    Role:         xdbschema.Column{Name: "role", Position: 12, Type: "integer", UdtType: "int4", Nullable: true},
    CreatedAt:    xdbschema.Column{Name: "created_at", Position: 13, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
}

MembershipInfoTableInfo provides table info for 'vw_membership_info'

var MembershipInfoTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.vw_membership_info",
    Schema:     "trustyca",
    Name:       "vw_membership_info",
    PrimaryKey: "",
    Columns:    []string{"id", "org_id", "project_id", "org_alias", "org_name", "org_status", "project_alias", "project_name", "user_id", "email", "name", "role", "created_at"},
    Indexes:    []string{},
    Dialect:    xsql.Postgres,
}

MembershipTableInfo provides table info for 'membership'

var MembershipTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.membership",
    Schema:     "trustyca",
    Name:       "membership",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "project_id", "user_id", "role", "created_at"},
    Indexes:    []string{"idx_membership_org_project", "idx_membership_user_id", "membership_pkey", "unique_membership_org_project_user"},
    Dialect:    xsql.Postgres,
}

Org provides column definitions for table 'trustyca.org'. Primary key: id Indexes:

idx_org_name_id: [id,name]
org_pkey: PRIMARY UNIQUE [id]
unique_org_alias: UNIQUE [alias]
var Org = struct {
    Table       *xdbschema.TableInfo
    ID          xdbschema.Column // id bigint
    Alias       xdbschema.Column // alias character varying
    Name        xdbschema.Column // name character varying
    Description xdbschema.Column // description text
    Status      xdbschema.Column // status integer
    CreatedAt   xdbschema.Column // created_at timestamp with time zone
}{
    Table:       &OrgTableInfo,
    ID:          xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    Alias:       xdbschema.Column{Name: "alias", Position: 2, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 32},
    Name:        xdbschema.Column{Name: "name", Position: 3, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Description: xdbschema.Column{Name: "description", Position: 4, Type: "text", UdtType: "text", Nullable: true},
    Status:      xdbschema.Column{Name: "status", Position: 5, Type: "integer", UdtType: "int4", Nullable: false},
    CreatedAt:   xdbschema.Column{Name: "created_at", Position: 6, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
}

OrgTableInfo provides table info for 'org'

var OrgTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.org",
    Schema:     "trustyca",
    Name:       "org",
    PrimaryKey: "id",
    Columns:    []string{"id", "alias", "name", "description", "status", "created_at"},
    Indexes:    []string{"idx_org_name_id", "org_pkey", "unique_org_alias"},
    Dialect:    xsql.Postgres,
}

Project provides column definitions for table 'trustyca.project'. Primary key: id Indexes:

idx_project_name_id: [name,id]
idx_project_org_status: [org_id,status]
project_pkey: PRIMARY UNIQUE [id]
unique_project_org_alias: UNIQUE [alias,org_id]
unique_project_org_id: UNIQUE [org_id,id]
var Project = struct {
    Table       *xdbschema.TableInfo
    ID          xdbschema.Column // id bigint
    OrgID       xdbschema.Column // org_id bigint
    Alias       xdbschema.Column // alias character varying
    Name        xdbschema.Column // name character varying
    Description xdbschema.Column // description text
    Status      xdbschema.Column // status integer
    CreatedAt   xdbschema.Column // created_at timestamp with time zone
    UpdatedAt   xdbschema.Column // updated_at timestamp with time zone
}{
    Table:       &ProjectTableInfo,
    ID:          xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:       xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: false},
    Alias:       xdbschema.Column{Name: "alias", Position: 3, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Name:        xdbschema.Column{Name: "name", Position: 4, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Description: xdbschema.Column{Name: "description", Position: 5, Type: "text", UdtType: "text", Nullable: true},
    Status:      xdbschema.Column{Name: "status", Position: 6, Type: "integer", UdtType: "int4", Nullable: false},
    CreatedAt:   xdbschema.Column{Name: "created_at", Position: 7, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    UpdatedAt:   xdbschema.Column{Name: "updated_at", Position: 8, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
}

ProjectTableInfo provides table info for 'project'

var ProjectTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.project",
    Schema:     "trustyca",
    Name:       "project",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "alias", "name", "description", "status", "created_at", "updated_at"},
    Indexes:    []string{"idx_project_name_id", "idx_project_org_status", "project_pkey", "unique_project_org_alias", "unique_project_org_id"},
    Dialect:    xsql.Postgres,
}

Revoked provides column definitions for table 'trustyca.revoked'. Primary key: id Indexes:

idx_revoked_ikid_notafter: [ikid,not_after]
idx_revoked_ikid_serial: UNIQUE [ikid,serial_number]
idx_revoked_org_project_id_desc: [id,org_id,project_id]
revoked_pkey: PRIMARY UNIQUE [id]
unique_revoked_certificate: UNIQUE [certificate_id]
var Revoked = struct {
    Table         *xdbschema.TableInfo
    ID            xdbschema.Column // id bigint
    OrgID         xdbschema.Column // org_id bigint
    ProjectID     xdbschema.Column // project_id bigint
    CertificateID xdbschema.Column // certificate_id bigint
    Ikid          xdbschema.Column // ikid character varying
    SerialNumber  xdbschema.Column // serial_number character varying
    NotAfter      xdbschema.Column // not_after timestamp with time zone
    RevokedAt     xdbschema.Column // revoked_at timestamp with time zone
    Reason        xdbschema.Column // reason integer
    ReasonText    xdbschema.Column // reason_text character varying
}{
    Table:         &RevokedTableInfo,
    ID:            xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:         xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: true},
    ProjectID:     xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    CertificateID: xdbschema.Column{Name: "certificate_id", Position: 4, Type: "bigint", UdtType: "int8", Nullable: false},
    Ikid:          xdbschema.Column{Name: "ikid", Position: 5, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    SerialNumber:  xdbschema.Column{Name: "serial_number", Position: 6, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    NotAfter:      xdbschema.Column{Name: "not_after", Position: 7, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    RevokedAt:     xdbschema.Column{Name: "revoked_at", Position: 8, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    Reason:        xdbschema.Column{Name: "reason", Position: 9, Type: "integer", UdtType: "int4", Nullable: false},
    ReasonText:    xdbschema.Column{Name: "reason_text", Position: 10, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 260},
}

RevokedCertificate provides column definitions for table 'trustyca.vw_revoked_certificate'.

var RevokedCertificate = struct {
    Table         *xdbschema.TableInfo
    ID            xdbschema.Column // id bigint
    OrgID         xdbschema.Column // org_id bigint
    ProjectID     xdbschema.Column // project_id bigint
    CertificateID xdbschema.Column // certificate_id bigint
    Skid          xdbschema.Column // skid character varying
    Ikid          xdbschema.Column // ikid character varying
    SerialNumber  xdbschema.Column // serial_number character varying
    NotBefore     xdbschema.Column // not_before timestamp with time zone
    NotAfter      xdbschema.Column // not_after timestamp with time zone
    Subject       xdbschema.Column // subject character varying
    Issuer        xdbschema.Column // issuer character varying
    Sha256        xdbschema.Column // sha256 character varying
    Profile       xdbschema.Column // profile character varying
    Label         xdbschema.Column // label character varying
    Locations     xdbschema.Column // locations ARRAY
    Metadata      xdbschema.Column // metadata jsonb
    Pem           xdbschema.Column // pem text
    IssuersPem    xdbschema.Column // issuers_pem text
    Status        xdbschema.Column // status integer
    CreatedAt     xdbschema.Column // created_at timestamp with time zone
    RevokedAt     xdbschema.Column // revoked_at timestamp with time zone
    Reason        xdbschema.Column // reason integer
    ReasonText    xdbschema.Column // reason_text character varying
}{
    Table:         &RevokedCertificateTableInfo,
    ID:            xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: true},
    OrgID:         xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: true},
    ProjectID:     xdbschema.Column{Name: "project_id", Position: 3, Type: "bigint", UdtType: "int8", Nullable: true},
    CertificateID: xdbschema.Column{Name: "certificate_id", Position: 4, Type: "bigint", UdtType: "int8", Nullable: true},
    Skid:          xdbschema.Column{Name: "skid", Position: 5, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 64},
    Ikid:          xdbschema.Column{Name: "ikid", Position: 6, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 64},
    SerialNumber:  xdbschema.Column{Name: "serial_number", Position: 7, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 64},
    NotBefore:     xdbschema.Column{Name: "not_before", Position: 8, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
    NotAfter:      xdbschema.Column{Name: "not_after", Position: 9, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
    Subject:       xdbschema.Column{Name: "subject", Position: 10, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 260},
    Issuer:        xdbschema.Column{Name: "issuer", Position: 11, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 260},
    Sha256:        xdbschema.Column{Name: "sha256", Position: 12, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 64},
    Profile:       xdbschema.Column{Name: "profile", Position: 13, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 64},
    Label:         xdbschema.Column{Name: "label", Position: 14, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 260},
    Locations:     xdbschema.Column{Name: "locations", Position: 15, Type: "ARRAY", UdtType: "_varchar", Nullable: true},
    Metadata:      xdbschema.Column{Name: "metadata", Position: 16, Type: "jsonb", UdtType: "jsonb", Nullable: true},
    Pem:           xdbschema.Column{Name: "pem", Position: 17, Type: "text", UdtType: "text", Nullable: true},
    IssuersPem:    xdbschema.Column{Name: "issuers_pem", Position: 18, Type: "text", UdtType: "text", Nullable: true},
    Status:        xdbschema.Column{Name: "status", Position: 19, Type: "integer", UdtType: "int4", Nullable: true},
    CreatedAt:     xdbschema.Column{Name: "created_at", Position: 20, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
    RevokedAt:     xdbschema.Column{Name: "revoked_at", Position: 21, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: true},
    Reason:        xdbschema.Column{Name: "reason", Position: 22, Type: "integer", UdtType: "int4", Nullable: true},
    ReasonText:    xdbschema.Column{Name: "reason_text", Position: 23, Type: "character varying", UdtType: "varchar", Nullable: true, MaxLength: 260},
}

RevokedCertificateTableInfo provides table info for 'vw_revoked_certificate'

var RevokedCertificateTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.vw_revoked_certificate",
    Schema:     "trustyca",
    Name:       "vw_revoked_certificate",
    PrimaryKey: "",
    Columns:    []string{"id", "org_id", "project_id", "certificate_id", "skid", "ikid", "serial_number", "not_before", "not_after", "subject", "issuer", "sha256", "profile", "label", "locations", "metadata", "pem", "issuers_pem", "status", "created_at", "revoked_at", "reason", "reason_text"},
    Indexes:    []string{},
    Dialect:    xsql.Postgres,
}

RevokedTableInfo provides table info for 'revoked'

var RevokedTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.revoked",
    Schema:     "trustyca",
    Name:       "revoked",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "project_id", "certificate_id", "ikid", "serial_number", "not_after", "revoked_at", "reason", "reason_text"},
    Indexes:    []string{"idx_revoked_ikid_notafter", "idx_revoked_ikid_serial", "idx_revoked_org_project_id_desc", "revoked_pkey", "unique_revoked_certificate"},
    Dialect:    xsql.Postgres,
}

RootCertificate provides column definitions for table 'trustyca.root_certificate'. Primary key: id Indexes:

idx_root_certificate_notafter: [not_after]
idx_root_certificate_org: [org_id]
idx_root_certificate_skid: [skid]
root_certificate_pkey: PRIMARY UNIQUE [id]
unique_root_certificate_sha256: UNIQUE [sha256]
var RootCertificate = struct {
    Table     *xdbschema.TableInfo
    ID        xdbschema.Column // id bigint
    OrgID     xdbschema.Column // org_id bigint
    Skid      xdbschema.Column // skid character varying
    NotBefore xdbschema.Column // not_before timestamp with time zone
    NotAfter  xdbschema.Column // not_after timestamp with time zone
    Subject   xdbschema.Column // subject character varying
    Sha256    xdbschema.Column // sha256 character varying
    Trust     xdbschema.Column // trust integer
    Pem       xdbschema.Column // pem text
    CreatedAt xdbschema.Column // created_at timestamp with time zone
}{
    Table:     &RootCertificateTableInfo,
    ID:        xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    OrgID:     xdbschema.Column{Name: "org_id", Position: 2, Type: "bigint", UdtType: "int8", Nullable: true},
    Skid:      xdbschema.Column{Name: "skid", Position: 3, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    NotBefore: xdbschema.Column{Name: "not_before", Position: 4, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    NotAfter:  xdbschema.Column{Name: "not_after", Position: 5, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
    Subject:   xdbschema.Column{Name: "subject", Position: 6, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 260},
    Sha256:    xdbschema.Column{Name: "sha256", Position: 7, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
    Trust:     xdbschema.Column{Name: "trust", Position: 8, Type: "integer", UdtType: "int4", Nullable: false},
    Pem:       xdbschema.Column{Name: "pem", Position: 9, Type: "text", UdtType: "text", Nullable: false},
    CreatedAt: xdbschema.Column{Name: "created_at", Position: 10, Type: "timestamp with time zone", UdtType: "timestamptz", Nullable: false},
}

RootCertificateTableInfo provides table info for 'root_certificate'

var RootCertificateTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.root_certificate",
    Schema:     "trustyca",
    Name:       "root_certificate",
    PrimaryKey: "id",
    Columns:    []string{"id", "org_id", "skid", "not_before", "not_after", "subject", "sha256", "trust", "pem", "created_at"},
    Indexes:    []string{"idx_root_certificate_notafter", "idx_root_certificate_org", "idx_root_certificate_skid", "root_certificate_pkey", "unique_root_certificate_sha256"},
    Dialect:    xsql.Postgres,
}

SchemaMigration provides column definitions for table 'trustyca.schema_migrations'. Primary key: version Indexes:

schema_migrations_pkey: PRIMARY UNIQUE [version]
var SchemaMigration = struct {
    Table   *xdbschema.TableInfo
    Version xdbschema.Column // version bigint
    Dirty   xdbschema.Column // dirty boolean
}{
    Table:   &SchemaMigrationTableInfo,
    Version: xdbschema.Column{Name: "version", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    Dirty:   xdbschema.Column{Name: "dirty", Position: 2, Type: "boolean", UdtType: "bool", Nullable: false},
}

SchemaMigrationTableInfo provides table info for 'schema_migrations'

var SchemaMigrationTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.schema_migrations",
    Schema:     "trustyca",
    Name:       "schema_migrations",
    PrimaryKey: "version",
    Columns:    []string{"version", "dirty"},
    Indexes:    []string{"schema_migrations_pkey"},
    Dialect:    xsql.Postgres,
}

TrustycadbTables provides tables map for trustycadb

var TrustycadbTables = map[string]*xdbschema.TableInfo{
    "apikey":                 &APIKeyTableInfo,
    "certificate":            &CertificateTableInfo,
    "certificate_profile":    &CertificateProfileTableInfo,
    "crl":                    &CrlTableInfo,
    "event":                  &EventTableInfo,
    "invite":                 &InviteTableInfo,
    "issuer":                 &IssuerTableInfo,
    "login":                  &LoginTableInfo,
    "membership":             &MembershipTableInfo,
    "org":                    &OrgTableInfo,
    "project":                &ProjectTableInfo,
    "revoked":                &RevokedTableInfo,
    "root_certificate":       &RootCertificateTableInfo,
    "schema_migrations":      &SchemaMigrationTableInfo,
    "user":                   &UserTableInfo,
    "vw_membership_info":     &MembershipInfoTableInfo,
    "vw_revoked_certificate": &RevokedCertificateTableInfo,
}

User provides column definitions for table 'trustyca.user'. Primary key: id Indexes:

unique_user_email: UNIQUE [email]
user_pkey: PRIMARY UNIQUE [id]
var User = struct {
    Table         *xdbschema.TableInfo
    ID            xdbschema.Column // id bigint
    Email         xdbschema.Column // email character varying
    EmailVerified xdbschema.Column // email_verified boolean
    Name          xdbschema.Column // name character varying
}{
    Table:         &UserTableInfo,
    ID:            xdbschema.Column{Name: "id", Position: 1, Type: "bigint", UdtType: "int8", Nullable: false},
    Email:         xdbschema.Column{Name: "email", Position: 2, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 160},
    EmailVerified: xdbschema.Column{Name: "email_verified", Position: 3, Type: "boolean", UdtType: "bool", Nullable: false},
    Name:          xdbschema.Column{Name: "name", Position: 4, Type: "character varying", UdtType: "varchar", Nullable: false, MaxLength: 64},
}

UserTableInfo provides table info for 'user'

var UserTableInfo = xdbschema.TableInfo{
    SchemaName: "trustyca.user",
    Schema:     "trustyca",
    Name:       "user",
    PrimaryKey: "id",
    Columns:    []string{"id", "email", "email_verified", "name"},
    Indexes:    []string{"unique_user_email", "user_pkey"},
    Dialect:    xsql.Postgres,
}

Generated by gomarkdoc