babproject

Tables (30)

banners

  • id — integer — Primary key — NOT NULL
  • thumbnail_url — text — NOT NULL
  • alt — text

comment_likes

  • id — integer — Primary key — NOT NULL
  • comment_id — integer — NOT NULL
  • profile_id — uuid — NOT NULL
  • created_at — timestamp

comments

  • id — integer — Primary key — NOT NULL
  • post_id — integer — NOT NULL
  • profile_id — uuid — NOT NULL
  • parent_id — integer
  • content — text — NOT NULL
  • created_at — timestamp

coupons

  • id — integer — Primary key — NOT NULL
  • name — character — NOT NULL
  • description — text
  • discount_amount — integer — NOT NULL
  • required_points — integer — NOT NULL

events

  • id — integer — Primary key — NOT NULL
  • title — character — NOT NULL
  • description — text
  • badge — USER-DEFINED
  • status — USER-DEFINED — NOT NULL
  • start_date — date
  • end_date — date
  • image_url — text
  • participation — USER-DEFINED
  • participants_count — integer
  • created_at — timestamp
  • benefit — text

helps

  • help_id — integer — Primary key — NOT NULL
  • profile_id — uuid — NOT NULL
  • help_type — USER-DEFINED — NOT NULL
  • title — text — NOT NULL
  • contents — text — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

interests

  • id — integer — Primary key — NOT NULL
  • name — character — NOT NULL
  • category — character — NOT NULL

matching_participants

  • id — integer — Primary key — NOT NULL
  • matching_id — integer — NOT NULL
  • profile_id — uuid — NOT NULL
  • joined_at — timestamp

matchings

  • id — integer — Primary key — NOT NULL
  • host_profile_id — uuid — NOT NULL
  • restaurant_id — integer — NOT NULL
  • type — character — NOT NULL
  • status — character — NOT NULL
  • created_at — timestamp
  • met_at — timestamp
  • description — text
  • desired_members — integer

menus

  • id — integer — Primary key — NOT NULL
  • restaurant_id — integer — NOT NULL
  • name — character — NOT NULL
  • description — text
  • price — integer — NOT NULL
  • image_url — text
  • category — USER-DEFINED — NOT NULL
  • is_active — boolean

notifications

  • id — integer — Primary key — NOT NULL
  • profile_id — uuid — NOT NULL
  • title — character — NOT NULL
  • content — text — NOT NULL
  • target — USER-DEFINED — NOT NULL
  • created_at — timestamp — NOT NULL

order_items

  • id — integer — Primary key — NOT NULL
  • order_id — integer — NOT NULL
  • menu_id — integer — NOT NULL
  • quantity — integer — NOT NULL

orders

  • id — integer — Primary key — NOT NULL
  • profile_id — uuid — NOT NULL
  • status — USER-DEFINED — NOT NULL
  • created_at — timestamp — NOT NULL

partner_applications

  • id — integer — Primary key — NOT NULL
  • profile_id — uuid — NOT NULL
  • status — USER-DEFINED — NOT NULL
  • submitted_at — timestamp — NOT NULL
  • reason — text — NOT NULL

point_changes

  • id — integer — Primary key — NOT NULL
  • profile_id — uuid — NOT NULL
  • change_type — USER-DEFINED — NOT NULL
  • amount — integer — NOT NULL
  • created_at — timestamp

point_rules

  • change_type — USER-DEFINED — Primary key — NOT NULL
  • default_amount — integer — NOT NULL

posts

  • id — integer — Primary key — NOT NULL
  • post_category — USER-DEFINED — NOT NULL
  • profile_id — uuid — NOT NULL
  • tag — USER-DEFINED — NOT NULL
  • title — character — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp
  • view_count — integer

profile_blocks

  • id — integer — Primary key — NOT NULL
  • profile_id — integer — NOT NULL
  • blocked_profile_id — integer — NOT NULL
  • nickname — character — NOT NULL
  • block_date — date — NOT NULL
  • is_active — boolean

profile_coupons

  • id — integer — Primary key — NOT NULL
  • profile_id — uuid — NOT NULL
  • coupon_id — integer — NOT NULL
  • is_used — boolean
  • issued_at — timestamp
  • expires_at — timestamp

profile_interests

  • id — integer — Primary key — NOT NULL
  • interest_id — integer — NOT NULL
  • profile_id — uuid — NOT NULL

profile_points

  • id — integer — Primary key — NOT NULL
  • point — integer — NOT NULL
  • updated_at — timestamp — NOT NULL
  • profile_id — uuid — NOT NULL

profiles

  • id — uuid — Primary key — NOT NULL
  • name — character — NOT NULL
  • nickname — character — NOT NULL
  • avatar_url — character — NOT NULL
  • comment — text — ex
  • birth — date — NOT NULL
  • gender — boolean — NOT NULL
  • avg_rating — numeric — NOT NULL
  • role — USER-DEFINED — NOT NULL
  • status — USER-DEFINED — NOT NULL
  • phone — character

reports

  • id — integer — Primary key — NOT NULL
  • report_type — USER-DEFINED — NOT NULL
  • report_id — uuid
  • report_int — integer
  • reporter_id — uuid — NOT NULL
  • accused_profile_id — uuid — NOT NULL
  • reason — text — NOT NULL
  • status — USER-DEFINED — NOT NULL
  • penalty — USER-DEFINED — NOT NULL
  • created_at — timestamp

restaurant_interests

  • id — integer — Primary key — NOT NULL
  • restaurant_id — integer — NOT NULL
  • interest_id — integer — NOT NULL

restaurants

  • id — integer — Primary key — NOT NULL
  • name — character — NOT NULL
  • phone — character — NOT NULL
  • address — character — NOT NULL
  • opentime — time
  • closetime — time
  • closeday — ARRAY
  • storeintro — text
  • created_at — timestamp
  • send_avg_rating — numeric
  • favorite — integer
  • category_id — integer
  • profile_id — uuid — NOT NULL
  • business_number — character
  • latitude — numeric
  • longitude — numeric
  • thumbnail_url — text

restaurants_favorites

  • id — integer — Primary key — NOT NULL
  • profile_id — uuid — NOT NULL
  • restaurant_id — integer — NOT NULL

review_likes

  • like_id — bigint — Primary key — NOT NULL
  • review_id — bigint — NOT NULL
  • profile_id — uuid — NOT NULL
  • created_at — timestamp

review_photos

  • photo_id — bigint — Primary key — NOT NULL
  • review_id — bigint — NOT NULL
  • photo_url — text — NOT NULL
  • created_at — timestamp

reviews

  • review_id — integer — Primary key — NOT NULL
  • restaurant_id — integer — NOT NULL
  • profile_id — uuid — NOT NULL
  • comment — text — ex
  • rating_food — integer
  • rating_service — integer
  • rating_ambience — integer
  • created_at — timestamp
  • updated_at — timestamp
  • partner_id — uuid
  • partner_comment — text — ex

sales

  • id — integer — Primary key — NOT NULL
  • restaurant_id — integer — NOT NULL
  • order_id — integer — NOT NULL
  • total_amount — integer — NOT NULL
  • status — USER-DEFINED — NOT NULL
  • sales_at — timestamp