123

Tables (47)

admin_cocktail_curation

  • curation_id — NUMBER(10) — Primary key — NOT NULL
  • admin_id — NUMBER(10) — Foreign key → admin_users.admin_id
  • cocktail_id — NUMBER(10) — Foreign key → cocktails.cocktail_id
  • title — VARCHAR2(200)
  • description — VARCHAR2(1000)
  • created_at — DATE

admin_flags

  • flag_id — NUMBER(10) — Primary key — NOT NULL
  • reporter_user_id — NUMBER(10)
  • target_type — VARCHAR2(50)
  • target_id — NUMBER(10)
  • reason — VARCHAR2(1000)
  • status — VARCHAR2(20)
  • created_at — DATE
  • handled_by_admin_id — NUMBER(10) — Foreign key → admin_users.admin_id

admin_highlight_recommendations

  • highlight_id — NUMBER(10) — Primary key — NOT NULL
  • admin_id — NUMBER(10)
  • cocktail_id — NUMBER(10) — Foreign key → cocktails.cocktail_id
  • title — VARCHAR2(200)
  • message — VARCHAR2(1000)
  • start_date — DATE
  • end_date — DATE

admin_logs

  • admin_log_id — NUMBER(10) — Primary key — NOT NULL
  • admin_id — NUMBER(10) — Foreign key → admin_users.admin_id
  • action — VARCHAR2(100)
  • target_type — VARCHAR2(50)
  • target_id — NUMBER(10)
  • created_at — DATE
  • detail — VARCHAR2(1000)

admin_users

  • admin_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10)
  • admin_role_id — NUMBER(10)
  • display_name — VARCHAR2(100)
  • email — VARCHAR2(100)

bar_location_mapping

  • bar_location_id — NUMBER(10) — Primary key — NOT NULL
  • bar_id — NUMBER(10) — NOT NULL
  • location_id — NUMBER(10) — NOT NULL

bar_reservations

  • bar_reservation_id — NUMBER(10) — Primary key — NOT NULL
  • bar_id — NUMBER(10) — NOT NULL
  • bar_table_id — NUMBER(10) — Foreign key → bar_tables.bar_table_id
  • user_id — NUMBER(10)
  • reservation_time — DATE
  • headcount — NUMBER(10)
  • status — VARCHAR2(20)

bar_reviews

  • bar_review_id — NUMBER(10) — Primary key — NOT NULL
  • bar_id — NUMBER(10) — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • rating — NUMBER(2,1)
  • content — VARCHAR2(1000)
  • created_at — DATE

bar_tables

  • bar_table_id — NUMBER(10) — Primary key — NOT NULL
  • bar_id — NUMBER(10) — NOT NULL
  • table_name — VARCHAR2(50)
  • capacity — NUMBER(10)

cart_items

  • cart_item_id — NUMBER(10) — Primary key — NOT NULL
  • cart_id — NUMBER(10) — Foreign key → carts.cart_id — NOT NULL
  • product_id — NUMBER(10) — NOT NULL
  • quantity — NUMBER(10)
  • unit_price — NUMBER(12,2)

carts

  • cart_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • created_at — DATE
  • status — VARCHAR2(20)

challenge_participants

  • participant_id — NUMBER(10) — Primary key — NOT NULL
  • challenge_id — NUMBER(10) — Foreign key → community_challenges.challenge_id — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • custom_cocktail_id — NUMBER(10)
  • joined_at — DATE

challenge_trophies

  • trophy_id — NUMBER(10) — Primary key — NOT NULL
  • challenge_id — NUMBER(10) — Foreign key → community_challenges.challenge_id — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • rank_no — NUMBER(3)
  • title — VARCHAR2(200)
  • awarded_at — DATE

cocktail_ingredients

  • cocktail_ingredient_id — NUMBER(10) — Primary key — NOT NULL
  • cocktail_id — NUMBER(10) — Foreign key → cocktails.cocktail_id — NOT NULL
  • ingredient_id — NUMBER(10) — Foreign key → ingredients.ingredient_id — NOT NULL
  • amount — VARCHAR2(50)
  • unit — VARCHAR2(20)

cocktail_keyword_tags

  • cocktail_keyword_tag_id — NUMBER(10) — Primary key — NOT NULL
  • cocktail_id — NUMBER(10) — Foreign key → cocktails.cocktail_id — NOT NULL
  • keyword_tag_id — NUMBER(10) — Foreign key → keyword_tags.keyword_tag_id — NOT NULL

cocktail_mood_tags

  • cocktail_mood_tag_id — NUMBER(10) — Primary key — NOT NULL
  • cocktail_id — NUMBER(10) — Foreign key → cocktails.cocktail_id — NOT NULL
  • mood_tag_id — NUMBER(10) — Foreign key → mood_tags.mood_tag_id — NOT NULL

cocktail_popularity_trends

  • trend_id — NUMBER(10) — Primary key — NOT NULL
  • cocktail_id — NUMBER(10) — Foreign key → cocktails.cocktail_id — NOT NULL
  • trend_date — DATE — NOT NULL
  • popularity — NUMBER(10)
  • source — VARCHAR2(100)

cocktail_similarity_matrix

  • cocktail_sim_id — NUMBER(10) — Primary key — NOT NULL
  • cocktail_id_1 — NUMBER(10) — Foreign key → cocktails.cocktail_id — NOT NULL
  • cocktail_id_2 — NUMBER(10) — Foreign key → cocktails.cocktail_id — NOT NULL
  • similarity — NUMBER(5,2)

cocktail_taste_tags

  • cocktail_taste_tag_id — NUMBER(10) — Primary key — NOT NULL
  • cocktail_id — NUMBER(10) — Foreign key → cocktails.cocktail_id — NOT NULL
  • taste_tag_id — NUMBER(10) — Foreign key → taste_tags.taste_tag_id — NOT NULL

cocktail_visual_tags

  • cocktail_visual_tag_id — NUMBER(10) — Primary key — NOT NULL
  • cocktail_id — NUMBER(10) — Foreign key → cocktails.cocktail_id — NOT NULL
  • color_tag_id — NUMBER(10) — Foreign key → visual_color_tags.color_tag_id — NOT NULL

cocktails

  • cocktail_id — NUMBER(10) — Primary key — NOT NULL
  • 이름 (name) — VARCHAR2(200) — NOT NULL
  • 베이스 (base_spirit_id) — NUMBER(10)
  • abv — NUMBER(4,1)
  • glass_type — VARCHAR2(50)
  • method — VARCHAR2(100)
  • description — VARCHAR2(1000)
  • image_url — VARCHAR2(300)
  • created_at — DATE

community_challenges

  • challenge_id — NUMBER(10) — Primary key — NOT NULL
  • title — VARCHAR2(200) — NOT NULL
  • description — VARCHAR2(1000)
  • start_date — DATE
  • end_date — DATE
  • status — VARCHAR2(20)

custom_cocktail_comments

  • comment_id — NUMBER(10) — Primary key — NOT NULL
  • custom_cocktail_id — NUMBER(10) — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • content — VARCHAR2(1000)
  • created_at — DATE

custom_cocktail_ingredients

  • custom_cocktail_ingredient_id — NUMBER(10) — Primary key — NOT NULL
  • custom_cocktail_id — NUMBER(10) — NOT NULL
  • ingredient_id — NUMBER(10) — Foreign key → ingredients.ingredient_id — NOT NULL
  • amount — VARCHAR2(50)
  • unit — VARCHAR2(20)

custom_cocktail_likes

  • like_id — NUMBER(10) — Primary key — NOT NULL
  • custom_cocktail_id — NUMBER(10) — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • created_at — DATE

custom_cocktail_photos

  • photo_id — NUMBER(10) — Primary key — NOT NULL
  • custom_cocktail_id — NUMBER(10) — NOT NULL
  • photo_url — VARCHAR2(300)
  • uploaded_at — DATE

custom_cocktail_tags

  • custom_tag_id — NUMBER(10) — Primary key — NOT NULL
  • custom_cocktail_id — NUMBER(10) — NOT NULL
  • tag_type — VARCHAR2(20)
  • tag_value — VARCHAR2(100)

custom_cocktail_videos

  • video_id — NUMBER(10) — Primary key — NOT NULL
  • custom_cocktail_id — NUMBER(10) — NOT NULL
  • video_url — VARCHAR2(300)
  • platform — VARCHAR2(50)

daily_mix_recommendations

  • daily_mix_id — NUMBER(10) — Primary key — NOT NULL
  • rec_date — DATE — NOT NULL
  • cocktail_id — NUMBER(10) — Foreign key → cocktails.cocktail_id — NOT NULL
  • rank_no — NUMBER(3)

ingredient_substitute_matrix

  • subs_id — NUMBER(10) — Primary key — NOT NULL
  • ingredient_id_from — NUMBER(10) — NOT NULL
  • ingredient_id_to — NUMBER(10) — Foreign key → ingredients.ingredient_id — NOT NULL
  • similarity — NUMBER(5,2)

ingredients

  • ingredient_id — NUMBER(10) — Primary key — NOT NULL
  • name — VARCHAR2(100) — NOT NULL
  • category — VARCHAR2(50)
  • alcoholic_yn — VARCHAR2(1)

keyword_tags

  • keyword_tag_id — NUMBER(10) — Primary key — NOT NULL
  • name — VARCHAR2(100) — NOT NULL

mood_tags

  • mood_tag_id — NUMBER(10) — Primary key — NOT NULL
  • name — VARCHAR2(50) — NOT NULL

product_prices

  • price_id — NUMBER(10) — Primary key — NOT NULL
  • product_id — NUMBER(10) — NOT NULL
  • source — VARCHAR2(100)
  • url — VARCHAR2(300)
  • price — NUMBER(12,2)
  • currency — VARCHAR2(10)
  • last_updated — DATE

purchase_recommendation_logs

  • purchase_rec_log_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10)
  • product_id — NUMBER(10)
  • cocktail_id — NUMBER(10) — Foreign key → cocktails.cocktail_id
  • message — VARCHAR2(500)
  • created_at — DATE

tag_similarity_matrix

  • tag_sim_id — NUMBER(10) — Primary key — NOT NULL
  • tag_type — VARCHAR2(20) — NOT NULL
  • tag_value_1 — VARCHAR2(100) — NOT NULL
  • tag_value_2 — VARCHAR2(100) — NOT NULL
  • similarity — NUMBER(5,2)

taste_tags

  • taste_tag_id — NUMBER(10) — Primary key — NOT NULL
  • name — VARCHAR2(50) — NOT NULL

user_disliked_ingredients

  • disliked_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • ingredient_id — NUMBER(10) — Foreign key → ingredients.ingredient_id — NOT NULL

user_inventory

  • inventory_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • ingredient_id — NUMBER(10) — Foreign key → ingredients.ingredient_id — NOT NULL
  • quantity — VARCHAR2(50)
  • unit — VARCHAR2(20)
  • updated_at — DATE

user_level_history

  • level_history_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • level_id — NUMBER(10) — Foreign key → user_levels.level_id — NOT NULL
  • changed_at — DATE

user_levels

  • level_id — NUMBER(10) — Primary key — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • min_exp — NUMBER(10)
  • description — VARCHAR2(300)

user_preferred_foods

  • preferred_food_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • food_type — VARCHAR2(100) — NOT NULL

user_preferred_tags

  • preferred_tag_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • tag_type — VARCHAR2(20) — NOT NULL
  • tag_value — VARCHAR2(100) — NOT NULL

user_profiles

  • user_profile_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • bio — VARCHAR2(500)
  • avatar_url — VARCHAR2(300)
  • birth_year — NUMBER(4)
  • gender — VARCHAR2(10)

user_purchase_history

  • order_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • order_date — DATE
  • total_amount — NUMBER(12,2)

user_wishlist_ingredients

  • wishlist_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10) — NOT NULL
  • ingredient_id — NUMBER(10) — Foreign key → ingredients.ingredient_id — NOT NULL
  • created_at — DATE

visual_color_tags

  • color_tag_id — NUMBER(10) — Primary key — NOT NULL
  • name — VARCHAR2(50) — NOT NULL