ERDtest
Tables (22)
Copy Of Untitled (회원)
- Key (아이디) — Primary key — NOT NULL
- Field (비밀번호)
- Field (이메일)
- Field (이름)
Copy Of Untitled2 (프로필)
- Field (학교)
- Field (회사)
- Field (작성일)
- Key (아이디) — Foreign key → Copy Of Untitled.Key — NOT NULL
Copy Of Untitled3 (글)
- Key (글번호) — Primary key — NOT NULL
- Key (아이디) — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (멘트)
- Field (조회수)
- Field (좋아요수)
- Field (등록날짜)
Copy Of Untitled4 (댓글)
- Key (댓글번호) — Primary key — NOT NULL
- Key (글번호) — Foreign key → Copy Of Untitled3.Key — NOT NULL
- Field (내용)
- Field (작성일)
- Key (아이디) — Foreign key → Copy Of Untitled.Key — NOT NULL
Copy Of Untitled5 (친구)
- Key (친구번호) — Primary key — NOT NULL
- Key (아이디) — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (친구아이디)
- Field (친구맺은 날짜)
- Field (관계)
Copy Of Untitled6 (좋아요)
- Field (좋아요한 날짜)
- Key (아이디) — Foreign key → Copy Of Untitled.Key — NOT NULL
- Key (글번호) — Foreign key → Copy Of Untitled3.Key — NOT NULL
Untitled (write(글쓰기))
- Field (memo_no) — int — Primary key
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (commant) — varchar
- Field (memo) — varchar
Untitled (friend(친구))
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (friend) — varchar
Untitled (like(좋아요))
- Key (like) — int — Primary key — NOT NULL
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (memo_no) — int — Foreign key → Untitled.Field
Untitled (replay(글보기))
- Field (memo_no) — int — Foreign key → Untitled.Field
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Key (like) — int — Foreign key → Untitled.Key — NOT NULL
- Field (write_date) — date
- Field (count) — int
- Field (like_user) — varchar
Untitled (member_pofile(프로필))
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (school) — varchar
- Field (com) — varchar
Untitled (join(회원))
- Key (id) — varchar — Primary key — NOT NULL
- Field (pw) — varchar
- Field (email) — varchar
- Field (name) — varchar
Untitled (coa)
- Field (coach) — varchar
- Key (year) — int — Foreign key → Untitled.Key — NOT NULL
- Field (winner) — varchar
Untitled (cup)
- Key (year) — int — Primary key — NOT NULL
- Field (winner) — varchar
Untitled (worldcup)
- Key (year) — int — Primary key — NOT NULL
- Field (winner) — varchar
- Field (coach) — varchar
Untitled (student_lec)
- Field (grade) — varchar
- Key (lecture) — varchar — NOT NULL
- Key (no) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (student_cmp)
- Key (no) — int — Primary key — NOT NULL
- Field (campus) — varchar
Untitled (student_lecture)
- Key (no) — int — Primary key — NOT NULL
- Field (lecture) — varchar — Primary key
- Field (campus) — varchar
- Field (grade) — varchar
Untitled (phonebook)
- Field (phone) — varchar
- Key (id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (member)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar
profile
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar
- Field (phone1) — varchar
- Field (phone2) — varchar