1from src import db 

2 

3 

4class ExternalModel(db.Model): 

5 """ 

6 External service Model for storing user service related details 

7 """ 

8 __tablename__ = "external_service" 

9 __table_args__ = ( 

10 db.UniqueConstraint('user_id', 'service_name', 

11 name='unique_userID_serviceName'), 

12 ) 

13 service_id = db.Column(db.Integer, primary_key=True, 

14 autoincrement=True, index=True) 

15 user_id = db.Column(db.Integer, db.ForeignKey( 

16 "user.user_id", ondelete="CASCADE"), nullable=False) 

17 service_name = db.Column(db.String(45), nullable=False) 

18 access_token = db.Column(db.Text, default=None) 

19 refresh_token = db.Column(db.Text, default=None)