모두의 부엌
테이블 (10)
categories
- id — uuid — 기본 키 — NOT NULL
- name — character — NOT NULL
- description — text
- is_active — boolean
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
comment_likes
- id — uuid — 기본 키 — NOT NULL
- comment_id — uuid — NOT NULL
- user_id — uuid — NOT NULL
- created_at — timestamp
comments
- id — uuid — 기본 키 — NOT NULL
- post_id — uuid — NOT NULL
- user_id — uuid — NOT NULL
- content — text — NOT NULL
- is_comment_active — boolean
- like_count — integer
- created_at — timestamp
- updated_at — timestamp
- is_user_active — boolean
email_verifications
- id — uuid — 기본 키 — NOT NULL
- email — character — NOT NULL
- code — character — NOT NULL
- verified — boolean
- expires_at — timestamp — NOT NULL
- created_at — timestamp
files
- id — uuid — 기본 키 — NOT NULL
- filename — text — NOT NULL
- file_type — USER-DEFINED — NOT NULL
- post_id — uuid
- user_id — uuid — NOT NULL
- created_at — timestamp
post_bookmarks
- id — uuid — 기본 키 — NOT NULL
- post_id — uuid — NOT NULL
- user_id — uuid — NOT NULL
- created_at — timestamp
post_votes
- id — uuid — 기본 키 — NOT NULL
- post_id — uuid — NOT NULL
- user_id — uuid — NOT NULL
- vote_type — USER-DEFINED — NOT NULL
- created_at — timestamp
posts
- id — uuid — 기본 키 — NOT NULL
- category_id — uuid
- user_id — uuid — NOT NULL
- post_type — USER-DEFINED
- title — character — NOT NULL
- content — text
- difficulty — USER-DEFINED
- cooking_time — integer
- ingredients — text
- servings — integer
- bookmark_count — integer
- share_status — USER-DEFINED
- pickup_location — text
- is_user_active — boolean
- is_post_active — boolean
- created_at — timestamp
- updated_at — timestamp
- like_count — integer
- dislike_count — integer
user_levels
- id — uuid — 기본 키 — NOT NULL
- user_id — uuid — NOT NULL
- current_level — integer — NOT NULL
- total_posts_created — integer — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- title — text
users
- id — uuid — 기본 키 — NOT NULL
- instance_id — uuid
- aud — character
- role — character
- email — character
- encrypted_password — character
- email_confirmed_at — timestamp
- invited_at — timestamp
- confirmation_token — character
- confirmation_sent_at — timestamp
- recovery_token — character
- recovery_sent_at — timestamp
- email_change_token_new — character
- email_change — character
- email_change_sent_at — timestamp
- last_sign_in_at — timestamp
- raw_app_meta_data — jsonb
- raw_user_meta_data — jsonb
- is_super_admin — boolean
- created_at — timestamp
- updated_at — timestamp
- phone — text
- phone_confirmed_at — timestamp
- phone_change — text
- phone_change_token — character
- phone_change_sent_at — timestamp
- confirmed_at — timestamp
- email_change_token_current — character
- email_change_confirm_status — smallint
- banned_until — timestamp
- reauthentication_token — character
- reauthentication_sent_at — timestamp
- is_sso_user — boolean — NOT NULL
- deleted_at — timestamp
- is_anonymous — boolean — NOT NULL