Busan-Hackathon

Tables (5)

FOOD (Untitled4)

  • food_id (Key) — Primary key — NOT NULL
  • foodName (못 먹는 음식 이름) — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL

HEART (Untitled3)

  • heart_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL
  • post_id (Key3) — Foreign key → POST.post_id — NOT NULL

MEMBER (Untitled)

  • member_id (Key) — Primary key — NOT NULL
  • loginId (아이디) — NOT NULL
  • password (비밀번호) — NOT NULL
  • nickname (닉네임) — NOT NULL

POST (Untitled5)

  • post_id (Key) — Primary key — NOT NULL
  • title (제목) — NOT NULL
  • content (본문) — NOT NULL
  • viewCount (조회수) — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL
  • recipe_id (Key3) — Foreign key → RECIPE.recipe_id — NOT NULL

RECIPE (Untitled2)

  • recipe_id (Key) — Primary key — NOT NULL
  • foodName (음식 이름) — NOT NULL
  • method (조리 방법) — NOT NULL
  • isPublic (Field) — NOT NULL
  • member_id (Key2) — Foreign key → MEMBER.member_id — NOT NULL