normalize
Tables (32)
1nf (profile)
- id (Key) — int — Primary key — NOT NULL
- name — varchar
- phone1 — varchar
- phone2 — varchar
Untitled (like)
- Field (count) — int
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (소분류)
- Key (소분류번호) — Primary key — NOT NULL
- Key (중분류번호) — Foreign key → Untitled.Key — NOT NULL
- Field (분류이름)
Untitled (중분류)
- Key (중분류번호) — Primary key — NOT NULL
- Field (분류이름)
- Key (대분류번호) — Foreign key → Untitled.Key — NOT NULL
Untitled (구매후기)
- Key (후기번호) — Primary key — NOT NULL
- Field (후기내용)
- Field (작성일)
- Field (품목아이디) — Foreign key → Untitled.Field
- Field (아이디2) — Foreign key → Untitled.Field
Untitled (대분류)
- Key (대분류번호) — Primary key — NOT NULL
- Field (분류이름)
Untitled (판매품목)
- Field (품목아이디) — Primary key
- Field (품목이름)
- Field (가격)
- Field (판매자 아이디) — Foreign key → Untitled.Field
- Key (대분류번호) — Foreign key → Untitled.Key — NOT NULL
- Key (중분류번호) — Foreign key → Untitled.Key — NOT NULL
- Key (소분류번호) — Foreign key → Untitled.Key — NOT NULL
Untitled (구매)
- Field (아이디) — Foreign key → Untitled.Field
- Field (품목아이디) — Foreign key → Untitled.Field
- Field (구매날짜)
- Field (수량)
Untitled (장바구니)
- Key (장바구니번호) — Primary key — NOT NULL
- Field (품목아이디) — Foreign key → Untitled.Field
- Field (담긴 날짜)
- Field (수량)
- Field (아이디2) — Foreign key → Untitled.Field
Untitled (판매자 회원)
- Field (판매자 아이디) — Primary key
- Field2 (비밀번호)
- Field3 (계좌번호)
Untitled (일반회원)
- Field (아이디) — Primary key
- Field2 (비밀번호)
- Field3 (배송지주소)
- Field4 (전화번호)
Untitled (회원)
- Field (아이디) — Primary key
- Field2 (비밀번호)
- Field3 (이메일)
- Field (이름)
Untitled (friend_list)
- Field (friend_name) — varchar
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (comment)
- Key (no) — int — Primary key — NOT NULL
- Field (reply) — varchar
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
Untitled (profile_r)
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (school) — varchar
- Field2 (company) — varchar
Untitled (student_lecture)
- Key (no) — int — Primary key — NOT NULL
- Key2 (lecture) — varchar — Primary key — NOT NULL
- Field (campus) — varchar
- Field (grade) — varchar
Untitled (student)
- Key (no) — int — Primary key — NOT NULL
- Field (campus) — varchar
Untitled (lecture)
- Field (lecture) — varchar
- Field (grade) — varchar
- Key (no) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (worldcup)
- Key (year) — int — Primary key — NOT NULL
- Field (winner) — varchar
- Field (coach) — varchar
Untitled (country)
- Field (year) — int — Primary key
- Key (winner) — varchar — NOT NULL
Untitled (coach)
- Field (year) — int — Foreign key → Untitled.Field
- Field (coach) — varchar
Untitled (winner list)
- Key (year) — int — Primary key — NOT NULL
- Field (nation) — varchar
Untitled (register)
- Key (id) — varchar — Primary key — NOT NULL
- Field (password) — varchar
- Field (email) — varchar
- Field (name) — varchar
Untitled (write)
- Key (no) — int — Primary key — NOT NULL
- Field (date) — date
- Field2 (view) — int
- Field3 (like) — int
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (content) — varchar
Untitled2 (프로필)
- Field (학교)
- Field2 (회사)
- Field (작성일)
- Field (아이디) — Foreign key → Untitled.Field
Untitled2 (teams)
- Key (nation_code) — int — Primary key — NOT NULL
- Field (coach) — varchar
- Key (nation) — varchar — NOT NULL
- Key (year) — int — Foreign key → Untitled.Key — NOT NULL
Untitled3 (좋아요)
- Field (아이디) — Foreign key → Untitled.Field
- Field (글번호) — Foreign key → Untitled4.Field
Untitled4 (글)
- Field (글번호) — Primary key
- Field (멘트)
- Field2 (조회수)
- Field (좋아요수)
- Field (등록날짜)
- Field (아이디) — Foreign key → Untitled.Field
Untitled5 (친구)
- Key (친구번호) — Primary key — NOT NULL
- Field (아이디) — Foreign key → Untitled.Field
- Field (친구아이디)
- Field
Untitled6 (댓글)
- Key (댓글번호) — Primary key — NOT NULL
- Field (글번호) — Foreign key → Untitled4.Field
- Field (내용)
- Field (등록날짜)
- Field (아이디) — Foreign key → Untitled.Field
member
- id (Key) — int — Primary key — NOT NULL
- name — varchar
phonebook
- Field (phone) — varchar
- id (Key) — int — Foreign key → member.id — NOT NULL