conn2

Tables (28)

aisle_edges

  • id — BIGINT — Primary key — NOT NULL
  • from_node_id — BIGINT — NOT NULL
  • to_node_id — BIGINT — NOT NULL
  • distance — DECIMAL(10, 2) — NOT NULL
  • weight — DECIMAL(10, 2) — NOT NULL
  • edge_type — VARCHAR(30) — NOT NULL — walkway, stairs_up, stairs_down, within_section, cross_section, cross_block
  • is_bidirectional — TINYINT(1)
  • estimated_seconds — INT
  • is_wheelchair_accessible — TINYINT(1)

aisle_nodes

  • id — BIGINT — Primary key — NOT NULL
  • hall_id — BIGINT — NOT NULL
  • node_type — VARCHAR(30) — NOT NULL — gate, ring_junction, block_boundary, section_entry, aisle_point, seat_group
  • name — VARCHAR(100) — NOT NULL
  • block_id — BIGINT
  • section_id — BIGINT
  • gate_id — BIGINT
  • angle — DECIMAL(5, 2)
  • radius — DECIMAL(10, 2)
  • x_coordinate — DECIMAL(10, 2) — NOT NULL
  • y_coordinate — DECIMAL(10, 2) — NOT NULL
  • floor_level — INT
  • icon_type — VARCHAR(30)

announcements

  • id — BIGINT — Primary key — NOT NULL
  • admin_name — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — VARCHAR(500)
  • is_pinned — TINYINT(1)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

artists

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • profile_image — VARCHAR(500)
  • created_at — TIMESTAMP

blocks

  • id — BIGINT — Primary key — NOT NULL
  • hall_id — BIGINT — NOT NULL
  • block_code — VARCHAR(10) — NOT NULL
  • block_name — VARCHAR(50) — NOT NULL
  • color_hex — VARCHAR(7)
  • start_angle — DECIMAL(5, 2)
  • end_angle — DECIMAL(5, 2)
  • direction_indicator — VARCHAR(20)

concert_artists

  • id — BIGINT — Primary key — NOT NULL
  • concert_id — BIGINT — NOT NULL
  • artist_id — BIGINT — NOT NULL
  • role — VARCHAR(50)
  • display_order — INT

concert_schedules

  • id — BIGINT — Primary key — NOT NULL
  • concert_id — BIGINT — NOT NULL
  • schedule_date — DATE — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME
  • round_number — INT
  • ticket_status — VARCHAR(20) — on_sale, sold_out, ended

concerts

  • id — BIGINT — Primary key — NOT NULL
  • hall_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • poster_image — VARCHAR(500)
  • genre — VARCHAR(50)
  • age_rating — VARCHAR(20)
  • running_time_minutes — INT
  • intermission_minutes — INT
  • description — TEXT
  • status — VARCHAR(20) — upcoming, ongoing, ended, cancelled
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

gates

  • id — BIGINT — Primary key — NOT NULL
  • hall_id — BIGINT — NOT NULL
  • gate_code — VARCHAR(10) — NOT NULL
  • gate_name — VARCHAR(50) — NOT NULL
  • floor_level — INT — NOT NULL
  • angle — DECIMAL(5, 2)
  • x_coordinate — DECIMAL(10, 2) — NOT NULL
  • y_coordinate — DECIMAL(10, 2) — NOT NULL
  • primary_block_id — BIGINT
  • has_elevator — TINYINT(1)
  • has_escalator — TINYINT(1)

location_share_requests

  • id — BIGINT — Primary key — NOT NULL
  • requester_id — BIGINT — NOT NULL
  • target_user_id — BIGINT — NOT NULL
  • group_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — pending, accepted, rejected, expired
  • created_at — TIMESTAMP
  • responded_at — TIMESTAMP

mate_group_members

  • id — BIGINT — Primary key — NOT NULL
  • group_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — invited, accepted, rejected
  • is_sharing_location — TINYINT(1)
  • last_latitude — DECIMAL(10, 7)
  • last_longitude — DECIMAL(10, 7)
  • location_updated_at — TIMESTAMP
  • joined_at — TIMESTAMP

mate_groups

  • id — BIGINT — Primary key — NOT NULL
  • owner_user_id — BIGINT — NOT NULL
  • concert_schedule_id — BIGINT — NOT NULL
  • group_name — VARCHAR(50)
  • created_at — TIMESTAMP

mates

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • mate_user_id — BIGINT — NOT NULL
  • nickname — VARCHAR(20)
  • created_at — TIMESTAMP

navigation_templates

  • id — BIGINT — Primary key — NOT NULL
  • edge_type — VARCHAR(30) — NOT NULL
  • maneuver — VARCHAR(30) — NOT NULL — go_straight, turn_left, turn_right, stairs_up, stairs_down, arrive
  • template_ko — VARCHAR(255) — NOT NULL
  • template_en — VARCHAR(255)

notifications

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • notification_type — VARCHAR(30) — NOT NULL — location_share_request, concert_reminder, mate_invitation, system
  • title — VARCHAR(100)
  • message — VARCHAR(500)
  • reference_type — VARCHAR(50)
  • reference_id — BIGINT
  • is_read — TINYINT(1)
  • created_at — TIMESTAMP

popular_venues

  • id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT — NOT NULL
  • rank_position — INT — NOT NULL
  • search_count — INT
  • updated_at — TIMESTAMP

search_histories

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • search_type — VARCHAR(20) — NOT NULL — venue, mate
  • keyword — VARCHAR(100)
  • target_venue_id — BIGINT
  • target_user_id — BIGINT
  • created_at — TIMESTAMP

seat_nearest_nodes

  • seat_id — BIGINT — Primary key — NOT NULL
  • nearest_node_id — BIGINT — NOT NULL
  • distance_to_node — DECIMAL(10, 2) — NOT NULL

seats

  • id — BIGINT — Primary key — NOT NULL
  • section_id — BIGINT — NOT NULL
  • row_name — VARCHAR(10) — NOT NULL
  • seat_number — INT — NOT NULL
  • display_name — VARCHAR(50) — NOT NULL
  • angle — DECIMAL(5, 2)
  • radius — DECIMAL(10, 2)
  • x_coordinate — DECIMAL(10, 2) — NOT NULL
  • y_coordinate — DECIMAL(10, 2) — NOT NULL
  • seat_type — VARCHAR(20) — regular, wheelchair, companion, restricted_view

sections

  • id — BIGINT — Primary key — NOT NULL
  • hall_id — BIGINT — NOT NULL
  • block_id — BIGINT — NOT NULL
  • section_number — INT — NOT NULL
  • display_name — VARCHAR(20) — NOT NULL
  • ring_position — VARCHAR(20) — inner, middle, outer
  • center_angle — DECIMAL(5, 2)
  • start_angle — DECIMAL(5, 2)
  • end_angle — DECIMAL(5, 2)
  • inner_radius — DECIMAL(10, 2)
  • outer_radius — DECIMAL(10, 2)
  • seat_capacity — INT
  • color_hex — VARCHAR(7)

tickets

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • concert_schedule_id — BIGINT — NOT NULL
  • seat_id — BIGINT — NOT NULL
  • floor_level — INT
  • block_name — VARCHAR(20)
  • section_name — VARCHAR(20)
  • row_name — VARCHAR(10)
  • seat_number — INT
  • seat_display_name — VARCHAR(50)
  • booking_number — VARCHAR(50) — NOT NULL
  • booking_date — TIMESTAMP
  • ticket_price — DECIMAL(10, 2)
  • status — VARCHAR(20) — booked, cancelled, used

today_concert_venues

  • id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT — NOT NULL
  • concert_date — DATE — NOT NULL
  • concert_count — INT

user_social_accounts

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • provider — VARCHAR(20) — NOT NULL — kakao, naver, google
  • provider_user_id — VARCHAR(100) — NOT NULL
  • access_token — VARCHAR(500)
  • refresh_token — VARCHAR(500)
  • token_expires_at — TIMESTAMP
  • created_at — TIMESTAMP

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • profile_image — VARCHAR(500)
  • status — VARCHAR(20) — active, inactive, banned
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

venue_congestion

  • id — BIGINT — Primary key — NOT NULL
  • hall_id — BIGINT — NOT NULL
  • concert_schedule_id — BIGINT
  • area_name — VARCHAR(50)
  • congestion_level — VARCHAR(20) — low, medium, high, very_high
  • estimated_wait_minutes — INT
  • updated_at — TIMESTAMP

venue_facilities

  • id — BIGINT — Primary key — NOT NULL
  • hall_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • facility_type — VARCHAR(30) — NOT NULL — restroom_m, restroom_f, shop, locker, etc
  • floor_level — INT
  • near_gate_id — BIGINT
  • x_coordinate — DECIMAL(10, 2) — NOT NULL
  • y_coordinate — DECIMAL(10, 2) — NOT NULL
  • icon_type — VARCHAR(30)

venue_halls

  • id — BIGINT — Primary key — NOT NULL
  • venue_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • center_x — DECIMAL(10, 2)
  • center_y — DECIMAL(10, 2)
  • layout_type — VARCHAR(20) — circular, semicircular, rectangular
  • inner_radius — DECIMAL(10, 2)
  • middle_radius — DECIMAL(10, 2)
  • outer_radius — DECIMAL(10, 2)
  • indoor_map_image — VARCHAR(500)
  • total_capacity — INT
  • floor_count — INT

venues

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • city — VARCHAR(50)
  • district — VARCHAR(50)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • thumbnail_image — VARCHAR(500)
  • total_capacity — INT
  • is_new — TINYINT(1)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP