In one table, a list of users (fields: id, login, password, rights), and the second is a table with video. That is, there will be 10 pieces of video and different users are shown different videos. Maybe 1 video or maybe all 10. It should also be possible for an administrator to add new videos and specify which videos to watch. Who can push ideas? but something in my head does not climb anything

  • three tables. Connection many to many. User table. Table Video. And the connection table is a video user, where only three columns are id, user_id, video_id. - n.osennij

1 answer 1

Первая таблица: id, login, password, role Вторая таблица: id, name_video и т.д. Третья таблица: id, id_user, id_video