ticket101

테이블 (7)

가수데이터 (ArtistsTable)

  • artist_id — VARCHAR — 기본 키 — NOT NULL
  • artist_name — VARCHAR
  • artist_num — INT
  • genre — VARCHAR

공연 태그 (PerformancesTable_tag)

  • performance_id — VARCHAR — 외래 키 → 공연데이터.performance_id — NOT NULL
  • performance_value — VARCHAR

공연데이터 (PerformancesTable)

  • performance_id — VARCHAR — 기본 키 — NOT NULL
  • age — INT
  • city — VARCHAR
  • start_date — DATE
  • end_date — DATE
  • genre — VARCHAR
  • image — VARCHAR
  • link — VARCHAR
  • location — VARCHAR
  • price — VARCHAR
  • site — VARCHAR
  • title — VARCHAR

사용자 추천 (userRecommend)

  • userid — VARCHAR — 외래 키 → 회원사전취향.userid — NOT NULL
  • performance_id — VARCHAR — 외래 키 → 공연데이터.performance_id — NOT NULL

영화데이터 (MoviesTable)

  • movie_id — VARCHAR — 기본 키 — NOT NULL
  • country — VARCHAR
  • genre — VARCHAR
  • movie_num — INT
  • movie_year — VARCHAR
  • title — VARCHAR

즐겨찾기 (favoritesTable)

  • userid — VARCHAR — 기본 키 — NOT NULL
  • performance_id — VARCHAR — 외래 키 → 공연데이터.performance_id — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • title — VARCHAR
  • image — VARCHAR

회원사전취향 (SurveyTable)

  • userid — VARCHAR — 기본 키 — NOT NULL
  • artist_id — VARCHAR — 외래 키 → 가수데이터.artist_id — NOT NULL
  • movie_id — VARCHAR — 외래 키 → 영화데이터.movie_id — NOT NULL
  • age — INT
  • artist_genre_number — INT
  • movie_genre_number — INT
  • user_genre — VARCHAR
  • city — VARCHAR
  • gender — VARCHAR