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