test
Tables (6)
Untitled (회원)
- Key (id) — varchar(20) — Primary key — NOT NULL
- Field (pw) — varchar(20)
- Field (email) — varchar(50)
- Field (name) — varchar(10)
Untitled (프로필)
- Key (id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (학교) — varchar(15)
- Field (회사) — varchar(15)
- Field (등록일)
Untitled (글)
- Key (글번호) — int(1000) auto_increment — Primary key — NOT NULL
- Key (id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (멘트) — varchar(300)
- Field (등록날짜) — date default current_date
- Field (조회수) — int(100)
- Field (등록일)
Untitled2 (댓글)
- Key (댓글번호) — Primary key — NOT NULL
- Field (내용)
- Key (글번호) — int(1000) auto_increment — Foreign key → Untitled.Key — NOT NULL
- Key (id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (등록일)
Untitled3 (친구목록)
- Key (id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Field (친구id)
- Field (관계)
- Field (등록일)
Untitled3 (좋아요)
- Key (id) — varchar(20) — Foreign key → Untitled.Key — NOT NULL
- Key (글번호) — int(1000) auto_increment — Foreign key → Untitled.Key — NOT NULL
- Field (등록일)