A continuation of HomeBox the inventory and organization system built for the Home User
// Code generated by ent, DO NOT EDIT.
package migrate
import (
"entgo.io/ent/dialect/entsql"
"entgo.io/ent/dialect/sql/schema"
"entgo.io/ent/schema/field"
)
var (
// APIKeysColumns holds the columns for the "api_keys" table.
APIKeysColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "token", Type: field.TypeBytes, Unique: true},
{Name: "expires_at", Type: field.TypeTime, Nullable: true},
{Name: "last_used_at", Type: field.TypeTime, Nullable: true},
{Name: "user_id", Type: field.TypeUUID},
}
// APIKeysTable holds the schema information for the "api_keys" table.
APIKeysTable = &schema.Table{
Name: "api_keys",
Columns: APIKeysColumns,
PrimaryKey: []*schema.Column{APIKeysColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "api_keys_users_api_keys",
Columns: []*schema.Column{APIKeysColumns[7]},
RefColumns: []*schema.Column{UsersColumns[0]},
OnDelete: schema.Cascade,
},
},
Indexes: []*schema.Index{
{
Name: "apikey_token",
Unique: false,
Columns: []*schema.Column{APIKeysColumns[4]},
},
{
Name: "apikey_user_id",
Unique: false,
Columns: []*schema.Column{APIKeysColumns[7]},
},
},
}
// AttachmentsColumns holds the columns for the "attachments" table.
AttachmentsColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "type", Type: field.TypeEnum, Enums: []string{"photo", "manual", "warranty", "attachment", "receipt", "thumbnail"}, Default: "attachment"},
{Name: "primary", Type: field.TypeBool, Default: false},
{Name: "title", Type: field.TypeString, Default: ""},
{Name: "path", Type: field.TypeString, Default: ""},
{Name: "mime_type", Type: field.TypeString, Default: "application/octet-stream"},
{Name: "attachment_thumbnail", Type: field.TypeUUID, Unique: true, Nullable: true},
{Name: "entity_attachments", Type: field.TypeUUID, Nullable: true},
}
// AttachmentsTable holds the schema information for the "attachments" table.
AttachmentsTable = &schema.Table{
Name: "attachments",
Columns: AttachmentsColumns,
PrimaryKey: []*schema.Column{AttachmentsColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "attachments_attachments_thumbnail",
Columns: []*schema.Column{AttachmentsColumns[8]},
RefColumns: []*schema.Column{AttachmentsColumns[0]},
OnDelete: schema.SetNull,
},
{
Symbol: "attachments_entities_attachments",
Columns: []*schema.Column{AttachmentsColumns[9]},
RefColumns: []*schema.Column{EntitiesColumns[0]},
OnDelete: schema.Cascade,
},
},
}
// AuthRolesColumns holds the columns for the "auth_roles" table.
AuthRolesColumns = []*schema.Column{
{Name: "id", Type: field.TypeInt, Increment: true},
{Name: "role", Type: field.TypeEnum, Enums: []string{"admin", "user", "attachments"}, Default: "user"},
{Name: "auth_tokens_roles", Type: field.TypeUUID, Unique: true, Nullable: true},
}
// AuthRolesTable holds the schema information for the "auth_roles" table.
AuthRolesTable = &schema.Table{
Name: "auth_roles",
Columns: AuthRolesColumns,
PrimaryKey: []*schema.Column{AuthRolesColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "auth_roles_auth_tokens_roles",
Columns: []*schema.Column{AuthRolesColumns[2]},
RefColumns: []*schema.Column{AuthTokensColumns[0]},
OnDelete: schema.Cascade,
},
},
}
// AuthTokensColumns holds the columns for the "auth_tokens" table.
AuthTokensColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "token", Type: field.TypeBytes, Unique: true},
{Name: "expires_at", Type: field.TypeTime},
{Name: "user_auth_tokens", Type: field.TypeUUID, Nullable: true},
}
// AuthTokensTable holds the schema information for the "auth_tokens" table.
AuthTokensTable = &schema.Table{
Name: "auth_tokens",
Columns: AuthTokensColumns,
PrimaryKey: []*schema.Column{AuthTokensColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "auth_tokens_users_auth_tokens",
Columns: []*schema.Column{AuthTokensColumns[5]},
RefColumns: []*schema.Column{UsersColumns[0]},
OnDelete: schema.Cascade,
},
},
Indexes: []*schema.Index{
{
Name: "authtokens_token",
Unique: false,
Columns: []*schema.Column{AuthTokensColumns[3]},
},
},
}
// EntitiesColumns holds the columns for the "entities" table.
EntitiesColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "description", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "import_ref", Type: field.TypeString, Nullable: true, Size: 100},
{Name: "notes", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "quantity", Type: field.TypeFloat64, Default: 1},
{Name: "insured", Type: field.TypeBool, Default: false},
{Name: "archived", Type: field.TypeBool, Default: false},
{Name: "asset_id", Type: field.TypeInt64, Default: 0},
{Name: "sync_child_entity_locations", Type: field.TypeBool, Default: false},
{Name: "serial_number", Type: field.TypeString, Nullable: true, Size: 255},
{Name: "model_number", Type: field.TypeString, Nullable: true, Size: 255},
{Name: "manufacturer", Type: field.TypeString, Nullable: true, Size: 255},
{Name: "lifetime_warranty", Type: field.TypeBool, Default: false},
{Name: "warranty_expires", Type: field.TypeTime, Nullable: true},
{Name: "warranty_details", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "purchase_date", Type: field.TypeTime, Nullable: true},
{Name: "purchase_from", Type: field.TypeString, Nullable: true},
{Name: "purchase_price", Type: field.TypeFloat64, Default: 0},
{Name: "sold_date", Type: field.TypeTime, Nullable: true},
{Name: "sold_to", Type: field.TypeString, Nullable: true},
{Name: "sold_price", Type: field.TypeFloat64, Default: 0},
{Name: "sold_notes", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "entity_children", Type: field.TypeUUID, Nullable: true},
{Name: "entity_location_entities", Type: field.TypeUUID, Nullable: true},
{Name: "entity_type_entities", Type: field.TypeUUID},
{Name: "group_entities", Type: field.TypeUUID},
}
// EntitiesTable holds the schema information for the "entities" table.
EntitiesTable = &schema.Table{
Name: "entities",
Columns: EntitiesColumns,
PrimaryKey: []*schema.Column{EntitiesColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "entities_entities_children",
Columns: []*schema.Column{EntitiesColumns[25]},
RefColumns: []*schema.Column{EntitiesColumns[0]},
OnDelete: schema.SetNull,
},
{
Symbol: "entities_entities_location_entities",
Columns: []*schema.Column{EntitiesColumns[26]},
RefColumns: []*schema.Column{EntitiesColumns[0]},
OnDelete: schema.SetNull,
},
{
Symbol: "entities_entity_types_entities",
Columns: []*schema.Column{EntitiesColumns[27]},
RefColumns: []*schema.Column{EntityTypesColumns[0]},
OnDelete: schema.Restrict,
},
{
Symbol: "entities_groups_entities",
Columns: []*schema.Column{EntitiesColumns[28]},
RefColumns: []*schema.Column{GroupsColumns[0]},
OnDelete: schema.Cascade,
},
},
Indexes: []*schema.Index{
{
Name: "entity_name",
Unique: false,
Columns: []*schema.Column{EntitiesColumns[3]},
},
{
Name: "entity_manufacturer",
Unique: false,
Columns: []*schema.Column{EntitiesColumns[14]},
},
{
Name: "entity_model_number",
Unique: false,
Columns: []*schema.Column{EntitiesColumns[13]},
},
{
Name: "entity_serial_number",
Unique: false,
Columns: []*schema.Column{EntitiesColumns[12]},
},
{
Name: "entity_archived",
Unique: false,
Columns: []*schema.Column{EntitiesColumns[9]},
},
{
Name: "entity_asset_id",
Unique: false,
Columns: []*schema.Column{EntitiesColumns[10]},
},
},
}
// EntityFieldsColumns holds the columns for the "entity_fields" table.
EntityFieldsColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "description", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "type", Type: field.TypeEnum, Enums: []string{"text", "number", "boolean", "time"}},
{Name: "text_value", Type: field.TypeString, Nullable: true, Size: 500},
{Name: "number_value", Type: field.TypeInt, Nullable: true},
{Name: "boolean_value", Type: field.TypeBool, Default: false},
{Name: "time_value", Type: field.TypeTime},
{Name: "entity_fields", Type: field.TypeUUID, Nullable: true},
}
// EntityFieldsTable holds the schema information for the "entity_fields" table.
EntityFieldsTable = &schema.Table{
Name: "entity_fields",
Columns: EntityFieldsColumns,
PrimaryKey: []*schema.Column{EntityFieldsColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "entity_fields_entities_fields",
Columns: []*schema.Column{EntityFieldsColumns[10]},
RefColumns: []*schema.Column{EntitiesColumns[0]},
OnDelete: schema.Cascade,
},
},
}
// EntityTemplatesColumns holds the columns for the "entity_templates" table.
EntityTemplatesColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "description", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "notes", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "default_quantity", Type: field.TypeFloat64, Default: 1},
{Name: "default_insured", Type: field.TypeBool, Default: false},
{Name: "default_name", Type: field.TypeString, Nullable: true, Size: 255},
{Name: "default_description", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "default_manufacturer", Type: field.TypeString, Nullable: true, Size: 255},
{Name: "default_model_number", Type: field.TypeString, Nullable: true, Size: 255},
{Name: "default_lifetime_warranty", Type: field.TypeBool, Default: false},
{Name: "default_warranty_details", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "include_warranty_fields", Type: field.TypeBool, Default: false},
{Name: "include_purchase_fields", Type: field.TypeBool, Default: false},
{Name: "include_sold_fields", Type: field.TypeBool, Default: false},
{Name: "default_tag_ids", Type: field.TypeJSON, Nullable: true},
{Name: "entity_template_location", Type: field.TypeUUID, Nullable: true},
{Name: "group_entity_templates", Type: field.TypeUUID},
}
// EntityTemplatesTable holds the schema information for the "entity_templates" table.
EntityTemplatesTable = &schema.Table{
Name: "entity_templates",
Columns: EntityTemplatesColumns,
PrimaryKey: []*schema.Column{EntityTemplatesColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "entity_templates_entities_location",
Columns: []*schema.Column{EntityTemplatesColumns[18]},
RefColumns: []*schema.Column{EntitiesColumns[0]},
OnDelete: schema.SetNull,
},
{
Symbol: "entity_templates_groups_entity_templates",
Columns: []*schema.Column{EntityTemplatesColumns[19]},
RefColumns: []*schema.Column{GroupsColumns[0]},
OnDelete: schema.Cascade,
},
},
Indexes: []*schema.Index{
{
Name: "entitytemplate_name",
Unique: false,
Columns: []*schema.Column{EntityTemplatesColumns[3]},
},
},
}
// EntityTypesColumns holds the columns for the "entity_types" table.
EntityTypesColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "description", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "is_location", Type: field.TypeBool, Default: false},
{Name: "icon", Type: field.TypeString, Nullable: true, Size: 255},
{Name: "entity_type_default_template", Type: field.TypeUUID, Nullable: true},
{Name: "group_entity_types", Type: field.TypeUUID},
}
// EntityTypesTable holds the schema information for the "entity_types" table.
EntityTypesTable = &schema.Table{
Name: "entity_types",
Columns: EntityTypesColumns,
PrimaryKey: []*schema.Column{EntityTypesColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "entity_types_entity_templates_default_template",
Columns: []*schema.Column{EntityTypesColumns[7]},
RefColumns: []*schema.Column{EntityTemplatesColumns[0]},
OnDelete: schema.SetNull,
},
{
Symbol: "entity_types_groups_entity_types",
Columns: []*schema.Column{EntityTypesColumns[8]},
RefColumns: []*schema.Column{GroupsColumns[0]},
OnDelete: schema.Cascade,
},
},
}
// ExportsColumns holds the columns for the "exports" table.
ExportsColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "kind", Type: field.TypeEnum, Enums: []string{"export", "import"}, Default: "export"},
{Name: "status", Type: field.TypeEnum, Enums: []string{"pending", "running", "completed", "failed"}, Default: "pending"},
{Name: "progress", Type: field.TypeInt, Default: 0},
{Name: "artifact_path", Type: field.TypeString, Nullable: true},
{Name: "size_bytes", Type: field.TypeInt64, Default: 0},
{Name: "error", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "group_id", Type: field.TypeUUID},
}
// ExportsTable holds the schema information for the "exports" table.
ExportsTable = &schema.Table{
Name: "exports",
Columns: ExportsColumns,
PrimaryKey: []*schema.Column{ExportsColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "exports_groups_exports",
Columns: []*schema.Column{ExportsColumns[9]},
RefColumns: []*schema.Column{GroupsColumns[0]},
OnDelete: schema.Cascade,
},
},
Indexes: []*schema.Index{
{
Name: "export_group_id",
Unique: false,
Columns: []*schema.Column{ExportsColumns[9]},
},
{
Name: "export_group_id_status",
Unique: false,
Columns: []*schema.Column{ExportsColumns[9], ExportsColumns[4]},
},
},
}
// GroupsColumns holds the columns for the "groups" table.
GroupsColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "currency", Type: field.TypeString, Default: "usd"},
}
// GroupsTable holds the schema information for the "groups" table.
GroupsTable = &schema.Table{
Name: "groups",
Columns: GroupsColumns,
PrimaryKey: []*schema.Column{GroupsColumns[0]},
}
// GroupInvitationTokensColumns holds the columns for the "group_invitation_tokens" table.
GroupInvitationTokensColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "token", Type: field.TypeBytes, Unique: true},
{Name: "expires_at", Type: field.TypeTime},
{Name: "uses", Type: field.TypeInt, Default: 0},
{Name: "group_invitation_tokens", Type: field.TypeUUID, Nullable: true},
}
// GroupInvitationTokensTable holds the schema information for the "group_invitation_tokens" table.
GroupInvitationTokensTable = &schema.Table{
Name: "group_invitation_tokens",
Columns: GroupInvitationTokensColumns,
PrimaryKey: []*schema.Column{GroupInvitationTokensColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "group_invitation_tokens_groups_invitation_tokens",
Columns: []*schema.Column{GroupInvitationTokensColumns[6]},
RefColumns: []*schema.Column{GroupsColumns[0]},
OnDelete: schema.Cascade,
},
},
}
// MaintenanceEntriesColumns holds the columns for the "maintenance_entries" table.
MaintenanceEntriesColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "date", Type: field.TypeTime, Nullable: true},
{Name: "scheduled_date", Type: field.TypeTime, Nullable: true},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "description", Type: field.TypeString, Nullable: true, Size: 2500},
{Name: "cost", Type: field.TypeFloat64, Default: 0},
{Name: "entity_id", Type: field.TypeUUID},
}
// MaintenanceEntriesTable holds the schema information for the "maintenance_entries" table.
MaintenanceEntriesTable = &schema.Table{
Name: "maintenance_entries",
Columns: MaintenanceEntriesColumns,
PrimaryKey: []*schema.Column{MaintenanceEntriesColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "maintenance_entries_entities_maintenance_entries",
Columns: []*schema.Column{MaintenanceEntriesColumns[8]},
RefColumns: []*schema.Column{EntitiesColumns[0]},
OnDelete: schema.Cascade,
},
},
}
// NotifiersColumns holds the columns for the "notifiers" table.
NotifiersColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "url", Type: field.TypeString, Size: 2083},
{Name: "is_active", Type: field.TypeBool, Default: true},
{Name: "group_id", Type: field.TypeUUID},
{Name: "user_id", Type: field.TypeUUID},
}
// NotifiersTable holds the schema information for the "notifiers" table.
NotifiersTable = &schema.Table{
Name: "notifiers",
Columns: NotifiersColumns,
PrimaryKey: []*schema.Column{NotifiersColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "notifiers_groups_notifiers",
Columns: []*schema.Column{NotifiersColumns[6]},
RefColumns: []*schema.Column{GroupsColumns[0]},
OnDelete: schema.Cascade,
},
{
Symbol: "notifiers_users_notifiers",
Columns: []*schema.Column{NotifiersColumns[7]},
RefColumns: []*schema.Column{UsersColumns[0]},
OnDelete: schema.Cascade,
},
},
Indexes: []*schema.Index{
{
Name: "notifier_user_id",
Unique: false,
Columns: []*schema.Column{NotifiersColumns[7]},
},
{
Name: "notifier_user_id_is_active",
Unique: false,
Columns: []*schema.Column{NotifiersColumns[7], NotifiersColumns[5]},
},
{
Name: "notifier_group_id",
Unique: false,
Columns: []*schema.Column{NotifiersColumns[6]},
},
{
Name: "notifier_group_id_is_active",
Unique: false,
Columns: []*schema.Column{NotifiersColumns[6], NotifiersColumns[5]},
},
},
}
// PasswordResetTokensColumns holds the columns for the "password_reset_tokens" table.
PasswordResetTokensColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "token", Type: field.TypeBytes, Unique: true},
{Name: "expires_at", Type: field.TypeTime},
{Name: "used_at", Type: field.TypeTime, Nullable: true},
{Name: "user_id", Type: field.TypeUUID},
}
// PasswordResetTokensTable holds the schema information for the "password_reset_tokens" table.
PasswordResetTokensTable = &schema.Table{
Name: "password_reset_tokens",
Columns: PasswordResetTokensColumns,
PrimaryKey: []*schema.Column{PasswordResetTokensColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "password_reset_tokens_users_password_reset_tokens",
Columns: []*schema.Column{PasswordResetTokensColumns[6]},
RefColumns: []*schema.Column{UsersColumns[0]},
OnDelete: schema.Cascade,
},
},
Indexes: []*schema.Index{
{
Name: "passwordresettokens_token",
Unique: false,
Columns: []*schema.Column{PasswordResetTokensColumns[3]},
},
},
}
// TagsColumns holds the columns for the "tags" table.
TagsColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "description", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "color", Type: field.TypeString, Nullable: true, Size: 255},
{Name: "icon", Type: field.TypeString, Nullable: true, Size: 255},
{Name: "group_tags", Type: field.TypeUUID},
{Name: "tag_children", Type: field.TypeUUID, Nullable: true},
}
// TagsTable holds the schema information for the "tags" table.
TagsTable = &schema.Table{
Name: "tags",
Columns: TagsColumns,
PrimaryKey: []*schema.Column{TagsColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "tags_groups_tags",
Columns: []*schema.Column{TagsColumns[7]},
RefColumns: []*schema.Column{GroupsColumns[0]},
OnDelete: schema.Cascade,
},
{
Symbol: "tags_tags_children",
Columns: []*schema.Column{TagsColumns[8]},
RefColumns: []*schema.Column{TagsColumns[0]},
OnDelete: schema.SetNull,
},
},
}
// TemplateFieldsColumns holds the columns for the "template_fields" table.
TemplateFieldsColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "description", Type: field.TypeString, Nullable: true, Size: 1000},
{Name: "type", Type: field.TypeEnum, Enums: []string{"text", "number", "boolean", "time"}},
{Name: "text_value", Type: field.TypeString, Nullable: true, Size: 500},
{Name: "number_value", Type: field.TypeInt, Nullable: true},
{Name: "boolean_value", Type: field.TypeBool, Default: false},
{Name: "time_value", Type: field.TypeTime},
{Name: "entity_template_fields", Type: field.TypeUUID, Nullable: true},
}
// TemplateFieldsTable holds the schema information for the "template_fields" table.
TemplateFieldsTable = &schema.Table{
Name: "template_fields",
Columns: TemplateFieldsColumns,
PrimaryKey: []*schema.Column{TemplateFieldsColumns[0]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "template_fields_entity_templates_fields",
Columns: []*schema.Column{TemplateFieldsColumns[10]},
RefColumns: []*schema.Column{EntityTemplatesColumns[0]},
OnDelete: schema.Cascade,
},
},
}
// UsersColumns holds the columns for the "users" table.
UsersColumns = []*schema.Column{
{Name: "id", Type: field.TypeUUID},
{Name: "created_at", Type: field.TypeTime},
{Name: "updated_at", Type: field.TypeTime},
{Name: "name", Type: field.TypeString, Size: 255},
{Name: "email", Type: field.TypeString, Unique: true, Size: 255},
{Name: "password", Type: field.TypeString, Nullable: true, Size: 255},
{Name: "is_superuser", Type: field.TypeBool, Default: false},
{Name: "superuser", Type: field.TypeBool, Default: false},
{Name: "activated_on", Type: field.TypeTime, Nullable: true},
{Name: "oidc_issuer", Type: field.TypeString, Nullable: true},
{Name: "oidc_subject", Type: field.TypeString, Nullable: true},
{Name: "default_group_id", Type: field.TypeUUID, Nullable: true},
{Name: "settings", Type: field.TypeJSON, Nullable: true},
}
// UsersTable holds the schema information for the "users" table.
UsersTable = &schema.Table{
Name: "users",
Columns: UsersColumns,
PrimaryKey: []*schema.Column{UsersColumns[0]},
Indexes: []*schema.Index{
{
Name: "user_oidc_issuer_oidc_subject",
Unique: true,
Columns: []*schema.Column{UsersColumns[9], UsersColumns[10]},
},
},
}
// UserGroupsColumns holds the columns for the "user_groups" table.
UserGroupsColumns = []*schema.Column{
{Name: "role", Type: field.TypeEnum, Enums: []string{"user", "owner"}, Default: "user"},
{Name: "user_id", Type: field.TypeUUID},
{Name: "group_id", Type: field.TypeUUID},
}
// UserGroupsTable holds the schema information for the "user_groups" table.
UserGroupsTable = &schema.Table{
Name: "user_groups",
Columns: UserGroupsColumns,
PrimaryKey: []*schema.Column{UserGroupsColumns[1], UserGroupsColumns[2]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "user_groups_users_user",
Columns: []*schema.Column{UserGroupsColumns[1]},
RefColumns: []*schema.Column{UsersColumns[0]},
OnDelete: schema.Cascade,
},
{
Symbol: "user_groups_groups_group",
Columns: []*schema.Column{UserGroupsColumns[2]},
RefColumns: []*schema.Column{GroupsColumns[0]},
OnDelete: schema.Cascade,
},
},
}
// TagEntitiesColumns holds the columns for the "tag_entities" table.
TagEntitiesColumns = []*schema.Column{
{Name: "tag_id", Type: field.TypeUUID},
{Name: "entity_id", Type: field.TypeUUID},
}
// TagEntitiesTable holds the schema information for the "tag_entities" table.
TagEntitiesTable = &schema.Table{
Name: "tag_entities",
Columns: TagEntitiesColumns,
PrimaryKey: []*schema.Column{TagEntitiesColumns[0], TagEntitiesColumns[1]},
ForeignKeys: []*schema.ForeignKey{
{
Symbol: "tag_entities_tag_id",
Columns: []*schema.Column{TagEntitiesColumns[0]},
RefColumns: []*schema.Column{TagsColumns[0]},
OnDelete: schema.Cascade,
},
{
Symbol: "tag_entities_entity_id",
Columns: []*schema.Column{TagEntitiesColumns[1]},
RefColumns: []*schema.Column{EntitiesColumns[0]},
OnDelete: schema.Cascade,
},
},
}
// Tables holds all the tables in the schema.
Tables = []*schema.Table{
APIKeysTable,
AttachmentsTable,
AuthRolesTable,
AuthTokensTable,
EntitiesTable,
EntityFieldsTable,
EntityTemplatesTable,
EntityTypesTable,
ExportsTable,
GroupsTable,
GroupInvitationTokensTable,
MaintenanceEntriesTable,
NotifiersTable,
PasswordResetTokensTable,
TagsTable,
TemplateFieldsTable,
UsersTable,
UserGroupsTable,
TagEntitiesTable,
}
)
func init() {
APIKeysTable.ForeignKeys[0].RefTable = UsersTable
AttachmentsTable.ForeignKeys[0].RefTable = AttachmentsTable
AttachmentsTable.ForeignKeys[1].RefTable = EntitiesTable
AuthRolesTable.ForeignKeys[0].RefTable = AuthTokensTable
AuthTokensTable.ForeignKeys[0].RefTable = UsersTable
EntitiesTable.ForeignKeys[0].RefTable = EntitiesTable
EntitiesTable.ForeignKeys[1].RefTable = EntitiesTable
EntitiesTable.ForeignKeys[2].RefTable = EntityTypesTable
EntitiesTable.ForeignKeys[3].RefTable = GroupsTable
EntityFieldsTable.ForeignKeys[0].RefTable = EntitiesTable
EntityTemplatesTable.ForeignKeys[0].RefTable = EntitiesTable
EntityTemplatesTable.ForeignKeys[1].RefTable = GroupsTable
EntityTypesTable.ForeignKeys[0].RefTable = EntityTemplatesTable
EntityTypesTable.ForeignKeys[1].RefTable = GroupsTable
ExportsTable.ForeignKeys[0].RefTable = GroupsTable
GroupInvitationTokensTable.ForeignKeys[0].RefTable = GroupsTable
MaintenanceEntriesTable.ForeignKeys[0].RefTable = EntitiesTable
NotifiersTable.ForeignKeys[0].RefTable = GroupsTable
NotifiersTable.ForeignKeys[1].RefTable = UsersTable
PasswordResetTokensTable.ForeignKeys[0].RefTable = UsersTable
TagsTable.ForeignKeys[0].RefTable = GroupsTable
TagsTable.ForeignKeys[1].RefTable = TagsTable
TemplateFieldsTable.ForeignKeys[0].RefTable = EntityTemplatesTable
UserGroupsTable.ForeignKeys[0].RefTable = UsersTable
UserGroupsTable.ForeignKeys[1].RefTable = GroupsTable
UserGroupsTable.Annotation = &entsql.Annotation{
Table: "user_groups",
}
TagEntitiesTable.ForeignKeys[0].RefTable = TagsTable
TagEntitiesTable.ForeignKeys[1].RefTable = EntitiesTable
}