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)