senioronline
Tables (31)
_prisma_migrations
- id — character varying — Primary key — NOT NULL
- checksum — character varying — NOT NULL
- finished_at — timestamp with time zone
- migration_name — character varying — NOT NULL
- logs — text
- rolled_back_at — timestamp with time zone
- started_at — timestamp with time zone — NOT NULL
- applied_steps_count — integer — NOT NULL
content_categories
- id — bigint — Primary key — NOT NULL
- code — character varying — NOT NULL
- name — character varying — NOT NULL
- display_order — integer — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
- is_active — boolean — NOT NULL
content_code_sequences
- origin_type — USER-DEFINED — Primary key — NOT NULL
- year — integer — Primary key — NOT NULL
- month — integer — Primary key — NOT NULL
- last_number — integer — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone — NOT NULL
content_favorites
- content_id — bigint — Foreign key → contents.id — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- created_at — timestamp without time zone — NOT NULL
content_images
- id — bigint — Primary key — NOT NULL
- content_id — bigint — Foreign key → contents.id — NOT NULL
- image_url — character varying — NOT NULL
- sort_order — integer — NOT NULL
- is_primary — boolean — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- storage_object_path — character varying
contents
- id — bigint — Primary key — NOT NULL
- category_id — bigint — Foreign key → content_categories.id — NOT NULL
- title — character varying — NOT NULL
- address — character varying
- latitude — numeric
- longitude — numeric
- img_url — character varying
- start_date — date
- end_date — date
- tel — character varying
- homepage_url — character varying
- origin_url — character varying
- display_status — boolean — NOT NULL
- view_count — integer — NOT NULL
- favorite_count — integer — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
- overview — text
- price — integer
- price_text — text
- organization — character varying
- location — USER-DEFINED
- place — character varying
- content_code — character varying — NOT NULL
- origin_type — USER-DEFINED — NOT NULL
- approval_status — USER-DEFINED — NOT NULL
- content_created_at — timestamp without time zone
- tags — ARRAY — NOT NULL
data_mappings
- id — bigint — Primary key — NOT NULL
- list_key — character varying — NOT NULL
- category_code — character varying — Foreign key → content_categories.code — NOT NULL
- field_mappings — jsonb — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone — NOT NULL
data_processing_artifacts
- id — bigint — Primary key — NOT NULL
- item_id — bigint — Foreign key → data_processing_items.id — NOT NULL
- stage_id — bigint — Foreign key → data_processing_stages.id — NOT NULL
- type — USER-DEFINED — NOT NULL
- artifact_key — character varying — NOT NULL
- payload — jsonb — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone — NOT NULL
data_processing_items
- id — bigint — Primary key — NOT NULL
- job_id — bigint — Foreign key → data_processing_jobs.id — NOT NULL
- source_identifier — text
- source_item_key — character varying — NOT NULL
- status — USER-DEFINED — NOT NULL
- failed_stage — USER-DEFINED
- error_message — text
- exclusion_reason — text
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone — NOT NULL
- content_id — bigint — Foreign key → contents.id
data_processing_jobs
- id — bigint — Primary key — NOT NULL
- data_source_id — bigint — Foreign key → data_sources.id — NOT NULL
- list_key_snapshot — character varying — NOT NULL
- data_source_name_snapshot — character varying — NOT NULL
- scheduled_date — date — NOT NULL
- execution_config — jsonb — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone — NOT NULL
data_processing_stages
- id — bigint — Primary key — NOT NULL
- job_id — bigint — Foreign key → data_processing_jobs.id — NOT NULL
- type — USER-DEFINED — NOT NULL
- status — USER-DEFINED — NOT NULL
- total_count — integer — NOT NULL
- success_count — integer — NOT NULL
- failed_count — integer — NOT NULL
- started_at — timestamp without time zone
- finished_at — timestamp without time zone
- error_message — text
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone — NOT NULL
data_source_api_configs
- data_source_id — bigint — Foreign key → data_sources.id — NOT NULL
- base_url — text — NOT NULL
- list_path — character varying — NOT NULL
- collection_method — USER-DEFINED — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone — NOT NULL
- request_parameters — jsonb — NOT NULL
data_source_credentials
- data_source_id — bigint — Foreign key → data_sources.id — NOT NULL
- api_key — text — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone — NOT NULL
data_sources
- id — bigint — Primary key — NOT NULL
- list_key — character varying — NOT NULL
- name — character varying — NOT NULL
- platform_name — character varying — NOT NULL
- region — character varying — NOT NULL
- category — USER-DEFINED — NOT NULL
- type — USER-DEFINED — NOT NULL
- data_format — USER-DEFINED — NOT NULL
- status — USER-DEFINED — NOT NULL
- catalog_url — text
- origin_url — text
- keywords — ARRAY
- provider_update_cycle — character varying
- collection_interval_unit — USER-DEFINED — NOT NULL
- collection_interval_value — integer — NOT NULL
- next_collection_date — date — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone — NOT NULL
- provider_name — character varying
- note — text
employment_startup_details
- id — bigint — Primary key — NOT NULL
- content_id — bigint — Foreign key → contents.id — NOT NULL
- target — character varying
- curriculum — text
- education_time — character varying
- material_cost — character varying
- application_start_at — timestamp without time zone
- application_end_at — timestamp without time zone
- max_capa — integer
- cur_capa — integer
- wait_count — integer
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
festival_details
- id — bigint — Primary key — NOT NULL
- content_id — bigint — Foreign key → contents.id — NOT NULL
- sponsor — character varying
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
- operating_time — character varying
oneday_details
- id — bigint — Primary key — NOT NULL
- content_id — bigint — Foreign key → contents.id — NOT NULL
- activity_detail — text
- experience_time — character varying
- material_cost — character varying
- application_start_at — timestamp without time zone
- application_end_at — timestamp without time zone
- max_capa — integer
- cur_capa — integer
- wait_count — integer
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
- target — character varying
performance_details
- id — bigint — Primary key — NOT NULL
- content_id — bigint — Foreign key → contents.id — NOT NULL
- running_time — character varying
- operating_time — character varying
- age_limit — character varying
- max_capa — integer
- cur_capa — integer
- sponsor — character varying
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
phone_verifications
- id — bigint — Primary key — NOT NULL
- phone_number — character varying — NOT NULL
- purpose — USER-DEFINED — NOT NULL
- code_hash — character varying — NOT NULL
- code_expires_at — timestamp without time zone — NOT NULL
- retry_available_at — timestamp without time zone — NOT NULL
- failed_attempts — integer — NOT NULL
- verified_at — timestamp without time zone
- verification_token_hash — character varying
- verification_token_expires_at — timestamp without time zone
- consumed_at — timestamp without time zone
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
regular_program_details
- id — bigint — Primary key — NOT NULL
- content_id — bigint — Foreign key → contents.id — NOT NULL
- target — character varying
- curriculum — text
- education_time — character varying
- material_cost — character varying
- application_start_at — timestamp without time zone
- application_end_at — timestamp without time zone
- max_capa — integer
- cur_capa — integer
- wait_count — integer
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
social_accounts
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- provider — USER-DEFINED — NOT NULL
- provider_user_id — character varying — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
support_posts
- id — bigint — Primary key — NOT NULL
- type — USER-DEFINED — NOT NULL
- title — character varying — NOT NULL
- content — text — NOT NULL
- view_count — integer — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
terms
- id — bigint — Primary key — NOT NULL
- code — character varying — NOT NULL
- title — character varying — NOT NULL
- version — character varying — NOT NULL
- is_required — boolean — NOT NULL
- status — USER-DEFINED — NOT NULL
- effective_from — timestamp without time zone
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
- content — text — NOT NULL
user_locations
- user_id — bigint — Foreign key → users.id — NOT NULL
- name — character varying
- base_address — character varying — NOT NULL
- detail_address — character varying
- latitude — numeric — NOT NULL
- longitude — numeric — NOT NULL
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
user_profiles
- user_id — bigint — Foreign key → users.id — NOT NULL
- name — character varying — NOT NULL
- gender — USER-DEFINED
- birth_date — date
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
- nickname — character varying — NOT NULL
- profile_image_url — text
- nickname_key — character varying
user_sessions
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- session_key — uuid — NOT NULL
- refresh_token_hash — character varying — NOT NULL
- expires_at — timestamp without time zone — NOT NULL
- revoked_at — timestamp without time zone
- last_used_at — timestamp without time zone
- user_agent — text
- ip_address — character varying
- device_type — character varying
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
user_status_histories
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- from_status — USER-DEFINED
- to_status — USER-DEFINED — NOT NULL
- reason_code — character varying
- reason_text — text
- actor_type — USER-DEFINED — NOT NULL
- actor_user_id — bigint — Foreign key → users.id
- created_at — timestamp without time zone — NOT NULL
- metadata — jsonb
user_terms_agreement_histories
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- terms_id — bigint — Foreign key → terms.id — NOT NULL
- action — USER-DEFINED — NOT NULL
- actor_type — USER-DEFINED — NOT NULL
- ip_address — character varying
- user_agent — text
- created_at — timestamp without time zone — NOT NULL
- metadata — jsonb
user_terms_agreements
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- terms_id — bigint — Foreign key → terms.id — NOT NULL
- agreed_at — timestamp without time zone — NOT NULL
- revoked_at — timestamp without time zone
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
user_withdrawal_histories
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id — NOT NULL
- reason_code — character varying
- reason_text — text
- requested_at — timestamp without time zone — NOT NULL
- processed_at — timestamp without time zone
- actor_type — USER-DEFINED — NOT NULL
- actor_user_id — bigint — Foreign key → users.id
- metadata — jsonb
users
- id — bigint — Primary key — NOT NULL
- role — USER-DEFINED — NOT NULL
- status — USER-DEFINED — NOT NULL
- withdrawn_at — timestamp without time zone
- created_at — timestamp without time zone — NOT NULL
- updated_at — timestamp without time zone
- phone_number — character varying — NOT NULL