MIS
Tables (6)
Channel (Untitled)
- ID (Key) — int — Primary key — NOT NULL
- MyMovie (Key2) — int — Foreign key → Movie.ID — NOT NULL
- ChannelName (Field) — varchar
- Description (Field2) — varchar
Member (Untitled6)
- ID (Key) — int — Primary key — NOT NULL
- Name (Field) — varchar
- Email (Field2) — varchar
- ResiterDate (Field3) — date
Movie (Untitled3)
- ID (Key) — int — Primary key — NOT NULL
- ChannelID (Key2) — int — Foreign key → Channel.ID — NOT NULL
- Title (Field2) — varchar
- Description (Field3) — varchar
- UploadDate (Field) — date
Subscribe_Event (Untitled2)
- MemberID (Key3) — int — Foreign key → Member.ID — NOT NULL
- ChannelID (Key2) — int — Foreign key → Channel.ID — NOT NULL
Tag (Untitled5)
- ID (Key) — int — Primary key — NOT NULL
- Tag (Field) — varchar
Tag_Movie (Untitled4)
- MovieID (Key2) — int — Foreign key → Movie.ID — NOT NULL
- TagID (Key) — int — Foreign key → Tag.ID — NOT NULL