6

SQL Server schema

Subscriptions
Id

RenewalDate
SubscriptionPlans
IsAutoRenewal
Id
IsDeleted
Name
SubscriptionPlanId
DownloadLimit

ResolutionLimit

DeviceLimit

IsDeleted

ManagementRoles
Id

Name

Admin
Id
Payments
EmployeeCode
Users
Id
AccountId Id
AdminRoles BirthDate
PaymentMethod

AdminId CardHolderName
PhoneNumber
RoleId ExpiryDate
PaymentId
CardNumber
SubscriptionId
Accounts CVV
AccountId
Id
IsDeleted
FirstName

LastName

Email

HashPassword

IsDeleted

Categories Profiles
ContentCategories
Id Id
ContentId
Name ProfileName
CategoryId
Isdeleted AvatarPath

IsKid

IsDeleted

UserId

FavProfileContent
UserId

ContentId

ProfileMovieRateings
UserId
ProfileEpRateings
MovieId UserId
Contents EpisodId
Id Seasons
Name Id

Description SeasonNum

Movies ReleaseDate TrailerPath

Id ContentType SeriesId Episods

TrailerPath CertificationId Isdeleted Id

ContentPath Isdeleted ContentPath

DurationTimeInMin Description

ContentId EpNum

Isdeleted EpName

DurationTimeInMin

Series SeasonId
Id
Isdeleted
ContentId

Isdeleted

ContentFilmMakers Certifications
ContentId Id

FilmMakerId Name

RoleId Description

Isdeleted

FilmMakers
FilmRoles
Id
Id
Name
Name
Isdeleted
Isdeleted

FilmMakerRoles
FilmMakerId

FilmRoleId