SNS
Tables (6)
Untitled (JOIN)
- Key (ID) — varchar(50) — Primary key — NOT NULL
- Field (PW) — varchar(50) — NOT NULL
- Field (email) — varchar(50) — NOT NULL
- Field (name) — varchar(50) — NOT NULL
Untitled (Profile)
- Key (ID) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
- Field (School) — varchar(50)
- Field (Company) — varchar(50)
Untitled (Post)
- Key (PostNo) — int(10) — Primary key — NOT NULL
- Field (date) — varchar(20) — NOT NULL
- Field (memo) — varchar(1000) — NOT NULL
- Field (view) — int(10) — NOT NULL
- Field (Likes) — int(10) — NOT NULL
- Key (ID) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
Untitled (Reply)
- Key (ReplNo) — int(10) — Primary key — NOT NULL
- Key (ID) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
- Key (PostNo) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Field (comment) — varchar(200) — NOT NULL
Untitled (Likes)
- Key (PostNo) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (ID) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
Untitled (Friends)
- Field (Friend_ID) — varchar(50) — NOT NULL
- Key (ID) — varchar(50) — Foreign key → Untitled.Key — NOT NULL