graduate-project
Tables (16)
ChatMessage
- chatMessageId — BINARY(16) — Primary key — NOT NULL
- userId — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- chatRoomId — BINARY(16) — Foreign key → ChatRoom.chatRoomId — NOT NULL
- type — VARCHAR(20) — NOT NULL
- detailMessage — TEXT — NOT NULL
- createTime — DATETIME
- isRead — BOOLEAN
ChatRoom
- chatRoomId — BINARY(16) — Primary key — NOT NULL
- shareId — BINARY(16) — Foreign key → Share.shareId — NOT NULL
- senderId — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- createTime — DATETIME
- updateTime — DATETIME
ChatRoomParticipant
- chatRoomId — BINARY(16) — Foreign key → ChatRoom.chatRoomId — NOT NULL
- recieverId — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- createTime — DATETIME
Ingredient
- ingredientId — BINARY(16) — Primary key — NOT NULL
- ingredientName — VARCHAR(100)
- category — VARCHAR(50)
Location
- locaionId (locationId) — BINARY(16) — Primary key — NOT NULL
- userId — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- latitude — DOUBLE
- longitude — DOUBLE
- fullAddress — VARCHAR(100)
- displayAddress — VARCHAR(50)
Ocr
- ocrId — BINARY(16) — Primary key — NOT NULL
- userId — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- imageUrl — VARCHAR(255)
- accuracy — DOUBLE
- createTime (createTIme) — DATETIME
OcrIngredient
- ocrIngredientId — BINARY(16) — Primary key — NOT NULL
- ocrId — BINARY(16) — Foreign key → Ocr.ocrId — NOT NULL
- corIngredientName (ocrIngredientName) — VARCHAR(100)
Recipe
- recipeId — BINARY(16) — Primary key — NOT NULL
- name — VARCHAR(100)
- category — VARCHAR(50)
- imageUrl — VARCHAR(255)
RecipeIngredient (Recipe_Ingredient)
- recipeIngredientId — BINARY(16) — Primary key — NOT NULL
- recipeId — BINARY(16) — Foreign key → Recipe.recipeId — NOT NULL
- ingredientId — BINARY(16) — Foreign key → Ingredient.ingredientId — NOT NULL
- amount — DOUBLE
- unit — VARCHAR(20)
RecipeStep (Recipe_Step)
- recipeStepId — BINARY(16) — Primary key — NOT NULL
- recipeId — BINARY(16) — Foreign key → Recipe.recipeId — NOT NULL
- stepOrder — BIGINT
- description — TEXT
Report
- reportId — BINARY(16) — Primary key — NOT NULL
- reporterId — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- shareId — BINARY(16) — Foreign key → Share.shareId — NOT NULL
- reason — TEXT — NOT NULL
- createTime — DATETIME
Share
- shareId — BINARY(16) — Primary key — NOT NULL
- userId — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- userIngredientId — BINARY(16) — Foreign key → UserIngredient.userIngredientId — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- status — VARCHAR(20)
- category — VARCHAR(50)
- expirationDate — DATE
- isView — VARCHAR(20)
- createTime — DATETIME
- updateTime — DATETIME
SharePicture
- sharePictureId — BINARY(16) — Primary key — NOT NULL
- shareId — BINARY(16) — Foreign key → Share.shareId — NOT NULL
- pictureUrl — VARCHAR(255) — NOT NULL
User
- userId — VARCHAR(50) — Primary key — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(100)
- nickName — VARCHAR(50) — NOT NULL
- firstLogin — VARCHAR(20)
- reportCount — BIGINT
- status — VARCHAR(20)
- deletedAt — DATETIME
UserIngredient
- userIngredientId — BINARY(16) — Primary key — NOT NULL
- userId — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- ingredientId — BINARY(16) — Foreign key → Ingredient.ingredientId — NOT NULL
- expirationDate — DATE
- status — VARCHAR(20)
UserPreferenceIngredient
- userPreferenceId — BINARY(16) — Primary key — NOT NULL
- userId — VARCHAR(50) — Foreign key → User.userId — NOT NULL
- ingredientId — BINARY(16) — Foreign key → Ingredient.ingredientId — NOT NULL
- type — VARCHAR(50)