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