task-kkj
Tables (6)
TB_CONTENT (CopyOf유저)
- content_id (유저아이디) — int — Primary key — NOT NULL
- content_name (Field2) — varchar
- content_upload_type (Field) — varchar
- content_owner_id (Field3) — int
- content_time (Field4) — time
TB_CONTENT_PLAYLIST_REL (CopyOfCopyOf유저2)
- content_id (유저아이디) — int — Foreign key → TB_CONTENT.content_id — NOT NULL
- playlist_id (유저아이디2) — int — Foreign key → TB_PLAYLIST.playlist_id — NOT NULL
TB_PLAYLIST (CopyOfCopyOf유저)
- playlist_id (유저아이디) — int — Primary key — NOT NULL
- playlist_name (Field) — varchar
- playlist_owner_id (Field2) — int
TB_USER (유저)
- user_id (유저아이디) — int — Primary key — NOT NULL
- user_name (Field) — varchar
- user_login_id (Field2) — varchar
TB_USER_CONTENT_REL (CopyOf유저2)
- user_id (유저아이디) — int — Foreign key → TB_USER.user_id — NOT NULL
- content_id (유저아이디2) — int — Foreign key → TB_CONTENT.content_id — NOT NULL
TB_USER_PLAYLIST_REL (CopyOfCopyOfCopyOf유저2)
- user_id (유저아이디) — int — Foreign key → TB_USER.user_id — NOT NULL
- playlist_id (유저아이디2) — int — Foreign key → TB_PLAYLIST.playlist_id — NOT NULL
- play_count (Field) — int