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