chukjibup

Tables (18)

admins

  • admin_id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE
  • department — VARCHAR(100)
  • joined_at — TIMESTAMPTZ — NOT NULL
  • is_withdrawn — BOOLEAN — NOT NULL
  • withdrawn_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ — NOT NULL

booth_congestion

  • congestion_id — BIGSERIAL — Primary key — NOT NULL
  • booth_id — BIGINT — Foreign key → booth_info.booth_id — NOT NULL
  • modifier_type — modifier_type — NOT NULL
  • modifier_admin_id — BIGINT — Foreign key → admins.admin_id
  • modifier_staff_id — BIGINT — Foreign key → festival_staff.staff_id
  • wait_minutes — INTEGER
  • congestion_level — congestion_level — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

booth_info

  • booth_id — BIGSERIAL — Primary key — NOT NULL
  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • booth_name — TEXT — NOT NULL
  • booth_content — TEXT
  • booth_location — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

festival_congestion

  • congestion_id — BIGSERIAL — Primary key — NOT NULL
  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • modifier_admin_id — BIGINT — Foreign key → admins.admin_id
  • congestion_level — congestion_level — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

festival_dashboard

  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • admin_id — BIGINT — Foreign key → admins.admin_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

festival_operator

  • operator_id — BIGSERIAL — Primary key — NOT NULL
  • admin_id — BIGINT — Foreign key → admins.admin_id — NOT NULL
  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • invite_id — BIGINT — Foreign key → festival_operator_invite.invite_id
  • created_at — TIMESTAMPTZ — NOT NULL

festival_operator_invite

  • invite_id — BIGSERIAL — Primary key — NOT NULL
  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • inviter_admin_id — BIGINT — Foreign key → admins.admin_id — NOT NULL
  • invitee_admin_id — BIGINT — Foreign key → admins.admin_id — NOT NULL
  • status — invite_status_type — NOT NULL
  • invited_at — TIMESTAMPTZ — NOT NULL
  • responded_at — TIMESTAMPTZ

festival_result

  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • congestion_flow — JSONB
  • booth_congestion_summary — JSONB
  • review_summary — JSONB
  • generated_at — TIMESTAMPTZ — NOT NULL

festival_review

  • review_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • rating — SMALLINT
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

festival_roadmap

  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • roadmap_type — roadmap_type — NOT NULL
  • base_image_url — TEXT
  • canvas_width — INTEGER
  • canvas_height — INTEGER
  • created_by_admin_id — BIGINT — Foreign key → admins.admin_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

festival_staff

  • staff_id — BIGSERIAL — Primary key — NOT NULL
  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE
  • phone_number — VARCHAR(20)
  • is_active — BOOLEAN — NOT NULL
  • created_by_admin_id — BIGINT — Foreign key → admins.admin_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

festival_visitor_count

  • visitor_count_id — BIGSERIAL — Primary key — NOT NULL
  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • visit_date — DATE — NOT NULL
  • visitor_count — INTEGER
  • congestion_level — congestion_level
  • created_at — TIMESTAMPTZ — NOT NULL

festival_visitor_excel

  • excel_plan_id — BIGSERIAL — Primary key — NOT NULL
  • source_file — TEXT — NOT NULL
  • plan_year — INTEGER — NOT NULL
  • row_no — INTEGER
  • sido_name — TEXT
  • sigungu_name — TEXT
  • festival_name — TEXT — NOT NULL
  • festival_type — TEXT
  • event_place_name — TEXT
  • event_place_type — TEXT
  • place_sido — TEXT
  • place_sigungu — TEXT
  • place_eupmyeondong — TEXT
  • start_date — DATE
  • end_date — DATE
  • period_raw_text — TEXT
  • total_days — INTEGER
  • hold_cycle — TEXT
  • hold_method — TEXT
  • first_held_year — INTEGER
  • budget_total_mil — NUMERIC(12,2)
  • budget_gov_mil — NUMERIC(12,2)
  • budget_local_mil — NUMERIC(12,2)
  • budget_etc_mil — NUMERIC(12,2)
  • gov_support_dept — TEXT
  • visitor_year — INTEGER
  • visitor_total — NUMERIC(14,0)
  • visitor_domestic — NUMERIC(14,0)
  • visitor_foreign — NUMERIC(14,0)
  • visitor_measure_method — TEXT
  • org_name — TEXT
  • org_type — TEXT
  • manager_dept — TEXT
  • manager_name — TEXT
  • manager_contact — TEXT
  • note — TEXT
  • matched_festival_id — BIGINT — Foreign key → festivals.festival_id
  • match_status — match_status_type — NOT NULL
  • matched_at — TIMESTAMPTZ
  • loaded_at — TIMESTAMPTZ — NOT NULL

festival_wishlist

  • wishlist_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • festival_id — BIGINT — Foreign key → festivals.festival_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

festivals

  • festival_id — BIGSERIAL — Primary key — NOT NULL
  • festival_name — TEXT — NOT NULL
  • event_place — TEXT
  • start_date — DATE
  • end_date — DATE
  • content — TEXT
  • supervisor_org — TEXT
  • host_org — TEXT
  • sponsor_org — TEXT
  • phone_number — TEXT
  • homepage_url — TEXT
  • related_info — TEXT
  • road_address — TEXT
  • jibun_address — TEXT
  • latitude — NUMERIC(10,6)
  • longitude — NUMERIC(10,6)
  • api_reference_date — DATE
  • raw_payload — JSONB
  • source_type — festival_source_type — NOT NULL
  • created_by_admin_id — BIGINT — Foreign key → admins.admin_id
  • api_last_seen_at — TIMESTAMPTZ
  • loaded_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

roadmap_icon_placement

  • placement_id — BIGSERIAL — Primary key — NOT NULL
  • festival_id — BIGINT — Foreign key → festival_roadmap.festival_id — NOT NULL
  • icon_type_id — BIGINT — Foreign key → roadmap_icon_type.icon_type_id — NOT NULL
  • related_booth_id — BIGINT — Foreign key → booth_info.booth_id
  • position_x — NUMERIC(8,2) — NOT NULL
  • position_y — NUMERIC(8,2) — NOT NULL
  • rotation_deg — NUMERIC(5,2) — NOT NULL
  • label — TEXT
  • created_by_admin_id — BIGINT — Foreign key → admins.admin_id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

roadmap_icon_type

  • icon_type_id — BIGSERIAL — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • icon_image_url — TEXT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • kakao_id — BIGINT — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image_url — TEXT
  • thumbnail_image_url — TEXT
  • email — VARCHAR(255)
  • gender — VARCHAR(10)
  • birthyear — CHAR(4)
  • birthday — CHAR(4)
  • phone_number — VARCHAR(30)
  • joined_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • is_withdrawn — BOOLEAN — NOT NULL
  • withdrawn_at — TIMESTAMPTZ