DB_KickOff

Tables (12)

Concert_fee (Untitled6)

  • Seat_grade (Key) — varchar(50) — Primary key — NOT NULL — key 두개 조합
  • Event_id (Key2) — int(10) — Foreign key → Discount_info.Event_id — NOT NULL
  • Seat_price (Field) — int(7)

Discount_info (Untitled8)

  • Event_id (Key2) — int(10) — Foreign key → Event.Event_id — NOT NULL
  • Soldier (Field) — float(2)
  • Local (Field2) — float(2)
  • Student (Field4) — float)2)

Event (Untitled)

  • Event_id (Key) — int(10) — Primary key — NOT NULL
  • Venue_id (Key2) — int(50) — Foreign key → Venue.Venue_id — NOT NULL
  • Genre_id (Key3) — int(10) — Foreign key → Genre.Genre_id — NOT NULL
  • Start_time (Field3) — datetime — NOT NULL
  • Finish_time (Field4) — datetime — NOT NULL
  • Event_type (Field2) — int(2) — NOT NULL — 콘서트vs fest
  • Event_link (Field6) — varchar(100)

Festival_fee (CopyOfUntitled6)

  • Event_id (Key22) — int(10) — Foreign key → Discount_info.Event_id — NOT NULL
  • fest_price (Field) — int(7)

Genre (Untitled11)

  • Genre_id (Key) — int(10) — Primary key — NOT NULL
  • Genre_name (Field) — varchar(50) — NOT NULL

Review (Untitled9)

  • Participate_id (Key2) — int(10) — Foreign key → participate.Participate_id — NOT NULL
  • star_ponit (Field) — float(1)
  • one_line (Field2) — varchar(200)
  • Image_link (Field3) — varchar(100)

Singer (Untitled2)

  • singer_id (Key) — int(10) — Primary key — NOT NULL
  • Event_id (Key2) — int(10) — Foreign key → Event.Event_id — NOT NULL
  • Genre_id (Key3) — int(10) — Foreign key → Genre.Genre_id — NOT NULL
  • song_id (Field) — varchar(10) — NOT NULL
  • Company (Field3) — varchar(50)

Song (Untitled4)

  • Song_id (Key2) — int(10) — Primary key — NOT NULL
  • Genre_id (Key3) — int(10) — Foreign key → Genre.Genre_id — NOT NULL
  • singer_id (Key4) — int(10) — Foreign key → Singer.singer_id — NOT NULL
  • song_id (Key) — int(10) — NOT NULL
  • play_time (Field) — datetime — NOT NULL — datetime확인
  • link (Field2) — varchar(100)

Song_list (Untitled10)

  • Song_list_id (Key) — int(10) — Primary key — NOT NULL
  • singer_id (Key3) — int(10) — Foreign key → Singer.singer_id — NOT NULL
  • Song_id (Key2) — int(10) — Foreign key → Song.Song_id — NOT NULL
  • Event_id (Key4) — int(10) — Foreign key → Event.Event_id — NOT NULL

User (Untitled5)

  • User_id (Key) — int(9) — Primary key — NOT NULL
  • Genre_id (Key2) — int(10) — Foreign key → Genre.Genre_id — NOT NULL
  • Gender (Field) — Boolean — 무응답 고려
  • Birth_day (Field2) — datetime — NOT NULL — age
  • user_city (Field3) — varchar(50) — NOT NULL

Venue (Untitled3)

  • Venue_id (Key) — int(10) — Primary key — NOT NULL
  • Capacity (Field) — int(7) — 광장, 공원 >>null
  • In_out door (Field5) — boolean
  • city (Field2) — varchar(50) — NOT NULL
  • convince (Field3) — int(2) — 편의점 갯수
  • Smoking (Field4) — int(2) — 흡연장 개수
  • Locker (Field6) — int(3)
  • Picnic (Field7) — int(8) — 제곱미터
  • Wheelchair_left (Field8) — int(2) — 리프트 설치여부
  • Wheelchair_Ramp (Field9) — int(2) — 경사로 설치여부
  • Barrier_free (Field10) — int(3)

participate (Untitled7)

  • Participate_id (Key2) — int(10) — Primary key — NOT NULL
  • concert_id (Key) — int(10) — Foreign key → Event.Event_id — NOT NULL
  • User_id (Key3) — int(9) — Foreign key → User.User_id — NOT NULL