SNS
Tables (6)
Untitled (회원가입)
- Field (id) — varchar — Primary key
- Field (password) — varchar
- Field (email) — varchar
- Field (name) — varchar
Untitled (프로필 등록)
- Field (id) — varchar — Foreign key → Untitled.Field
- Field (학교) — varchar
- Field (회사) — varchar
Untitled (글 등록)
- Key (글 번호) — int — Primary key — NOT NULL
- Field (등록날짜) — varchar
- Field (조회수) — varchar
- Field (좋아요) — int
- Field (id) — varchar — Foreign key → Untitled.Field
Untitled (좋아요)
- Field (id) — varchar — Foreign key → Untitled.Field
- Key (글 번호) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (댓글)
- Key (댓글번호) — int — Primary key — NOT NULL
- Field (내용) — varchar
- Field (id) — varchar — Foreign key → Untitled.Field
- Key (글 번호) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (친구목록)
- Field (id) — varchar — Foreign key → Untitled.Field
- Field (친구id) — varchar
- Field (등록날짜) — varchar