식구

테이블 (7)

Untitled5

  • tagId (tag_id) — NOTNULL — 기본 키 — NOT NULL
  • tagName (태그명) — NOTNULL

comments (Untitled7)

  • Key — 기본 키 — NOT NULL
  • body (본문) — NOTNULL
  • createdAt (작성시기) — NOTNULL
  • status (채택유무) — NOTNULL
  • memberId (외래키) — NOTNULL
  • postId (FK) — NOTNULL

groups (Untitled6)

  • groupId (group_id) — NOTNULL — 기본 키 — NOT NULL
  • postId (외래키) — NOTNULL
  • memberId (FK) — NOTNULL

member (Untitled)

  • memberId (member_id) — NOTNULL — 기본 키 — NOT NULL
  • myPageId — NOTNULL — 외래 키 → mypages.myPageId — NOT NULL
  • name (이름) — NOTNULL
  • email (이메일) — NOTNULL
  • password (비밀번호) — NOTNULL
  • createdAt (생성시기) — NOTNULL
  • gender (성별) — NOTNULL
  • ageRange (연령대) — NOTNULL

mypages (Untitled2)

  • myPageId — NOTNULL — 기본 키 — NOT NULL
  • introduce (자기소개) — NOTNULL
  • likes (좋아요) — NOTNULL
  • img (이미지파일) — NULLABLE
  • followerCount (팔로워수) — NOTNULL
  • review (한줄평) — NULLABLE
  • memberId (외래키) — NOTNULL

posts (Untitled3)

  • postId (post_id) — NOTNULL — 기본 키 — NOT NULL
  • memberId (member_id) — NOTNULL — 외래 키 → member.memberId — NOT NULL
  • title (제목) — NOTNULL
  • body (본문) — NOTNULL
  • mealTime (식사시간) — NOTNULL
  • createdAt (작성시기) — NOTNULL
  • status (활성유무) — NOTNULL
  • memberId (외래키) — NOTNULL

posts_tags (Untitled4)

  • postId — NOTNULL — 기본 키 — NOT NULL
  • tagId (tag_id) — NOTNULL