OMC_ERD

Tables (15)

omc_categoryi

  • id — BIGINT — Primary key — NOT NULL
  • index — VARCHAR(30) — NOT NULL
  • name — VARCHAR(30) — NOT NULL

omc_categorym

  • id — BIGINT — Primary key — NOT NULL
  • index — VARCHAR(30) — NOT NULL
  • name — VARCHAR(30) — NOT NULL

omc_categorys

  • id — BIGINT — Primary key — NOT NULL
  • index — VARCHAR(30) — NOT NULL
  • name — VARCHAR(30) — NOT NULL

omc_categoryt

  • id — BIGINT — Primary key — NOT NULL
  • index — VARCHAR(30) — NOT NULL
  • name — VARCHAR(30) — NOT NULL

omc_comment

  • id — BIGINT — Primary key — NOT NULL
  • content — LONGTEXT — NOT NULL
  • createdAt — DATETIME(6) — NOT NULL
  • modifiedAt — DATETIME(6) — NOT NULL
  • star — INT — NOT NULL
  • thumbnail — VARCHAR(100)
  • recipeId_id — BIGINT — Foreign key → omc_recipe.id — NOT NULL
  • userId_id — BIGINT — Foreign key → omc_user.id — NOT NULL
  • INDEX — `omc_comment_recipeId_id_a4a5aedc_fk_omc_recipe_id`
  • INDEX — `omc_comment_userId_id_05dacad0_fk_omc_user_id`

omc_icebox

  • id — BIGINT — Primary key — NOT NULL
  • userId_id — BIGINT — Foreign key → omc_user.id — NOT NULL
  • INDEX — `omc_icebox_userId_id_0cc69cea_fk_omc_user_id`

omc_icebox_userIngredientId

  • id — BIGINT — Primary key — NOT NULL
  • icebox_id — BIGINT — Foreign key → omc_icebox.id — NOT NULL
  • useringredient_id — BIGINT — Foreign key → omc_useringredient.id — NOT NULL
  • INDEX — `omc_icebox_userIngre_useringredient_id_5b51ae7b_fk_omc_useri`

omc_ingredient

  • id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • volume — VARCHAR(30) — NOT NULL
  • recipeId_id — BIGINT — Foreign key → omc_recipe.id — NOT NULL
  • INDEX — `omc_ingredient_recipeId_id_4dc6ddeb_fk_omc_recipe_id`

omc_recipe

  • id — BIGINT — Primary key — NOT NULL
  • mangaeId — VARCHAR(100) — NOT NULL
  • link — VARCHAR(200) — NOT NULL
  • name — VARCHAR(400) — NOT NULL
  • thumbnail — VARCHAR(200)
  • description — VARCHAR(2000)
  • amount — VARCHAR(30)
  • time — VARCHAR(30)
  • level — VARCHAR(30)
  • star — DOUBLE — NOT NULL
  • reviewCount — INT — NOT NULL
  • viewCount — INT — NOT NULL
  • categoryIId_id — BIGINT — Foreign key → omc_categoryi.id
  • categoryMId_id — BIGINT — Foreign key → omc_categorym.id
  • categorySId_id — BIGINT — Foreign key → omc_categorys.id
  • categoryTId_id — BIGINT — Foreign key → omc_categoryt.id
  • INDEX — `omc_recipe_categoryIId_id_37f49f44_fk_omc_categoryi_id`
  • INDEX — `omc_recipe_categoryMId_id_f0a04157_fk_omc_categorym_id`
  • INDEX — `omc_recipe_categorySId_id_cadb0c00_fk_omc_categorys_id`
  • INDEX — `omc_recipe_categoryTId_id_97eacfe5_fk_omc_categoryt_id`

omc_recipe_like

  • id — BIGINT — Primary key — NOT NULL
  • recipe_id — BIGINT — Foreign key → omc_recipe.id — NOT NULL
  • user_id — BIGINT — Foreign key → omc_user.id — NOT NULL
  • INDEX — `omc_recipe_like_user_id_85c9630f_fk_omc_user_id`

omc_recipehashtag

  • id — BIGINT — Primary key — NOT NULL
  • description — VARCHAR(30) — NOT NULL
  • recipeId_id — BIGINT — Foreign key → omc_recipe.id — NOT NULL
  • INDEX — `omc_recipehashtag_recipeId_id_23f774a9_fk_omc_recipe_id`
  • INDEX — `omc_recipehashtag_description_09d9a0e9`

omc_recipeorder

  • id — BIGINT — Primary key — NOT NULL
  • number — INT — NOT NULL
  • description — VARCHAR(2000) — NOT NULL
  • thumbnail — VARCHAR(200)
  • recipeId_id — BIGINT — Foreign key → omc_recipe.id — NOT NULL
  • INDEX — `omc_recipeorder_recipeId_id_db8a0717_fk_omc_recipe_id`

omc_user

  • id — BIGINT — Primary key — NOT NULL
  • password — VARCHAR(128) — NOT NULL
  • last_login — DATETIME(6)
  • is_superuser — TINYINT(1) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(10) — NOT NULL
  • avatar — VARCHAR(100)
  • is_active — TINYINT(1) — NOT NULL
  • is_admin — TINYINT(1) — NOT NULL
  • gender — TINYINT(1) — NOT NULL
  • ageGroup — VARCHAR(2) — NOT NULL
  • householdSize — VARCHAR(3) — NOT NULL

omc_usercustomingredient

  • id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • createdAt — DATETIME(6) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • iceBoxId_id — BIGINT — Foreign key → omc_icebox.id — NOT NULL
  • userId_id — BIGINT — Foreign key → omc_user.id — NOT NULL
  • INDEX — `omc_usercustomingredient_iceBoxId_id_b45ba02f_fk_omc_icebox_id`
  • INDEX — `omc_usercustomingredient_userId_id_52c9cc7f_fk_omc_user_id`

omc_useringredient

  • id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • name — VARCHAR(30) — NOT NULL