SNS SERVICE

Tables (6)

Friends (친구목록)

  • friendID (친구아이디) — varchar — NOT NULL
  • id (아이디) — varchar — Foreign key → User.id — NOT NULL

Like (좋아요)

  • id (아이디) — varchar — Foreign key → User.id — NOT NULL
  • pnum (글번호) — varchar — Foreign key → Post.pnum — NOT NULL

Post (게시글)

  • pnum (글번호) — int — Primary key — NOT NULL
  • view (조회수) — varchar — NOT NULL
  • like (좋아요수) — int — NOT NULL
  • id (아이디) — varchar — Foreign key → User.id — NOT NULL

Profile (프로필)

  • id (아이디) — varchar — Foreign key — NOT NULL
  • company (회사) — varchar
  • school (학교) — varchar

Reply (댓글)

  • rnum (댓글번호) — int — Primary key — NOT NULL
  • comment (내용) — varchar — NOT NULL
  • id (아이디) — varchar — Foreign key → User.id — NOT NULL
  • pnum (글번호) — varchar — Foreign key → Post.pnum — NOT NULL

User (회원)

  • id (아이디) — varchar — Primary key — NOT NULL
  • password (비밀번호) — varchar — NOT NULL
  • email (이메일) — varchar — NOT NULL
  • name (이름) — varchar — NOT NULL