nomalize
Tables (21)
Untitled (profil_e)
- Key (school) — varchar — NOT NULL
- Field (company) — varchar
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (좋아요)
- Field (아이디) — Foreign key → Untitled.Field
- Field (글 번호) — Foreign key → Untitled.Field
- Field (좋아요한날짜)
Untitled (친구)
- Field (친구번호) — Primary key
- Field (아이디) — Foreign key → Untitled.Field
- Field (친구아이디)
- Field (친구맺은날짜)
- Field (관계)
Untitled (댓글)
- Key (댓글번호) — Primary key — NOT NULL
- Field (글 번호) — Foreign key → Untitled.Field
- Field (내용)
- Field (작성일)
- Field (아이디) — Foreign key → Untitled.Field
Untitled (글)
- Field (글 번호) — Primary key
- Field (멘트)
- Field (조회수)
- Field (좋아요수)
- Field (등록날짜)
- Field (아이디) — Foreign key → Untitled.Field
Untitled (프로필)
- Field (학교)
- Field (회사)
- Field (작성일)
- Field (아이디) — Foreign key → Untitled.Field
Untitled (회원)
- Field (아이디) — Primary key
- Field (비밀번호)
- Field (이메일)
- Field (이름)
Untitled (글 읽기)
- Key (글번호) — int — Primary key — NOT NULL
- Field (id) — varchar
- Field (등록날짜) — date
- Field (글 내용) — varchar
- Field (조회 수) — int
- Field (좋아요) — int
Untitled (like)
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Key (w_no) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (reply)
- Key (w_no) — int — NOT NULL
- Field (r_no) — int
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (글 작성)
- Key (w_no) — int — Primary key — NOT NULL
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (등록날짜) — date
- Field (글 내용) — varchar
Untitled (profile)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar
- Field (phone1) — varchar
- Field (phone2) — varchar
Untitled (user)
- Key (id) — varchar — Primary key — NOT NULL
- Field (pw) — varchar
- Field (email) — varchar
- Field (name) — varchar
Untitled (worldcup_team)
- Field (nation) — varchar
- Field2 (coach) — varchar
Untitled (worldcup_win)
- Key (year) — int — Primary key — NOT NULL
- Field (nation) — varchar
Untitled (worldcup)
- Key (year) — int — Primary key — NOT NULL
- Field (winner) — varchar
- Field (coach) — varchar
Untitled (lectures)
- Field (grade) — varchar
- Key (no) — int — Foreign key → Untitled.Key — NOT NULL
- Key (lecture) — varchar — NOT NULL
Untitled (student)
- Key (no) — int — Primary key — NOT NULL
- Field (campus) — varchar
Untitled (student_lecture)
- Key (no) — int — Primary key — NOT NULL
- Key (lecture) — varchar — Primary key — NOT NULL
- 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