SNS
Tables (6)
Untitled (member)
- Key (id) — varchar — Primary key — NOT NULL
- Field (pwd) — varchar
- Field (email) — varchar
- Field (name) — varchar
Untitled (profile)
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (school) — varchar
- Field (job) — varchar
Untitled (friends)
- Field (friend_id) — varchar
- Key (id2) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (posting)
- Key (post_no) — int — Primary key — NOT NULL
- Field (date) — date
- Field (look) — int
- Field (like) — int
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (reply)
- Field (reply_no) — int — Primary key
- Key (post_no) — int — Foreign key → Untitled.Key — NOT NULL
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (like)
- Key (post_no) — int — Foreign key → Untitled.Key — NOT NULL
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL