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