Coffeeing Note

Tables (16)

Cafe (cafe)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (hash_id) — char(64)
  • Field (name) — varchar
  • Field (description) — varchar
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

CafeLike (cafe_like)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (cafe_id) — bigint — Foreign key → Cafe.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (like_type) — integer
  • Field (created_at) — datetime

CafeMember (cafe_member)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (cafe_id) — bigint — Foreign key → Cafe.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (permission) — integer
  • Field (is_received) — boolean
  • Field (created_at) — datetime

CafeMessage (cafe_message)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (cafe_id) — bigint — Foreign key → Cafe.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (hash_id) — char(64)
  • Field (hashed_content) — char(64)
  • Field (read_users) — json
  • Field (is_blinded) — boolean
  • Field (created_at) — datetime

CafeRecipe (cafe_recipe)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (cafe_id) — bigint — Foreign key → Cafe.Key — NOT NULL
  • Key (recipe_id) — bigint — Foreign key → Recipe.Key — NOT NULL
  • Field (is_received) — boolean
  • Field (created_at) — datetime

Recipe (recipe)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (hash_id) — char(64)
  • Field (title) — varchar
  • Field (description) — varchar
  • Field (extract_type) — integer
  • Field (bean_amount) — integer
  • Field (water_amount) — integer
  • Field (elapsed_start_time) — integer
  • Field (elapsed_end_time) — integer
  • Field (status) — integer
  • Field (is_published) — boolean
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

RecipeAttachment (recipe_attachment)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (recipe_id) — bigint — Foreign key → Recipe.Key — NOT NULL
  • Field (file) — File
  • Field (created_at) — datetime

RecipeFeedback (recipe_feedback)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (recipe_id) — bigint — Foreign key → Recipe.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (hash_id) — char(64)
  • Field (content) — varchar
  • Field (is_blinded) — boolean
  • Field (created_at) — datetime
  • Key (root_feedback) — bigint — Foreign key → RecipeFeedback.Key — NOT NULL

RecipeFeedbackLike (recipe_feedback_like)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (recipe_feedback_id) — bigint — Foreign key → RecipeFeedback.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (like_type) — integer
  • Field (created_at) — datetime

RecipeLike (recipe_like)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (recipe_id) — bigint — Foreign key → Recipe.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (like_type) — integer
  • Field (created_at) — datetime

RecipeTag (recipe_tag)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (recipe_id) — bigint — Foreign key → Recipe.Key — NOT NULL
  • Key (tag_id) — bigint — Foreign key → Tag.Key — NOT NULL

Tag (tag)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (keyword) — varchar
  • Field (created_at) — datetime

User (user)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (hash_id) — char(64)
  • Field (username) — email
  • Field (password) — char
  • Field (nickname) — varchar
  • Field (is_email_auth) — boolean
  • Field (is_blocked) — boolean
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

UserReport (user_report)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Key (target_user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (content) — varchar
  • Field (created_at) — datetime

UserReportResult (user_report_result)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_report_id) — bigint — Foreign key → UserReport.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (content) — varchar
  • Field (created_at) — datetime

UserSubscribe (user_subscribe)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Key (follow_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (created_at) — datetime