3조

테이블 (14)

artist (Untitled2)

  • idx (Key) — 기본 키 — NOT NULL
  • artist_name (Field)
  • artist_img (Field2)
  • artist_description (Field3)
  • artist_type (Field4)

artist_list (Untitled4)

  • id (Key) — 외래 키 → events.event_id — NOT NULL
  • idx (Key2) — 외래 키 → artist.idx — NOT NULL

book_mark (Untitled10)

  • user_id (Key) — 외래 키 → users.user_id — NOT NULL
  • idx (Key2) — 외래 키 → artist.idx — NOT NULL
  • id (Key3) — 외래 키 → events.event_id — NOT NULL
  • category_code (Key4) — 외래 키 → category.category_code — NOT NULL

category (Untitled6)

  • category_code (Key) — 기본 키 — NOT NULL
  • category_name (Field)

community (Untitled12)

  • comunity_idx (Key) — 기본 키 — NOT NULL
  • title (Field)
  • content (Field2)
  • user_id (Key2) — 외래 키 → users.user_id — NOT NULL
  • id (Key3) — 외래 키 → events.event_id — NOT NULL

events (Untitled3)

  • event_id (Key) — 기본 키 — NOT NULL
  • event_title (Field)
  • event_description (Field5)
  • start_date (Field6)
  • end_date (Field7)
  • price (Field8)
  • category_code (Key2) — 외래 키 → category.category_code — NOT NULL
  • venues_id (Key3) — 외래 키 → venues.venues_id — NOT NULL
  • platform_code (Key4) — 외래 키 → platform.platform_code — NOT NULL
  • ranking (Field2)

events_schedules (Untitled8)

  • idx (Key) — 기본 키 — NOT NULL
  • id (Key2) — 외래 키 → events.event_id — NOT NULL
  • venues_id (Key3) — 외래 키 → venues.venues_id — NOT NULL
  • platform_code (Key4) — 외래 키 → platform.platform_code — NOT NULL
  • open_date (Field)
  • ticket_url (Field2)
  • openYn (Field3)

platform (Untitled5)

  • platform_code (Key) — 기본 키 — NOT NULL
  • platform_name (Field)
  • platform_url (Field2)

reserved_ticket (Untitled7)

  • user_id (Key) — 외래 키 → users.user_id — NOT NULL
  • id (Key2) — 외래 키 → events.event_id — NOT NULL
  • seat_num (Field)

review (Untitled13)

  • review_index (Key) — 기본 키 — NOT NULL
  • user_id (Key3) — 외래 키 → users.user_id — NOT NULL
  • id (Key2) — 외래 키 → events.event_id — NOT NULL
  • timestamp (Field)
  • review (Field2)
  • star_rate (Field3)

seat_info (Untitled11)

  • seat_id (Key2) — 기본 키 — NOT NULL
  • venues_id (Key) — 외래 키 → venues.venues_id — NOT NULL
  • 360_img (Field)
  • seat_num (Field2)

seat_review (Untitled14)

  • seat_review_idx (Key3) — 기본 키 — NOT NULL
  • user_id (Key) — 외래 키 → users.user_id — NOT NULL
  • seat_id (Key2) — 외래 키 → seat_info.seat_id — NOT NULL
  • timestamp (Field)
  • review (Field2)
  • star_rate (Field3)

users (Untitled)

  • user_id (Key) — 기본 키 — NOT NULL
  • email (Field2)
  • password (Field)
  • name (Field3)
  • create_at (Field4)
  • gender (Field5)
  • B_date (Field6)

venues (Untitled9)

  • venues_id (Key) — 기본 키 — NOT NULL
  • venues_name (Field)
  • venues_location (Field2)
  • seat_count (Field3)
  • open_time (Field4)
  • close_time (Field5)