likelion

Tables (6)

comment

  • Key — Primary key — NOT NULL
  • post (게시글) — Foreign key → post.Key — NOT NULL
  • content (내용)

comment like

  • Key — Primary key — NOT NULL
  • comment (댓글 좋아요) — Foreign key → comment.Key — NOT NULL
  • like_user (사용자) — Foreign key → user.Key — NOT NULL

post

  • Key — Primary key — NOT NULL
  • writer (작성자) — Foreign key → user.Key — NOT NULL
  • content (내용)

post like

  • Key — Primary key — NOT NULL
  • post (게시글) — Foreign key → post.Key — NOT NULL
  • like_user (사용자) — Foreign key → user.Key — NOT NULL

team

  • Key — Primary key — NOT NULL

user

  • Key — Primary key — NOT NULL
  • user_id (사용자 아이디)
  • user_password (사용자 비밀번호)
  • user_email (사용자 이메일)
  • user_tellphone (사용자 전화번호)
  • team (사용자 팀) — Foreign key → team.Key — NOT NULL