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