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)