Python String Examples

Example #1

File: agency.py Project: o-ozogie/Yves-Saint-Laurent

class Agency(db.Model):
    __tablename__ = 'AGENCY_TB'

    code = db.Column(db.String(20), primary_key=True)
    email = db.Column(db.String(50), nullable=True)
    pw = db.Column(db.String(50), nullable=True)
    name = db.Column(db.String(50), nullable=True)
    kind = db.Column(db.String(50), nullable=True)
    explanation = db.Column(db.Text, nullable=True)

Example #2

File: belong.py Project: o-ozogie/Yves-Saint-Laurent

class Belong(db.Model):
    __tablename__ = 'BELONG_TB'

    agency = db.Column(db.String(20),
                       db.ForeignKey("AGENCY_TB.code"),
                       primary_key=True)
    interviewer = db.Column(db.String(50),
                            db.ForeignKey("INTERVIEWER_TB.email"),
                            primary_key=True)

Example #3

class Question(db.Model):
    __tablename__ = 'QUESTION_TB'

    id = db.Column(db.Integer, primary_key=True)
    num = db.Column(db.Integer, nullable=True)
    content = db.Column(db.String(100), nullable=True)
    type = db.Column(db.Integer, nullable=True)
    interview = db.Column(db.Integer, db.ForeignKey("INTERVIEW_TB.interview_id"), nullable=True)

Example #4

File: access.py Project: o-ozogie/Yves-Saint-Laurent

class Access(db.Model):
    __tablename__ = 'ACCESS_TB'

    interviewer = db.Column(db.String(50),
                            db.ForeignKey("INTERVIEWER_TB.email"),
                            primary_key=True)
    interview = db.Column(db.Integer,
                          db.ForeignKey("INTERVIEW_TB.interview_id"),
                          primary_key=True)

Example #5

class Evaluation(db.Model):
    __tablename__ = 'EVALUATION_TB'

    id = db.Column(db.Integer, primary_key=True)
    interview = db.Column(db.Integer,
                          db.ForeignKey("INTERVIEW_TB.interview_id"),
                          nullable=True)
    interviewer = db.Column(db.String(50),
                            db.ForeignKey("INTERVIEWER_TB.email"),
                            nullable=True)
    interviewee = db.Column(db.Integer,
                            db.ForeignKey("INTERVIEWEE_TB.student_code"),
                            nullable=True)
    question = db.Column(db.Integer,
                         db.ForeignKey("QUESTION_TB.id"),
                         nullable=True)
    answer = db.Column(db.Text, nullable=True)

Example #6

class Interviewee(db.Model):
    __tablename__ = 'INTERVIEWEE_TB'

    student_code = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50), nullable=True)
    interview = db.Column(db.Integer, db.ForeignKey("INTERVIEW_TB.interview_id"), nullable=True)

Example #7

class Interviewer(db.Model):
    __tablename__ = 'INTERVIEWER_TB'

    email = db.Column(db.String(50), primary_key=True)
    pw = db.Column(db.String(50), nullable=True)
    name = db.Column(db.String(50), nullable=True)