import { Entity, Column, PrimaryGeneratedColumn, ManyToOne, JoinColumn } from 'typeorm';
import { Blog } from './blog.entity';

@Entity('blog_translations')
export class BlogTranslation {
  @PrimaryGeneratedColumn({ name: 'translation_id' })
  translationId: number;

  @ManyToOne(() => Blog, blog => blog.translations, { onDelete: 'CASCADE' })
  @JoinColumn({ name: 'blog_id' })
  blog: Blog;

  @Column({ name: 'blog_id' })
  blogId: number;

  @Column({ type: 'varchar', length: 2 }) // 'en' or 'np'
  language: string;

  @Column({ type: 'text', nullable: false, charset: 'utf8mb4', collation: 'utf8mb4_general_ci' }) // Markdown content
  title: string;

  @Column({ type: 'longtext', nullable: false, charset: 'utf8mb4', collation: 'utf8mb4_general_ci' }) // Markdown content
  content: string;
}