k404Cookey

Tables (11)

comment (의견)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • created_datd (Field) — DATETIME(6)
  • modified_date (Field2) — DATETIME(6(
  • content (Field3) — VARCHAR(255)
  • image_url (Field4) — VARCHAR(255)
  • parent_id (Field5) — BIGINT
  • recipe_id (Field6) — BIGINT — NOT NULL
  • user_id (Field7) — BIGINT — NOT NULL

ingredient (재료)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • is_sub (Field) — VARCHAR(255)
  • name (Field2) — VARCHAR(255)
  • recipe_id (Field3) — BIGINT — NOT NULL

label (라벨)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • created_date (Field) — DATETIME(6)
  • modified_date (Field2) — DATETIME(6)
  • recipe_id (Field3) — BIGINT — NOT NULL
  • user_id (Field4) — BIGINT — NOT NULL

rating (평점)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • created_date (Field) — DATETIME(6)
  • modified_date (Field2) — DATETIME(6)
  • star (Field3) — DOUBLE — NOT NULL
  • recipe_id (Field4) — BIGINT — NOT NULL
  • Field6

recipe (레시피)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • created_date (Field) — DATETIME(6)
  • modified_date (Field2) — DATETIME(6)
  • description (Field3) — VARCHAR(255)
  • star_count (Field4) — DOUBLE — NOT NULL
  • step (Field5) — INT — NOT NULL
  • thumbnail (Field6) — VARCHAR(255)
  • time (Field7) — INT — NOT NULL
  • title (Field8) — VARCHAR(255)
  • view_count (Field9) — INT — NOT NULL
  • wish_count (Field10) — INT — NOT NULL
  • pid (Field11) — BIGINT
  • user_id (Field12) — BIGINT — NOT NULL

recipe_theme (레시피주제)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • recipe_id (Field) — BIGINT — NOT NULL
  • theme_id (Field2) — NOT NULL

step (단계)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • description (Field) — VARCHAR(255)
  • image_url (Field2) — VARCHAR(255)
  • sequence (Field3) — INT — NOT NULL
  • recipe_id (Field4) — BIGINT — NOT NULL

theme (주제)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)

user (유저)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(255)
  • image_url (Field2) — VARCHAR(255)
  • name (Field3) — VARCHAR(255)

user_follow (유저 즐겨찾기)

  • follower_id (Key) — BIGINT — Primary key — NOT NULL
  • following_id (Key2) — BIGINT — Primary key — NOT NULL
  • follower_alarm (Field) — INT
  • following_alarm (Field2) — INT

user_roles (유저 역할)

  • user_id (Field) — BIGINT — NOT NULL
  • roles (Field2) — VARCHAR(255)