SNS
Tables (6)
Untitled (profile)
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (school) — varchar
- Field (company) — varchar
Untitled (membership)
- Key (id) — varchar — Primary key — NOT NULL
- Field (password) — int — NOT NULL
- Field (email) — varchar — NOT NULL
- Field (name) — varchar — NOT NULL
Untitled (reply)
- Key (reply_no) — int — Primary key — NOT NULL
- Field (reply) — varchar — NOT NULL
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Key (wtnum) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (writ)
- Key (wtnum) — int — Primary key — NOT NULL
- Field (writing) — varchar — NOT NULL
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (like) — int — NOT NULL
- Field (view) — int — NOT NULL
- Field (date) — varchar — NOT NULL
Untitled (Like)
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Key (wtnum) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (friends)
- Field (friend_id) — varchar — NOT NULL
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL