from dostadmin import db
from dostadmin.mixins import TimestampMixin


class FamilyMetrics(TimestampMixin, db.Model):
    __tablename__ = "family_metrics"

    id = db.Column(db.Integer, primary_key=True)
    user_phone = db.Column(db.String(15), nullable=False, unique=True)
    mother_code = db.Column(db.String(50))
    mother_name = db.Column(db.String(50))
    mother_count = db.Column(db.Integer, default=0)
    father_code = db.Column(db.String(50))
    father_count = db.Column(db.Integer, default=0)
    father_name = db.Column(db.String(50))
    child_code = db.Column(db.String(50))
    child_count = db.Column(db.Integer, default=0)
    child_name = db.Column(db.String(50))
    activity_id = db.Column(db.Integer, db.ForeignKey("activities.id"))