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