babababababababa

Tables (28)

comment_likes

  • id — serial
  • comment_id — int
  • profile_id — uuid

comments

  • id — serial
  • post_id — int
  • parent_id — int
  • profile_id — uuid
  • content — text

coupons

  • id — serial
  • description — text
  • discount_amount — int

direct_chats

  • id — uuid
  • user1_id — uuid
  • user2_id — uuid
  • CHECK — (user1_id <> user2_id)

direct_messages

  • id — serial
  • chat_id — uuid
  • sender_id — uuid
  • content — text

helps

  • help_id — serial
  • profile_id — uuid

interests

  • id — serial
  • name — text
  • category — text

matching_participants

  • id — serial
  • matching_id — uuid
  • profile_id — uuid

matchings

  • id — uuid
  • restaurant_id — uuid
  • host_profile_id — uuid
  • desired_members — int

menus

  • id — serial
  • restaurant_id — uuid
  • name — text
  • price — int

notifications

  • id — serial
  • profile_id — uuid

order_items

  • id — serial
  • order_id — int
  • menu_id — int

orders

  • id — serial
  • profile_id — uuid

partner_applications

  • id — serial
  • profile_id — uuid

point_changes

  • id — serial
  • profile_id — uuid

posts

  • id — serial
  • profile_id — uuid
  • title — text

profile_coupons

  • id — serial
  • profile_id — uuid
  • coupon_id — int

profile_interests

  • id — serial
  • profile_id — uuid
  • interest_id — int

profile_points

  • id — serial
  • profile_id — uuid

profiles

  • id — uuid
  • nickname — text
  • email — text

reports

  • id — serial
  • reporter_id — uuid
  • accused_profile_id — uuid
  • report_type — text

restaurant_interests

  • id — serial
  • restaurant_id — uuid
  • interest_id — int

restaurants

  • id — uuid
  • name — text
  • category_id — int
  • profile_id — uuid
  • business_number — text

restaurants_favorites

  • id — serial
  • restaurant_id — uuid
  • profile_id — uuid

review_likes

  • like_id — serial
  • review_id — int
  • profile_id — uuid

review_photos

  • photo_id — serial
  • review_id — int

reviews

  • review_id — serial
  • restaurant_id — uuid
  • profile_id — uuid
  • partner_id — uuid
  • rating_food — int
  • rating_service — int
  • rating_ambience — int

sales

  • id — serial
  • order_id — int
  • restaurant_id — uuid