SNS Service

Tables (6)

Friend (Untitled5)

  • User2 no. (Key2) — Primary key — NOT NULL
  • 누가 (Key) — Foreign key → User.User no. — NOT NULL
  • 누구에게 (Key3) — Foreign key → User.User no. — NOT NULL

Like (Untitled6)

  • User no. (Key) — Foreign key → User.User no. — NOT NULL
  • Post no. (Key2) — Foreign key → Post.Post no. — NOT NULL
  • 좋아요한 날짜 (Field)

Post (Untitled3)

  • Post no. (Key2) — Primary key — NOT NULL
  • 제목 (Field)
  • 내용 (Field2)
  • 조회수 (Field3)
  • User no. (Key) — Foreign key → User.User no. — NOT NULL
  • 등록날짜 (Field4)

Profile (Untitled2)

  • Profile no. (Key2) — Primary key — NOT NULL
  • User no. (Key) — Foreign key → User.User no. — NOT NULL
  • School (Field)
  • Company (Field2)

Reply (Untitled4)

  • Reply no. (Key) — Primary key — NOT NULL
  • 댓글 작성자 (Field)
  • 댓글 내용 (Field2)
  • Post no. (Key2) — Foreign key → Post.Post no. — NOT NULL
  • User no. (Key3) — Foreign key → User.User no. — NOT NULL

User (Untitled)

  • User no. (Key) — Primary key — NOT NULL
  • ID (Field)
  • PW (Field2)
  • E-Mail (Field3)
  • Name (Field4)