# institution/models.py
from django.db import models
from django.utils import timezone
from core.models import BaseTimeStampModel, User


class Institution(BaseTimeStampModel):
    user = models.OneToOneField(User, on_delete=models.CASCADE, related_name='institution_profile')
    contact_detail = models.JSONField(null=True, blank=True)
    citizenship = models.CharField(max_length=255, null=True, blank=True)
    nid = models.CharField(max_length=255, null=True, blank=True)
    company_registration_document = models.CharField(max_length=255, null=True, blank=True)
    pan_vat_document = models.CharField(max_length=255, null=True, blank=True)
    pan_number = models.CharField(max_length=50, null=True, blank=True)
    vat_number = models.CharField(max_length=50, null=True, blank=True)
    ceo_detail = models.JSONField(null=True, blank=True)
    is_approved = models.BooleanField(default=False)
    
    class Meta:
        db_table = 'institution'