class profile_picture(db.Model):
id_user = db.Column(db.Integer, primary_key=True, nullable=False)
id_picture = db.Column(db.Integer, primary_key=True, autoincrement=True)
url_picture = db.Column(db.String(200), nullable=False)
def __repr__(self):
return f"profile_picture: {self.id_user, self.id_picture}"
class level(db.Model):
id_level = db.Column(db.Integer,
primary_key=True,
nullable=False,
autoincrement=True)
level_description = db.Column(db.String(80), nullable=False)
def __repr__(self):
return f"level: {self.id_level}"
class report_type(db.Model):
id_report_type = db.Column(db.Integer,
primary_key=True,
nullable=False,
autoincrement=True)
report_type_description = db.Column(db.String(80), nullable=False)
def __repr__(self):
return f"report_type: {self.id_report_type}"
class language(db.Model):
id_language = db.Column(db.Integer,
primary_key=True,
nullable=False,
autoincrement=True)
language_description = db.Column(db.String(80), nullable=False)
def __repr__(self):
return f"language: {self.id_language}"
class log_login_user(db.Model):
id_user = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
date_created = db.Column(db.DateTime,
default=db.func.current_timestamp(),
primary_key=True)
def __repr__(self):
return f"country: {self.id_user, self.country_iso_2_code, self.date_created}"
class report_text(db.Model):
id_report = db.Column(db.Integer,
db.ForeignKey('report.id_report'),
primary_key=True,
nullable=False,
unique=True)
report_text = db.Column(db.String(50), nullable=False)
date_created = db.Column(db.DateTime, default=db.func.current_timestamp())
def __repr__(self):
return f"report_text: {self.id_report}"
class user_status(db.Model):
id_user = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
user_status = db.Column(db.String(80), nullable=False, primary_key=True)
date_created = db.Column(db.DateTime,
default=db.func.current_timestamp(),
primary_key=True)
def __repr__(self):
return f"user_status: {self.user_status}"
class block(db.Model):
id_user_blocker = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
id_user_blocked = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
date_created = db.Column(db.DateTime, default=db.func.current_timestamp())
def __repr__(self):
return f"id_user_blocker: {self.id_user_blocker, self.id_user_blocked, self.date_created}"
class follower(db.Model):
id_user_followed = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
id_user_following = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
date_created = db.Column(db.DateTime, default=db.func.current_timestamp())
def __repr__(self):
return f"follower: {self.id_user_following}"
class report_status(db.Model):
id_report = db.Column(db.Integer,
db.ForeignKey('report.id_report'),
primary_key=True,
nullable=False,
unique=True)
is_pending = db.Column(db.BOOLEAN, default=False, primary_key=True)
date_created = db.Column(db.DateTime,
default=db.func.current_timestamp(),
primary_key=True,
unique=True)
def __repr__(self):
return f"report_status: {self.id_report, self.is_pending}"
class spoken_language(db.Model):
id_user = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
id_language = db.Column(db.Integer,
db.ForeignKey('language.id_language'),
primary_key=True,
nullable=False)
is_native = db.Column(db.BOOLEAN, default=False, primary_key=True)
id_level = db.Column(db.Integer,
db.ForeignKey('level.id_level'),
nullable=True)
def __repr__(self):
return f"spoken_language: {self.id_language}"
class disabled_account(db.Model):
id = db.Column(db.Integer,
primary_key=True,
nullable=False,
autoincrement=True)
id_user = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
is_disabled = db.Column(db.BOOLEAN, default=False, primary_key=True)
date_created = db.Column(db.DateTime,
default=db.func.current_timestamp(),
primary_key=True)
def __repr__(self):
return f"disabled_account: {self.id_disabled_account}"
class feedback(db.Model):
id_feedback = db.Column(db.Integer,
primary_key=True,
nullable=False,
autoincrement=True)
id_user_receiver = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
id_user_giver = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
date_created = db.Column(db.DateTime, default=db.func.current_timestamp())
feedback_description = db.Column(db.String(140), nullable=False)
def __repr__(self):
return f"feedback: {self.id_feedback}"
class user(db.Model):
id_user = db.Column(db.Integer, primary_key=True, autoincrement=True)
first_name = db.Column(db.String(80), nullable=False)
last_name = db.Column(db.String(80), nullable=False)
birth_date = db.Column(db.DateTime)
email = db.Column(db.String(255), unique=True, nullable=False)
genre = db.Column(db.Integer,
db.ForeignKey('genre.id_genre'),
nullable=False)
topics_descriptions = db.Column(db.String(140), nullable=False)
date_created = db.Column(db.DateTime, default=db.func.current_timestamp())
def __repr__(self):
return f"user: {self.id_user}"
class report(db.Model):
id_report = db.Column(db.Integer,
primary_key=True,
nullable=False,
autoincrement=True,
unique=True)
id_report_type = db.Column(db.Integer,
db.ForeignKey('report_type.id_report_type'),
primary_key=True,
nullable=False)
id_user_reported = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
id_user_reported_by = db.Column(db.Integer,
db.ForeignKey('user.id_user'),
primary_key=True,
nullable=False)
date_created = db.Column(db.DateTime, default=db.func.current_timestamp())
def __repr__(self):
return f"report: {self.id_report}"
class admin(db.Model):
id_admin = db.Column(db.Integer, primary_key=True, autoincrement=True)
first_name = db.Column(db.String(80), nullable=False)
last_name = db.Column(db.String(80), nullable=False)
email = db.Column(db.String(255), unique=True, nullable=False)
password = db.Column(db.String(255))
date_created = db.Column(db.DateTime, default=db.func.current_timestamp())
def __repr__(self):
return f"admin: {self.email}"
class fb_user(db.Model):
fb_user_id = db.Column(db.String(250), primary_key=True, unique=True)
id_user = db.Column(db.Integer, db.ForeignKey('user.id_user'))
def __repr__(self):
return f"user: {self.id_user}"
