models.py

from init import app
from flask import Flask, request, json, Response
from flask_sqlalchemy import SQLAlchemy
import config

db = SQLAlchemy(app)

user_in_group = db.Table('user_in_group',
    db.Column('user_id',db.Integer,db.ForeignKey('user.id'),primary_key=True),
    db.Column('group_id',db.Integer,db.ForeignKey('group.id'),primary_key=True) 
)

user_admin_group = db.Table('user_admin_group',
    db.Column('user_id',db.Integer,db.ForeignKey('user.id'),primary_key=True),
    db.Column('group_id',db.Integer,db.ForeignKey('group.id'),primary_key=True) 
)

user_with_group_invitation = db.Table('user_with_group_invitation',
    db.Column('user_id',db.Integer,db.ForeignKey('user.id'),primary_key=True),
    db.Column('group_id',db.Integer,db.ForeignKey('group.id'),primary_key=True) 
)

user_quit_group = db.Table('user_quit_group',
    db.Column('user_id',db.Integer,db.ForeignKey('user.id'),primary_key=True),
    db.Column('group_id',db.Integer,db.ForeignKey('group.id'),primary_key=True) 
)

user_with_assign_invitation = db.Table('user_with_assign_invitation',
    db.Column('user_id',db.Integer,db.ForeignKey('user.id')),
    db.Column('assign_id',db.Integer,db.ForeignKey('assignment.id')) 
)

user_agree_pendingTask = db.Table('user_agree_pendingTask',
    db.Column('user_id',db.Integer,db.ForeignKey('user.id'),primary_key=True),
    db.Column('pending_id',db.Integer,db.ForeignKey('pendingtask.id'),primary_key=True) 
)

user_disagree_pendingTask = db.Table('user_disagree_pendingTask',
    db.Column('user_id',db.Integer,db.ForeignKey('user.id'),primary_key=True),
    db.Column('pending_id',db.Integer,db.ForeignKey('pendingtask.id'),primary_key=True) 
)

user_take_assign = db.Table('user_take_assign',
    db.Column('user_id',db.Integer,db.ForeignKey('user.id')),
    db.Column('assign_id',db.Integer,db.ForeignKey('assignment.id')) 
)

class User(db.Model):
    __tablename__ = 'user'
    id = db.Column(db.Integer, autoincrement = True,primary_key=True)
    name = db.Column(db.String(20))
    openID = db.Column(db.String(50))
    taskList = db.relationship('Task', backref = 'user')
    ownAssignList = db.relationship('Assignment', backref = 'user')
    pendingTaskList = db.relationship('PendingTask',backref = 'user')
    
    groupList = db.relationship('Group',secondary= user_in_group,backref = db.backref('userList'))
    adminGroupList = db.relationship('Group',secondary= user_admin_group,backref = db.backref('adminList'))
    assignList = db.relationship('Assignment',secondary= user_take_assign,backref = db.backref('executorList'))
    groupInvitationList = db.relationship('Group',secondary= user_with_group_invitation,backref = db.backref('invitingList'))
    noticeList = db.relationship('Group',secondary= user_quit_group,backref = db.backref('quiterList'))
    assignInvitationList = db.relationship('Assignment',secondary= user_with_assign_invitation,backref = db.backref('invitingList'))

class Group(db.Model):
    __tablename__ = 'group'
    id = db.Column(db.Integer, autoincrement = True, primary_key=True)
    name = db.Column(db.String(20))
    owner_id = db.Column(db.Integer)
    taskList = db.relationship('Task',backref = 'group')
    pendingTaskList = db.relationship('PendingTask',backref = 'group')
    assignList = db.relationship('Assignment',backref = 'group')
    
class Task(db.Model):
    __tablename__ = 'task'
    id = db.Column(db.Integer, autoincrement = True, primary_key=True)
    startTime = db.Column(db.String(20))
    endTime = db.Column(db.String(20))
    content = db.Column(db.Text)
    name = db.Column(db.String(20))
    group_id = db.Column(db.Integer,db.ForeignKey('group.id'))
    user_id = db.Column(db.Integer,db.ForeignKey('user.id'))
    
class PendingTask(db.Model):
    __tablename__ = 'pendingtask'
    id = db.Column(db.Integer, autoincrement = True, primary_key=True)
    startTime = db.Column(db.String(20))
    endTime = db.Column(db.String(20))
    content = db.Column(db.Text)
    name = db.Column(db.String(20))
    agreeNum = db.Column(db.Integer)
    disagreeNum = db.Column(db.Integer)
    group_id = db.Column(db.Integer,db.ForeignKey('group.id'))
    user_id = db.Column(db.Integer,db.ForeignKey('user.id'))
    
    agreeList = db.relationship('User',secondary= user_agree_pendingTask,backref = db.backref('agreeList'))
    disagreeList = db.relationship('User',secondary= user_disagree_pendingTask,backref = db.backref('disagreeList'))
    
class Assignment(db.Model):
    __tablename__ = 'assignment'
    id = db.Column(db.Integer, autoincrement = True, primary_key=True)
    startTime = db.Column(db.String(20))
    endTime = db.Column(db.String(20))
    content = db.Column(db.Text)
    name = db.Column(db.String(20))
    category = db.Column(db.Integer)
    prior = db.Column(db.Integer)
    group_id = db.Column(db.Integer,db.ForeignKey('group.id'))
    publisher_id = db.Column(db.Integer,db.ForeignKey('user.id'))
    
db.create_all()