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