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