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)