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