test
Tables (24)
article
- article_id — INT — Primary key — NOT NULL
- article_type — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- article_content — VARCHAR(1000)
- article_img — VARCHAR(1000)
- artist_channel_artist_id — INT — Foreign key → artist_channel.channel_id — NOT NULL
- bookmark_feed_bookmark_id — INT — NOT NULL
- bookmark_feed_user_user_id — VARCHAR(45) — NOT NULL
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- INDEX — `fk_artist_article_artist_channel1_idx`
- INDEX — `fk_article_user1_idx`
- INDEX — `ffdjkslajfkdsla_idx`
article_comment
- comment_id — INT — Primary key — NOT NULL
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- article_article_id — INT — Foreign key → article.article_id — NOT NULL
- comment_content — VARCHAR(1000)
- INDEX — `fk_article_comment_user1_idx`
- INDEX — `fk_article_comment_article1_idx`
article_comment_comment
- comment_comment_id — INT — Primary key — NOT NULL
- comment_content — VARCHAR(1000)
- article_comment_comment_id — INT — Foreign key → article_comment.comment_id — NOT NULL
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- INDEX — `fk_article_comment_comment_article_comment1_idx`
- INDEX — `fk_article_comment_comment_user1_idx`
- filepath — VARCHAR(500)
- start_time — DATETIME
- end_time — DATETIME
- view_count — INT
- artist_channel_channel_id — INT — Foreign key → artist_channel.channel_id — NOT NULL
- user_user_id — VARCHAR(45) — NOT NULL
- INDEX — `fk_live_artist_channel1_idx`
- INDEX — `fk_live_user1_idx`
article_heart
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- article_article_id — INT — Foreign key → article.article_id — NOT NULL
- INDEX — `fk_user_has_article_article1_idx`
- INDEX — `fk_user_has_article_user1_idx`
artist_channel
- channel_id — INT — Primary key — NOT NULL
- channel_name — VARCHAR(30)
artist_feed
- artist_feed_id — INT — Primary key — NOT NULL
artist_group
- group_id — INT — Primary key — NOT NULL
- group_name_kor — VARCHAR(45)
- group_name_eng — VARCHAR(45)
- artist_id — VARCHAR(45)
artist_search_data
- artist_search_id — INT — Primary key — NOT NULL
- search_keyword — VARCHAR(45) — NOT NULL
- search_artist — VARCHAR(45)
bookmark
- article_article_id — INT — Foreign key → article.article_id — NOT NULL
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- INDEX — `fk_article_has_user_user1_idx`
- INDEX — `fk_article_has_user_article1_idx`
concert
- idconcert_id — INT — Primary key — NOT NULL
- concert_name — VARCHAR(45) — NOT NULL
- concert_ — VARCHAR(45)
fan_feed
- fan_feed_id — INT — Primary key — NOT NULL
fan_signing
- fan_signing_id — INT — Primary key — NOT NULL
- start_time — DATETIME
- end_time — DATETIME
- fan_signing_name — VARCHAR(45)
- fan_signing_content — VARCHAR(1000)
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- artist_channel_channel_id — INT — Foreign key → artist_channel.channel_id — NOT NULL
- INDEX — `fk_fan_signing_user1_idx`
- INDEX — `fk_fan_signing_artist_channel1_idx`
live_chat
- live_chat_id — INT — Primary key — NOT NULL
- live_chat_content — VARCHAR(1000)
- live_chat_date — DATETIME
- live_live_id — INT — NOT NULL
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- INDEX — `fk_live_chat_live1_idx`
- INDEX — `fk_live_chat_user1_idx`
live_comment
- live_comment_id — INT — Primary key — NOT NULL
- live_comment_content — VARCHAR(1000)
- live_comment_date — DATETIME
- live_live_id — INT — NOT NULL
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- INDEX — `fk_live_comment_live1_idx`
- INDEX — `fk_live_comment_user1_idx`
live_heart
- live_live_id — INT — Primary key — NOT NULL
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- INDEX — `fk_user_has_live_live1_idx`
- INDEX — `fk_user_has_live_user1_idx`
notice
- notice_id — INT — Primary key — NOT NULL
- artist_channel_channel_id — INT — Foreign key → artist_channel.channel_id — NOT NULL
- INDEX — `fk_notice_artist_channel1_idx`
online_concert
- online_concert_id — INT — Primary key — NOT NULL
- start_time — DATETIME
- end_time — DATETIME
- online_concert_name — VARCHAR(45)
- online_concert_content — VARCHAR(1000)
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- artist_channel_channel_id — INT — Foreign key → artist_channel.channel_id — NOT NULL
- apply_start_time — DATETIME
- apply_end_time — DATETIME
- INDEX — `fk_fan_signing_user1_idx`
- INDEX — `fk_fan_signing_artist_channel1_idx`
public_broadcast
- public_broadcast_id — INT — Primary key — NOT NULL
- public_broadcast_name — VARCHAR(45)
- public_broadcast_content — VARCHAR(45)
- start_time — DATETIME
- end_time — DATETIME
- apply_start_time — DATETIME
- apply_end_time — DATETIME
- public_broadcast_place — VARCHAR(45)
- capacity — INT
- artist_channel_channel_id — INT — Foreign key → artist_channel.channel_id — NOT NULL
- user_manager_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- INDEX — `fk_public_broadcast_artist_channel1_idx`
- INDEX — `fk_public_broadcast_user1_idx`
user
- user_id — VARCHAR(45) — Primary key — NOT NULL
- user_type — VARCHAR(45) — NOT NULL
- user_name — VARCHAR(45) — NOT NULL
- user_password — VARCHAR(45) — NOT NULL
- user_email — VARCHAR(80) — NOT NULL
- user_tel — VARCHAR(45)
- user_nickname — VARCHAR(45)
- user_birth — DATE
- user_profile_img — VARCHAR(1000)
- user_locked — INT — NOT NULL
- artist_channel_channel_id — INT — Foreign key → artist_channel.channel_id
- google_token — VARCHAR(100)
- INDEX — `fk_user_artist_channel1_idx`
user_has_artist_channel
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- artist_channel_channel_id — INT — Foreign key → artist_channel.channel_id — NOT NULL
- INDEX — `fk_user_has_artist_channel_artist_channel1_idx`
- INDEX — `fk_user_has_artist_channel_user_idx`
user_has_artist_group
- artist_group_group_id — INT — Foreign key → artist_group.group_id — NOT NULL
- INDEX — `fk_user_has_artist_group_artist_group1_idx`
user_has_notice
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- notice_notice_id — INT — Foreign key → notice.notice_id — NOT NULL
- INDEX — `fk_user_has_notice_notice1_idx`
- INDEX — `fk_user_has_notice_user1_idx`
user_has_public_broadcast
- user_user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- public_broadcast_public_broadcast_id — INT — Foreign key → public_broadcast.public_broadcast_id — NOT NULL
- INDEX — `fk_user_has_public_broadcast_public_broadcast1_idx`
- INDEX — `fk_user_has_public_broadcast_user1_idx`
user_notice
- notice_id — INT — Primary key — NOT NULL
- notice_channel — VARCHAR(45) — NOT NULL
- notice_title — VARCHAR(45) — NOT NULL
- notice_link — VARCHAR(45) — NOT NULL