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