3.1) Design database schema for input form, for video with customization

[PhuocOng]

• 2 thằng viết riêng design schema, rồi gửi draft vào đây

[phuc-nguyen-tran]

**Database: DynamoDB

NoSQL, Fast, Scalable

TABLE**

VideoPart

Partition Key: ID Sort Key: UserID (can be email if use auth library, or userID if do auth on our own) YouTube link: String (200) Cut detail: data type: map { start_sec: int, end_sec: int, customization: int, default = 0, min = 0, required }

User (if do auth on our own - alternative library: firebase, clerk (rec))

Partition Key: UserID, int, pk, required, auto increment Sort Key: Email: string (100), unique, non-null (no email type in dynamodb - see this: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.NamingRulesDataTypes.html) Password: string (100) (hashed the password)

@PhuocOng review nhe!

[phuc-nguyen-tran]

New Feature

1. Playlist

• Create a new table called Playlist Table with partition key as auto-increment id and sort key as userID (or email if used clerk). Fields should be a list of video part id and customization (loop the whole playlist again)
• If add a video to a playlist, also add it to video part table