| | | 1 | | // SPDX-FileCopyrightText: 2026 Alper Çelik <[email protected]> |
| | | 2 | | // |
| | | 3 | | // SPDX-License-Identifier: AGPL-3.0-or-later |
| | | 4 | | |
| | | 5 | | using System.ComponentModel.DataAnnotations; |
| | | 6 | | using System.ComponentModel.DataAnnotations.Schema; |
| | | 7 | | |
| | | 8 | | using Api.Auth.Models; |
| | | 9 | | |
| | | 10 | | using Microsoft.EntityFrameworkCore; |
| | | 11 | | using Microsoft.EntityFrameworkCore.Metadata.Builders; |
| | | 12 | | |
| | | 13 | | namespace Api.Works.Models; |
| | | 14 | | |
| | | 15 | | [Table("work_tags")] |
| | | 16 | | [Index(nameof(OwnerId), nameof(TagName), IsUnique = true)] |
| | | 17 | | public class WorkTag : IEntityMetadata |
| | | 18 | | { |
| | | 19 | | [Key] |
| | | 20 | | public Guid Id { get; set; } |
| | | 21 | | public int RowVersion { get; set; } |
| | | 22 | | public NodaTime.Instant MetadataAddedAt { get; set; } |
| | | 23 | | public NodaTime.Instant MetadataUpdatedAt { get; set; } |
| | | 24 | | |
| | | 25 | | public Guid OwnerId { get; set; } |
| | | 26 | | |
| | | 27 | | public required string TagType { get; set; } |
| | | 28 | | |
| | | 29 | | public required string TagName { get; set; } |
| | | 30 | | |
| | | 31 | | // Navigation Properties |
| | 0 | 32 | | public List<WorkTag_Work> WorkTagWorks { get; set; } = null!; |
| | 0 | 33 | | public List<Work> Works { get; set; } = null!; |
| | 0 | 34 | | public User Owner { get; set; } = null!; |
| | | 35 | | |
| | | 36 | | } |
| | | 37 | | |
| | | 38 | | |
| | | 39 | | [Table("work_tag___tag")] |
| | | 40 | | [PrimaryKey(nameof(WorkId), nameof(WorkTagId))] |
| | | 41 | | public class WorkTag_Work |
| | | 42 | | { |
| | | 43 | | public Guid WorkId { get; set; } |
| | | 44 | | public Guid WorkTagId { get; set; } |
| | | 45 | | |
| | | 46 | | // Navigation Properties |
| | | 47 | | public Work Work { get; set; } = null!; |
| | | 48 | | public WorkTag WorkTag { get; set; } = null!; |
| | | 49 | | } |
| | | 50 | | |
| | | 51 | | public class WorkTagTypeConfiguration : IEntityTypeConfiguration<WorkTag> |
| | | 52 | | { |
| | | 53 | | void IEntityTypeConfiguration<WorkTag>.Configure(EntityTypeBuilder<WorkTag> builder) |
| | | 54 | | { |
| | | 55 | | builder |
| | | 56 | | .HasMany(wt => wt.Works) |
| | | 57 | | .WithMany(w => w.WorkTags) |
| | | 58 | | .UsingEntity(typeof(WorkTag_Work)); |
| | | 59 | | } |
| | | 60 | | } |