Create Python backend APIs connected with a database

API 1 - Create_user
Mandatory Inputs
username - varchar of maximum length 10, minimum 8 - should be unique
Outputs
user_id
created_timestamp
API 2 - Create_tweets
Mandatory Inputs
user_id
Text of max length 140 characters, minimum length 2
Outputs:
Tweet_id
created_timestamp
API 3 - Read tweets of a user not older than a specific date
Mandatory Inputs
Username
Date
Outputs
Count of tweets greater than given date
List of tweets
API 4 - Delete_tweets
Mandatory Inputs
Username
Outputs
No of tweets deleted
Text and id of tweets deleted

Insert/Delete new tweets to ten tables in async fashion -> asyncio
Read existing tweets from any one table
Error scenarios to be handled
Secure the APIs with jwt