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