recipe

Tables (4)

Untitled (nemo_board_type)

  • Key (BOARD_TYPE_ID) — int — Primary key — NOT NULL
  • Field (BOARD_NAME) — varchar
  • Field2 (REG_DATE) — datetype
  • Field3 (EDIT_DATE) — datetype

Untitled (nemo_board)

  • Key (BOARD_ID) — int — Primary key — NOT NULL
  • Key (USER_ID) — int — Primary key — NOT NULL
  • Field (USER_NICKNAME) — varchar
  • Field2

nemo_recipe (NEMO_RECIPE)

  • recipe_id (RECIPE_ID) — int — Primary key — NOT NULL
  • Key (BOARD_TYPE_ID) — int — Primary key — NOT NULL
  • Field2 (RECIPE_IMG) — longtext
  • Field3 (RECIPE_CATE01) — int
  • Field4 (RECIPE_CATE02) — int
  • Field5 (RECIPE_CATE03) — int
  • Field6 (RECIPE_CATE04) — int
  • Field7 (RECIPE_INFO01) — int
  • Field (RECIPE_INFO02) — int
  • Field2 (RECIPE_INFO03) — int
  • Field3 (RECIPE_INGRAD) — longtext
  • Field4 (RECIPE_HOWTO) — longtext
  • Field5 (RECIPE_REGDATE) — datetype
  • Field6 (RECIPE_VIEWCNT) — int
  • Field (RECIPE_LIKECNT) — int
  • Field (RECIPE_SCRAPCNT) — int

nemo_user (NEMO_USER)

  • Key (USER_ID) — INT — Primary key — NOT NULL
  • Field (USER_NICKNAME) — varcahr
  • Field2 (USER_EMAL) — varchar
  • Field3 (USER_PHONENUM) — varchar
  • Field4 (USER_REGDATE) — datetype
  • Field