project2

Tables (5)

LIKES

  • LIKE_ID — UNSIGNED BIG INT — Primary key — NOT NULL
  • USER_ID — UNSIGNED BIG INT — Foreign key → USERS.USER_ID — NOT NULL
  • RCP_SNO — UNSIGNED BIG INT — Foreign key → RECIPE.RCP_SNO — NOT NULL
  • CREATED_AT — TIMESTAMP
  • MODIFIED_AT (Field)

RECIPE

  • RCP_SNO — UNSIGNED BIG INT — Primary key — NOT NULL
  • RCP_TTL — VARCHAR(255)
  • CKG_NM
  • INQ_CNT
  • RCMM_CNT
  • CKG_MTH_ACTO_NM
  • CKG_MTRL_ACTO_NM
  • CKG_KND_ACTO_NM
  • CKG_MTRL_CN
  • CKG_INBUN_NM
  • CKG_DODF_NM
  • CKG_TIME_NM
  • FIRST_REG_DT — TIMESTAMP
  • RCP_IMG_URL

RECIPE_COMPLETIONS

  • COMPLETION_ID — UNSIGNED BIG INT — Primary key — NOT NULL
  • USER_ID — UNSIGNED BIG INT — Foreign key → USERS.USER_ID — NOT NULL
  • RCP_SNO — UNSIGNED BIG INT — Foreign key → RECIPE.RCP_SNO — NOT NULL
  • CREATED_AT — TIMESTAMP
  • MODIFIED_AT (Field)

USERS

  • USER_ID — UNSIGNED BIG INT — Primary key — NOT NULL
  • ID — VARCHAR(50)
  • PWD — VARCHAR(255)
  • NAME — VARCHAR(100)
  • NICKNAME — VARCHAR(50)
  • EMAIL — VARCHAR(50)
  • BIRTH — DATE
  • GENDER — ENUM('F', 'M')
  • ROLE — ENUM('ADMIN', 'GUEST')
  • CREATED_AT (CAREATED_AT) — TIMESTAMP
  • MODIFIED_AT — TIMESTAMP

USER_REFERENCES

  • PREFERENCE_ID — UNSIGNED BIG INT — Primary key — NOT NULL
  • USER_ID — UNSIGNED BIG INT — Foreign key → USERS.USER_ID — NOT NULL
  • RCP_SNO — UNSIGNED BIG INT — Foreign key → RECIPE.RCP_SNO — NOT NULL
  • PREFERENCE_TYPE — ENUM ('VIEW', 'LIKE')
  • CREATED_AT — TIMESTAMP
  • MODIFIED_AT (Field)