from django.db import models
from django.conf import settings


class TUGMember(models.Model):

    real_name = models.CharField(max_length=20)
    phone = models.CharField(max_length=20)
    email = models.EmailField()
    company_name = models.CharField(max_length=30)
    job_title_code = models.CharField(max_length=64)
    job_title_text = models.CharField(max_length=64)
    stage_of_company_use_of_tidb = models.CharField(max_length=64)
    reason_for_application = models.TextField()
    preferred_way_of_sharing = models.JSONField(default=list)
    roles_want_to_play = models.JSONField(default=list)
    wechat_id = models.CharField(max_length=50)
    bio = models.TextField(blank=True, null=True)
    channel = models.CharField(max_length=64, blank=True, null=True)
    referrer = models.CharField(max_length=32, blank=True, null=True)
    user = models.OneToOneField(
        settings.AUTH_USER_MODEL, on_delete=models.DO_NOTHING)
    updated_at = models.DateTimeField(auto_now=True)
    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        db_table = 'pingcap_tug_memebers'
        permissions = (
            ('manage_tug', 'Manage TUG'),
        )