from django.db import models

# Create your models here.
class Birthday(models.Model):
    username = models.CharField(max_length=20)
    year = models.CharField(max_length=20,default='2021')
    month = models.CharField(max_length=20,default='1')
    day = models.CharField(max_length=20,default='1')

    class Meta:
        db_table = 'birthday'


class VIP(models.Model):
    vipname = models.CharField(max_length=20,default='张三')
    level = models.CharField(max_length=20,default='普通会员')
    score = models.IntegerField(default=0)
    money = models.IntegerField(default=0)

    class Meta:
        db_table = 'VIP'

class User(models.Model):
    realname = models.CharField(max_length=20,default='张三')
    username = models.CharField(max_length=20)
    password = models.CharField(max_length=20)
    email = models.CharField(max_length=20)
    phonenumber = models.CharField(max_length=20)
    gender = models.CharField(max_length=20,default='外星人')
    age = models.CharField(max_length=20,default='20')
    personality = models.CharField(max_length=20,default='伞兵')
    image = models.CharField(max_length=20)
    birthday = models.ForeignKey(Birthday,on_delete=models.CASCADE)
    vip = models.ForeignKey(VIP,on_delete=models.CASCADE)

    class Meta:
        db_table = 'app_user'

class Order(models.Model):
    username = models.CharField(max_length=20)
    movieid = models.IntegerField()
    movietype = models.IntegerField()
    seats = models.CharField(max_length=100)
    theater = models.CharField(max_length=100)
    class Meta:
        db_table = 'app_order'