모두의 부엌

테이블 (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