심화(반오십)

테이블 (35)

admission_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • admission_ticket_id — BIGINT — 외래 키 → admission_tickets.id — NOT NULL
  • staff_member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • action — VARCHAR(30) — NOT NULL
  • result — VARCHAR(20) — NOT NULL
  • gate_name — VARCHAR(100)
  • processed_at — TIMESTAMPTZ — NOT NULL

admission_tickets

  • id — BIGINT — 기본 키 — NOT NULL
  • exchange_code_id — BIGINT — 외래 키 → exchange_codes.id — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id
  • qr_token — VARCHAR(150) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • issued_at — TIMESTAMPTZ — NOT NULL
  • used_at — TIMESTAMPTZ
  • cancelled_at — TIMESTAMPTZ

advertisements

  • id — BIGINT — 기본 키 — NOT NULL
  • ad_type — VARCHAR(20) — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id
  • booth_id — BIGINT — 외래 키 → booths.id
  • applicant_organization_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • payment_order_id — BIGINT — 외래 키 → payment_orders.id
  • banner_file_id — BIGINT — 외래 키 → file_assets.id
  • ad_text — VARCHAR(300)
  • start_at — TIMESTAMPTZ — NOT NULL
  • end_at — TIMESTAMPTZ — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • reviewed_by — BIGINT — 외래 키 → members.id
  • rejection_reason — TEXT
  • approved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

audit_logs

  • id — BIGINT — 기본 키 — NOT NULL
  • actor_member_id — BIGINT — 외래 키 → members.id
  • target_type — VARCHAR(40) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • action — VARCHAR(50) — NOT NULL
  • before_data — JSONB
  • after_data — JSONB
  • reason — TEXT
  • ip_address — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL

booth_application_files

  • id — BIGINT — 기본 키 — NOT NULL
  • booth_application_id — BIGINT — 외래 키 → booth_applications.id — NOT NULL
  • file_id — BIGINT — 외래 키 → file_assets.id — NOT NULL
  • file_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

booth_applications

  • id — BIGINT — 기본 키 — NOT NULL
  • application_no — VARCHAR(40) — NOT NULL
  • recruitment_id — BIGINT — 외래 키 → booth_recruitments.id — NOT NULL
  • booth_id — BIGINT — 외래 키 → booths.id — NOT NULL
  • applicant_organization_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • applicant_member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • team_name — VARCHAR(150) — NOT NULL
  • contact_name — VARCHAR(50) — NOT NULL
  • contact_email — VARCHAR(255) — NOT NULL
  • contact_phone — VARCHAR(30) — NOT NULL
  • activity_description — TEXT — NOT NULL
  • exhibition_content — TEXT — NOT NULL
  • expected_visitors — INTEGER
  • electricity_required — BOOLEAN — NOT NULL
  • water_required — BOOLEAN — NOT NULL
  • drainage_required — BOOLEAN — NOT NULL
  • internet_required — BOOLEAN — NOT NULL
  • application_reason — TEXT
  • status — VARCHAR(30) — NOT NULL
  • submitted_at — TIMESTAMPTZ — NOT NULL
  • reviewed_by — BIGINT — 외래 키 → members.id
  • reviewed_at — TIMESTAMPTZ
  • rejection_reason — TEXT
  • cancelled_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ — NOT NULL

booth_daily_statistics

  • id — BIGINT — 기본 키 — NOT NULL
  • booth_id — BIGINT — 외래 키 → booths.id — NOT NULL
  • stat_date — DATE — NOT NULL
  • reservation_count — INTEGER — NOT NULL
  • no_show_count — INTEGER — NOT NULL
  • qr_scan_count — INTEGER — NOT NULL
  • popularity_rank — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL

booth_hourly_statistics

  • id — BIGINT — 기본 키 — NOT NULL
  • booth_id — BIGINT — 외래 키 → booths.id — NOT NULL
  • stat_date — DATE — NOT NULL
  • stat_hour — SMALLINT — NOT NULL
  • reservation_count — INTEGER — NOT NULL
  • no_show_count — INTEGER — NOT NULL
  • qr_scan_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

booth_interests

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • booth_id — BIGINT — 외래 키 → booths.id — NOT NULL
  • vacancy_notification_enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

booth_map_positions

  • id — BIGINT — 기본 키 — NOT NULL
  • venue_map_id — BIGINT — 외래 키 → venue_maps.id — NOT NULL
  • booth_id — BIGINT — 외래 키 → booths.id — NOT NULL
  • x_ratio — NUMERIC(8,6) — NOT NULL
  • y_ratio — NUMERIC(8,6) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

booth_qr_scans

  • id — BIGINT — 기본 키 — NOT NULL
  • booth_id — BIGINT — 외래 키 → booths.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id
  • anonymous_key_hash — VARCHAR(100)
  • scanned_at — TIMESTAMPTZ — NOT NULL
  • duplicate — BOOLEAN — NOT NULL
  • counted_for_congestion — BOOLEAN — NOT NULL
  • user_agent — VARCHAR(500)

booth_recruitments

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • recruitment_start_at — TIMESTAMPTZ — NOT NULL
  • recruitment_end_at — TIMESTAMPTZ — NOT NULL
  • participant_target — TEXT — NOT NULL
  • recruitment_field — TEXT
  • qualification — TEXT
  • selection_method — TEXT
  • expected_decision_at — TIMESTAMPTZ
  • contact_name — VARCHAR(50) — NOT NULL
  • contact_email — VARCHAR(255) — NOT NULL
  • contact_phone — VARCHAR(30) — NOT NULL
  • notice — TEXT
  • status — VARCHAR(30) — NOT NULL
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

booth_reservation_sessions

  • id — BIGINT — 기본 키 — NOT NULL
  • booth_reservation_slot_id — BIGINT — 외래 키 → booth_reservation_slots.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • party_size — INTEGER — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

booth_reservation_slots

  • id — BIGINT — 기본 키 — NOT NULL
  • booth_id — BIGINT — 외래 키 → booths.id — NOT NULL
  • start_at — TIMESTAMPTZ — NOT NULL
  • end_at — TIMESTAMPTZ — NOT NULL
  • capacity — INTEGER — NOT NULL
  • reserved_count — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

booth_reservations

  • id — BIGINT — 기본 키 — NOT NULL
  • booth_id — BIGINT — 외래 키 → booths.id — NOT NULL
  • booth_reservation_slot_id — BIGINT — 외래 키 → booth_reservation_slots.id — NOT NULL
  • reservation_session_id — BIGINT — 외래 키 → booth_reservation_sessions.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • party_size — INTEGER — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • reserved_at — TIMESTAMPTZ — NOT NULL
  • cancelled_at — TIMESTAMPTZ
  • checked_in_at — TIMESTAMPTZ
  • no_show_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ — NOT NULL

booth_reviews

  • id — BIGINT — 기본 키 — NOT NULL
  • booth_id — BIGINT — 외래 키 → booths.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • rating — SMALLINT — NOT NULL
  • comment — VARCHAR(300)
  • created_at — TIMESTAMPTZ — NOT NULL

booths

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • assigned_organization_id — BIGINT — 외래 키 → organizations.id
  • booth_code — VARCHAR(30) — NOT NULL
  • booth_type — VARCHAR(50) — NOT NULL
  • floor_name — VARCHAR(50)
  • zone_name — VARCHAR(50)
  • location_description — VARCHAR(200)
  • width_meter — NUMERIC(6,2)
  • depth_meter — NUMERIC(6,2)
  • area_sqm — NUMERIC(8,2)
  • basic_equipment — JSONB
  • electricity_available — BOOLEAN — NOT NULL
  • water_available — BOOLEAN — NOT NULL
  • drainage_available — BOOLEAN — NOT NULL
  • internet_available — BOOLEAN — NOT NULL
  • price — NUMERIC(12,0) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • category — VARCHAR(50)
  • display_name — VARCHAR(150)
  • short_intro — VARCHAR(300)
  • description — TEXT
  • exhibition_content — TEXT
  • representative_file_id — BIGINT — 외래 키 → file_assets.id
  • qr_token — VARCHAR(100)
  • qr_issued_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

event_contents

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • author_member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • content_type — VARCHAR(20) — NOT NULL
  • resource_type — VARCHAR(30)
  • audience — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • file_id — BIGINT — 외래 키 → file_assets.id
  • version — VARCHAR(20)
  • pinned — BOOLEAN — NOT NULL
  • published_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

event_members

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • event_role — VARCHAR(30) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

events

  • id — BIGINT — 기본 키 — NOT NULL
  • organizer_organization_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • event_type — VARCHAR(30) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • short_description — VARCHAR(300)
  • description — TEXT — NOT NULL
  • venue_name — VARCHAR(200) — NOT NULL
  • address — VARCHAR(300) — NOT NULL
  • detail_address — VARCHAR(200)
  • start_at — TIMESTAMPTZ — NOT NULL
  • end_at — TIMESTAMPTZ — NOT NULL
  • ticket_sales_start_at — TIMESTAMPTZ
  • ticket_sales_end_at — TIMESTAMPTZ
  • representative_file_id — BIGINT — 외래 키 → file_assets.id
  • status — VARCHAR(30) — NOT NULL
  • booth_recruitment_enabled — BOOLEAN — NOT NULL
  • venue_map_enabled — BOOLEAN — NOT NULL
  • booth_reservation_enabled — BOOLEAN — NOT NULL
  • no_show_grace_minutes — INTEGER — NOT NULL
  • congestion_window_minutes — INTEGER — NOT NULL
  • congestion_low_max — INTEGER — NOT NULL
  • congestion_normal_max — INTEGER — NOT NULL
  • congestion_busy_max — INTEGER — NOT NULL
  • refund_deadline_hours — INTEGER — NOT NULL
  • rejection_reason — TEXT
  • published_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

exchange_code_requests

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • ticket_type_id — BIGINT — 외래 키 → ticket_types.id — NOT NULL
  • organizer_organization_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • requested_by — BIGINT — 외래 키 → members.id — NOT NULL
  • requested_quantity — INTEGER — NOT NULL
  • purpose — TEXT
  • status — VARCHAR(30) — NOT NULL
  • reviewed_by — BIGINT — 외래 키 → members.id
  • rejection_reason — TEXT
  • reviewed_at — TIMESTAMPTZ
  • emailed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

exchange_codes

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • ticket_type_id — BIGINT — 외래 키 → ticket_types.id — NOT NULL
  • exchange_code_request_id — BIGINT — 외래 키 → exchange_code_requests.id
  • ticket_order_item_id — BIGINT — 외래 키 → ticket_order_items.id
  • holder_member_id — BIGINT — 외래 키 → members.id
  • code — VARCHAR(100) — NOT NULL
  • source — VARCHAR(30) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • expires_at — TIMESTAMPTZ
  • redeemed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

file_assets

  • id — BIGINT — 기본 키 — NOT NULL
  • uploaded_by — BIGINT — 외래 키 → members.id — NOT NULL
  • storage_key — VARCHAR(500) — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • mime_type — VARCHAR(100) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • access_level — VARCHAR(20) — NOT NULL
  • checksum — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL

members

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • oauth_provider — VARCHAR(20) — NOT NULL
  • oauth_subject — VARCHAR(255) — NOT NULL
  • platform_role — VARCHAR(30) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

notifications

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • notification_type — VARCHAR(40) — NOT NULL
  • reference_type — VARCHAR(30)
  • reference_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • read_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

organization_members

  • id — BIGINT — 기본 키 — NOT NULL
  • organization_id — BIGINT — 외래 키 → organizations.id — NOT NULL
  • member_id — BIGINT — 외래 키 → members.id — NOT NULL
  • organization_role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL

organizations

  • id — BIGINT — 기본 키 — NOT NULL
  • organization_type — VARCHAR(20) — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • business_number — VARCHAR(20)
  • representative_name — VARCHAR(50)
  • contact_email — VARCHAR(255) — NOT NULL
  • contact_phone — VARCHAR(30) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

payment_orders

  • id — BIGINT — 기본 키 — NOT NULL
  • order_no — VARCHAR(64) — NOT NULL
  • buyer_member_id — BIGINT — 외래 키 → members.id
  • buyer_name — VARCHAR(50)
  • buyer_email — VARCHAR(255)
  • buyer_phone — VARCHAR(30)
  • order_type — VARCHAR(20) — NOT NULL
  • total_amount — NUMERIC(12,0) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • expires_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

payment_refunds

  • id — BIGINT — 기본 키 — NOT NULL
  • payment_id — BIGINT — 외래 키 → payments.id — NOT NULL
  • exchange_code_id — BIGINT — 외래 키 → exchange_codes.id
  • requester_member_id — BIGINT — 외래 키 → members.id
  • refund_amount — NUMERIC(12,0) — NOT NULL
  • reason — TEXT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • requested_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • pg_cancel_key — VARCHAR(200)

payments

  • id — BIGINT — 기본 키 — NOT NULL
  • payment_order_id — BIGINT — 외래 키 → payment_orders.id — NOT NULL
  • pg_provider — VARCHAR(30) — NOT NULL
  • payment_key — VARCHAR(200)
  • method — VARCHAR(30)
  • amount — NUMERIC(12,0) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • failure_code — VARCHAR(100)
  • failure_message — TEXT
  • requested_at — TIMESTAMPTZ — NOT NULL
  • approved_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ — NOT NULL

ticket_order_items

  • id — BIGINT — 기본 키 — NOT NULL
  • ticket_order_id — BIGINT — 외래 키 → ticket_orders.id — NOT NULL
  • ticket_type_id — BIGINT — 외래 키 → ticket_types.id — NOT NULL
  • unit_price — NUMERIC(12,0) — NOT NULL
  • quantity — INTEGER — NOT NULL
  • subtotal — NUMERIC(12,0) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

ticket_orders

  • id — BIGINT — 기본 키 — NOT NULL
  • payment_order_id — BIGINT — 외래 키 → payment_orders.id — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • total_quantity — INTEGER — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • confirmed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

ticket_types

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — NUMERIC(12,0) — NOT NULL
  • sales_start_at — TIMESTAMPTZ — NOT NULL
  • sales_end_at — TIMESTAMPTZ — NOT NULL
  • total_quantity — INTEGER — NOT NULL
  • sold_quantity — INTEGER — NOT NULL
  • purchase_limit — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

venue_map_ocr_results

  • id — BIGINT — 기본 키 — NOT NULL
  • venue_map_id — BIGINT — 외래 키 → venue_maps.id — NOT NULL
  • matched_booth_id — BIGINT — 외래 키 → booths.id
  • detected_text — VARCHAR(100) — NOT NULL
  • confidence — NUMERIC(5,2) — NOT NULL
  • x_ratio — NUMERIC(8,6) — NOT NULL
  • y_ratio — NUMERIC(8,6) — NOT NULL
  • width_ratio — NUMERIC(8,6)
  • height_ratio — NUMERIC(8,6)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

venue_maps

  • id — BIGINT — 기본 키 — NOT NULL
  • event_id — BIGINT — 외래 키 → events.id — NOT NULL
  • map_type — VARCHAR(20) — NOT NULL
  • floor_name — VARCHAR(50) — NOT NULL
  • image_file_id — BIGINT — 외래 키 → file_assets.id — NOT NULL
  • original_width — INTEGER — NOT NULL
  • original_height — INTEGER — NOT NULL
  • version — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • published_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL