project DB

Tables (7)

CATEGORIES (Untitled3)

  • category_id (Key) — Primary key — NOT NULL
  • videoid (Key2) — Foreign key → VIDEOS.videoid — NOT NULL

FRIEND_LIST (Untitled5)

  • userid (Key) — Foreign key → USER PROFILE.userid — NOT NULL
  • friendid (Field)

RECENTLY VIEWED (Untitled4)

  • videoid (Key2) — Foreign key → VIDEOS.videoid — NOT NULL
  • userid (Key22) — Foreign key → VIDEOS.userid — NOT NULL
  • viewed_date (Field)

USER PROFILE (Untitled)

  • userid (Key) — Primary key — NOT NULL
  • username (Field)
  • pw (Field3)
  • certificates (Field4)
  • email (Field5)
  • indate (Field6)

USER_MESSAGES (Untitled7)

  • message_id (Key2) — Primary key — NOT NULL
  • userid (Key) — Foreign key → USER PROFILE.userid — NOT NULL
  • message_content (Field)
  • sender_id (Field2)
  • indate (Field3)

VIDEOS (Untitled2)

  • videoid (Key) — Primary key — NOT NULL
  • userid (Key2) — Foreign key → USER PROFILE.userid — NOT NULL
  • title (Field)
  • description (Field2)
  • indate (Field3)
  • tmp_name (Field4)
  • file_name (Field5)
  • hits (Field6)
  • tags (Field7)

VIDEO_COMMENTS (Untitled6)

  • comment_id (Key3) — Primary key — NOT NULL
  • videoid (Key) — Foreign key → VIDEOS.videoid — NOT NULL
  • userid (Key2) — Foreign key → VIDEOS.userid — NOT NULL
  • reply_id (Field3)
  • comment_content (Field)
  • indate (Field2)