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