심화(반오십)
테이블 (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