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