bababba
Tables (32)
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
direct_chats
- id — uuid — Primary key — NOT NULL
- user1_id — uuid — NOT NULL
- user2_id — uuid — NOT NULL
- created_at — timestamp
- last_message_at — timestamp
- user_pair_high — uuid
- user_pair_low — uuid
direct_messages
- id — uuid — Primary key — NOT NULL
- chat_id — uuid — NOT NULL
- sender_id — uuid — NOT NULL
- content — text — NOT NULL
- is_read — boolean
- read_at — timestamp
- created_at — timestamp
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
- status — USER-DEFINED
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