React project

Tables (8)

category (Untitled2)

  • Key (category_id) — Primary key — NOT NULL
  • Field (category_name)

comment (Untitled5)

  • Key — Primary key — NOT NULL
  • Key (uid) — Foreign key → user.Key — NOT NULL
  • Key (post_id2) — Foreign key → post.Key — NOT NULL
  • Key (uid2) — Foreign key → post.Key — NOT NULL
  • Key (category_id) — Foreign key → post.Key — NOT NULL
  • Field (post_id)
  • Field (content)

heart (Untitled6)

  • Key — Primary key — NOT NULL
  • Key (uid) — Foreign key → user.Key — NOT NULL
  • Key (post_id2) — Foreign key → post.Key — NOT NULL
  • Key (uid2) — Foreign key → post.Key — NOT NULL
  • Key (category_id) — Foreign key → post.Key — NOT NULL
  • Field (post_id)

member (Untitled7)

  • Key — Primary key — NOT NULL
  • Key (uid) — Foreign key → user.Key — NOT NULL
  • Key (project_id2) — Foreign key → teamproject.Key — NOT NULL
  • Field (project_id)

myproject (Untitled8)

  • Key (myproject_id) — Primary key — NOT NULL
  • Key (uid) — Foreign key → user.Key — NOT NULL
  • Field (title)
  • Field (content)
  • Field (img)

post (Untitled4)

  • Key (post_id) — Primary key — NOT NULL
  • Key (uid) — Foreign key → user.Key — NOT NULL
  • Key (category_id) — Foreign key → category.Key — NOT NULL
  • Field2 (title)
  • Field (img)
  • 내용 (content)
  • Field (tag)

teamproject (Untitled3)

  • Key (project_id) — Primary key — NOT NULL
  • Key (uid) — Foreign key → user.Key — NOT NULL
  • Field (title)
  • Field (content)
  • Field (img)

user (Untitled)

  • Key (uid) — Primary key — NOT NULL
  • Field (nick)
  • Field (upw)
  • 성별 (gender)
  • 전화번호 (phonenum)
  • 생년월 (dob)
  • 주소 (address)