4
Tables (20)
Admin_Account
- adminId — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- passwordHash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — ENUM('ADMIN', 'OPERATOR') — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
- lastLoginAt — DATETIME
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
Admin_Audit_Log
- auditLogId — BIGINT — Primary key — NOT NULL
- adminId — BIGINT — Foreign key → Admin_Account.adminId — NOT NULL
- actionType — VARCHAR(50) — NOT NULL
- targetType — VARCHAR(50) — NOT NULL
- targetId — BIGINT
- detail — TEXT
- createTime — DATETIME — NOT NULL
Banner
- bannerId — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- imageUrl — VARCHAR(255) — NOT NULL
- linkUrl — VARCHAR(255)
- status — ENUM('DRAFT', 'SCHEDULED', 'ACTIVE', 'ENDED') — NOT NULL
- startAt — DATETIME
- endAt — DATETIME
- createdBy — BIGINT — Foreign key → Admin_Account.adminId — NOT NULL
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
ChatMessage
- chatMessageId — BIGINT — Primary key — NOT NULL
- userId — BIGINT — Foreign key → User.userId — NOT NULL
- chatRoomId — BIGINT — Foreign key → ChatRoom.chatRoomId — NOT NULL
- type — ENUM('TEXT', 'IMAGE', 'SYSTEM') — NOT NULL
- detailMessage — TEXT — NOT NULL
- createTime — DATETIME — NOT NULL
ChatRoom
- chatRoomId — BIGINT — Primary key — NOT NULL
- shareId — BIGINT — Foreign key → Share.shareId — NOT NULL
- buyerId — BIGINT — Foreign key → User.userId — NOT NULL
- status — ENUM('ACTIVE', 'CLOSED') — NOT NULL
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
ChatRoomParticipant
- chatRoomId — BIGINT — Foreign key → ChatRoom.chatRoomId — NOT NULL
- userId — BIGINT — Foreign key → User.userId — NOT NULL
- role — ENUM('SELLER', 'BUYER') — NOT NULL
- lastReadAt — DATETIME
- createTime — DATETIME — NOT NULL
Ingredient_Master
- ingredientId — BIGINT — Primary key — NOT NULL
- ingredientName — VARCHAR(100) — NOT NULL
- category — VARCHAR(50)
- storageType — VARCHAR(20)
- baseUnit — VARCHAR(20)
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
Ingredients
- inventoryId — BIGINT — Primary key — NOT NULL
- userId — BIGINT — Foreign key → User.userId — NOT NULL
- ingredientId — BIGINT — Foreign key → Ingredient_Master.ingredientId — NOT NULL
- quantity — DECIMAL(10,2) — NOT NULL
- unit — VARCHAR(20)
- purchaseDate — DATE
- expirationDate — DATE
- status — ENUM('IN_FRIDGE', 'USED', 'SHARED', 'EXPIRED', 'DELETED') — NOT NULL
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
Location
- locationId — BIGINT — Primary key — NOT NULL
- userId — BIGINT — Foreign key → User.userId — NOT NULL
- latitude — DOUBLE
- longitude — DOUBLE
- fullAddress — VARCHAR(255)
- displayAddress — VARCHAR(100)
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
Notice
- noticeId — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('DRAFT', 'SCHEDULED', 'ACTIVE', 'ENDED') — NOT NULL
- startAt — DATETIME
- endAt — DATETIME
- createdBy — BIGINT — Foreign key → Admin_Account.adminId — NOT NULL
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
OCR_Job
- ocrJobId — BIGINT — Primary key — NOT NULL
- userId — BIGINT — Foreign key → User.userId — NOT NULL
- imageUrl — VARCHAR(255) — NOT NULL
- requestType — ENUM('REGISTER', 'RECHECK') — NOT NULL
- requestId — VARCHAR(100)
- status — ENUM('QUEUED', 'PROCESSING', 'COMPLETED', 'FAILED', 'RETRYING') — NOT NULL
- overallConfidence — DECIMAL(5,4)
- lowConfidenceCount — INT — NOT NULL
- purchaseDate — DATE
- rawText — TEXT
- modelVersion — VARCHAR(50)
- failureReason — VARCHAR(255)
- processedAt — DATETIME
- retryCount — INT — NOT NULL
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
OCR_Result_Item
- ocrResultItemId — BIGINT — Primary key — NOT NULL
- ocrJobId — BIGINT — Foreign key → OCR_Job.ocrJobId — NOT NULL
- lineNo — INT — NOT NULL
- rawName — VARCHAR(100) — NOT NULL
- normalizedName — VARCHAR(100)
- ingredientId — BIGINT — Foreign key → Ingredient_Master.ingredientId
- quantity — DECIMAL(10,2)
- unit — VARCHAR(20)
- confidence — DECIMAL(5,4)
- isLowConfidence — BOOLEAN — NOT NULL
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
Recipe
- recipeId — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50)
- cookingMethod — VARCHAR(50)
- calories — INT
- imageUrl — VARCHAR(255)
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
Recipe_Ingredient
- riId — BIGINT — Primary key — NOT NULL
- recipeId — BIGINT — Foreign key → Recipe.recipeId — NOT NULL
- ingredientId — BIGINT — Foreign key → Ingredient_Master.ingredientId — NOT NULL
- amount — DECIMAL(10,2)
- unit — VARCHAR(20)
Recipe_Step
- rsId — BIGINT — Primary key — NOT NULL
- recipeId — BIGINT — Foreign key → Recipe.recipeId — NOT NULL
- stepOrder — INT — NOT NULL
- description — TEXT — NOT NULL
- createTime — DATETIME — NOT NULL
Report
- reportId — BIGINT — Primary key — NOT NULL
- reporterId — BIGINT — Foreign key → User.userId — NOT NULL
- shareId — BIGINT — Foreign key → Share.shareId — NOT NULL
- reasonCode — VARCHAR(50) — NOT NULL
- reasonDetail — TEXT
- status — ENUM('RECEIVED', 'REVIEWING', 'RESOLVED', 'REJECTED') — NOT NULL
- handledBy — BIGINT — Foreign key → Admin_Account.adminId
- resolution — TEXT
- handledAt — DATETIME
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
Share
- shareId — BIGINT — Primary key — NOT NULL
- userId — BIGINT — Foreign key → User.userId — NOT NULL
- inventoryId — BIGINT — Foreign key → Ingredients.inventoryId — NOT NULL
- locationId — BIGINT — Foreign key → Location.locationId
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- ingredientNameSnapshot — VARCHAR(100) — NOT NULL
- quantitySnapshot — DECIMAL(10,2) — NOT NULL
- unitSnapshot — VARCHAR(20)
- expirationDateSnapshot — DATE
- status — ENUM('PROCEEDING', 'RESERVED', 'COMPLETED', 'HIDDEN', 'DELETED') — NOT NULL
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
Share_Picture
- spId — BIGINT — Primary key — NOT NULL
- shareId — BIGINT — Foreign key → Share.shareId — NOT NULL
- pictureUrl — VARCHAR(255) — NOT NULL
- sortOrder — INT — NOT NULL
- createTime — DATETIME — NOT NULL
User
- userId — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- passwordHash — VARCHAR(255)
- nickName — VARCHAR(50) — NOT NULL
- address — VARCHAR(255)
- authProvider — ENUM('local', 'kakao', 'google', 'apple') — NOT NULL
- createTime — DATETIME — NOT NULL
- updateTime — DATETIME — NOT NULL
User_Preference
- prefId — BIGINT — Primary key — NOT NULL
- userId — BIGINT — Foreign key → User.userId — NOT NULL
- ingredientId — BIGINT — Foreign key → Ingredient_Master.ingredientId
- preferenceType — ENUM('ALLERGY', 'FAVORITE', 'DISLIKE') — NOT NULL
- preferenceValue — VARCHAR(100) — NOT NULL
- createTime — DATETIME — NOT NULL