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)