recipe
Tables (3)
recipe (레시피)
- recipe_id (Key) — BIGINT — Primary key — NOT NULL
- recipe_user_id (Key2) — BIGINT — Foreign key → recipe_user.recipe_user_id — NOT NULL
- recipe_name (Field) — VARCHAR(20)
- recipe_url (Field2) — VARCHAR
- recipe_desc (Field3) — VARCHAR
- recipe_stored (Field4) — VARCHAR
recipe_user (레시피 사용자)
- recipe_user_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key4) — BIG INT — Foreign key → user.user_id — NOT NULL
- recipe_id (Key2) — BIGINT — Foreign key → recipe.recipe_id — NOT NULL
- group_name (Field) — VARCHAR
user (사용자)
- user_id (Key) — BIG INT — Primary key — NOT NULL
- user_email (Field) — VARCHAR(20)
- user_nickname (Field2) — VARCHAR(10)
- user_password (Field3) — VARCHAR(20)
- auth_code (Field4) — VARCHAR