2711 lines
55 KiB
Go
Generated
2711 lines
55 KiB
Go
Generated
package model
|
|
|
|
// This file is auto-generated.
|
|
//
|
|
// Changes to this file may cause incorrect behavior and will be lost if
|
|
// the code is regenerated.
|
|
//
|
|
|
|
import (
|
|
"github.com/cortezaproject/corteza/server/pkg/dal"
|
|
"github.com/cortezaproject/corteza/server/system/types"
|
|
)
|
|
|
|
var ApigwFilter = &dal.Model{
|
|
Ident: "apigw_filters",
|
|
ResourceType: types.ApigwFilterResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Route", Sortable: true,
|
|
Type: &dal.TypeRef{
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:apigw-route",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_route"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Weight", Sortable: true,
|
|
Type: &dal.TypeNumber{Precision: -1, Scale: -1, Meta: map[string]interface{}{"rdbms:type": "integer"}},
|
|
Store: &dal.CodecAlias{Ident: "weight"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Kind", Sortable: true,
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "kind"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Ref",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "ref"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Enabled", Sortable: true,
|
|
Type: &dal.TypeBoolean{},
|
|
Store: &dal.CodecAlias{Ident: "enabled"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Params",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "params"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var ApigwRoute = &dal.Model{
|
|
Ident: "apigw_routes",
|
|
ResourceType: types.ApigwRouteResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Endpoint", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "endpoint"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Method", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "method"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Enabled", Sortable: true,
|
|
Type: &dal.TypeBoolean{},
|
|
Store: &dal.CodecAlias{Ident: "enabled"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Group", Sortable: true,
|
|
Type: &dal.TypeRef{
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:apigw-group",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_group"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var Application = &dal.Model{
|
|
Ident: "applications",
|
|
ResourceType: types.ApplicationResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Name", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "name"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Enabled", Sortable: true,
|
|
Type: &dal.TypeBoolean{HasDefault: true,
|
|
DefaultValue: true,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "enabled"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Weight", Sortable: true,
|
|
Type: &dal.TypeNumber{HasDefault: true,
|
|
DefaultValue: 0,
|
|
Precision: -1, Scale: -1, Meta: map[string]interface{}{"rdbms:type": "integer"},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "weight"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Unify",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "unify"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "OwnerID",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_owner"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var Attachment = &dal.Model{
|
|
Ident: "attachments",
|
|
ResourceType: types.AttachmentResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "OwnerID",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_owner"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Kind", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "kind"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Url",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "url"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "PreviewUrl",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "preview_url"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Name", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "name"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var AuthClient = &dal.Model{
|
|
Ident: "auth_clients",
|
|
ResourceType: types.AuthClientResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Handle",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "handle"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Secret",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "secret"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Scope",
|
|
Type: &dal.TypeText{Length: 512},
|
|
Store: &dal.CodecAlias{Ident: "scope"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ValidGrant",
|
|
Type: &dal.TypeText{Length: 32},
|
|
Store: &dal.CodecAlias{Ident: "valid_grant"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "RedirectURI",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "redirect_uri"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Enabled", Sortable: true,
|
|
Type: &dal.TypeBoolean{HasDefault: true,
|
|
DefaultValue: false,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "enabled"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Trusted", Sortable: true,
|
|
Type: &dal.TypeBoolean{HasDefault: true,
|
|
DefaultValue: false,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "trusted"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ValidFrom", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "valid_from"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ExpiresAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "expires_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Security",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "security"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "OwnedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "owned_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var AuthConfirmedClient = &dal.Model{
|
|
Ident: "auth_confirmed_clients",
|
|
ResourceType: types.AuthConfirmedClientResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "UserID",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_user"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ClientID",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:auth-client",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_client"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ConfirmedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "confirmed_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "UserID",
|
|
},
|
|
|
|
{
|
|
AttributeIdent: "ClientID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var AuthOa2token = &dal.Model{
|
|
Ident: "auth_oa2tokens",
|
|
ResourceType: types.AuthOa2tokenResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Code",
|
|
Type: &dal.TypeText{Length: 48},
|
|
Store: &dal.CodecAlias{Ident: "code"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Access",
|
|
Type: &dal.TypeText{Length: 2048},
|
|
Store: &dal.CodecAlias{Ident: "access"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Refresh",
|
|
Type: &dal.TypeText{Length: 48},
|
|
Store: &dal.CodecAlias{Ident: "refresh"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Data",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "data"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "RemoteAddr",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "remote_addr"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UserAgent",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "user_agent"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ClientID",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:auth-client",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_client"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UserID",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_user"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ExpiresAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "expires_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "auth_oa2tokens_clientId",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ClientID",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "auth_oa2tokens_code",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "Code",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "auth_oa2tokens_refresh",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "Refresh",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var AuthSession = &dal.Model{
|
|
Ident: "auth_sessions",
|
|
ResourceType: types.AuthSessionResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Data",
|
|
Type: &dal.TypeBlob{},
|
|
Store: &dal.CodecAlias{Ident: "data"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UserID",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_user"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "RemoteAddr",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "remote_addr"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UserAgent",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "user_agent"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ExpiresAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "expires_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "auth_sessions_expiresAt",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ExpiresAt",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var Credential = &dal.Model{
|
|
Ident: "credentials",
|
|
ResourceType: types.CredentialResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "OwnerID",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_owner"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Label",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "label"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Kind",
|
|
Type: &dal.TypeText{Length: 128},
|
|
Store: &dal.CodecAlias{Ident: "kind"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Credentials",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "credentials"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "LastUsedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "last_used_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ExpiresAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "expires_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "credentials_ownerKind",
|
|
Type: "BTREE",
|
|
|
|
Predicate: "deleted_at IS NULL",
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "OwnerID",
|
|
},
|
|
|
|
{
|
|
AttributeIdent: "Kind",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var DalConnection = &dal.Model{
|
|
Ident: "dal_connections",
|
|
ResourceType: types.DalConnectionResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Handle",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "handle"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Type", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "type"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Config",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "config"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var DalSchemaAlteration = &dal.Model{
|
|
Ident: "dal_schema_alterations",
|
|
ResourceType: types.DalSchemaAlterationResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "BatchID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "batch_id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DependsOn",
|
|
Type: &dal.TypeRef{
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:dal-schema-alteration",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "depends_on"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Resource",
|
|
Type: &dal.TypeText{Length: 256},
|
|
Store: &dal.CodecAlias{Ident: "resource"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ResourceType",
|
|
Type: &dal.TypeText{Length: 256},
|
|
Store: &dal.CodecAlias{Ident: "resource_type"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ConnectionID",
|
|
Type: &dal.TypeRef{
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:dal-connection",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "connection_id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Kind",
|
|
Type: &dal.TypeText{Length: 256},
|
|
Store: &dal.CodecAlias{Ident: "kind"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Params",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "params"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Error",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "error"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CompletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "completed_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DismissedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "dismissed_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CompletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "completed_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DismissedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "dismissed_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "dal_schema_alterations_uniqueAlteration",
|
|
Type: "BTREE",
|
|
Unique: true,
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
|
|
{
|
|
AttributeIdent: "BatchID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var DalSensitivityLevel = &dal.Model{
|
|
Ident: "dal_sensitivity_levels",
|
|
ResourceType: types.DalSensitivityLevelResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Handle",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "handle"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Level", Sortable: true,
|
|
Type: &dal.TypeNumber{Precision: -1, Scale: -1, Meta: map[string]interface{}{"rdbms:type": "integer"}},
|
|
Store: &dal.CodecAlias{Ident: "level"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var DataPrivacyRequest = &dal.Model{
|
|
Ident: "data_privacy_requests",
|
|
ResourceType: types.DataPrivacyRequestResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Kind", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "kind"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Status", Sortable: true,
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "status"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Payload",
|
|
Type: &dal.TypeJSON{},
|
|
Store: &dal.CodecAlias{Ident: "payload"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "RequestedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "requested_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "RequestedBy",
|
|
Type: &dal.TypeRef{
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "requested_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CompletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "completed_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CompletedBy",
|
|
Type: &dal.TypeRef{
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "completed_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var DataPrivacyRequestComment = &dal.Model{
|
|
Ident: "data_privacy_request_comments",
|
|
ResourceType: types.DataPrivacyRequestCommentResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "RequestID",
|
|
Type: &dal.TypeRef{
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_request"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Comment",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "comment"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var Queue = &dal.Model{
|
|
Ident: "queue_settings",
|
|
ResourceType: types.QueueResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Consumer", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "consumer"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Queue", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "queue"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var QueueMessage = &dal.Model{
|
|
Ident: "queue_messages",
|
|
ResourceType: types.QueueMessageResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Queue", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "queue"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Payload",
|
|
Type: &dal.TypeBlob{},
|
|
Store: &dal.CodecAlias{Ident: "payload"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Created", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "created"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Processed", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "processed"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var Reminder = &dal.Model{
|
|
Ident: "reminders",
|
|
ResourceType: types.ReminderResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Resource", Sortable: true,
|
|
Type: &dal.TypeText{Length: 512},
|
|
Store: &dal.CodecAlias{Ident: "resource"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Payload",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "payload"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "SnoozeCount",
|
|
Type: &dal.TypeNumber{Precision: -1, Scale: -1, Meta: map[string]interface{}{"rdbms:type": "integer"}},
|
|
Store: &dal.CodecAlias{Ident: "snooze_count"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "AssignedTo",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "assigned_to"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "AssignedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "assigned_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "AssignedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "assigned_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DismissedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "dismissed_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DismissedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "dismissed_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "RemindAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "remind_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "reminders_assignedTo",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "AssignedTo",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "reminders_resource",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "Resource",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var Report = &dal.Model{
|
|
Ident: "reports",
|
|
ResourceType: types.ReportResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Handle",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "handle"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Scenarios",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "scenarios"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Sources",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "sources"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Blocks",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "blocks"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "OwnedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "owned_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var ResourceTranslation = &dal.Model{
|
|
Ident: "resource_translations",
|
|
ResourceType: types.ResourceTranslationResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Lang",
|
|
Type: &dal.TypeText{Length: 32},
|
|
Store: &dal.CodecAlias{Ident: "lang"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Resource",
|
|
Type: &dal.TypeText{Length: 256},
|
|
Store: &dal.CodecAlias{Ident: "resource"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "K",
|
|
Type: &dal.TypeText{Length: 256},
|
|
Store: &dal.CodecAlias{Ident: "k"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Message",
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "message"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "OwnedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "owned_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "deleted_by"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "resource_translations_uniqueTranslation",
|
|
Type: "BTREE",
|
|
Unique: true,
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "Lang",
|
|
Modifiers: []dal.IndexFieldModifier{"LOWERCASE"},
|
|
},
|
|
|
|
{
|
|
AttributeIdent: "Resource",
|
|
Modifiers: []dal.IndexFieldModifier{"LOWERCASE"},
|
|
},
|
|
|
|
{
|
|
AttributeIdent: "K",
|
|
Modifiers: []dal.IndexFieldModifier{"LOWERCASE"},
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var Role = &dal.Model{
|
|
Ident: "roles",
|
|
ResourceType: types.RoleResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Name", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "name"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Handle",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "handle"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "ArchivedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "archived_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var RoleMember = &dal.Model{
|
|
Ident: "role_members",
|
|
ResourceType: types.RoleMemberResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "UserID",
|
|
Type: &dal.TypeRef{
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_user"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "RoleID",
|
|
Type: &dal.TypeRef{
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:role",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_role"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "UserID",
|
|
},
|
|
|
|
{
|
|
AttributeIdent: "RoleID",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var SettingValue = &dal.Model{
|
|
Ident: "settings",
|
|
ResourceType: types.SettingValueResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "OwnedBy",
|
|
Type: &dal.TypeRef{
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_owner"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Name",
|
|
Type: &dal.TypeText{Length: 512},
|
|
Store: &dal.CodecAlias{Ident: "name"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Value",
|
|
Type: &dal.TypeJSON{},
|
|
Store: &dal.CodecAlias{Ident: "value"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedBy",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "updated_by"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "OwnedBy",
|
|
},
|
|
|
|
{
|
|
AttributeIdent: "Name",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var Template = &dal.Model{
|
|
Ident: "templates",
|
|
ResourceType: types.TemplateResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "OwnerID",
|
|
Type: &dal.TypeRef{HasDefault: true,
|
|
DefaultValue: 0,
|
|
|
|
RefAttribute: "id",
|
|
RefModel: &dal.ModelRef{
|
|
ResourceType: "corteza::system:user",
|
|
},
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "rel_owner"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Handle",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "handle"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Language", Sortable: true,
|
|
Type: &dal.TypeText{Length: 32},
|
|
Store: &dal.CodecAlias{Ident: "language"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Type", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "type"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Partial",
|
|
Type: &dal.TypeBoolean{},
|
|
Store: &dal.CodecAlias{Ident: "partial"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Template", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "template"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "LastUsedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "last_used_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "templates_uniqueLanguageHandle",
|
|
Type: "BTREE",
|
|
Unique: true,
|
|
Predicate: "handle != '' AND deleted_at IS NULL",
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "Language",
|
|
},
|
|
|
|
{
|
|
AttributeIdent: "Handle",
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
var User = &dal.Model{
|
|
Ident: "users",
|
|
ResourceType: types.UserResourceType,
|
|
|
|
Attributes: dal.AttributeSet{
|
|
&dal.Attribute{
|
|
Ident: "ID",
|
|
Type: &dal.TypeID{},
|
|
Store: &dal.CodecAlias{Ident: "id"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Email", Sortable: true,
|
|
Type: &dal.TypeText{Length: 254},
|
|
Store: &dal.CodecAlias{Ident: "email"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "EmailConfirmed",
|
|
Type: &dal.TypeBoolean{},
|
|
Store: &dal.CodecAlias{Ident: "email_confirmed"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Username", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "username"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Name", Sortable: true,
|
|
Type: &dal.TypeText{},
|
|
Store: &dal.CodecAlias{Ident: "name"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Handle",
|
|
Type: &dal.TypeText{Length: 64},
|
|
Store: &dal.CodecAlias{Ident: "handle"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Kind", Sortable: true,
|
|
Type: &dal.TypeText{Length: 8},
|
|
Store: &dal.CodecAlias{Ident: "kind"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "Meta",
|
|
Type: &dal.TypeJSON{
|
|
DefaultValue: "{}",
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "meta"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "SuspendedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "suspended_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "CreatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{
|
|
DefaultCurrentTimestamp: true, Timezone: true, Precision: -1,
|
|
},
|
|
Store: &dal.CodecAlias{Ident: "created_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "UpdatedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "updated_at"},
|
|
},
|
|
|
|
&dal.Attribute{
|
|
Ident: "DeletedAt", Sortable: true,
|
|
Type: &dal.TypeTimestamp{Nullable: true, Timezone: true, Precision: -1},
|
|
Store: &dal.CodecAlias{Ident: "deleted_at"},
|
|
},
|
|
},
|
|
|
|
Indexes: dal.IndexSet{
|
|
&dal.Index{
|
|
Ident: "PRIMARY",
|
|
Type: "BTREE",
|
|
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "ID",
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "users_uniqueEmail",
|
|
Type: "BTREE",
|
|
Unique: true,
|
|
Predicate: "email != '' AND deleted_at IS NULL",
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "Email",
|
|
Modifiers: []dal.IndexFieldModifier{"LOWERCASE"},
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "users_uniqueHandle",
|
|
Type: "BTREE",
|
|
Unique: true,
|
|
Predicate: "handle != '' AND deleted_at IS NULL",
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "Handle",
|
|
Modifiers: []dal.IndexFieldModifier{"LOWERCASE"},
|
|
},
|
|
},
|
|
},
|
|
|
|
&dal.Index{
|
|
Ident: "users_uniqueUsername",
|
|
Type: "BTREE",
|
|
Unique: true,
|
|
Predicate: "username != '' AND deleted_at IS NULL",
|
|
Fields: []*dal.IndexField{
|
|
{
|
|
AttributeIdent: "Username",
|
|
Modifiers: []dal.IndexFieldModifier{"LOWERCASE"},
|
|
},
|
|
},
|
|
},
|
|
},
|
|
}
|
|
|
|
func init() {
|
|
models = append(
|
|
models,
|
|
ApigwFilter,
|
|
ApigwRoute,
|
|
Application,
|
|
Attachment,
|
|
AuthClient,
|
|
AuthConfirmedClient,
|
|
AuthOa2token,
|
|
AuthSession,
|
|
Credential,
|
|
DalConnection,
|
|
DalSchemaAlteration,
|
|
DalSensitivityLevel,
|
|
DataPrivacyRequest,
|
|
DataPrivacyRequestComment,
|
|
Queue,
|
|
QueueMessage,
|
|
Reminder,
|
|
Report,
|
|
ResourceTranslation,
|
|
Role,
|
|
RoleMember,
|
|
SettingValue,
|
|
Template,
|
|
User,
|
|
)
|
|
}
|