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