CuppingMap

Tables (24)

auth_accounts

  • id — UUID — Primary key — NOT NULL
  • member_id — UUID — Foreign key → members.id — NOT NULL
  • provider_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • provider_email — CITEXT
  • provider_profile_image_url — TEXT
  • provider_email_verified — BOOLEAN
  • raw_profile — JSONB
  • linked_at — TIMESTAMPTZ — NOT NULL
  • last_login_at — TIMESTAMPTZ

coffee_beans

  • id — UUID — Primary key — NOT NULL
  • producer_roastery_id — UUID — Foreign key → roasteries.id
  • bean_name — VARCHAR(255) — NOT NULL
  • origin_country_code — VARCHAR(140) — Foreign key → metadata_values.code
  • origin_region — VARCHAR(255)
  • farm_or_producer — VARCHAR(255)
  • variety — VARCHAR(255)
  • harvest_year — SMALLINT
  • processing_method_code — VARCHAR(140) — Foreign key → metadata_values.code
  • roast_level_code — VARCHAR(140) — Foreign key → metadata_values.code
  • bean_description — TEXT
  • data_source_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • verified_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

entity_metadata_values

  • id — UUID — Primary key — NOT NULL
  • metadata_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • source_code — VARCHAR(140) — Foreign key → metadata_values.code
  • roastery_id — UUID — Foreign key → roasteries.id
  • coffee_bean_id — UUID — Foreign key → coffee_beans.id
  • roastery_bean_offering_id — UUID — Foreign key → roastery_bean_offerings.id
  • tasting_note_id — UUID — Foreign key → tasting_notes.id
  • numeric_value — NUMERIC(10, 4)
  • text_value — TEXT
  • boolean_value — BOOLEAN
  • json_value — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

media_assets

  • id — UUID — Primary key — NOT NULL
  • roastery_id — UUID — Foreign key → roasteries.id
  • tasting_note_id — UUID — Foreign key → tasting_notes.id
  • media_type_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • storage_key — TEXT — NOT NULL
  • original_filename — TEXT
  • mime_type — VARCHAR(150)
  • width — INTEGER
  • height — INTEGER
  • alt_text — TEXT
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

member_sessions

  • id — UUID — Primary key — NOT NULL
  • member_id — UUID — Foreign key → auth_accounts.member_id — NOT NULL
  • auth_account_id — UUID — Foreign key → auth_accounts.id — NOT NULL
  • refresh_token_hash — VARCHAR(255) — NOT NULL
  • device_id — VARCHAR(255)
  • device_name — VARCHAR(255)
  • user_agent — TEXT
  • ip_address — INET
  • expires_at — TIMESTAMPTZ — NOT NULL
  • revoked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • last_used_at — TIMESTAMPTZ

member_term_consent_events

  • id — UUID — Primary key — NOT NULL
  • member_id — UUID — Foreign key → members.id — NOT NULL
  • term_id — UUID — Foreign key → terms.id — NOT NULL
  • action_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • occurred_at — TIMESTAMPTZ — NOT NULL
  • ip_address — INET
  • user_agent — TEXT

members

  • id — UUID — Primary key — NOT NULL
  • email — CITEXT
  • nickname — VARCHAR(80) — NOT NULL
  • profile_image_url — TEXT
  • account_status_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • onboarding_completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

metadata_categories

  • category_key — VARCHAR(60) — Primary key — NOT NULL
  • name_ko — VARCHAR(100) — NOT NULL
  • name_en — VARCHAR(100)
  • description — TEXT
  • is_runtime_editable — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

metadata_values

  • code — VARCHAR(140) — Primary key — NOT NULL
  • category_key — VARCHAR(60) — Foreign key → metadata_categories.category_key — NOT NULL
  • value_key — VARCHAR(80) — NOT NULL
  • name_ko — VARCHAR(150) — NOT NULL
  • name_en — VARCHAR(150)
  • description — TEXT
  • parent_code — VARCHAR(140) — Foreign key → metadata_values.code
  • attributes — JSONB — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

preference_answer_options

  • answer_id — UUID — Foreign key → preference_answers.id — NOT NULL
  • option_id — UUID — Foreign key → preference_question_options.id — NOT NULL
  • question_id — UUID — Foreign key → preference_question_options.question_id — NOT NULL

preference_answers

  • id — UUID — Primary key — NOT NULL
  • session_id — UUID — Foreign key → preference_test_sessions.id — NOT NULL
  • question_set_id — UUID — Foreign key → preference_questions.question_set_id — NOT NULL
  • question_id — UUID — Foreign key → preference_questions.id — NOT NULL
  • answer_value — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

preference_question_options

  • id — UUID — Primary key — NOT NULL
  • question_id — UUID — Foreign key → preference_questions.id — NOT NULL
  • option_key — VARCHAR(80) — NOT NULL
  • label — TEXT — NOT NULL
  • description — TEXT
  • option_value — VARCHAR(255)
  • score_payload — JSONB — NOT NULL
  • sort_order — INTEGER — NOT NULL

preference_question_sets

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(80) — NOT NULL
  • version — INTEGER — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

preference_questions

  • id — UUID — Primary key — NOT NULL
  • question_set_id — UUID — Foreign key → preference_question_sets.id — NOT NULL
  • question_key — VARCHAR(80) — NOT NULL
  • title — TEXT — NOT NULL
  • description — TEXT
  • question_type_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • category_code — VARCHAR(140) — Foreign key → metadata_values.code
  • is_required — BOOLEAN — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

preference_scoring_rules

  • id — UUID — Primary key — NOT NULL
  • question_set_id — UUID — Foreign key → preference_question_sets.id — NOT NULL
  • rule_name — VARCHAR(150) — NOT NULL
  • rule_version — INTEGER — NOT NULL
  • scoring_config — JSONB — NOT NULL
  • dislike_penalty_rule — JSONB — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

preference_test_sessions

  • id — UUID — Primary key — NOT NULL
  • member_id — UUID — Foreign key → members.id
  • question_set_id — UUID — Foreign key → preference_question_sets.id — NOT NULL
  • status_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • skipped_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

roasteries

  • id — UUID — Primary key — NOT NULL
  • roastery_name — VARCHAR(255) — NOT NULL
  • address — TEXT — NOT NULL
  • location — GEOGRAPHY(POINT, 4326)
  • phone_number — VARCHAR(50)
  • roastery_description — TEXT
  • verified_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

roastery_bean_offerings

  • id — UUID — Primary key — NOT NULL
  • roastery_id — UUID — Foreign key → roasteries.id — NOT NULL
  • bean_id — UUID — Foreign key → coffee_beans.id — NOT NULL
  • availability_status_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • price_amount — NUMERIC(12, 2)
  • currency_code — VARCHAR(140) — Foreign key → metadata_values.code
  • available_from — DATE
  • available_until — DATE
  • verified_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

roastery_business_hour_exceptions

  • id — UUID — Primary key — NOT NULL
  • roastery_id — UUID — Foreign key → roasteries.id — NOT NULL
  • business_date — DATE — NOT NULL
  • open_time — TIME
  • close_time — TIME
  • is_closed — BOOLEAN — NOT NULL
  • sequence — SMALLINT — NOT NULL
  • reason — TEXT

roastery_business_hours

  • id — UUID — Primary key — NOT NULL
  • roastery_id — UUID — Foreign key → roasteries.id — NOT NULL
  • day_of_week — SMALLINT — NOT NULL
  • open_time — TIME
  • close_time — TIME
  • is_closed — BOOLEAN — NOT NULL
  • sequence — SMALLINT — NOT NULL

roastery_external_places

  • id — UUID — Primary key — NOT NULL
  • roastery_id — UUID — Foreign key → roasteries.id — NOT NULL
  • provider_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • external_place_id — VARCHAR(255) — NOT NULL
  • external_place_url — TEXT

taste_profiles

  • id — UUID — Primary key — NOT NULL
  • member_id — UUID — Foreign key → preference_test_sessions.member_id — NOT NULL
  • source_session_id — UUID — Foreign key → preference_test_sessions.id — NOT NULL
  • question_set_id — UUID — Foreign key → preference_scoring_rules.question_set_id — NOT NULL
  • scoring_rule_id — UUID — Foreign key → preference_scoring_rules.id — NOT NULL
  • preference_type_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • preference_result — JSONB — NOT NULL
  • calculated_at — TIMESTAMPTZ — NOT NULL
  • superseded_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

tasting_notes

  • id — UUID — Primary key — NOT NULL
  • member_id — UUID — Foreign key → members.id — NOT NULL
  • roastery_bean_offering_id — UUID — Foreign key → roastery_bean_offerings.id
  • bean_name_snapshot — VARCHAR(255) — NOT NULL
  • roastery_name_snapshot — VARCHAR(255)
  • tasted_at — TIMESTAMPTZ — NOT NULL
  • brew_method_code — VARCHAR(140) — Foreign key → metadata_values.code
  • serving_temperature_code — VARCHAR(140) — Foreign key → metadata_values.code
  • rating — SMALLINT
  • paid_price — NUMERIC(12, 2)
  • currency_code — VARCHAR(140) — Foreign key → metadata_values.code
  • memo — TEXT
  • use_for_preference_learning — BOOLEAN — NOT NULL
  • visibility_code — VARCHAR(140) — Foreign key → metadata_values.code — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

terms

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(80) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • version — INTEGER — NOT NULL
  • is_required — BOOLEAN — NOT NULL
  • content_storage_key — TEXT — NOT NULL
  • content_hash — VARCHAR(128) — NOT NULL
  • effective_from — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL